Write an Oracle function to extract the following string: $PROFILES $. MFG_ORGANIZATION_ID, : $FLEX $. GBINV_ACCOUNT_TYPE, : $FLEX $. GB_START_DATE and: $FLEX $. GB_END_DATE and so on a string and returns an array

Where MMT. Transaction_id in (select Max (mmt2. Transaction_id)
The from mtl_material_transactions mmt2
Where anization_id=mmt2.org: $PROFILES $MFG_ORGANIZATION_ID
And mmt2. Transaction_type_id=: $FLEX $. GBINV_ACCOUNT_TYPE
And MMT2. Transaction_Date & gt;=To_Date (: $FLEX $GB_START_DATE, 'YYYY/MM/DD)
And MMT2. Transaction_Date & lt; To_Date (: $FLEX $GB_END_DATE, 'YYYY/MM/DD) + 1
And MMT. Attribute1=mmt2. Attribute1
And mmt2. Attribute1 is not null)

CodePudding user response:

Has been to help you achieve this using Java