ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 4029817952284B099668B388F54454D0Y select null action_, null status_, null message_, null modified_columns_, mkc.kanban_card_id, mp.organization_code, mkc.kanban_card_number card_number, msiv.concatenated_segments item, msiv.description item_description, mkc.subinventory_name subinventory, (select milk.concatenated_segments from mtl_item_locations_kfv milk where mkc.locator_id=milk.inventory_location_id and mkc.organization_id=milk.organization_id) locator, xxen_util.yes(decode(mkc.kanban_card_type,1,'Y')) replenishable, mkc.kanban_size, xxen_util.meaning(mkc.card_status,'MTL_KANBAN_CARD_STATUS',700) card_status, xxen_util.meaning(mkc.supply_status,'MTL_KANBAN_SUPPLY_STATUS',700) supply_status, mkc.last_print_date printed_on, xxen_util.meaning(mkc.error_code,'MTL_KANBAN_ERROR_CODE',700) error, xxen_util.meaning(mkc.source_type,'MTL_KANBAN_SOURCE_TYPE',700) source_type, (select aps.vendor_name from ap_suppliers aps where mkc.supplier_id=aps.vendor_id) supplier, (select assa.vendor_site_code from ap_supplier_sites_all assa where mkc.supplier_site_id=assa.vendor_site_id) supplier_site, (select mp_s.organization_code from mtl_parameters mp_s where mkc.source_organization_id=mp_s.organization_id) source_organization, mkc.source_subinventory, (select milk.concatenated_segments from mtl_item_locations_kfv milk where mkc.source_locator_id=milk.inventory_location_id and mkc.source_organization_id=milk.organization_id) source_locator, (select wl.line_code from wip_lines wl where mkc.wip_line_id=wl.line_id) line_code, xxen_util.display_flexfield_context(401,'MTL_KANBAN_CARDS',mkc.attribute_category) flexfield_context, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE1',mkc.rowid,mkc.attribute1) kb_attribute1, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE2',mkc.rowid,mkc.attribute2) kb_attribute2, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE3',mkc.rowid,mkc.attribute3) kb_attribute3, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE4',mkc.rowid,mkc.attribute4) kb_attribute4, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE5',mkc.rowid,mkc.attribute5) kb_attribute5, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE6',mkc.rowid,mkc.attribute6) kb_attribute6, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE7',mkc.rowid,mkc.attribute7) kb_attribute7, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE8',mkc.rowid,mkc.attribute8) kb_attribute8, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE9',mkc.rowid,mkc.attribute9) kb_attribute9, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE10',mkc.rowid,mkc.attribute10) kb_attribute10, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE11',mkc.rowid,mkc.attribute11) kb_attribute11, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE12',mkc.rowid,mkc.attribute12) kb_attribute12, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE13',mkc.rowid,mkc.attribute13) kb_attribute13, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE14',mkc.rowid,mkc.attribute14) kb_attribute14, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE15',mkc.rowid,mkc.attribute15) kb_attribute15, null delete_card, to_number(null) upload_row from mtl_parameters mp, mtl_kanban_cards mkc, 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=mkc.organization_id and mkc.inventory_item_id=msiv.inventory_item_id and mkc.organization_id=msiv.organization_id Initial version U A xxen_inv_upload.upload_kanban_card US INV Kanban Card Upload Creates kanban cards for existing pull sequences and updates the size, card status, supply status and descriptive flexfield of kanban cards, as the Kanban Cards window (Inventory > Kanban > Kanban Cards). A new card takes its source from the pull sequence of its item, subinventory and locator; leave Card Number blank to have it generated. Card and supply status changes follow the status transitions the form allows, and a supply status of Empty triggers the replenishment of the card. Cards can be deleted with Delete Card. 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 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 4 40 1=1 mkc.subinventory_name=: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 mkc.card_status=:card_status LOV custom select ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='MTL_KANBAN_CARD_STATUS' order by ml.lookup_code US Card Status 6 60 1=1 mkc.supply_status=:supply_status LOV custom select ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='MTL_KANBAN_SUPPLY_STATUS' order by ml.lookup_code US Supply Status 605B803D24D248548CC7103158071680 Card Status Change Changes the card status and supply status of existing kanban cards. ENGINATICS 2 CARD_NUMBER 8 CARD_STATUS 3 ITEM 4 ITEM_DESCRIPTION Y 7 KANBAN_SIZE 6 LOCATOR 1 ORGANIZATION_CODE 5 SUBINVENTORY 9 SUPPLY_STATUS Upload Mode C,U Y S Site 0C2EA9429D2844119C17879B8EAABB36 Create Cards Opens an empty sheet to create kanban cards for existing pull sequences. ENGINATICS 2 CARD_NUMBER 9 CARD_STATUS 3 ITEM 4 ITEM_DESCRIPTION Y 8 KANBAN_SIZE 6 LOCATOR 1 ORGANIZATION_CODE 7 REPLENISHABLE 5 SUBINVENTORY 10 SUPPLY_STATUS Upload Mode C Y S Site Card Status Item Subinventory Supply Status 87A74278C1E14669A44863FACF922ED9 Default Creates and updates kanban cards, without the descriptive flexfield. ENGINATICS 2 CARD_NUMBER 9 CARD_STATUS 20 DELETE_CARD 12 ERROR 3 ITEM 4 ITEM_DESCRIPTION Y 8 KANBAN_SIZE 19 LINE_CODE 6 LOCATOR 1 ORGANIZATION_CODE 11 PRINTED_ON 7 REPLENISHABLE 18 SOURCE_LOCATOR 16 SOURCE_ORGANIZATION 17 SOURCE_SUBINVENTORY 13 SOURCE_TYPE 5 SUBINVENTORY 14 SUPPLIER 15 SUPPLIER_SITE 10 SUPPLY_STATUS Upload Mode C,U S Site 87A74278C1E14669A44863FACF922ED9 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 KANBAN_CARD_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 CARD_NUMBER Char varchar2 Leave blank on a new card to have the number generated. Y 8 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.inventory_item_id in (select mkps.inventory_item_id from mtl_kanban_pull_sequences mkps where mkps.organization_id=mp.organization_id and mkps.kanban_plan_id=-1) order by msiv.concatenated_segments Y Y 9 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 10 SUBINVENTORY LOV custom varchar2 select distinct mkps.subinventory_name value, null description from mtl_parameters mp, mtl_system_items_vl msiv, mtl_kanban_pull_sequences mkps where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.item and msiv.organization_id=mkps.organization_id and msiv.inventory_item_id=mkps.inventory_item_id and mkps.kanban_plan_id=-1 order by mkps.subinventory_name Y Y 11 LOCATOR LOV custom varchar2 select milk.inventory_location_id id, milk.concatenated_segments value, milk.description from mtl_parameters mp, mtl_system_items_vl msiv, mtl_kanban_pull_sequences mkps, mtl_item_locations_kfv milk where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.item and msiv.organization_id=mkps.organization_id and msiv.inventory_item_id=mkps.inventory_item_id and mkps.subinventory_name=:$column$.subinventory and mkps.kanban_plan_id=-1 and mkps.locator_id=milk.inventory_location_id and mkps.organization_id=milk.organization_id order by milk.concatenated_segments Y 12 REPLENISHABLE LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual xxen_util.meaning('Y','YES_NO',0) Y 13 KANBAN_SIZE Number number select mkps.kanban_size from mtl_parameters mp, mtl_system_items_vl msiv, mtl_kanban_pull_sequences mkps where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.item and msiv.organization_id=mkps.organization_id and msiv.inventory_item_id=mkps.inventory_item_id and mkps.subinventory_name=:$column$.subinventory and mkps.kanban_plan_id=-1 and rownum=1 14 CARD_STATUS LOV custom varchar2 select ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='MTL_KANBAN_CARD_STATUS' and ml.lookup_code in (1,2,3) order by ml.lookup_code xxen_util.meaning(1,'MTL_KANBAN_CARD_STATUS',700) Y 15 SUPPLY_STATUS LOV custom varchar2 select ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='MTL_KANBAN_SUPPLY_STATUS' order by ml.lookup_code xxen_util.meaning(1,'MTL_KANBAN_SUPPLY_STATUS',700) Y 16 PRINTED_ON Date date Y 17 ERROR Char varchar2 Y 18 SOURCE_TYPE Char varchar2 Y 19 SUPPLIER Char varchar2 Y 20 SUPPLIER_SITE Char varchar2 Y 21 SOURCE_ORGANIZATION Char varchar2 Y 22 SOURCE_SUBINVENTORY Char varchar2 Y 23 SOURCE_LOCATOR Char varchar2 Y 24 LINE_CODE Char varchar2 Y 25 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_KANBAN_CARDS' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 26 KB_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_KANBAN_CARDS', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.kb_attribute1, p_attribute2=>:$column$.kb_attribute2, p_attribute3=>:$column$.kb_attribute3, p_attribute4=>:$column$.kb_attribute4, p_attribute5=>:$column$.kb_attribute5, p_attribute6=>:$column$.kb_attribute6, p_attribute7=>:$column$.kb_attribute7, p_attribute8=>:$column$.kb_attribute8, p_attribute9=>:$column$.kb_attribute9, p_attribute10=>:$column$.kb_attribute10, p_attribute11=>:$column$.kb_attribute11, p_attribute12=>:$column$.kb_attribute12, p_attribute13=>:$column$.kb_attribute13, p_attribute14=>:$column$.kb_attribute14, p_attribute15=>:$column$.kb_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_KANBAN_CARDS' and fdfcuv.application_column_name = 'ATTRIBUTE1' 27 KB_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_KANBAN_CARDS', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.kb_attribute1, p_attribute2=>:$column$.kb_attribute2, p_attribute3=>:$column$.kb_attribute3, p_attribute4=>:$column$.kb_attribute4, p_attribute5=>:$column$.kb_attribute5, p_attribute6=>:$column$.kb_attribute6, p_attribute7=>:$column$.kb_attribute7, p_attribute8=>:$column$.kb_attribute8, p_attribute9=>:$column$.kb_attribute9, p_attribute10=>:$column$.kb_attribute10, p_attribute11=>:$column$.kb_attribute11, p_attribute12=>:$column$.kb_attribute12, p_attribute13=>:$column$.kb_attribute13, p_attribute14=>:$column$.kb_attribute14, p_attribute15=>:$column$.kb_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_KANBAN_CARDS' and fdfcuv.application_column_name = 'ATTRIBUTE2' 28 KB_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_KANBAN_CARDS', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.kb_attribute1, p_attribute2=>:$column$.kb_attribute2, p_attribute3=>:$column$.kb_attribute3, p_attribute4=>:$column$.kb_attribute4, p_attribute5=>:$column$.kb_attribute5, p_attribute6=>:$column$.kb_attribute6, p_attribute7=>:$column$.kb_attribute7, p_attribute8=>:$column$.kb_attribute8, p_attribute9=>:$column$.kb_attribute9, p_attribute10=>:$column$.kb_attribute10, p_attribute11=>:$column$.kb_attribute11, p_attribute12=>:$column$.kb_attribute12, p_attribute13=>:$column$.kb_attribute13, p_attribute14=>:$column$.kb_attribute14, p_attribute15=>:$column$.kb_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_KANBAN_CARDS' and fdfcuv.application_column_name = 'ATTRIBUTE3' 29 KB_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_KANBAN_CARDS', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.kb_attribute1, p_attribute2=>:$column$.kb_attribute2, p_attribute3=>:$column$.kb_attribute3, p_attribute4=>:$column$.kb_attribute4, p_attribute5=>:$column$.kb_attribute5, p_attribute6=>:$column$.kb_attribute6, p_attribute7=>:$column$.kb_attribute7, p_attribute8=>:$column$.kb_attribute8, p_attribute9=>:$column$.kb_attribute9, p_attribute10=>:$column$.kb_attribute10, p_attribute11=>:$column$.kb_attribute11, p_attribute12=>:$column$.kb_attribute12, p_attribute13=>:$column$.kb_attribute13, p_attribute14=>:$column$.kb_attribute14, p_attribute15=>:$column$.kb_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_KANBAN_CARDS' and fdfcuv.application_column_name = 'ATTRIBUTE4' 30 KB_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_KANBAN_CARDS', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.kb_attribute1, p_attribute2=>:$column$.kb_attribute2, p_attribute3=>:$column$.kb_attribute3, p_attribute4=>:$column$.kb_attribute4, p_attribute5=>:$column$.kb_attribute5, p_attribute6=>:$column$.kb_attribute6, p_attribute7=>:$column$.kb_attribute7, p_attribute8=>:$column$.kb_attribute8, p_attribute9=>:$column$.kb_attribute9, p_attribute10=>:$column$.kb_attribute10, p_attribute11=>:$column$.kb_attribute11, p_attribute12=>:$column$.kb_attribute12, p_attribute13=>:$column$.kb_attribute13, p_attribute14=>:$column$.kb_attribute14, p_attribute15=>:$column$.kb_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_KANBAN_CARDS' and fdfcuv.application_column_name = 'ATTRIBUTE5' 31 KB_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_KANBAN_CARDS', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.kb_attribute1, p_attribute2=>:$column$.kb_attribute2, p_attribute3=>:$column$.kb_attribute3, p_attribute4=>:$column$.kb_attribute4, p_attribute5=>:$column$.kb_attribute5, p_attribute6=>:$column$.kb_attribute6, p_attribute7=>:$column$.kb_attribute7, p_attribute8=>:$column$.kb_attribute8, p_attribute9=>:$column$.kb_attribute9, p_attribute10=>:$column$.kb_attribute10, p_attribute11=>:$column$.kb_attribute11, p_attribute12=>:$column$.kb_attribute12, p_attribute13=>:$column$.kb_attribute13, p_attribute14=>:$column$.kb_attribute14, p_attribute15=>:$column$.kb_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_KANBAN_CARDS' and fdfcuv.application_column_name = 'ATTRIBUTE6' 32 KB_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_KANBAN_CARDS', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.kb_attribute1, p_attribute2=>:$column$.kb_attribute2, p_attribute3=>:$column$.kb_attribute3, p_attribute4=>:$column$.kb_attribute4, p_attribute5=>:$column$.kb_attribute5, p_attribute6=>:$column$.kb_attribute6, p_attribute7=>:$column$.kb_attribute7, p_attribute8=>:$column$.kb_attribute8, p_attribute9=>:$column$.kb_attribute9, p_attribute10=>:$column$.kb_attribute10, p_attribute11=>:$column$.kb_attribute11, p_attribute12=>:$column$.kb_attribute12, p_attribute13=>:$column$.kb_attribute13, p_attribute14=>:$column$.kb_attribute14, p_attribute15=>:$column$.kb_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_KANBAN_CARDS' and fdfcuv.application_column_name = 'ATTRIBUTE7' 33 KB_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_KANBAN_CARDS', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.kb_attribute1, p_attribute2=>:$column$.kb_attribute2, p_attribute3=>:$column$.kb_attribute3, p_attribute4=>:$column$.kb_attribute4, p_attribute5=>:$column$.kb_attribute5, p_attribute6=>:$column$.kb_attribute6, p_attribute7=>:$column$.kb_attribute7, p_attribute8=>:$column$.kb_attribute8, p_attribute9=>:$column$.kb_attribute9, p_attribute10=>:$column$.kb_attribute10, p_attribute11=>:$column$.kb_attribute11, p_attribute12=>:$column$.kb_attribute12, p_attribute13=>:$column$.kb_attribute13, p_attribute14=>:$column$.kb_attribute14, p_attribute15=>:$column$.kb_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_KANBAN_CARDS' and fdfcuv.application_column_name = 'ATTRIBUTE8' 34 KB_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_KANBAN_CARDS', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.kb_attribute1, p_attribute2=>:$column$.kb_attribute2, p_attribute3=>:$column$.kb_attribute3, p_attribute4=>:$column$.kb_attribute4, p_attribute5=>:$column$.kb_attribute5, p_attribute6=>:$column$.kb_attribute6, p_attribute7=>:$column$.kb_attribute7, p_attribute8=>:$column$.kb_attribute8, p_attribute9=>:$column$.kb_attribute9, p_attribute10=>:$column$.kb_attribute10, p_attribute11=>:$column$.kb_attribute11, p_attribute12=>:$column$.kb_attribute12, p_attribute13=>:$column$.kb_attribute13, p_attribute14=>:$column$.kb_attribute14, p_attribute15=>:$column$.kb_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_KANBAN_CARDS' and fdfcuv.application_column_name = 'ATTRIBUTE9' 35 KB_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_KANBAN_CARDS', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.kb_attribute1, p_attribute2=>:$column$.kb_attribute2, p_attribute3=>:$column$.kb_attribute3, p_attribute4=>:$column$.kb_attribute4, p_attribute5=>:$column$.kb_attribute5, p_attribute6=>:$column$.kb_attribute6, p_attribute7=>:$column$.kb_attribute7, p_attribute8=>:$column$.kb_attribute8, p_attribute9=>:$column$.kb_attribute9, p_attribute10=>:$column$.kb_attribute10, p_attribute11=>:$column$.kb_attribute11, p_attribute12=>:$column$.kb_attribute12, p_attribute13=>:$column$.kb_attribute13, p_attribute14=>:$column$.kb_attribute14, p_attribute15=>:$column$.kb_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_KANBAN_CARDS' and fdfcuv.application_column_name = 'ATTRIBUTE10' 36 KB_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_KANBAN_CARDS', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.kb_attribute1, p_attribute2=>:$column$.kb_attribute2, p_attribute3=>:$column$.kb_attribute3, p_attribute4=>:$column$.kb_attribute4, p_attribute5=>:$column$.kb_attribute5, p_attribute6=>:$column$.kb_attribute6, p_attribute7=>:$column$.kb_attribute7, p_attribute8=>:$column$.kb_attribute8, p_attribute9=>:$column$.kb_attribute9, p_attribute10=>:$column$.kb_attribute10, p_attribute11=>:$column$.kb_attribute11, p_attribute12=>:$column$.kb_attribute12, p_attribute13=>:$column$.kb_attribute13, p_attribute14=>:$column$.kb_attribute14, p_attribute15=>:$column$.kb_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_KANBAN_CARDS' and fdfcuv.application_column_name = 'ATTRIBUTE11' 37 KB_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_KANBAN_CARDS', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.kb_attribute1, p_attribute2=>:$column$.kb_attribute2, p_attribute3=>:$column$.kb_attribute3, p_attribute4=>:$column$.kb_attribute4, p_attribute5=>:$column$.kb_attribute5, p_attribute6=>:$column$.kb_attribute6, p_attribute7=>:$column$.kb_attribute7, p_attribute8=>:$column$.kb_attribute8, p_attribute9=>:$column$.kb_attribute9, p_attribute10=>:$column$.kb_attribute10, p_attribute11=>:$column$.kb_attribute11, p_attribute12=>:$column$.kb_attribute12, p_attribute13=>:$column$.kb_attribute13, p_attribute14=>:$column$.kb_attribute14, p_attribute15=>:$column$.kb_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_KANBAN_CARDS' and fdfcuv.application_column_name = 'ATTRIBUTE12' 38 KB_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_KANBAN_CARDS', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.kb_attribute1, p_attribute2=>:$column$.kb_attribute2, p_attribute3=>:$column$.kb_attribute3, p_attribute4=>:$column$.kb_attribute4, p_attribute5=>:$column$.kb_attribute5, p_attribute6=>:$column$.kb_attribute6, p_attribute7=>:$column$.kb_attribute7, p_attribute8=>:$column$.kb_attribute8, p_attribute9=>:$column$.kb_attribute9, p_attribute10=>:$column$.kb_attribute10, p_attribute11=>:$column$.kb_attribute11, p_attribute12=>:$column$.kb_attribute12, p_attribute13=>:$column$.kb_attribute13, p_attribute14=>:$column$.kb_attribute14, p_attribute15=>:$column$.kb_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_KANBAN_CARDS' and fdfcuv.application_column_name = 'ATTRIBUTE13' 39 KB_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_KANBAN_CARDS', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.kb_attribute1, p_attribute2=>:$column$.kb_attribute2, p_attribute3=>:$column$.kb_attribute3, p_attribute4=>:$column$.kb_attribute4, p_attribute5=>:$column$.kb_attribute5, p_attribute6=>:$column$.kb_attribute6, p_attribute7=>:$column$.kb_attribute7, p_attribute8=>:$column$.kb_attribute8, p_attribute9=>:$column$.kb_attribute9, p_attribute10=>:$column$.kb_attribute10, p_attribute11=>:$column$.kb_attribute11, p_attribute12=>:$column$.kb_attribute12, p_attribute13=>:$column$.kb_attribute13, p_attribute14=>:$column$.kb_attribute14, p_attribute15=>:$column$.kb_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_KANBAN_CARDS' and fdfcuv.application_column_name = 'ATTRIBUTE14' 40 KB_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_KANBAN_CARDS', p_context_name=>:$column$.flexfield_context, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.kb_attribute1, p_attribute2=>:$column$.kb_attribute2, p_attribute3=>:$column$.kb_attribute3, p_attribute4=>:$column$.kb_attribute4, p_attribute5=>:$column$.kb_attribute5, p_attribute6=>:$column$.kb_attribute6, p_attribute7=>:$column$.kb_attribute7, p_attribute8=>:$column$.kb_attribute8, p_attribute9=>:$column$.kb_attribute9, p_attribute10=>:$column$.kb_attribute10, p_attribute11=>:$column$.kb_attribute11, p_attribute12=>:$column$.kb_attribute12, p_attribute13=>:$column$.kb_attribute13, p_attribute14=>:$column$.kb_attribute14, p_attribute15=>:$column$.kb_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_KANBAN_CARDS' and fdfcuv.application_column_name = 'ATTRIBUTE15' 41 DELETE_CARD LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 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_kanban_card_id in Number Y KANBAN_CARD_ID U 5 p_kanban_card_id_out out Number KANBAN_CARD_ID U 6 p_organization_id in Number ORGANIZATION_CODE U 7 p_card_number in Char Y CARD_NUMBER U 8 p_inventory_item_id in Number Y ITEM U 9 p_subinventory in Char Y SUBINVENTORY U 10 p_locator_id in Number Y LOCATOR U 11 p_replenishable in Char Y REPLENISHABLE U 12 p_kanban_size in Number Y KANBAN_SIZE U 13 p_card_status in Number Y CARD_STATUS U 14 p_supply_status in Number Y SUPPLY_STATUS U 15 p_attribute_category in Char Y FLEXFIELD_CONTEXT U 16 p_kb_attribute1 in Char Y KB_ATTRIBUTE1 U 17 p_kb_attribute2 in Char Y KB_ATTRIBUTE2 U 18 p_kb_attribute3 in Char Y KB_ATTRIBUTE3 U 19 p_kb_attribute4 in Char Y KB_ATTRIBUTE4 U 20 p_kb_attribute5 in Char Y KB_ATTRIBUTE5 U 21 p_kb_attribute6 in Char Y KB_ATTRIBUTE6 U 22 p_kb_attribute7 in Char Y KB_ATTRIBUTE7 U 23 p_kb_attribute8 in Char Y KB_ATTRIBUTE8 U 24 p_kb_attribute9 in Char Y KB_ATTRIBUTE9 U 25 p_kb_attribute10 in Char Y KB_ATTRIBUTE10 U 26 p_kb_attribute11 in Char Y KB_ATTRIBUTE11 U 27 p_kb_attribute12 in Char Y KB_ATTRIBUTE12 U 28 p_kb_attribute13 in Char Y KB_ATTRIBUTE13 U 29 p_kb_attribute14 in Char Y KB_ATTRIBUTE14 U 30 p_kb_attribute15 in Char Y KB_ATTRIBUTE15 U 31 p_delete_card in Char Y DELETE_CARD Error SQL Order By upload_row, organization_code, item, card_number Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, nvl(mkc.kanban_card_id,xu.kanban_card_id) kanban_card_id, xu.organization_code, nvl(mkc.kanban_card_number,xu.card_number) card_number, nvl(msiv.concatenated_segments,xu.item) item, nvl(msiv.description,xu.item_description) item_description, mkc.subinventory_name subinventory, (select milk.concatenated_segments from mtl_item_locations_kfv milk where mkc.locator_id=milk.inventory_location_id and mkc.organization_id=milk.organization_id) locator, xxen_util.yes(decode(mkc.kanban_card_type,1,'Y')) replenishable, mkc.kanban_size, xxen_util.meaning(mkc.card_status,'MTL_KANBAN_CARD_STATUS',700) card_status, xxen_util.meaning(mkc.supply_status,'MTL_KANBAN_SUPPLY_STATUS',700) supply_status, mkc.last_print_date printed_on, xxen_util.meaning(mkc.error_code,'MTL_KANBAN_ERROR_CODE',700) error, xxen_util.meaning(mkc.source_type,'MTL_KANBAN_SOURCE_TYPE',700) source_type, (select aps.vendor_name from ap_suppliers aps where mkc.supplier_id=aps.vendor_id) supplier, (select assa.vendor_site_code from ap_supplier_sites_all assa where mkc.supplier_site_id=assa.vendor_site_id) supplier_site, (select mp_s.organization_code from mtl_parameters mp_s where mkc.source_organization_id=mp_s.organization_id) source_organization, mkc.source_subinventory, (select milk.concatenated_segments from mtl_item_locations_kfv milk where mkc.source_locator_id=milk.inventory_location_id and mkc.source_organization_id=milk.organization_id) source_locator, (select wl.line_code from wip_lines wl where mkc.wip_line_id=wl.line_id) line_code, xxen_util.display_flexfield_context(401,'MTL_KANBAN_CARDS',mkc.attribute_category) flexfield_context, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE1',mkc.rowid,mkc.attribute1) kb_attribute1, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE2',mkc.rowid,mkc.attribute2) kb_attribute2, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE3',mkc.rowid,mkc.attribute3) kb_attribute3, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE4',mkc.rowid,mkc.attribute4) kb_attribute4, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE5',mkc.rowid,mkc.attribute5) kb_attribute5, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE6',mkc.rowid,mkc.attribute6) kb_attribute6, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE7',mkc.rowid,mkc.attribute7) kb_attribute7, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE8',mkc.rowid,mkc.attribute8) kb_attribute8, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE9',mkc.rowid,mkc.attribute9) kb_attribute9, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE10',mkc.rowid,mkc.attribute10) kb_attribute10, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE11',mkc.rowid,mkc.attribute11) kb_attribute11, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE12',mkc.rowid,mkc.attribute12) kb_attribute12, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE13',mkc.rowid,mkc.attribute13) kb_attribute13, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE14',mkc.rowid,mkc.attribute14) kb_attribute14, xxen_util.display_flexfield_value(401,'MTL_KANBAN_CARDS',mkc.attribute_category,'ATTRIBUTE15',mkc.rowid,mkc.attribute15) kb_attribute15, xu.delete_card, xu.upload_row from xxen_inv_kanban_card_up_5567_u xu, mtl_kanban_cards mkc, mtl_system_items_vl msiv where xu.status_code_=xxen_upload.status_success and xu.kanban_card_id=mkc.kanban_card_id(+) and mkc.inventory_item_id=msiv.inventory_item_id(+) and mkc.organization_id=msiv.organization_id(+)