ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 21ACCFDE169F483FB16B00D530835AE1Y select null action_, null status_, null message_, null modified_columns_, mtrh.header_id, mtrl.line_id, mp.organization_code, mtrh.request_number move_order, mtrh.description, xxen_util.meaning(mtrh.header_status,'MTL_TXN_REQUEST_STATUS',700) header_status, null approve, mtrl.line_number, msiv.concatenated_segments item, msiv.description item_description, mtrl.revision, (select mtt.transaction_type_name from mtl_transaction_types mtt where mtrl.transaction_type_id=mtt.transaction_type_id) transaction_type, mtrl.date_required, mtrl.uom_code uom, mtrl.quantity, mtrl.quantity_delivered, mtrl.from_subinventory_code source_subinventory, (select milk.concatenated_segments from mtl_item_locations_kfv milk where mtrl.from_locator_id=milk.inventory_location_id and mtrl.organization_id=milk.organization_id) source_locator, mtrl.lot_number, mtrl.serial_number_start serial_from, mtrl.serial_number_end serial_to, mtrl.to_subinventory_code destination_subinventory, (select milk.concatenated_segments from mtl_item_locations_kfv milk where mtrl.to_locator_id=milk.inventory_location_id and mtrl.organization_id=milk.organization_id) destination_locator, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where mtrl.to_account_id=gcck.code_combination_id) destination_account, (select hla.location_code from hr_locations_all hla where mtrl.ship_to_location_id=hla.location_id) ship_to_location, (select mtr.reason_name from mtl_transaction_reasons mtr where mtrl.reason_id=mtr.reason_id) reason, mtrl.reference, xxen_util.meaning(mtrl.line_status,'MTL_TXN_REQUEST_STATUS',700) line_status, null line_action, xxen_util.display_flexfield_context(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category) header_context, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE1',mtrh.rowid,mtrh.attribute1) hdr_attribute1, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE2',mtrh.rowid,mtrh.attribute2) hdr_attribute2, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE3',mtrh.rowid,mtrh.attribute3) hdr_attribute3, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE4',mtrh.rowid,mtrh.attribute4) hdr_attribute4, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE5',mtrh.rowid,mtrh.attribute5) hdr_attribute5, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE6',mtrh.rowid,mtrh.attribute6) hdr_attribute6, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE7',mtrh.rowid,mtrh.attribute7) hdr_attribute7, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE8',mtrh.rowid,mtrh.attribute8) hdr_attribute8, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE9',mtrh.rowid,mtrh.attribute9) hdr_attribute9, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE10',mtrh.rowid,mtrh.attribute10) hdr_attribute10, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE11',mtrh.rowid,mtrh.attribute11) hdr_attribute11, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE12',mtrh.rowid,mtrh.attribute12) hdr_attribute12, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE13',mtrh.rowid,mtrh.attribute13) hdr_attribute13, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE14',mtrh.rowid,mtrh.attribute14) hdr_attribute14, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE15',mtrh.rowid,mtrh.attribute15) hdr_attribute15, xxen_util.display_flexfield_context(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category) line_context, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE1',mtrl.rowid,mtrl.attribute1) line_attribute1, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE2',mtrl.rowid,mtrl.attribute2) line_attribute2, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE3',mtrl.rowid,mtrl.attribute3) line_attribute3, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE4',mtrl.rowid,mtrl.attribute4) line_attribute4, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE5',mtrl.rowid,mtrl.attribute5) line_attribute5, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE6',mtrl.rowid,mtrl.attribute6) line_attribute6, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE7',mtrl.rowid,mtrl.attribute7) line_attribute7, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE8',mtrl.rowid,mtrl.attribute8) line_attribute8, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE9',mtrl.rowid,mtrl.attribute9) line_attribute9, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE10',mtrl.rowid,mtrl.attribute10) line_attribute10, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE11',mtrl.rowid,mtrl.attribute11) line_attribute11, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE12',mtrl.rowid,mtrl.attribute12) line_attribute12, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE13',mtrl.rowid,mtrl.attribute13) line_attribute13, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE14',mtrl.rowid,mtrl.attribute14) line_attribute14, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE15',mtrl.rowid,mtrl.attribute15) line_attribute15, to_number(null) upload_row from mtl_parameters mp, mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl, mtl_system_items_vl msiv where 1=1 and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and mp.organization_id=mtrh.organization_id and mtrh.move_order_type=1 and mtrh.header_id=mtrl.header_id and mtrl.inventory_item_id=msiv.inventory_item_id and mtrl.organization_id=msiv.organization_id Initial version U A xxen_inv_upload.upload_move_order xxen_inv_upload.approve_move_order US INV Move Order Upload Creates and updates move order requisitions with their lines, approves them, and cancels or closes move order lines, as the Move Orders window (Inventory > Move Orders > Move Orders). Each row carries the move order header and one line. Rows with the same Move Order belong to one move order; leave Move Order blank on new rows to have the number generated, rows with a blank number and the same header values then form one move order. Approve submits the move order for approval as the Approve button of the form: it is approved immediately unless the organization's move order approval timeout requires the approval workflow. Allocating and transacting the approved lines is done in the Transact Move Orders window. Enginatics Upload 1=1 1 10 1=1 :p_upload_mode like '%'||xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create||','||xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C,U Y US Upload Mode 2 20 1=1 mp.organization_code=:organization_code LOV INV Organization Code (including master) 0B22DF18E239D64AE0630100007FBD85 select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where ood.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate order by ood.organization_code select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') Y US Organization Code 3 30 1=1 mtrh.request_number=:move_order LOV custom select mtrh.request_number value, mtrh.description from mtl_parameters mp, mtl_txn_request_headers mtrh where mp.organization_code=:$flex$.organization_code and mp.organization_id=mtrh.organization_id and mtrh.move_order_type=1 order by mtrh.header_id desc US Move Order 4 40 1=1 mtrh.header_status=:header_status LOV custom select ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='MTL_TXN_REQUEST_STATUS' order by ml.lookup_code US Header Status 5 50 1=1 msiv.concatenated_segments=:item LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments US Item E133D7DAB3EC4797A281B3EE4ED46BAC Create Move Orders Opens an empty sheet to create and approve move order requisitions, one row per line. ENGINATICS 4 APPROVE 9 DATE_REQUIRED 3 DESCRIPTION Y 17 DESTINATION_ACCOUNT 16 DESTINATION_LOCATOR 15 DESTINATION_SUBINVENTORY 5 ITEM 6 ITEM_DESCRIPTION 14 LOT_NUMBER 2 MOVE_ORDER 1 ORGANIZATION_CODE 11 QUANTITY 18 REASON 19 REFERENCE 7 REVISION 13 SOURCE_LOCATOR 12 SOURCE_SUBINVENTORY 8 TRANSACTION_TYPE 10 UOM Upload Mode C Y S Site Header Status Item Move Order 241322095C9C404282ABEC5CD4F76A7E Default Creates, updates and approves move order requisitions, without the descriptive flexfields. ENGINATICS 5 APPROVE 11 DATE_REQUIRED 3 DESCRIPTION Y 22 DESTINATION_ACCOUNT 21 DESTINATION_LOCATOR 20 DESTINATION_SUBINVENTORY 4 HEADER_STATUS 7 ITEM 8 ITEM_DESCRIPTION 27 LINE_ACTION 6 LINE_NUMBER 26 LINE_STATUS 17 LOT_NUMBER 2 MOVE_ORDER 1 ORGANIZATION_CODE 13 QUANTITY 14 QUANTITY_DELIVERED 24 REASON 25 REFERENCE 9 REVISION 18 SERIAL_FROM 19 SERIAL_TO 23 SHIP_TO_LOCATION 16 SOURCE_LOCATOR 15 SOURCE_SUBINVENTORY 10 TRANSACTION_TYPE 12 UOM Upload Mode C,U S Site B1913CBAFDFA4975A4C29BE480EE7350 Flexfields Creates and updates move order requisitions including the descriptive flexfields. ENGINATICS 5 APPROVE 26 DATE_REQUIRED 3 DESCRIPTION Y 30 DESTINATION_SUBINVENTORY 7 HDR_ATTRIBUTE1 16 HDR_ATTRIBUTE10 17 HDR_ATTRIBUTE11 18 HDR_ATTRIBUTE12 19 HDR_ATTRIBUTE13 20 HDR_ATTRIBUTE14 21 HDR_ATTRIBUTE15 8 HDR_ATTRIBUTE2 9 HDR_ATTRIBUTE3 10 HDR_ATTRIBUTE4 11 HDR_ATTRIBUTE5 12 HDR_ATTRIBUTE6 13 HDR_ATTRIBUTE7 14 HDR_ATTRIBUTE8 15 HDR_ATTRIBUTE9 6 HEADER_CONTEXT 4 HEADER_STATUS 23 ITEM 24 ITEM_DESCRIPTION 33 LINE_ATTRIBUTE1 42 LINE_ATTRIBUTE10 43 LINE_ATTRIBUTE11 44 LINE_ATTRIBUTE12 45 LINE_ATTRIBUTE13 46 LINE_ATTRIBUTE14 47 LINE_ATTRIBUTE15 34 LINE_ATTRIBUTE2 35 LINE_ATTRIBUTE3 36 LINE_ATTRIBUTE4 37 LINE_ATTRIBUTE5 38 LINE_ATTRIBUTE6 39 LINE_ATTRIBUTE7 40 LINE_ATTRIBUTE8 41 LINE_ATTRIBUTE9 32 LINE_CONTEXT 22 LINE_NUMBER 31 LINE_STATUS 2 MOVE_ORDER 1 ORGANIZATION_CODE 28 QUANTITY 29 SOURCE_SUBINVENTORY 25 TRANSACTION_TYPE 27 UOM Upload Mode C,U S Site 241322095C9C404282ABEC5CD4F76A7E 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 HEADER_ID Number number Y 6 LINE_ID Number number Y 7 ORGANIZATION_CODE LOV custom varchar2 select mp.organization_id id, mp.organization_code value, haouv.name description from mtl_parameters mp, hr_all_organization_units_vl haouv where mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and mp.organization_id=haouv.organization_id order by mp.organization_code :$flex$.organization_code Y Y 8 MOVE_ORDER Char varchar2 Leave blank on new rows to have the move order number generated. Y 9 DESCRIPTION Char varchar2 10 HEADER_STATUS Char varchar2 Y 11 APPROVE LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Submits the move order for approval after its lines are created. 12 LINE_NUMBER Number number Y 13 ITEM LOV custom varchar2 select msiv.inventory_item_id id, msiv.concatenated_segments value, msiv.description from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.mtl_transactions_enabled_flag='Y' order by msiv.concatenated_segments Y 14 ITEM_DESCRIPTION Char varchar2 select msiv.description from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.item Y 15 REVISION LOV custom varchar2 select mir.revision value, mir.description from mtl_parameters mp, mtl_system_items_vl msiv, mtl_item_revisions mir where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.item and msiv.inventory_item_id=mir.inventory_item_id and msiv.organization_id=mir.organization_id order by mir.revision 16 TRANSACTION_TYPE LOV custom varchar2 select mtt.transaction_type_id id, mtt.transaction_type_name value, mtt.description from mtl_transaction_types mtt where mtt.transaction_source_type_id=4 and mtt.transaction_action_id in (1,2) and nvl(mtt.disable_date,sysdate+1)>sysdate order by mtt.transaction_type_name select mtt.transaction_type_name from mtl_transaction_types mtt where mtt.transaction_type_id=64 17 DATE_REQUIRED Date date sysdate 18 UOM LOV custom varchar2 select miuv.uom_code value, miuv.unit_of_measure description from mtl_parameters mp, mtl_system_items_vl msiv, mtl_item_uoms_view miuv where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.item and msiv.inventory_item_id=miuv.inventory_item_id and msiv.organization_id=miuv.organization_id order by miuv.uom_code select msiv.primary_uom_code from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.item 19 QUANTITY Number number 20 QUANTITY_DELIVERED Number number Y 21 SOURCE_SUBINVENTORY LOV custom varchar2 select msi.secondary_inventory_name value, msi.description from mtl_parameters mp, mtl_secondary_inventories msi where mp.organization_code=:$column$.organization_code and mp.organization_id=msi.organization_id and nvl(msi.disable_date,sysdate+1)>sysdate order by msi.secondary_inventory_name 22 SOURCE_LOCATOR LOV custom varchar2 select milk.inventory_location_id id, milk.concatenated_segments value, milk.description from mtl_parameters mp, mtl_item_locations_kfv milk where mp.organization_code=:$column$.organization_code and mp.organization_id=milk.organization_id and milk.subinventory_code=:$column$.source_subinventory and nvl(milk.disable_date,sysdate+1)>sysdate order by milk.concatenated_segments 23 LOT_NUMBER LOV custom varchar2 select mln.lot_number value, mln.description from mtl_parameters mp, mtl_system_items_vl msiv, mtl_lot_numbers mln where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.item and msiv.inventory_item_id=mln.inventory_item_id and msiv.organization_id=mln.organization_id order by mln.lot_number 24 SERIAL_FROM LOV custom varchar2 select msn.serial_number value, null description from mtl_parameters mp, mtl_system_items_vl msiv, mtl_serial_numbers msn where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.item and msiv.inventory_item_id=msn.inventory_item_id and msiv.organization_id=msn.current_organization_id and msn.current_status=3 order by msn.serial_number 25 SERIAL_TO LOV custom varchar2 select msn.serial_number value, null description from mtl_parameters mp, mtl_system_items_vl msiv, mtl_serial_numbers msn where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.item and msiv.inventory_item_id=msn.inventory_item_id and msiv.organization_id=msn.current_organization_id and msn.current_status=3 and msn.serial_number>=:$column$.serial_from order by msn.serial_number 26 DESTINATION_SUBINVENTORY LOV custom varchar2 select msi.secondary_inventory_name value, msi.description from mtl_parameters mp, mtl_secondary_inventories msi where mp.organization_code=:$column$.organization_code and mp.organization_id=msi.organization_id and nvl(msi.disable_date,sysdate+1)>sysdate order by msi.secondary_inventory_name 27 DESTINATION_LOCATOR LOV custom varchar2 select milk.inventory_location_id id, milk.concatenated_segments value, milk.description from mtl_parameters mp, mtl_item_locations_kfv milk where mp.organization_code=:$column$.organization_code and mp.organization_id=milk.organization_id and milk.subinventory_code=:$column$.destination_subinventory and nvl(milk.disable_date,sysdate+1)>sysdate order by milk.concatenated_segments 28 DESTINATION_ACCOUNT LOV custom varchar2 select gcck.code_combination_id id, gcck.concatenated_segments value, null description from mtl_parameters mp, org_organization_definitions ood, gl_code_combinations_kfv gcck where mp.organization_code=:$column$.organization_code and mp.organization_id=ood.organization_id and ood.chart_of_accounts_id=gcck.chart_of_accounts_id and gcck.enabled_flag='Y' and gcck.summary_flag='N' and gcck.detail_posting_allowed='Y' order by gcck.concatenated_segments 29 SHIP_TO_LOCATION LOV custom varchar2 select hla.location_id id, hla.location_code value, hla.description from hr_locations_all hla where nvl(hla.inactive_date,sysdate+1)>sysdate order by hla.location_code 30 REASON LOV custom varchar2 select mtr.reason_id id, mtr.reason_name value, mtr.description from mtl_transaction_reasons mtr where nvl(mtr.disable_date,sysdate+1)>sysdate order by mtr.reason_name 31 REFERENCE Char varchar2 32 LINE_STATUS Char varchar2 Y 33 LINE_ACTION LOV custom varchar2 select 'CANCEL' id, xxen_util.meaning(6,'MTL_TXN_REQUEST_STATUS',700) value, null description from dual union all select 'CLOSE' id, xxen_util.meaning(5,'MTL_TXN_REQUEST_STATUS',700) value, null description from dual 34 HEADER_CONTEXT LOV custom varchar2 select fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=401 and fdfcv.descriptive_flexfield_name='MTL_TXN_REQUEST_HEADERS' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 35 HDR_ATTRIBUTE1 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_HEADERS', p_context_name=>:$column$.header_context, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE1' 36 HDR_ATTRIBUTE2 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_HEADERS', p_context_name=>:$column$.header_context, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE2' 37 HDR_ATTRIBUTE3 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_HEADERS', p_context_name=>:$column$.header_context, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE3' 38 HDR_ATTRIBUTE4 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_HEADERS', p_context_name=>:$column$.header_context, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE4' 39 HDR_ATTRIBUTE5 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_HEADERS', p_context_name=>:$column$.header_context, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE5' 40 HDR_ATTRIBUTE6 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_HEADERS', p_context_name=>:$column$.header_context, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE6' 41 HDR_ATTRIBUTE7 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_HEADERS', p_context_name=>:$column$.header_context, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE7' 42 HDR_ATTRIBUTE8 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_HEADERS', p_context_name=>:$column$.header_context, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE8' 43 HDR_ATTRIBUTE9 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_HEADERS', p_context_name=>:$column$.header_context, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE9' 44 HDR_ATTRIBUTE10 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_HEADERS', p_context_name=>:$column$.header_context, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE10' 45 HDR_ATTRIBUTE11 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_HEADERS', p_context_name=>:$column$.header_context, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE11' 46 HDR_ATTRIBUTE12 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_HEADERS', p_context_name=>:$column$.header_context, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE12' 47 HDR_ATTRIBUTE13 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_HEADERS', p_context_name=>:$column$.header_context, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE13' 48 HDR_ATTRIBUTE14 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_HEADERS', p_context_name=>:$column$.header_context, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE14' 49 HDR_ATTRIBUTE15 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_HEADERS', p_context_name=>:$column$.header_context, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.hdr_attribute1, p_attribute2=>:$column$.hdr_attribute2, p_attribute3=>:$column$.hdr_attribute3, p_attribute4=>:$column$.hdr_attribute4, p_attribute5=>:$column$.hdr_attribute5, p_attribute6=>:$column$.hdr_attribute6, p_attribute7=>:$column$.hdr_attribute7, p_attribute8=>:$column$.hdr_attribute8, p_attribute9=>:$column$.hdr_attribute9, p_attribute10=>:$column$.hdr_attribute10, p_attribute11=>:$column$.hdr_attribute11, p_attribute12=>:$column$.hdr_attribute12, p_attribute13=>:$column$.hdr_attribute13, p_attribute14=>:$column$.hdr_attribute14, p_attribute15=>:$column$.hdr_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE15' 50 LINE_CONTEXT LOV custom varchar2 select fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=401 and fdfcv.descriptive_flexfield_name='MTL_TXN_REQUEST_LINES' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 51 LINE_ATTRIBUTE1 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_LINES', p_context_name=>:$column$.line_context, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE1' 52 LINE_ATTRIBUTE2 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_LINES', p_context_name=>:$column$.line_context, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE2' 53 LINE_ATTRIBUTE3 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_LINES', p_context_name=>:$column$.line_context, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE3' 54 LINE_ATTRIBUTE4 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_LINES', p_context_name=>:$column$.line_context, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE4' 55 LINE_ATTRIBUTE5 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_LINES', p_context_name=>:$column$.line_context, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE5' 56 LINE_ATTRIBUTE6 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_LINES', p_context_name=>:$column$.line_context, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE6' 57 LINE_ATTRIBUTE7 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_LINES', p_context_name=>:$column$.line_context, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE7' 58 LINE_ATTRIBUTE8 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_LINES', p_context_name=>:$column$.line_context, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE8' 59 LINE_ATTRIBUTE9 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_LINES', p_context_name=>:$column$.line_context, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE9' 60 LINE_ATTRIBUTE10 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_LINES', p_context_name=>:$column$.line_context, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE10' 61 LINE_ATTRIBUTE11 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_LINES', p_context_name=>:$column$.line_context, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE11' 62 LINE_ATTRIBUTE12 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_LINES', p_context_name=>:$column$.line_context, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE12' 63 LINE_ATTRIBUTE13 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_LINES', p_context_name=>:$column$.line_context, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE13' 64 LINE_ATTRIBUTE14 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_LINES', p_context_name=>:$column$.line_context, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE14' 65 LINE_ATTRIBUTE15 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_TXN_REQUEST_LINES', p_context_name=>:$column$.line_context, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.line_attribute1, p_attribute2=>:$column$.line_attribute2, p_attribute3=>:$column$.line_attribute3, p_attribute4=>:$column$.line_attribute4, p_attribute5=>:$column$.line_attribute5, p_attribute6=>:$column$.line_attribute6, p_attribute7=>:$column$.line_attribute7, p_attribute8=>:$column$.line_attribute8, p_attribute9=>:$column$.line_attribute9, p_attribute10=>:$column$.line_attribute10, p_attribute11=>:$column$.line_attribute11, p_attribute12=>:$column$.line_attribute12, p_attribute13=>:$column$.line_attribute13, p_attribute14=>:$column$.line_attribute14, p_attribute15=>:$column$.line_attribute15 ) ) lov select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 401 and fdfv.descriptive_flexfield_name = 'MTL_TXN_REQUEST_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE15' 66 UPLOAD_ROW Number number Y U 1 action_ in Char ACTION_CODE_ U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 4 p_header_id in Number Y HEADER_ID U 5 p_header_id_out out Number HEADER_ID U 6 p_line_id in Number Y LINE_ID U 7 p_line_id_out out Number LINE_ID U 8 p_organization_id in Number ORGANIZATION_CODE U 9 p_move_order in Char Y MOVE_ORDER U 10 p_description in Char Y DESCRIPTION U 11 p_header_context in Char Y HEADER_CONTEXT U 12 p_hdr_attribute1 in Char Y HDR_ATTRIBUTE1 U 13 p_hdr_attribute2 in Char Y HDR_ATTRIBUTE2 U 14 p_hdr_attribute3 in Char Y HDR_ATTRIBUTE3 U 15 p_hdr_attribute4 in Char Y HDR_ATTRIBUTE4 U 16 p_hdr_attribute5 in Char Y HDR_ATTRIBUTE5 U 17 p_hdr_attribute6 in Char Y HDR_ATTRIBUTE6 U 18 p_hdr_attribute7 in Char Y HDR_ATTRIBUTE7 U 19 p_hdr_attribute8 in Char Y HDR_ATTRIBUTE8 U 20 p_hdr_attribute9 in Char Y HDR_ATTRIBUTE9 U 21 p_hdr_attribute10 in Char Y HDR_ATTRIBUTE10 U 22 p_hdr_attribute11 in Char Y HDR_ATTRIBUTE11 U 23 p_hdr_attribute12 in Char Y HDR_ATTRIBUTE12 U 24 p_hdr_attribute13 in Char Y HDR_ATTRIBUTE13 U 25 p_hdr_attribute14 in Char Y HDR_ATTRIBUTE14 U 26 p_hdr_attribute15 in Char Y HDR_ATTRIBUTE15 U 27 p_line_number in Number Y LINE_NUMBER U 28 p_inventory_item_id in Number Y ITEM U 29 p_revision in Char Y REVISION U 30 p_transaction_type_id in Number Y TRANSACTION_TYPE U 31 p_date_required in Date Y DATE_REQUIRED U 32 p_uom_code in Char Y UOM U 33 p_quantity in Number Y QUANTITY U 34 p_from_subinventory in Char Y SOURCE_SUBINVENTORY U 35 p_from_locator_id in Number Y SOURCE_LOCATOR U 36 p_lot_number in Char Y LOT_NUMBER U 37 p_serial_number_start in Char Y SERIAL_FROM U 38 p_serial_number_end in Char Y SERIAL_TO U 39 p_to_subinventory in Char Y DESTINATION_SUBINVENTORY U 40 p_to_locator_id in Number Y DESTINATION_LOCATOR U 41 p_to_account_id in Number Y DESTINATION_ACCOUNT U 42 p_ship_to_location_id in Number Y SHIP_TO_LOCATION U 43 p_reason_id in Number Y REASON U 44 p_reference in Char Y REFERENCE U 45 p_line_context in Char Y LINE_CONTEXT U 46 p_line_attribute1 in Char Y LINE_ATTRIBUTE1 U 47 p_line_attribute2 in Char Y LINE_ATTRIBUTE2 U 48 p_line_attribute3 in Char Y LINE_ATTRIBUTE3 U 49 p_line_attribute4 in Char Y LINE_ATTRIBUTE4 U 50 p_line_attribute5 in Char Y LINE_ATTRIBUTE5 U 51 p_line_attribute6 in Char Y LINE_ATTRIBUTE6 U 52 p_line_attribute7 in Char Y LINE_ATTRIBUTE7 U 53 p_line_attribute8 in Char Y LINE_ATTRIBUTE8 U 54 p_line_attribute9 in Char Y LINE_ATTRIBUTE9 U 55 p_line_attribute10 in Char Y LINE_ATTRIBUTE10 U 56 p_line_attribute11 in Char Y LINE_ATTRIBUTE11 U 57 p_line_attribute12 in Char Y LINE_ATTRIBUTE12 U 58 p_line_attribute13 in Char Y LINE_ATTRIBUTE13 U 59 p_line_attribute14 in Char Y LINE_ATTRIBUTE14 U 60 p_line_attribute15 in Char Y LINE_ATTRIBUTE15 U 61 p_line_action in Char Y LINE_ACTION P 1 p_header_id in Number HEADER_ID P 2 p_line_id in Number LINE_ID P 3 p_approve in Char APPROVE P 4 status_ out Char STATUS_CODE_ P 5 message_ out Char MESSAGE_ Error SQL Order By upload_row, organization_code, move_order, line_number Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, mtrh.header_id, nvl(mtrl.line_id,xu.line_id) line_id, xu.organization_code, mtrh.request_number move_order, mtrh.description, xxen_util.meaning(mtrh.header_status,'MTL_TXN_REQUEST_STATUS',700) header_status, xu.approve, nvl(mtrl.line_number,xu.line_number) line_number, nvl(msiv.concatenated_segments,xu.item) item, nvl(msiv.description,xu.item_description) item_description, mtrl.revision, (select mtt.transaction_type_name from mtl_transaction_types mtt where mtrl.transaction_type_id=mtt.transaction_type_id) transaction_type, mtrl.date_required, mtrl.uom_code uom, mtrl.quantity, mtrl.quantity_delivered, mtrl.from_subinventory_code source_subinventory, (select milk.concatenated_segments from mtl_item_locations_kfv milk where mtrl.from_locator_id=milk.inventory_location_id and mtrl.organization_id=milk.organization_id) source_locator, mtrl.lot_number, mtrl.serial_number_start serial_from, mtrl.serial_number_end serial_to, mtrl.to_subinventory_code destination_subinventory, (select milk.concatenated_segments from mtl_item_locations_kfv milk where mtrl.to_locator_id=milk.inventory_location_id and mtrl.organization_id=milk.organization_id) destination_locator, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where mtrl.to_account_id=gcck.code_combination_id) destination_account, (select hla.location_code from hr_locations_all hla where mtrl.ship_to_location_id=hla.location_id) ship_to_location, (select mtr.reason_name from mtl_transaction_reasons mtr where mtrl.reason_id=mtr.reason_id) reason, mtrl.reference, xxen_util.meaning(mtrl.line_status,'MTL_TXN_REQUEST_STATUS',700) line_status, xu.line_action, xxen_util.display_flexfield_context(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category) header_context, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE1',mtrh.rowid,mtrh.attribute1) hdr_attribute1, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE2',mtrh.rowid,mtrh.attribute2) hdr_attribute2, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE3',mtrh.rowid,mtrh.attribute3) hdr_attribute3, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE4',mtrh.rowid,mtrh.attribute4) hdr_attribute4, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE5',mtrh.rowid,mtrh.attribute5) hdr_attribute5, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE6',mtrh.rowid,mtrh.attribute6) hdr_attribute6, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE7',mtrh.rowid,mtrh.attribute7) hdr_attribute7, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE8',mtrh.rowid,mtrh.attribute8) hdr_attribute8, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE9',mtrh.rowid,mtrh.attribute9) hdr_attribute9, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE10',mtrh.rowid,mtrh.attribute10) hdr_attribute10, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE11',mtrh.rowid,mtrh.attribute11) hdr_attribute11, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE12',mtrh.rowid,mtrh.attribute12) hdr_attribute12, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE13',mtrh.rowid,mtrh.attribute13) hdr_attribute13, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE14',mtrh.rowid,mtrh.attribute14) hdr_attribute14, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_HEADERS',mtrh.attribute_category,'ATTRIBUTE15',mtrh.rowid,mtrh.attribute15) hdr_attribute15, xxen_util.display_flexfield_context(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category) line_context, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE1',mtrl.rowid,mtrl.attribute1) line_attribute1, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE2',mtrl.rowid,mtrl.attribute2) line_attribute2, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE3',mtrl.rowid,mtrl.attribute3) line_attribute3, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE4',mtrl.rowid,mtrl.attribute4) line_attribute4, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE5',mtrl.rowid,mtrl.attribute5) line_attribute5, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE6',mtrl.rowid,mtrl.attribute6) line_attribute6, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE7',mtrl.rowid,mtrl.attribute7) line_attribute7, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE8',mtrl.rowid,mtrl.attribute8) line_attribute8, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE9',mtrl.rowid,mtrl.attribute9) line_attribute9, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE10',mtrl.rowid,mtrl.attribute10) line_attribute10, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE11',mtrl.rowid,mtrl.attribute11) line_attribute11, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE12',mtrl.rowid,mtrl.attribute12) line_attribute12, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE13',mtrl.rowid,mtrl.attribute13) line_attribute13, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE14',mtrl.rowid,mtrl.attribute14) line_attribute14, xxen_util.display_flexfield_value(401,'MTL_TXN_REQUEST_LINES',mtrl.attribute_category,'ATTRIBUTE15',mtrl.rowid,mtrl.attribute15) line_attribute15, xu.upload_row from xxen_inv_move_order_upl_8083_u xu, mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl, mtl_system_items_vl msiv where xu.status_code_=xxen_upload.status_success and xu.header_id=mtrh.header_id and xu.line_id=mtrl.line_id(+) and mtrl.inventory_item_id=msiv.inventory_item_id(+) and mtrl.organization_id=msiv.organization_id(+)