ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN F1BEFF37C05A458BAED7E24B751495B4Y select null action_, null status_, null message_, null modified_columns_, mcce.cycle_count_entry_id, mp.organization_code, mcch.cycle_count_header_name cycle_count, mcce.count_list_sequence count_sequence, msiv.concatenated_segments item, msiv.description item_description, mcce.revision, mcce.subinventory, (select milk.concatenated_segments from mtl_item_locations_kfv milk where mcce.locator_id=milk.inventory_location_id and mcce.organization_id=milk.organization_id) locator, mcce.lot_number, mcce.serial_number, nvl(mcce.count_uom_current,msiv.primary_uom_code) uom, mcce.count_quantity_current count_quantity, msiv.secondary_uom_code secondary_uom, mcce.secondary_uom_quantity_current secondary_count_quantity, (select mtr.reason_name from mtl_transaction_reasons mtr where mcce.transaction_reason_id=mtr.reason_id) reason, mcce.reference_current reference, case when mcce.counted_by_employee_id_current is not null then (select x.value from ( select mecv.employee_id, mecv.employee_num, case when count(*) over (partition by mecv.full_name)>1 then mecv.full_name||' ('||mecv.employee_num||')' else mecv.full_name end value from mtl_employees_current_view mecv where mecv.organization_id=mcce.organization_id ) x where mcce.counted_by_employee_id_current=x.employee_id) end counted_by, mcce.count_date_current count_date, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where nvl(mcce.inventory_adjustment_account,mcch.inventory_adjustment_account)=gcck.code_combination_id) adjustment_account, xxen_util.meaning(mcce.entry_status_code,'MTL_CC_ENTRY_STATUSES',700) entry_status, xxen_util.display_flexfield_context(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category) flexfield_context, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE1',mcce.rowid,mcce.attribute1) cc_attribute1, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE2',mcce.rowid,mcce.attribute2) cc_attribute2, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE3',mcce.rowid,mcce.attribute3) cc_attribute3, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE4',mcce.rowid,mcce.attribute4) cc_attribute4, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE5',mcce.rowid,mcce.attribute5) cc_attribute5, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE6',mcce.rowid,mcce.attribute6) cc_attribute6, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE7',mcce.rowid,mcce.attribute7) cc_attribute7, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE8',mcce.rowid,mcce.attribute8) cc_attribute8, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE9',mcce.rowid,mcce.attribute9) cc_attribute9, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE10',mcce.rowid,mcce.attribute10) cc_attribute10, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE11',mcce.rowid,mcce.attribute11) cc_attribute11, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE12',mcce.rowid,mcce.attribute12) cc_attribute12, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE13',mcce.rowid,mcce.attribute13) cc_attribute13, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE14',mcce.rowid,mcce.attribute14) cc_attribute14, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE15',mcce.rowid,mcce.attribute15) cc_attribute15, to_number(null) upload_row from mtl_parameters mp, mtl_cycle_count_headers mcch, mtl_cycle_count_entries mcce, 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=mcch.organization_id and mcch.cycle_count_header_id=mcce.cycle_count_header_id and mcce.entry_status_code in (1,3) and nvl(mcce.export_flag,2)=2 and mcce.inventory_item_id=msiv.inventory_item_id and mcce.organization_id=msiv.organization_id Initial version U A xxen_inv_upload.upload_cycle_count US INV Cycle Count Upload Enters counts for open cycle count requests and unscheduled counts, as the Cycle Count Entries window (Inventory > Counting > Cycle Counting > Cycle Count Entries). Download the open count requests of a cycle count, enter Count Quantity, Counted By and Count Date, and upload. The counts are processed by the cycle count open interface api: counts within the approval tolerances are adjusted right away, others go to Pending Approval or Recount according to the cycle count setup. Count Date must be in an open inventory period. New rows without a count request create an unscheduled count, where the cycle count allows unscheduled entries. Approving counts is done in the Approve Adjustments 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 mcch.cycle_count_header_name=:cycle_count LOV custom select mcch.cycle_count_header_name value, mcch.description from mtl_parameters mp, mtl_cycle_count_headers mcch where mp.organization_code=:$flex$.organization_code and mp.organization_id=mcch.organization_id and nvl(mcch.disable_date,sysdate+1)>sysdate order by mcch.cycle_count_header_name Y US Cycle Count 4 40 1=1 mcce.subinventory=:subinventory LOV custom select msi.secondary_inventory_name value, msi.description from mtl_parameters mp, mtl_secondary_inventories msi where mp.organization_code=:$flex$.organization_code and mp.organization_id=msi.organization_id order by msi.secondary_inventory_name US Subinventory 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 6 60 1=1 (mcce.entry_status_code=1 or :include_recounts='Y') LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual xxen_util.meaning('Y','YES_NO',0) US Include Recounts 39D35D706D9E4901B3839FAB5526CD3F Default Enters counts for the open count requests of a cycle count, without the descriptive flexfield. ENGINATICS 19 ADJUSTMENT_ACCOUNT 17 COUNTED_BY 18 COUNT_DATE 12 COUNT_QUANTITY 3 COUNT_SEQUENCE 2 CYCLE_COUNT 20 ENTRY_STATUS 4 ITEM 5 ITEM_DESCRIPTION Y 8 LOCATOR 9 LOT_NUMBER 1 ORGANIZATION_CODE 15 REASON 16 REFERENCE 6 REVISION 14 SECONDARY_COUNT_QUANTITY 13 SECONDARY_UOM 10 SERIAL_NUMBER 7 SUBINVENTORY 11 UOM Upload Mode C,U S Site ED9E20D85DA245A695414F8DB5BB512A Unscheduled Counts Opens an empty sheet to enter unscheduled counts for a cycle count. ENGINATICS 18 ADJUSTMENT_ACCOUNT 16 COUNTED_BY 17 COUNT_DATE 11 COUNT_QUANTITY 2 CYCLE_COUNT 3 ITEM 4 ITEM_DESCRIPTION Y 7 LOCATOR 8 LOT_NUMBER 1 ORGANIZATION_CODE 14 REASON 15 REFERENCE 5 REVISION 13 SECONDARY_COUNT_QUANTITY 12 SECONDARY_UOM 9 SERIAL_NUMBER 6 SUBINVENTORY 10 UOM Upload Mode C Y S Site Include Recounts Item Subinventory 39D35D706D9E4901B3839FAB5526CD3F 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 CYCLE_COUNT_ENTRY_ID Number number Y 6 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 7 CYCLE_COUNT LOV custom varchar2 select mcch.cycle_count_header_id id, mcch.cycle_count_header_name value, mcch.description from mtl_parameters mp, mtl_cycle_count_headers mcch where mp.organization_code=:$column$.organization_code and mp.organization_id=mcch.organization_id order by mcch.cycle_count_header_name :$flex$.cycle_count Y Y 8 COUNT_SEQUENCE Number number Y 9 ITEM LOV custom varchar2 select msiv.inventory_item_id id, msiv.concatenated_segments value, msiv.description from mtl_parameters mp, mtl_cycle_count_headers mcch, mtl_cycle_count_items mcci, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and mp.organization_id=mcch.organization_id and mcch.cycle_count_header_name=:$column$.cycle_count and mcch.cycle_count_header_id=mcci.cycle_count_header_id and mcci.inventory_item_id=msiv.inventory_item_id and mcch.organization_id=msiv.organization_id order by msiv.concatenated_segments Y 10 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 11 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 Y 12 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 msi.quantity_tracked=1 order by msi.secondary_inventory_name Y 13 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$.subinventory and nvl(milk.disable_date,sysdate+1)>sysdate order by milk.concatenated_segments Y 14 LOT_NUMBER LOV custom varchar2 Y 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 Y 15 SERIAL_NUMBER LOV custom varchar2 Y 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 order by msn.serial_number Y 16 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 Y 17 COUNT_QUANTITY Number number Y 18 SECONDARY_UOM Char varchar2 select msiv.secondary_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 Y 19 SECONDARY_COUNT_QUANTITY Number number 20 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 21 REFERENCE Char varchar2 22 COUNTED_BY LOV custom varchar2 select x.employee_id id, x.value, x.employee_num description from ( select mecv.employee_id, mecv.employee_num, case when count(*) over (partition by mecv.full_name)>1 then mecv.full_name||' ('||mecv.employee_num||')' else mecv.full_name end value from mtl_employees_current_view mecv where mecv.organization_id=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$column$.organization_code) ) x order by x.value 23 COUNT_DATE Date date sysdate 24 ADJUSTMENT_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 select gcck.concatenated_segments from mtl_parameters mp, mtl_cycle_count_headers mcch, gl_code_combinations_kfv gcck where mp.organization_code=:$column$.organization_code and mp.organization_id=mcch.organization_id and mcch.cycle_count_header_name=:$column$.cycle_count and mcch.inventory_adjustment_account=gcck.code_combination_id 25 ENTRY_STATUS Char varchar2 Y 26 FLEXFIELD_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_CYCLE_COUNT_ENTRIES' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 27 CC_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_CYCLE_COUNT_ENTRIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.cc_attribute1, p_attribute2=>:$column$.cc_attribute2, p_attribute3=>:$column$.cc_attribute3, p_attribute4=>:$column$.cc_attribute4, p_attribute5=>:$column$.cc_attribute5, p_attribute6=>:$column$.cc_attribute6, p_attribute7=>:$column$.cc_attribute7, p_attribute8=>:$column$.cc_attribute8, p_attribute9=>:$column$.cc_attribute9, p_attribute10=>:$column$.cc_attribute10, p_attribute11=>:$column$.cc_attribute11, p_attribute12=>:$column$.cc_attribute12, p_attribute13=>:$column$.cc_attribute13, p_attribute14=>:$column$.cc_attribute14, p_attribute15=>:$column$.cc_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_CYCLE_COUNT_ENTRIES' and fdfcuv.application_column_name = 'ATTRIBUTE1' 28 CC_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_CYCLE_COUNT_ENTRIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.cc_attribute1, p_attribute2=>:$column$.cc_attribute2, p_attribute3=>:$column$.cc_attribute3, p_attribute4=>:$column$.cc_attribute4, p_attribute5=>:$column$.cc_attribute5, p_attribute6=>:$column$.cc_attribute6, p_attribute7=>:$column$.cc_attribute7, p_attribute8=>:$column$.cc_attribute8, p_attribute9=>:$column$.cc_attribute9, p_attribute10=>:$column$.cc_attribute10, p_attribute11=>:$column$.cc_attribute11, p_attribute12=>:$column$.cc_attribute12, p_attribute13=>:$column$.cc_attribute13, p_attribute14=>:$column$.cc_attribute14, p_attribute15=>:$column$.cc_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_CYCLE_COUNT_ENTRIES' and fdfcuv.application_column_name = 'ATTRIBUTE2' 29 CC_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_CYCLE_COUNT_ENTRIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.cc_attribute1, p_attribute2=>:$column$.cc_attribute2, p_attribute3=>:$column$.cc_attribute3, p_attribute4=>:$column$.cc_attribute4, p_attribute5=>:$column$.cc_attribute5, p_attribute6=>:$column$.cc_attribute6, p_attribute7=>:$column$.cc_attribute7, p_attribute8=>:$column$.cc_attribute8, p_attribute9=>:$column$.cc_attribute9, p_attribute10=>:$column$.cc_attribute10, p_attribute11=>:$column$.cc_attribute11, p_attribute12=>:$column$.cc_attribute12, p_attribute13=>:$column$.cc_attribute13, p_attribute14=>:$column$.cc_attribute14, p_attribute15=>:$column$.cc_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_CYCLE_COUNT_ENTRIES' and fdfcuv.application_column_name = 'ATTRIBUTE3' 30 CC_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_CYCLE_COUNT_ENTRIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.cc_attribute1, p_attribute2=>:$column$.cc_attribute2, p_attribute3=>:$column$.cc_attribute3, p_attribute4=>:$column$.cc_attribute4, p_attribute5=>:$column$.cc_attribute5, p_attribute6=>:$column$.cc_attribute6, p_attribute7=>:$column$.cc_attribute7, p_attribute8=>:$column$.cc_attribute8, p_attribute9=>:$column$.cc_attribute9, p_attribute10=>:$column$.cc_attribute10, p_attribute11=>:$column$.cc_attribute11, p_attribute12=>:$column$.cc_attribute12, p_attribute13=>:$column$.cc_attribute13, p_attribute14=>:$column$.cc_attribute14, p_attribute15=>:$column$.cc_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_CYCLE_COUNT_ENTRIES' and fdfcuv.application_column_name = 'ATTRIBUTE4' 31 CC_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_CYCLE_COUNT_ENTRIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.cc_attribute1, p_attribute2=>:$column$.cc_attribute2, p_attribute3=>:$column$.cc_attribute3, p_attribute4=>:$column$.cc_attribute4, p_attribute5=>:$column$.cc_attribute5, p_attribute6=>:$column$.cc_attribute6, p_attribute7=>:$column$.cc_attribute7, p_attribute8=>:$column$.cc_attribute8, p_attribute9=>:$column$.cc_attribute9, p_attribute10=>:$column$.cc_attribute10, p_attribute11=>:$column$.cc_attribute11, p_attribute12=>:$column$.cc_attribute12, p_attribute13=>:$column$.cc_attribute13, p_attribute14=>:$column$.cc_attribute14, p_attribute15=>:$column$.cc_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_CYCLE_COUNT_ENTRIES' and fdfcuv.application_column_name = 'ATTRIBUTE5' 32 CC_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_CYCLE_COUNT_ENTRIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.cc_attribute1, p_attribute2=>:$column$.cc_attribute2, p_attribute3=>:$column$.cc_attribute3, p_attribute4=>:$column$.cc_attribute4, p_attribute5=>:$column$.cc_attribute5, p_attribute6=>:$column$.cc_attribute6, p_attribute7=>:$column$.cc_attribute7, p_attribute8=>:$column$.cc_attribute8, p_attribute9=>:$column$.cc_attribute9, p_attribute10=>:$column$.cc_attribute10, p_attribute11=>:$column$.cc_attribute11, p_attribute12=>:$column$.cc_attribute12, p_attribute13=>:$column$.cc_attribute13, p_attribute14=>:$column$.cc_attribute14, p_attribute15=>:$column$.cc_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_CYCLE_COUNT_ENTRIES' and fdfcuv.application_column_name = 'ATTRIBUTE6' 33 CC_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_CYCLE_COUNT_ENTRIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.cc_attribute1, p_attribute2=>:$column$.cc_attribute2, p_attribute3=>:$column$.cc_attribute3, p_attribute4=>:$column$.cc_attribute4, p_attribute5=>:$column$.cc_attribute5, p_attribute6=>:$column$.cc_attribute6, p_attribute7=>:$column$.cc_attribute7, p_attribute8=>:$column$.cc_attribute8, p_attribute9=>:$column$.cc_attribute9, p_attribute10=>:$column$.cc_attribute10, p_attribute11=>:$column$.cc_attribute11, p_attribute12=>:$column$.cc_attribute12, p_attribute13=>:$column$.cc_attribute13, p_attribute14=>:$column$.cc_attribute14, p_attribute15=>:$column$.cc_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_CYCLE_COUNT_ENTRIES' and fdfcuv.application_column_name = 'ATTRIBUTE7' 34 CC_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_CYCLE_COUNT_ENTRIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.cc_attribute1, p_attribute2=>:$column$.cc_attribute2, p_attribute3=>:$column$.cc_attribute3, p_attribute4=>:$column$.cc_attribute4, p_attribute5=>:$column$.cc_attribute5, p_attribute6=>:$column$.cc_attribute6, p_attribute7=>:$column$.cc_attribute7, p_attribute8=>:$column$.cc_attribute8, p_attribute9=>:$column$.cc_attribute9, p_attribute10=>:$column$.cc_attribute10, p_attribute11=>:$column$.cc_attribute11, p_attribute12=>:$column$.cc_attribute12, p_attribute13=>:$column$.cc_attribute13, p_attribute14=>:$column$.cc_attribute14, p_attribute15=>:$column$.cc_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_CYCLE_COUNT_ENTRIES' and fdfcuv.application_column_name = 'ATTRIBUTE8' 35 CC_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_CYCLE_COUNT_ENTRIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.cc_attribute1, p_attribute2=>:$column$.cc_attribute2, p_attribute3=>:$column$.cc_attribute3, p_attribute4=>:$column$.cc_attribute4, p_attribute5=>:$column$.cc_attribute5, p_attribute6=>:$column$.cc_attribute6, p_attribute7=>:$column$.cc_attribute7, p_attribute8=>:$column$.cc_attribute8, p_attribute9=>:$column$.cc_attribute9, p_attribute10=>:$column$.cc_attribute10, p_attribute11=>:$column$.cc_attribute11, p_attribute12=>:$column$.cc_attribute12, p_attribute13=>:$column$.cc_attribute13, p_attribute14=>:$column$.cc_attribute14, p_attribute15=>:$column$.cc_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_CYCLE_COUNT_ENTRIES' and fdfcuv.application_column_name = 'ATTRIBUTE9' 36 CC_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_CYCLE_COUNT_ENTRIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.cc_attribute1, p_attribute2=>:$column$.cc_attribute2, p_attribute3=>:$column$.cc_attribute3, p_attribute4=>:$column$.cc_attribute4, p_attribute5=>:$column$.cc_attribute5, p_attribute6=>:$column$.cc_attribute6, p_attribute7=>:$column$.cc_attribute7, p_attribute8=>:$column$.cc_attribute8, p_attribute9=>:$column$.cc_attribute9, p_attribute10=>:$column$.cc_attribute10, p_attribute11=>:$column$.cc_attribute11, p_attribute12=>:$column$.cc_attribute12, p_attribute13=>:$column$.cc_attribute13, p_attribute14=>:$column$.cc_attribute14, p_attribute15=>:$column$.cc_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_CYCLE_COUNT_ENTRIES' and fdfcuv.application_column_name = 'ATTRIBUTE10' 37 CC_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_CYCLE_COUNT_ENTRIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.cc_attribute1, p_attribute2=>:$column$.cc_attribute2, p_attribute3=>:$column$.cc_attribute3, p_attribute4=>:$column$.cc_attribute4, p_attribute5=>:$column$.cc_attribute5, p_attribute6=>:$column$.cc_attribute6, p_attribute7=>:$column$.cc_attribute7, p_attribute8=>:$column$.cc_attribute8, p_attribute9=>:$column$.cc_attribute9, p_attribute10=>:$column$.cc_attribute10, p_attribute11=>:$column$.cc_attribute11, p_attribute12=>:$column$.cc_attribute12, p_attribute13=>:$column$.cc_attribute13, p_attribute14=>:$column$.cc_attribute14, p_attribute15=>:$column$.cc_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_CYCLE_COUNT_ENTRIES' and fdfcuv.application_column_name = 'ATTRIBUTE11' 38 CC_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_CYCLE_COUNT_ENTRIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.cc_attribute1, p_attribute2=>:$column$.cc_attribute2, p_attribute3=>:$column$.cc_attribute3, p_attribute4=>:$column$.cc_attribute4, p_attribute5=>:$column$.cc_attribute5, p_attribute6=>:$column$.cc_attribute6, p_attribute7=>:$column$.cc_attribute7, p_attribute8=>:$column$.cc_attribute8, p_attribute9=>:$column$.cc_attribute9, p_attribute10=>:$column$.cc_attribute10, p_attribute11=>:$column$.cc_attribute11, p_attribute12=>:$column$.cc_attribute12, p_attribute13=>:$column$.cc_attribute13, p_attribute14=>:$column$.cc_attribute14, p_attribute15=>:$column$.cc_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_CYCLE_COUNT_ENTRIES' and fdfcuv.application_column_name = 'ATTRIBUTE12' 39 CC_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_CYCLE_COUNT_ENTRIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.cc_attribute1, p_attribute2=>:$column$.cc_attribute2, p_attribute3=>:$column$.cc_attribute3, p_attribute4=>:$column$.cc_attribute4, p_attribute5=>:$column$.cc_attribute5, p_attribute6=>:$column$.cc_attribute6, p_attribute7=>:$column$.cc_attribute7, p_attribute8=>:$column$.cc_attribute8, p_attribute9=>:$column$.cc_attribute9, p_attribute10=>:$column$.cc_attribute10, p_attribute11=>:$column$.cc_attribute11, p_attribute12=>:$column$.cc_attribute12, p_attribute13=>:$column$.cc_attribute13, p_attribute14=>:$column$.cc_attribute14, p_attribute15=>:$column$.cc_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_CYCLE_COUNT_ENTRIES' and fdfcuv.application_column_name = 'ATTRIBUTE13' 40 CC_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_CYCLE_COUNT_ENTRIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.cc_attribute1, p_attribute2=>:$column$.cc_attribute2, p_attribute3=>:$column$.cc_attribute3, p_attribute4=>:$column$.cc_attribute4, p_attribute5=>:$column$.cc_attribute5, p_attribute6=>:$column$.cc_attribute6, p_attribute7=>:$column$.cc_attribute7, p_attribute8=>:$column$.cc_attribute8, p_attribute9=>:$column$.cc_attribute9, p_attribute10=>:$column$.cc_attribute10, p_attribute11=>:$column$.cc_attribute11, p_attribute12=>:$column$.cc_attribute12, p_attribute13=>:$column$.cc_attribute13, p_attribute14=>:$column$.cc_attribute14, p_attribute15=>:$column$.cc_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_CYCLE_COUNT_ENTRIES' and fdfcuv.application_column_name = 'ATTRIBUTE14' 41 CC_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_CYCLE_COUNT_ENTRIES', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.cc_attribute1, p_attribute2=>:$column$.cc_attribute2, p_attribute3=>:$column$.cc_attribute3, p_attribute4=>:$column$.cc_attribute4, p_attribute5=>:$column$.cc_attribute5, p_attribute6=>:$column$.cc_attribute6, p_attribute7=>:$column$.cc_attribute7, p_attribute8=>:$column$.cc_attribute8, p_attribute9=>:$column$.cc_attribute9, p_attribute10=>:$column$.cc_attribute10, p_attribute11=>:$column$.cc_attribute11, p_attribute12=>:$column$.cc_attribute12, p_attribute13=>:$column$.cc_attribute13, p_attribute14=>:$column$.cc_attribute14, p_attribute15=>:$column$.cc_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_CYCLE_COUNT_ENTRIES' and fdfcuv.application_column_name = 'ATTRIBUTE15' 42 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_cycle_count_entry_id in Number Y CYCLE_COUNT_ENTRY_ID U 5 p_cycle_count_entry_id_out out Number CYCLE_COUNT_ENTRY_ID U 6 p_organization_id in Number ORGANIZATION_CODE U 7 p_cycle_count_header_id in Number CYCLE_COUNT U 8 p_inventory_item_id in Number Y ITEM U 9 p_revision in Char Y REVISION U 10 p_subinventory in Char Y SUBINVENTORY U 11 p_locator_id in Number Y LOCATOR U 12 p_lot_number in Char Y LOT_NUMBER U 13 p_serial_number in Char Y SERIAL_NUMBER U 14 p_count_uom in Char Y UOM U 15 p_count_quantity in Number Y COUNT_QUANTITY U 16 p_secondary_count_quantity in Number Y SECONDARY_COUNT_QUANTITY U 17 p_transaction_reason_id in Number Y REASON U 18 p_reference in Char Y REFERENCE U 19 p_employee_id in Number Y COUNTED_BY U 20 p_count_date in Date Y COUNT_DATE U 21 p_adjustment_account_id in Number Y ADJUSTMENT_ACCOUNT U 22 p_attribute_category in Char Y FLEXFIELD_CONTEXT U 23 p_cc_attribute1 in Char Y CC_ATTRIBUTE1 U 24 p_cc_attribute2 in Char Y CC_ATTRIBUTE2 U 25 p_cc_attribute3 in Char Y CC_ATTRIBUTE3 U 26 p_cc_attribute4 in Char Y CC_ATTRIBUTE4 U 27 p_cc_attribute5 in Char Y CC_ATTRIBUTE5 U 28 p_cc_attribute6 in Char Y CC_ATTRIBUTE6 U 29 p_cc_attribute7 in Char Y CC_ATTRIBUTE7 U 30 p_cc_attribute8 in Char Y CC_ATTRIBUTE8 U 31 p_cc_attribute9 in Char Y CC_ATTRIBUTE9 U 32 p_cc_attribute10 in Char Y CC_ATTRIBUTE10 U 33 p_cc_attribute11 in Char Y CC_ATTRIBUTE11 U 34 p_cc_attribute12 in Char Y CC_ATTRIBUTE12 U 35 p_cc_attribute13 in Char Y CC_ATTRIBUTE13 U 36 p_cc_attribute14 in Char Y CC_ATTRIBUTE14 U 37 p_cc_attribute15 in Char Y CC_ATTRIBUTE15 Error SQL Order By upload_row, organization_code, cycle_count, count_sequence Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, mcce.cycle_count_entry_id, mp.organization_code, mcch.cycle_count_header_name cycle_count, mcce.count_list_sequence count_sequence, msiv.concatenated_segments item, msiv.description item_description, mcce.revision, mcce.subinventory, (select milk.concatenated_segments from mtl_item_locations_kfv milk where mcce.locator_id=milk.inventory_location_id and mcce.organization_id=milk.organization_id) locator, mcce.lot_number, mcce.serial_number, nvl(mcce.count_uom_current,msiv.primary_uom_code) uom, mcce.count_quantity_current count_quantity, msiv.secondary_uom_code secondary_uom, mcce.secondary_uom_quantity_current secondary_count_quantity, (select mtr.reason_name from mtl_transaction_reasons mtr where mcce.transaction_reason_id=mtr.reason_id) reason, mcce.reference_current reference, case when mcce.counted_by_employee_id_current is not null then (select x.value from ( select mecv.employee_id, mecv.employee_num, case when count(*) over (partition by mecv.full_name)>1 then mecv.full_name||' ('||mecv.employee_num||')' else mecv.full_name end value from mtl_employees_current_view mecv where mecv.organization_id=mcce.organization_id ) x where mcce.counted_by_employee_id_current=x.employee_id) end counted_by, mcce.count_date_current count_date, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where nvl(mcce.inventory_adjustment_account,mcch.inventory_adjustment_account)=gcck.code_combination_id) adjustment_account, xxen_util.meaning(mcce.entry_status_code,'MTL_CC_ENTRY_STATUSES',700) entry_status, xxen_util.display_flexfield_context(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category) flexfield_context, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE1',mcce.rowid,mcce.attribute1) cc_attribute1, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE2',mcce.rowid,mcce.attribute2) cc_attribute2, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE3',mcce.rowid,mcce.attribute3) cc_attribute3, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE4',mcce.rowid,mcce.attribute4) cc_attribute4, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE5',mcce.rowid,mcce.attribute5) cc_attribute5, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE6',mcce.rowid,mcce.attribute6) cc_attribute6, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE7',mcce.rowid,mcce.attribute7) cc_attribute7, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE8',mcce.rowid,mcce.attribute8) cc_attribute8, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE9',mcce.rowid,mcce.attribute9) cc_attribute9, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE10',mcce.rowid,mcce.attribute10) cc_attribute10, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE11',mcce.rowid,mcce.attribute11) cc_attribute11, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE12',mcce.rowid,mcce.attribute12) cc_attribute12, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE13',mcce.rowid,mcce.attribute13) cc_attribute13, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE14',mcce.rowid,mcce.attribute14) cc_attribute14, xxen_util.display_flexfield_value(401,'MTL_CYCLE_COUNT_ENTRIES',mcce.attribute_category,'ATTRIBUTE15',mcce.rowid,mcce.attribute15) cc_attribute15, xu.upload_row from xxen_inv_cycle_count_up_2212_u xu, mtl_cycle_count_entries mcce, mtl_parameters mp, mtl_cycle_count_headers mcch, mtl_system_items_vl msiv where xu.status_code_=xxen_upload.status_success and xu.cycle_count_entry_id=mcce.cycle_count_entry_id and mcce.organization_id=mp.organization_id and mcce.cycle_count_header_id=mcch.cycle_count_header_id and mcce.inventory_item_id=msiv.inventory_item_id and mcce.organization_id=msiv.organization_id