ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE7F79D2E0530100007F1FF2 AR Account Number Y Y select hca.account_number value, hp.party_name||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name US 8E2FF36EDE8679D2E0530100007F1FF2 AR Customer Name Y select hp.party_name value, hca.account_number||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name US E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y 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 US 8E2FF36EDE8879D2E0530100007F1FF2 HR Operating Unit (all) Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) order by hou.name US 8E2FF36EDECB79D2E0530100007F1FF2 INV Category Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mcv.structure_id order by mcv.category_concat_segs US 8E2FF36EDEA279D2E0530100007F1FF2 INV Organization Code (all) Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id 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 and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code US All active inventory organization codes 92EDCA82621F0FBDE053BB6B6358DEED MRP Assignment Set Y select mas.assignment_set_name value, mas.description from mrp_assignment_sets mas order by mas.assignment_set_name US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 0C1D83C933980FC0E06362FB09058616Y select null action_, null status_, null message_, null request_id_, null modified_columns_, null set_row_id, null ass_row_id, :p_upload_mode upload_mode, :p_bypass_dff_validation bypass_dff_validation, -- assignment set mas.assignment_set_name assignment_set, mas.description assignment_set_description, -- assignment case mrav.assignment_type when 1 then 'Global' when 2 then 'Category' when 3 then 'Item' when 4 then 'Organization' when 5 then 'Category-Organization' when 6 then 'Item-Organization' end assignment_type, mrav.organization_code organization, msiv.concatenated_segments item, case when mrav.assignment_type in (2,5) then mrav.entity_name else null end category, case when mrav.assignment_type in (3,6) then msiv.description else mrav.description end description, mrav.customer_name, hca.account_number customer_number, hcsua.location customer_site, xxen_util.meaning(hcsua.site_use_code,'SITE_USE_CODE',222) customer_site_use, haouv.name customer_site_ou, mrav.ship_to_address, mrav.sourcing_rule_type_text sourcing_rule_type, mrav.sourcing_rule_name, mp.organization_code sourcing_rule_org, -- attributes xxen_util.display_flexfield_context(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category) set_attribute_category, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE1',mas.rowid,mas.attribute1) sr_set_attribute1, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE2',mas.rowid,mas.attribute2) sr_set_attribute2, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE3',mas.rowid,mas.attribute3) sr_set_attribute3, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE4',mas.rowid,mas.attribute4) sr_set_attribute4, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE5',mas.rowid,mas.attribute5) sr_set_attribute5, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE6',mas.rowid,mas.attribute6) sr_set_attribute6, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE7',mas.rowid,mas.attribute7) sr_set_attribute7, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE8',mas.rowid,mas.attribute8) sr_set_attribute8, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE9',mas.rowid,mas.attribute9) sr_set_attribute9, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE10',mas.rowid,mas.attribute10) sr_set_attribute10, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE11',mas.rowid,mas.attribute11) sr_set_attribute11, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE12',mas.rowid,mas.attribute12) sr_set_attribute12, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE13',mas.rowid,mas.attribute13) sr_set_attribute13, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE14',mas.rowid,mas.attribute14) sr_set_attribute14, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE15',mas.rowid,mas.attribute15) sr_set_attribute15, -- xxen_util.display_flexfield_context(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category) assign_attribute_category, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE1',mrav.row_id,mrav.attribute1) sr_assign_attribute1, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE2',mrav.row_id,mrav.attribute2) sr_assign_attribute2, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE3',mrav.row_id,mrav.attribute3) sr_assign_attribute3, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE4',mrav.row_id,mrav.attribute4) sr_assign_attribute4, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE5',mrav.row_id,mrav.attribute5) sr_assign_attribute5, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE6',mrav.row_id,mrav.attribute6) sr_assign_attribute6, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE7',mrav.row_id,mrav.attribute7) sr_assign_attribute7, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE8',mrav.row_id,mrav.attribute8) sr_assign_attribute8, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE9',mrav.row_id,mrav.attribute9) sr_assign_attribute9, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE10',mrav.row_id,mrav.attribute10) sr_assign_attribute10, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE11',mrav.row_id,mrav.attribute11) sr_assign_attribute11, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE12',mrav.row_id,mrav.attribute12) sr_assign_attribute12, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE13',mrav.row_id,mrav.attribute13) sr_assign_attribute13, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE14',mrav.row_id,mrav.attribute14) sr_assign_attribute14, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE15',mrav.row_id,mrav.attribute15) sr_assign_attribute15, -- null delete_option, -- ids mas.assignment_set_id, mrav.assignment_id, mrav.sourcing_rule_id, mrav.assignment_type assignment_type_id, :p_master_org_id master_organization_id from mrp_assignment_sets mas, mrp_sr_assignments_v mrav, mrp_sourcing_rules msr, mtl_parameters mp, mtl_system_items_vl msiv, hz_cust_accounts hca, hz_cust_site_uses_all hcsua, hr_all_organization_units_vl haouv where 1=1 and :p_master_org_code is not null and mas.assignment_set_id = mrav.assignment_set_id and mrav.sourcing_rule_id = msr.sourcing_rule_id (+) and msr.organization_id = mp.organization_id (+) and case when mrav.assignment_type in (3,6) then nvl(mrav.organization_id,:p_master_org_id) else null end = msiv.organization_id (+) and case when mrav.assignment_type in (3,6) then mrav.inventory_item_id else null end = msiv.inventory_item_id (+) and mrav.customer_id = hca.cust_account_id (+) and mrav.ship_to_site_id = hcsua.site_use_id (+) and hcsua.org_id = haouv.organization_id (+) and (mrav.assignment_type in (1,2,4,5) or mrav.organization_id is not null or (mrav.assignment_type in (3,6) and mrav.organization_id is null and exists (select null from mtl_system_items_b msib where msib.organization_id = :p_master_org_id and msib.inventory_item_id = mrav.inventory_item_id) ) ) U A xxen_mrp_upload.upload_sourcing_rule_assignmt US MRP Sourcing Rule Assignment Upload MRP Sourcing Rule Assignment Upload ============================= - Upload new Assignment Sets and Sourcing Rule Assignments - Update Existing Assignment Sets and Sourcing Rule Assignments Notes: If an Assignment Organization is specified, then this determines the selecatable items. If an Assignment Organization is not specified, then the Master Organization determines the selectable Items. The selectable Assignment Organizations is not restricted by the Master Organization. This is the same logic as used in the Sourcing Assignments form Enginatics Upload 1=1 :p_bypass_dff_validation :p_master_org_code :p_master_org_id :p_upload_mode 1 -40 :p_master_org_id Number select mp.organization_id from mtl_parameters mp where mp.organization_code = :$flex$.Master_Organization_Code Y US Master Organization ID 2 -30 1=1 :p_category_set is not null Char select mcs.category_set_name from mtl_category_sets mcs where mcs.category_set_id = to_number(fnd_profile.value('MRP_SRA_CATEGORY_SET')) Y US Category Set 3 -20 :p_bypass_dff_validation LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Bypass DFF Validation 4 10 :p_master_org_code LOV custom Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where ood.organization_id in (select distinct mp.master_organization_id from mtl_parameters mp 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 nvl(ood.disable_date,sysdate)>=sysdate order by ood.organization_code select mpm.organization_code from mtl_parameters mp, mtl_parameters mpm where mp.master_organization_id = mpm.organization_id and mp.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') Y US Master Organization Code 5 20 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y 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 Y US Upload Mode 6 30 1=1 mas.assignment_set_name = :p_assign_set_name LOV MRP Assignment Set 92EDCA82621F0FBDE053BB6B6358DEED Y select mas.assignment_set_name value, mas.description from mrp_assignment_sets mas order by mas.assignment_set_name US Assignment Set 7 40 1=1 case mrav.assignment_type when 1 then 'Global' when 2 then 'Category' when 3 then 'Item' when 4 then 'Organization' when 5 then 'Category-Organization' when 6 then 'Item-Organization' end = :p_assign_type LOV custom Y select x.value, null description from ( select '1' id, 'Global' value from dual union all select '2' id, 'Category' value from dual where :$flex$.category_set is not null and (select mcs.control_level from mtl_category_sets mcs where mcs.category_set_name = :$flex$.category_set) != 2 union all select '3' id, 'Item' value from dual union all select '4' id, 'Organization' value from dual union all select '5' id, 'Category-Organization' value from dual where :$flex$.category_set is not null union all select '6' id, 'Item-Organization' value from dual ) x order by x.value US Assignment Type 8 50 1=1 mrav.sourcing_rule_type_text = :p_src_rule_type LOV custom Y select ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type = 'MRP_SOURCING_RULE_TYPE' and ml.lookup_code in (1, 2) and (:$flex$.assignment_type is null or (:$flex$.assignment_type in ('Global', 'Category', 'Item') and ml.lookup_code in (1, 2)) or (:$flex$.assignment_type in ('Organization', 'Category-Organization', 'Item-Organization') and ml.lookup_code = 1) ) order by value US Sourcing Rule Type 9 60 1=1 mrav.sourcing_rule_name = :p_src_rule_name LOV custom Y select mrs.sourcing_rule_name value, mrs.description || ' (' || xxen_util.meaning(mrs.sourcing_rule_type,'MRP_SOURCING_RULE_TYPE',700) || ')' || decode(mrs.sourcing_rule_type,1,' (' || nvl(mp.organization_code,'All Orgs') || ')') description from mrp_sourcing_rules mrs, mtl_parameters mp where mp.organization_id (+) = mrs.organization_id and (:$flex$.Sourcing_Rule_Type is null or xxen_util.contains(:$flex$.Sourcing_Rule_Type,xxen_util.meaning(mrs.sourcing_rule_type,'MRP_SOURCING_RULE_TYPE',700)) = 'Y' ) and (:$flex$.Sourcing_Rule_Organization is null or xxen_util.contains(:$flex$.Sourcing_Rule_Organization,mp.organization_code) = 'Y' ) order by value US Sourcing Rule Name 10 70 1=1 mrav.organization_code = :p_assign_org LOV INV Organization Code (all) 8E2FF36EDEA279D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id 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 and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code US Organization Code 11 80 1=1 (mrav.category_set_id,mrav.category_id) in (select mcsv.category_set_id, mcv.category_id from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.structure_id=mcv.structure_id and mcv.category_concat_segs = :p_assign_category and mcsv.category_set_name=:p_category_set ) and mrav.assignment_type in (2,5) LOV INV Category 8E2FF36EDECB79D2E0530100007F1FF2 Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mcv.structure_id order by mcv.category_concat_segs US Category 12 90 1=1 mrav.inventory_item_id in (select msiv.inventory_item_id from mtl_system_items_vl msiv where msiv.organization_id = nvl(mrav.organization_id,:p_master_org_id) and msiv.concatenated_segments = :p_assign_item ) and mrav.assignment_type in (3,6) LOV custom Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id=mp.organization_id and msiv.bom_item_type in (1,2,4) and ((:$flex$.organization_code is not null and xxen_util.contains(:$flex$.organization_code,mp.organization_code) = 'Y') or (:$flex$.organization_code is null and mp.organization_code = :$flex$.master_organization_code) ) order by mp.organization_code, msiv.concatenated_segments US Item 13 100 1=1 mrav.customer_name = :p_assign_cust_name LOV AR Customer Name 8E2FF36EDE8679D2E0530100007F1FF2 Y select hp.party_name value, hca.account_number||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name US Customer 14 110 1=1 hca.account_number= :p_assign_cust_num LOV AR Account Number 8E2FF36EDE7F79D2E0530100007F1FF2 Y Y select hca.account_number value, hp.party_name||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name US Customer Number 15 120 1=1 haouv.name = :p_assign_cust_site_ou LOV HR Operating Unit (all) 8E2FF36EDE8879D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) order by hou.name US Customer Operating Unit AC747D930D300AC94CC823A8BC580D6D Default SYSADMIN 1 ASSIGNMENT_SET 2 ASSIGNMENT_SET_DESCRIPTION 3 ASSIGNMENT_TYPE 6 CATEGORY 8 CUSTOMER_NAME 9 CUSTOMER_SITE 11 CUSTOMER_SITE_OU 10 CUSTOMER_SITE_USE 16 DELETE_OPTION 7 DESCRIPTION 5 ITEM 4 ORGANIZATION 12 SHIP_TO_ADDRESS 14 SOURCING_RULE_NAME 15 SOURCING_RULE_ORG 13 SOURCING_RULE_TYPE S Site AC747D930D300AC94CC823A8BC580D6D 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 REQUEST_ID_ Char varchar2 Y 5 MODIFIED_COLUMNS_ Char varchar2 Y 6 SET_ROW_ID Char varchar2 Y 7 ASS_ROW_ID Char varchar2 Y 8 UPLOAD_MODE Char varchar2 2000 :$flex$.Upload_Mode Y 9 BYPASS_DFF_VALIDATION Char varchar2 2000 :$flex$.Bypass_DFF_Validation Y Y 10 ASSIGNMENT_SET LOV custom varchar2 30 select mas.assignment_set_name value, mas.description from mrp_assignment_sets mas order by mas.assignment_set_name Y 11 ASSIGNMENT_SET_DESCRIPTION Char varchar2 80 select mas.description from mrp_assignment_sets mas where mas.assignment_set_name = :$column$.assignment_set 12 ASSIGNMENT_TYPE LOV custom varchar2 21 Y select x.value, null description from ( select '1' id, 'Global' value from dual union all select '2' id, 'Category' value from dual where :$flex$.category_set is not null and (select mcs.control_level from mtl_category_sets mcs where mcs.category_set_name = :$flex$.category_set) != 2 union all select '3' id, 'Item' value from dual union all select '4' id, 'Organization' value from dual union all select '5' id, 'Category-Organization' value from dual where :$flex$.category_set is not null union all select '6' id, 'Item-Organization' value from dual ) x order by x.value select x.id, x.value from ( select '1' id, 'Global' value from dual union all select '2' id, 'Category' value from dual union all select '3' id, 'Item' value from dual union all select '4' id, 'Organization' value from dual union all select '5' id, 'Category-Organization' value from dual union all select '6' id, 'Item-Organization' value from dual ) x Y Y 13 ORGANIZATION LOV custom varchar2 Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where :$column$.customer_name is null and nvl(ood.disable_date,sysdate)>=sysdate and :$column$.assignment_type in ('Organization', 'Category-Organization', 'Item-Organization') order by ood.organization_code select organization_id id, organization_code value from mtl_parameters 14 ITEM LOV custom varchar2 40 Y Y select msiv.concatenated_segments value, msiv.description description from mtl_system_items_vl msiv where msiv.organization_id = nvl((select mp.organization_id from mtl_parameters mp where mp.organization_code = :$column$.organization), :$flex$.master_organization_id ) and msiv.bom_item_type in (1,2,4) and :$column$.assignment_type in ('Item','Item-Organization') order by value 15 CATEGORY LOV custom varchar2 Y select mcv.category_concat_segs value, mcv.description description from mtl_category_sets mcs, mtl_categories_v mcv where mcs.structure_id = mcv.structure_id and mcs.category_set_name = :$flex$.category_set and (nvl(mcv.disable_date,sysdate+1) > sysdate) and :$column$.assignment_type in ('Category','Category-Organization') order by value 16 DESCRIPTION LOV custom varchar2 Y select x.value, null description from ( select msiv.description value from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id = mp.organization_id and mp.organization_code = nvl(:$column$.organization,:$flex$.master_organization_code) and msiv.concatenated_segments = :$column$.item and :$column$.category is null union select mcv.description value from mtl_category_sets mcs, mtl_categories_v mcv where mcs.structure_id = mcv.structure_id and mcs.category_set_name = :$flex$.category_set and (nvl(mcv.disable_date,sysdate+1) > sysdate) and mcv.category_concat_segs = :$column$.category and :$column$.item is null ) x select x.value from ( select msiv.description value from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id = mp.organization_id and mp.organization_code = nvl(:$column$.organization,:$flex$.master_organization_code) and msiv.concatenated_segments = :$column$.item and :$column$.category is null union select mcv.description value from mtl_category_sets mcs, mtl_categories_v mcv where mcs.structure_id = mcv.structure_id and mcs.category_set_name = :$flex$.category_set and (nvl(mcv.disable_date,sysdate+1) > sysdate) and mcv.category_concat_segs = :$column$.category and :$column$.item is null ) x Y 17 CUSTOMER_NAME LOV custom varchar2 Y select hp.party_name value, hca.account_number description from hz_parties hp, hz_cust_accounts hca where hca.party_id = hp.party_id and :$column$.assignment_type in ('Organization','Category-Organization','Item-Organization') and :$column$.organization is null and exists (select null from hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa where hcasa.cust_acct_site_id = hcsua.cust_acct_site_id and hcsua.site_use_code in ('SHIP_TO','BILL_TO') and hcsua.status = 'A' and hcasa.cust_account_id = hca.cust_account_id ) order by value 18 CUSTOMER_NUMBER LOV custom varchar2 30 Y select hca.account_number value, hp.party_name description from hz_parties hp, hz_cust_accounts hca where hca.party_id = hp.party_id and hp.party_name = :$column$.customer_name order by value select x.value from ( select hca.account_number value, count(distinct hca.account_number) over () cnt from hz_parties hp, hz_cust_accounts hca where hca.party_id = hp.party_id and hp.party_name = :$column$.customer_name ) x where x.cnt = 1 19 CUSTOMER_SITE LOV custom varchar2 40 Y select hcsua.location value, xxen_util.meaning(hcsua.site_use_code,'SITE_USE_CODE',222) || ': ' || hl.address1 || ' / ' || hl.country || ' / ' || haouv.name description from hz_parties hp, hz_cust_accounts hca, hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa, hz_party_sites hps, hz_locations hl, hr_all_organization_units_vl haouv where hp.party_id = hca.party_id and hca.cust_account_id = hcasa.cust_account_id and hcasa.cust_acct_site_id = hcsua.cust_acct_site_id and hcsua.site_use_code in ('SHIP_TO','BILL_TO') and hcsua.status = 'A' and hcasa.party_site_id = hps.party_site_id and hps.location_id = hl.location_id and hcsua.org_id = haouv.organization_id (+) and hp.party_name = :$column$.customer_name and hca.account_number = nvl(:$column$.customer_number,hca.account_number) and :$column$.assignment_type != 'Global' order by value 20 CUSTOMER_SITE_USE LOV custom varchar2 Y select xxen_util.meaning(hcsua.site_use_code,'SITE_USE_CODE',222) value, null description from hz_parties hp, hz_cust_accounts hca, hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa, hz_party_sites hps, hz_locations hl, hr_all_organization_units_vl haouv where hp.party_id = hca.party_id and hca.cust_account_id = hcasa.cust_account_id and hcasa.cust_acct_site_id = hcsua.cust_acct_site_id and hcsua.site_use_code in ('SHIP_TO','BILL_TO') and hcsua.status = 'A' and hcasa.party_site_id = hps.party_site_id and hps.location_id = hl.location_id and hcsua.org_id = haouv.organization_id (+) and hp.party_name = :$column$.customer_name and hca.account_number = nvl(:$column$.customer_number,hca.account_number) and hcsua.location = :$column$.customer_site and :$column$.assignment_type != 'Global' order by value select flvv.lookup_code id, flvv.meaning value from fnd_lookup_values_vl flvv where flvv.lookup_type = 'SITE_USE_CODE' and flvv.view_application_id = 222 and flvv.security_group_id = fnd_global.security_group_id select x.value from ( select xxen_util.meaning(hcsua.site_use_code,'SITE_USE_CODE',222) value, count(distinct hcsua.site_use_code) over () cnt from hz_parties hp, hz_cust_accounts hca, hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa, hz_party_sites hps, hz_locations hl, hr_all_organization_units_vl haouv where hp.party_id = hca.party_id and hca.cust_account_id = hcasa.cust_account_id and hcasa.cust_acct_site_id = hcsua.cust_acct_site_id and hcsua.site_use_code in ('SHIP_TO','BILL_TO') and hcasa.party_site_id = hps.party_site_id and hps.location_id = hl.location_id and hcsua.org_id = haouv.organization_id and hp.party_name = :$column$.customer_name and hca.account_number = nvl(:$column$.customer_number,hca.account_number) and hcsua.location = :$column$.customer_site ) x where x.cnt = 1 21 CUSTOMER_SITE_OU LOV custom varchar2 240 Y select haouv.name value, null description from hz_parties hp, hz_cust_accounts hca, hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa, hz_party_sites hps, hz_locations hl, hr_all_organization_units_vl haouv where hp.party_id = hca.party_id and hca.cust_account_id = hcasa.cust_account_id and hcasa.cust_acct_site_id = hcsua.cust_acct_site_id and hcsua.site_use_code in ('SHIP_TO','BILL_TO') and hcsua.status = 'A' and hcasa.party_site_id = hps.party_site_id and hps.location_id = hl.location_id and hcsua.org_id = haouv.organization_id and hp.party_name = :$column$.customer_name and hca.account_number = nvl(:$column$.customer_number,hca.account_number) and hcsua.location = :$column$.customer_site and hcsua.site_use_code = nvl(xxen_util.lookup_code(:$column$.customer_site_use,'SITE_USE_CODE',222),hcsua.site_use_code) and :$column$.assignment_type != 'Global' order by value select x.value from ( select distinct haouv.name value, count(distinct haouv.name) over () cnt from hz_parties hp, hz_cust_accounts hca, hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa, hz_party_sites hps, hz_locations hl, hr_all_organization_units_vl haouv where hp.party_id = hca.party_id and hca.cust_account_id = hcasa.cust_account_id and hcasa.cust_acct_site_id = hcsua.cust_acct_site_id and hcsua.site_use_code in ('SHIP_TO','BILL_TO') and hcasa.party_site_id = hps.party_site_id and hps.location_id = hl.location_id and hcsua.org_id = haouv.organization_id and hp.party_name = :$column$.customer_name and hca.account_number = nvl(:$column$.customer_number,hca.account_number) and hcsua.location = :$column$.customer_site and hcsua.site_use_code = nvl(xxen_util.lookup_code(:$column$.customer_site_use,'SITE_USE_CODE',222),hcsua.site_use_code) ) x where x.cnt = 1 22 SHIP_TO_ADDRESS Char varchar2 select x.value from ( select distinct hl.address1 value, count(distinct hl.address1) over () cnt from hz_parties hp, hz_cust_accounts hca, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua, hz_party_sites hps, hz_locations hl, hr_all_organization_units_vl haouv where hp.party_id = hca.party_id and hca.cust_account_id = hcasa.cust_account_id and hcasa.cust_acct_site_id = hcsua.cust_acct_site_id and hcsua.site_use_code in ('SHIP_TO','BILL_TO') and hcasa.party_site_id = hps.party_site_id and hps.location_id = hl.location_id and hcsua.org_id = haouv.organization_id (+) and hp.party_name = :$column$.customer_name and hca.account_number = nvl(:$column$.customer_number,hca.account_number) and hcsua.location = :$column$.customer_site and hcsua.site_use_code = nvl(xxen_util.lookup_code(:$column$.customer_site_use,'SITE_USE_CODE',222),hcsua.site_use_code) and nvl(haouv.name,'?') = nvl(:$column$.customer_site_ou,nvl(haouv.name,'?')) ) x where x.cnt = 1 Y 23 SOURCING_RULE_TYPE LOV custom varchar2 Y select ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type = 'MRP_SOURCING_RULE_TYPE' and ((:$column$.assignment_type in ('Global', 'Category', 'Item') and ml.lookup_code in (1, 2)) or (:$column$.assignment_type in ('Organization', 'Category-Organization', 'Item-Organization') and ml.lookup_code = 1) ) order by value select lookup_code id, meaning value from mfg_lookups where lookup_type = 'MRP_SOURCING_RULE_TYPE' Y 24 SOURCING_RULE_NAME LOV custom varchar2 50 Y select msr.sourcing_rule_name value, msr.description || ' (' || nvl(mp.organization_code,'All Orgs') || ')' description from mrp_sourcing_rules msr, mtl_parameters mp where msr.organization_id = mp.organization_id (+) and msr.sourcing_rule_type = xxen_util.lookup_code(:$column$.sourcing_rule_type,'MRP_SOURCING_RULE_TYPE',700) and msr.planning_active = 1 and ((:$column$.assignment_type in ('Global', 'Category', 'Item') and msr.organization_id is null) or (:$column$.assignment_type in ('Organization', 'Category-Organization', 'Item-Organization') and (msr.organization_id is null or mp.organization_code = :$column$.organization)) ) and exists (select 'x' from mrp_sr_receipt_org msro where msro.sourcing_rule_id = msr.sourcing_rule_id and trunc(sysdate) <= trunc(nvl(msro.disable_date,sysdate)) ) order by value Y 25 SOURCING_RULE_ORG LOV custom varchar2 3 Y select mp.organization_code value, null description from mrp_sourcing_rules msr, mtl_parameters mp where msr.organization_id = mp.organization_id and msr.sourcing_rule_type = xxen_util.lookup_code(:$column$.sourcing_rule_type,'MRP_SOURCING_RULE_TYPE',700) and msr.sourcing_rule_name = :$column$.sourcing_rule_name and :$column$.assignment_type in ('Organization', 'Category-Organization', 'Item-Organization') and mp.organization_code = :$column$.organization order by value select organization_id id, organization_code value from mtl_parameters select mp.organization_code from mrp_sourcing_rules msr, mtl_parameters mp where msr.organization_id = mp.organization_id and msr.sourcing_rule_type = xxen_util.lookup_code(:$column$.sourcing_rule_type,'MRP_SOURCING_RULE_TYPE',700) and msr.sourcing_rule_name = :$column$.sourcing_rule_name and :$column$.assignment_type in ('Organization', 'Category-Organization', 'Item-Organization') and mp.organization_code = :$column$.organization 26 SET_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id = fdfv.application_id and fdfcv.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfcv.enabled_flag = 'Y' and fdfv.application_id = 704 and fdfv.descriptive_flexfield_name = 'MRP_ASSIGNMENT_SETS' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 27 SR_SET_ATTRIBUTE1 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_ASSIGNMENT_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.sr_set_attribute1, p_attribute2 => :$column$.sr_set_attribute2, p_attribute3 => :$column$.sr_set_attribute3, p_attribute4 => :$column$.sr_set_attribute4, p_attribute5 => :$column$.sr_set_attribute5, p_attribute6 => :$column$.sr_set_attribute6, p_attribute7 => :$column$.sr_set_attribute7, p_attribute8 => :$column$.sr_set_attribute8, p_attribute9 => :$column$.sr_set_attribute9, p_attribute10 => :$column$.sr_set_attribute10, p_attribute11 => :$column$.sr_set_attribute11, p_attribute12 => :$column$.sr_set_attribute12, p_attribute13 => :$column$.sr_set_attribute13, p_attribute14 => :$column$.sr_set_attribute14, p_attribute15 => :$column$.sr_set_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_ASSIGNMENT_SETS' and fdfcuv.application_column_name = 'ATTRIBUTE1' 28 SR_SET_ATTRIBUTE2 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_ASSIGNMENT_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.sr_set_attribute1, p_attribute2 => :$column$.sr_set_attribute2, p_attribute3 => :$column$.sr_set_attribute3, p_attribute4 => :$column$.sr_set_attribute4, p_attribute5 => :$column$.sr_set_attribute5, p_attribute6 => :$column$.sr_set_attribute6, p_attribute7 => :$column$.sr_set_attribute7, p_attribute8 => :$column$.sr_set_attribute8, p_attribute9 => :$column$.sr_set_attribute9, p_attribute10 => :$column$.sr_set_attribute10, p_attribute11 => :$column$.sr_set_attribute11, p_attribute12 => :$column$.sr_set_attribute12, p_attribute13 => :$column$.sr_set_attribute13, p_attribute14 => :$column$.sr_set_attribute14, p_attribute15 => :$column$.sr_set_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_ASSIGNMENT_SETS' and fdfcuv.application_column_name = 'ATTRIBUTE2' 29 SR_SET_ATTRIBUTE3 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_ASSIGNMENT_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.sr_set_attribute1, p_attribute2 => :$column$.sr_set_attribute2, p_attribute3 => :$column$.sr_set_attribute3, p_attribute4 => :$column$.sr_set_attribute4, p_attribute5 => :$column$.sr_set_attribute5, p_attribute6 => :$column$.sr_set_attribute6, p_attribute7 => :$column$.sr_set_attribute7, p_attribute8 => :$column$.sr_set_attribute8, p_attribute9 => :$column$.sr_set_attribute9, p_attribute10 => :$column$.sr_set_attribute10, p_attribute11 => :$column$.sr_set_attribute11, p_attribute12 => :$column$.sr_set_attribute12, p_attribute13 => :$column$.sr_set_attribute13, p_attribute14 => :$column$.sr_set_attribute14, p_attribute15 => :$column$.sr_set_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_ASSIGNMENT_SETS' and fdfcuv.application_column_name = 'ATTRIBUTE3' 30 SR_SET_ATTRIBUTE4 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_ASSIGNMENT_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.sr_set_attribute1, p_attribute2 => :$column$.sr_set_attribute2, p_attribute3 => :$column$.sr_set_attribute3, p_attribute4 => :$column$.sr_set_attribute4, p_attribute5 => :$column$.sr_set_attribute5, p_attribute6 => :$column$.sr_set_attribute6, p_attribute7 => :$column$.sr_set_attribute7, p_attribute8 => :$column$.sr_set_attribute8, p_attribute9 => :$column$.sr_set_attribute9, p_attribute10 => :$column$.sr_set_attribute10, p_attribute11 => :$column$.sr_set_attribute11, p_attribute12 => :$column$.sr_set_attribute12, p_attribute13 => :$column$.sr_set_attribute13, p_attribute14 => :$column$.sr_set_attribute14, p_attribute15 => :$column$.sr_set_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_ASSIGNMENT_SETS' and fdfcuv.application_column_name = 'ATTRIBUTE4' 31 SR_SET_ATTRIBUTE5 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_ASSIGNMENT_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.sr_set_attribute1, p_attribute2 => :$column$.sr_set_attribute2, p_attribute3 => :$column$.sr_set_attribute3, p_attribute4 => :$column$.sr_set_attribute4, p_attribute5 => :$column$.sr_set_attribute5, p_attribute6 => :$column$.sr_set_attribute6, p_attribute7 => :$column$.sr_set_attribute7, p_attribute8 => :$column$.sr_set_attribute8, p_attribute9 => :$column$.sr_set_attribute9, p_attribute10 => :$column$.sr_set_attribute10, p_attribute11 => :$column$.sr_set_attribute11, p_attribute12 => :$column$.sr_set_attribute12, p_attribute13 => :$column$.sr_set_attribute13, p_attribute14 => :$column$.sr_set_attribute14, p_attribute15 => :$column$.sr_set_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_ASSIGNMENT_SETS' and fdfcuv.application_column_name = 'ATTRIBUTE5' 32 SR_SET_ATTRIBUTE6 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_ASSIGNMENT_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.sr_set_attribute1, p_attribute2 => :$column$.sr_set_attribute2, p_attribute3 => :$column$.sr_set_attribute3, p_attribute4 => :$column$.sr_set_attribute4, p_attribute5 => :$column$.sr_set_attribute5, p_attribute6 => :$column$.sr_set_attribute6, p_attribute7 => :$column$.sr_set_attribute7, p_attribute8 => :$column$.sr_set_attribute8, p_attribute9 => :$column$.sr_set_attribute9, p_attribute10 => :$column$.sr_set_attribute10, p_attribute11 => :$column$.sr_set_attribute11, p_attribute12 => :$column$.sr_set_attribute12, p_attribute13 => :$column$.sr_set_attribute13, p_attribute14 => :$column$.sr_set_attribute14, p_attribute15 => :$column$.sr_set_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_ASSIGNMENT_SETS' and fdfcuv.application_column_name = 'ATTRIBUTE6' 33 SR_SET_ATTRIBUTE7 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_ASSIGNMENT_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.sr_set_attribute1, p_attribute2 => :$column$.sr_set_attribute2, p_attribute3 => :$column$.sr_set_attribute3, p_attribute4 => :$column$.sr_set_attribute4, p_attribute5 => :$column$.sr_set_attribute5, p_attribute6 => :$column$.sr_set_attribute6, p_attribute7 => :$column$.sr_set_attribute7, p_attribute8 => :$column$.sr_set_attribute8, p_attribute9 => :$column$.sr_set_attribute9, p_attribute10 => :$column$.sr_set_attribute10, p_attribute11 => :$column$.sr_set_attribute11, p_attribute12 => :$column$.sr_set_attribute12, p_attribute13 => :$column$.sr_set_attribute13, p_attribute14 => :$column$.sr_set_attribute14, p_attribute15 => :$column$.sr_set_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_ASSIGNMENT_SETS' and fdfcuv.application_column_name = 'ATTRIBUTE7' 34 SR_SET_ATTRIBUTE8 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_ASSIGNMENT_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.sr_set_attribute1, p_attribute2 => :$column$.sr_set_attribute2, p_attribute3 => :$column$.sr_set_attribute3, p_attribute4 => :$column$.sr_set_attribute4, p_attribute5 => :$column$.sr_set_attribute5, p_attribute6 => :$column$.sr_set_attribute6, p_attribute7 => :$column$.sr_set_attribute7, p_attribute8 => :$column$.sr_set_attribute8, p_attribute9 => :$column$.sr_set_attribute9, p_attribute10 => :$column$.sr_set_attribute10, p_attribute11 => :$column$.sr_set_attribute11, p_attribute12 => :$column$.sr_set_attribute12, p_attribute13 => :$column$.sr_set_attribute13, p_attribute14 => :$column$.sr_set_attribute14, p_attribute15 => :$column$.sr_set_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_ASSIGNMENT_SETS' and fdfcuv.application_column_name = 'ATTRIBUTE8' 35 SR_SET_ATTRIBUTE9 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_ASSIGNMENT_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.sr_set_attribute1, p_attribute2 => :$column$.sr_set_attribute2, p_attribute3 => :$column$.sr_set_attribute3, p_attribute4 => :$column$.sr_set_attribute4, p_attribute5 => :$column$.sr_set_attribute5, p_attribute6 => :$column$.sr_set_attribute6, p_attribute7 => :$column$.sr_set_attribute7, p_attribute8 => :$column$.sr_set_attribute8, p_attribute9 => :$column$.sr_set_attribute9, p_attribute10 => :$column$.sr_set_attribute10, p_attribute11 => :$column$.sr_set_attribute11, p_attribute12 => :$column$.sr_set_attribute12, p_attribute13 => :$column$.sr_set_attribute13, p_attribute14 => :$column$.sr_set_attribute14, p_attribute15 => :$column$.sr_set_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_ASSIGNMENT_SETS' and fdfcuv.application_column_name = 'ATTRIBUTE9' 36 SR_SET_ATTRIBUTE10 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_ASSIGNMENT_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.sr_set_attribute1, p_attribute2 => :$column$.sr_set_attribute2, p_attribute3 => :$column$.sr_set_attribute3, p_attribute4 => :$column$.sr_set_attribute4, p_attribute5 => :$column$.sr_set_attribute5, p_attribute6 => :$column$.sr_set_attribute6, p_attribute7 => :$column$.sr_set_attribute7, p_attribute8 => :$column$.sr_set_attribute8, p_attribute9 => :$column$.sr_set_attribute9, p_attribute10 => :$column$.sr_set_attribute10, p_attribute11 => :$column$.sr_set_attribute11, p_attribute12 => :$column$.sr_set_attribute12, p_attribute13 => :$column$.sr_set_attribute13, p_attribute14 => :$column$.sr_set_attribute14, p_attribute15 => :$column$.sr_set_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_ASSIGNMENT_SETS' and fdfcuv.application_column_name = 'ATTRIBUTE10' 37 SR_SET_ATTRIBUTE11 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_ASSIGNMENT_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.sr_set_attribute1, p_attribute2 => :$column$.sr_set_attribute2, p_attribute3 => :$column$.sr_set_attribute3, p_attribute4 => :$column$.sr_set_attribute4, p_attribute5 => :$column$.sr_set_attribute5, p_attribute6 => :$column$.sr_set_attribute6, p_attribute7 => :$column$.sr_set_attribute7, p_attribute8 => :$column$.sr_set_attribute8, p_attribute9 => :$column$.sr_set_attribute9, p_attribute10 => :$column$.sr_set_attribute10, p_attribute11 => :$column$.sr_set_attribute11, p_attribute12 => :$column$.sr_set_attribute12, p_attribute13 => :$column$.sr_set_attribute13, p_attribute14 => :$column$.sr_set_attribute14, p_attribute15 => :$column$.sr_set_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_ASSIGNMENT_SETS' and fdfcuv.application_column_name = 'ATTRIBUTE11' 38 SR_SET_ATTRIBUTE12 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_ASSIGNMENT_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.sr_set_attribute1, p_attribute2 => :$column$.sr_set_attribute2, p_attribute3 => :$column$.sr_set_attribute3, p_attribute4 => :$column$.sr_set_attribute4, p_attribute5 => :$column$.sr_set_attribute5, p_attribute6 => :$column$.sr_set_attribute6, p_attribute7 => :$column$.sr_set_attribute7, p_attribute8 => :$column$.sr_set_attribute8, p_attribute9 => :$column$.sr_set_attribute9, p_attribute10 => :$column$.sr_set_attribute10, p_attribute11 => :$column$.sr_set_attribute11, p_attribute12 => :$column$.sr_set_attribute12, p_attribute13 => :$column$.sr_set_attribute13, p_attribute14 => :$column$.sr_set_attribute14, p_attribute15 => :$column$.sr_set_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_ASSIGNMENT_SETS' and fdfcuv.application_column_name = 'ATTRIBUTE12' 39 SR_SET_ATTRIBUTE13 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_ASSIGNMENT_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.sr_set_attribute1, p_attribute2 => :$column$.sr_set_attribute2, p_attribute3 => :$column$.sr_set_attribute3, p_attribute4 => :$column$.sr_set_attribute4, p_attribute5 => :$column$.sr_set_attribute5, p_attribute6 => :$column$.sr_set_attribute6, p_attribute7 => :$column$.sr_set_attribute7, p_attribute8 => :$column$.sr_set_attribute8, p_attribute9 => :$column$.sr_set_attribute9, p_attribute10 => :$column$.sr_set_attribute10, p_attribute11 => :$column$.sr_set_attribute11, p_attribute12 => :$column$.sr_set_attribute12, p_attribute13 => :$column$.sr_set_attribute13, p_attribute14 => :$column$.sr_set_attribute14, p_attribute15 => :$column$.sr_set_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_ASSIGNMENT_SETS' and fdfcuv.application_column_name = 'ATTRIBUTE13' 40 SR_SET_ATTRIBUTE14 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_ASSIGNMENT_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.sr_set_attribute1, p_attribute2 => :$column$.sr_set_attribute2, p_attribute3 => :$column$.sr_set_attribute3, p_attribute4 => :$column$.sr_set_attribute4, p_attribute5 => :$column$.sr_set_attribute5, p_attribute6 => :$column$.sr_set_attribute6, p_attribute7 => :$column$.sr_set_attribute7, p_attribute8 => :$column$.sr_set_attribute8, p_attribute9 => :$column$.sr_set_attribute9, p_attribute10 => :$column$.sr_set_attribute10, p_attribute11 => :$column$.sr_set_attribute11, p_attribute12 => :$column$.sr_set_attribute12, p_attribute13 => :$column$.sr_set_attribute13, p_attribute14 => :$column$.sr_set_attribute14, p_attribute15 => :$column$.sr_set_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_ASSIGNMENT_SETS' and fdfcuv.application_column_name = 'ATTRIBUTE14' 41 SR_SET_ATTRIBUTE15 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_ASSIGNMENT_SETS', p_context_name => :$column$.set_attribute_category, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.sr_set_attribute1, p_attribute2 => :$column$.sr_set_attribute2, p_attribute3 => :$column$.sr_set_attribute3, p_attribute4 => :$column$.sr_set_attribute4, p_attribute5 => :$column$.sr_set_attribute5, p_attribute6 => :$column$.sr_set_attribute6, p_attribute7 => :$column$.sr_set_attribute7, p_attribute8 => :$column$.sr_set_attribute8, p_attribute9 => :$column$.sr_set_attribute9, p_attribute10 => :$column$.sr_set_attribute10, p_attribute11 => :$column$.sr_set_attribute11, p_attribute12 => :$column$.sr_set_attribute12, p_attribute13 => :$column$.sr_set_attribute13, p_attribute14 => :$column$.sr_set_attribute14, p_attribute15 => :$column$.sr_set_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_ASSIGNMENT_SETS' and fdfcuv.application_column_name = 'ATTRIBUTE15' 42 ASSIGN_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id = fdfv.application_id and fdfcv.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfcv.enabled_flag = 'Y' and fdfv.application_id = 704 and fdfv.descriptive_flexfield_name = 'MRP_SR_ASSIGNMENTS' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 43 SR_ASSIGN_ATTRIBUTE1 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_SR_ASSIGNMENTS', p_context_name => :$column$.assign_attribute_category, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.sr_assign_attribute1, p_attribute2 => :$column$.sr_assign_attribute2, p_attribute3 => :$column$.sr_assign_attribute3, p_attribute4 => :$column$.sr_assign_attribute4, p_attribute5 => :$column$.sr_assign_attribute5, p_attribute6 => :$column$.sr_assign_attribute6, p_attribute7 => :$column$.sr_assign_attribute7, p_attribute8 => :$column$.sr_assign_attribute8, p_attribute9 => :$column$.sr_assign_attribute9, p_attribute10 => :$column$.sr_assign_attribute10, p_attribute11 => :$column$.sr_assign_attribute11, p_attribute12 => :$column$.sr_assign_attribute12, p_attribute13 => :$column$.sr_assign_attribute13, p_attribute14 => :$column$.sr_assign_attribute14, p_attribute15 => :$column$.sr_assign_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_SR_ASSIGNMENTS' and fdfcuv.application_column_name = 'ATTRIBUTE1' 44 SR_ASSIGN_ATTRIBUTE2 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_SR_ASSIGNMENTS', p_context_name => :$column$.assign_attribute_category, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.sr_assign_attribute1, p_attribute2 => :$column$.sr_assign_attribute2, p_attribute3 => :$column$.sr_assign_attribute3, p_attribute4 => :$column$.sr_assign_attribute4, p_attribute5 => :$column$.sr_assign_attribute5, p_attribute6 => :$column$.sr_assign_attribute6, p_attribute7 => :$column$.sr_assign_attribute7, p_attribute8 => :$column$.sr_assign_attribute8, p_attribute9 => :$column$.sr_assign_attribute9, p_attribute10 => :$column$.sr_assign_attribute10, p_attribute11 => :$column$.sr_assign_attribute11, p_attribute12 => :$column$.sr_assign_attribute12, p_attribute13 => :$column$.sr_assign_attribute13, p_attribute14 => :$column$.sr_assign_attribute14, p_attribute15 => :$column$.sr_assign_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_SR_ASSIGNMENTS' and fdfcuv.application_column_name = 'ATTRIBUTE2' 45 SR_ASSIGN_ATTRIBUTE3 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_SR_ASSIGNMENTS', p_context_name => :$column$.assign_attribute_category, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.sr_assign_attribute1, p_attribute2 => :$column$.sr_assign_attribute2, p_attribute3 => :$column$.sr_assign_attribute3, p_attribute4 => :$column$.sr_assign_attribute4, p_attribute5 => :$column$.sr_assign_attribute5, p_attribute6 => :$column$.sr_assign_attribute6, p_attribute7 => :$column$.sr_assign_attribute7, p_attribute8 => :$column$.sr_assign_attribute8, p_attribute9 => :$column$.sr_assign_attribute9, p_attribute10 => :$column$.sr_assign_attribute10, p_attribute11 => :$column$.sr_assign_attribute11, p_attribute12 => :$column$.sr_assign_attribute12, p_attribute13 => :$column$.sr_assign_attribute13, p_attribute14 => :$column$.sr_assign_attribute14, p_attribute15 => :$column$.sr_assign_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_SR_ASSIGNMENTS' and fdfcuv.application_column_name = 'ATTRIBUTE3' 46 SR_ASSIGN_ATTRIBUTE4 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_SR_ASSIGNMENTS', p_context_name => :$column$.assign_attribute_category, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.sr_assign_attribute1, p_attribute2 => :$column$.sr_assign_attribute2, p_attribute3 => :$column$.sr_assign_attribute3, p_attribute4 => :$column$.sr_assign_attribute4, p_attribute5 => :$column$.sr_assign_attribute5, p_attribute6 => :$column$.sr_assign_attribute6, p_attribute7 => :$column$.sr_assign_attribute7, p_attribute8 => :$column$.sr_assign_attribute8, p_attribute9 => :$column$.sr_assign_attribute9, p_attribute10 => :$column$.sr_assign_attribute10, p_attribute11 => :$column$.sr_assign_attribute11, p_attribute12 => :$column$.sr_assign_attribute12, p_attribute13 => :$column$.sr_assign_attribute13, p_attribute14 => :$column$.sr_assign_attribute14, p_attribute15 => :$column$.sr_assign_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_SR_ASSIGNMENTS' and fdfcuv.application_column_name = 'ATTRIBUTE4' 47 SR_ASSIGN_ATTRIBUTE5 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_SR_ASSIGNMENTS', p_context_name => :$column$.assign_attribute_category, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.sr_assign_attribute1, p_attribute2 => :$column$.sr_assign_attribute2, p_attribute3 => :$column$.sr_assign_attribute3, p_attribute4 => :$column$.sr_assign_attribute4, p_attribute5 => :$column$.sr_assign_attribute5, p_attribute6 => :$column$.sr_assign_attribute6, p_attribute7 => :$column$.sr_assign_attribute7, p_attribute8 => :$column$.sr_assign_attribute8, p_attribute9 => :$column$.sr_assign_attribute9, p_attribute10 => :$column$.sr_assign_attribute10, p_attribute11 => :$column$.sr_assign_attribute11, p_attribute12 => :$column$.sr_assign_attribute12, p_attribute13 => :$column$.sr_assign_attribute13, p_attribute14 => :$column$.sr_assign_attribute14, p_attribute15 => :$column$.sr_assign_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_SR_ASSIGNMENTS' and fdfcuv.application_column_name = 'ATTRIBUTE5' 48 SR_ASSIGN_ATTRIBUTE6 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_SR_ASSIGNMENTS', p_context_name => :$column$.assign_attribute_category, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.sr_assign_attribute1, p_attribute2 => :$column$.sr_assign_attribute2, p_attribute3 => :$column$.sr_assign_attribute3, p_attribute4 => :$column$.sr_assign_attribute4, p_attribute5 => :$column$.sr_assign_attribute5, p_attribute6 => :$column$.sr_assign_attribute6, p_attribute7 => :$column$.sr_assign_attribute7, p_attribute8 => :$column$.sr_assign_attribute8, p_attribute9 => :$column$.sr_assign_attribute9, p_attribute10 => :$column$.sr_assign_attribute10, p_attribute11 => :$column$.sr_assign_attribute11, p_attribute12 => :$column$.sr_assign_attribute12, p_attribute13 => :$column$.sr_assign_attribute13, p_attribute14 => :$column$.sr_assign_attribute14, p_attribute15 => :$column$.sr_assign_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_SR_ASSIGNMENTS' and fdfcuv.application_column_name = 'ATTRIBUTE6' 49 SR_ASSIGN_ATTRIBUTE7 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_SR_ASSIGNMENTS', p_context_name => :$column$.assign_attribute_category, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.sr_assign_attribute1, p_attribute2 => :$column$.sr_assign_attribute2, p_attribute3 => :$column$.sr_assign_attribute3, p_attribute4 => :$column$.sr_assign_attribute4, p_attribute5 => :$column$.sr_assign_attribute5, p_attribute6 => :$column$.sr_assign_attribute6, p_attribute7 => :$column$.sr_assign_attribute7, p_attribute8 => :$column$.sr_assign_attribute8, p_attribute9 => :$column$.sr_assign_attribute9, p_attribute10 => :$column$.sr_assign_attribute10, p_attribute11 => :$column$.sr_assign_attribute11, p_attribute12 => :$column$.sr_assign_attribute12, p_attribute13 => :$column$.sr_assign_attribute13, p_attribute14 => :$column$.sr_assign_attribute14, p_attribute15 => :$column$.sr_assign_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_SR_ASSIGNMENTS' and fdfcuv.application_column_name = 'ATTRIBUTE7' 50 SR_ASSIGN_ATTRIBUTE8 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_SR_ASSIGNMENTS', p_context_name => :$column$.assign_attribute_category, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.sr_assign_attribute1, p_attribute2 => :$column$.sr_assign_attribute2, p_attribute3 => :$column$.sr_assign_attribute3, p_attribute4 => :$column$.sr_assign_attribute4, p_attribute5 => :$column$.sr_assign_attribute5, p_attribute6 => :$column$.sr_assign_attribute6, p_attribute7 => :$column$.sr_assign_attribute7, p_attribute8 => :$column$.sr_assign_attribute8, p_attribute9 => :$column$.sr_assign_attribute9, p_attribute10 => :$column$.sr_assign_attribute10, p_attribute11 => :$column$.sr_assign_attribute11, p_attribute12 => :$column$.sr_assign_attribute12, p_attribute13 => :$column$.sr_assign_attribute13, p_attribute14 => :$column$.sr_assign_attribute14, p_attribute15 => :$column$.sr_assign_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_SR_ASSIGNMENTS' and fdfcuv.application_column_name = 'ATTRIBUTE8' 51 SR_ASSIGN_ATTRIBUTE9 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_SR_ASSIGNMENTS', p_context_name => :$column$.assign_attribute_category, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.sr_assign_attribute1, p_attribute2 => :$column$.sr_assign_attribute2, p_attribute3 => :$column$.sr_assign_attribute3, p_attribute4 => :$column$.sr_assign_attribute4, p_attribute5 => :$column$.sr_assign_attribute5, p_attribute6 => :$column$.sr_assign_attribute6, p_attribute7 => :$column$.sr_assign_attribute7, p_attribute8 => :$column$.sr_assign_attribute8, p_attribute9 => :$column$.sr_assign_attribute9, p_attribute10 => :$column$.sr_assign_attribute10, p_attribute11 => :$column$.sr_assign_attribute11, p_attribute12 => :$column$.sr_assign_attribute12, p_attribute13 => :$column$.sr_assign_attribute13, p_attribute14 => :$column$.sr_assign_attribute14, p_attribute15 => :$column$.sr_assign_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_SR_ASSIGNMENTS' and fdfcuv.application_column_name = 'ATTRIBUTE9' 52 SR_ASSIGN_ATTRIBUTE10 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_SR_ASSIGNMENTS', p_context_name => :$column$.assign_attribute_category, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.sr_assign_attribute1, p_attribute2 => :$column$.sr_assign_attribute2, p_attribute3 => :$column$.sr_assign_attribute3, p_attribute4 => :$column$.sr_assign_attribute4, p_attribute5 => :$column$.sr_assign_attribute5, p_attribute6 => :$column$.sr_assign_attribute6, p_attribute7 => :$column$.sr_assign_attribute7, p_attribute8 => :$column$.sr_assign_attribute8, p_attribute9 => :$column$.sr_assign_attribute9, p_attribute10 => :$column$.sr_assign_attribute10, p_attribute11 => :$column$.sr_assign_attribute11, p_attribute12 => :$column$.sr_assign_attribute12, p_attribute13 => :$column$.sr_assign_attribute13, p_attribute14 => :$column$.sr_assign_attribute14, p_attribute15 => :$column$.sr_assign_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_SR_ASSIGNMENTS' and fdfcuv.application_column_name = 'ATTRIBUTE10' 53 SR_ASSIGN_ATTRIBUTE11 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_SR_ASSIGNMENTS', p_context_name => :$column$.assign_attribute_category, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.sr_assign_attribute1, p_attribute2 => :$column$.sr_assign_attribute2, p_attribute3 => :$column$.sr_assign_attribute3, p_attribute4 => :$column$.sr_assign_attribute4, p_attribute5 => :$column$.sr_assign_attribute5, p_attribute6 => :$column$.sr_assign_attribute6, p_attribute7 => :$column$.sr_assign_attribute7, p_attribute8 => :$column$.sr_assign_attribute8, p_attribute9 => :$column$.sr_assign_attribute9, p_attribute10 => :$column$.sr_assign_attribute10, p_attribute11 => :$column$.sr_assign_attribute11, p_attribute12 => :$column$.sr_assign_attribute12, p_attribute13 => :$column$.sr_assign_attribute13, p_attribute14 => :$column$.sr_assign_attribute14, p_attribute15 => :$column$.sr_assign_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_SR_ASSIGNMENTS' and fdfcuv.application_column_name = 'ATTRIBUTE11' 54 SR_ASSIGN_ATTRIBUTE12 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_SR_ASSIGNMENTS', p_context_name => :$column$.assign_attribute_category, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.sr_assign_attribute1, p_attribute2 => :$column$.sr_assign_attribute2, p_attribute3 => :$column$.sr_assign_attribute3, p_attribute4 => :$column$.sr_assign_attribute4, p_attribute5 => :$column$.sr_assign_attribute5, p_attribute6 => :$column$.sr_assign_attribute6, p_attribute7 => :$column$.sr_assign_attribute7, p_attribute8 => :$column$.sr_assign_attribute8, p_attribute9 => :$column$.sr_assign_attribute9, p_attribute10 => :$column$.sr_assign_attribute10, p_attribute11 => :$column$.sr_assign_attribute11, p_attribute12 => :$column$.sr_assign_attribute12, p_attribute13 => :$column$.sr_assign_attribute13, p_attribute14 => :$column$.sr_assign_attribute14, p_attribute15 => :$column$.sr_assign_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_SR_ASSIGNMENTS' and fdfcuv.application_column_name = 'ATTRIBUTE12' 55 SR_ASSIGN_ATTRIBUTE13 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_SR_ASSIGNMENTS', p_context_name => :$column$.assign_attribute_category, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.sr_assign_attribute1, p_attribute2 => :$column$.sr_assign_attribute2, p_attribute3 => :$column$.sr_assign_attribute3, p_attribute4 => :$column$.sr_assign_attribute4, p_attribute5 => :$column$.sr_assign_attribute5, p_attribute6 => :$column$.sr_assign_attribute6, p_attribute7 => :$column$.sr_assign_attribute7, p_attribute8 => :$column$.sr_assign_attribute8, p_attribute9 => :$column$.sr_assign_attribute9, p_attribute10 => :$column$.sr_assign_attribute10, p_attribute11 => :$column$.sr_assign_attribute11, p_attribute12 => :$column$.sr_assign_attribute12, p_attribute13 => :$column$.sr_assign_attribute13, p_attribute14 => :$column$.sr_assign_attribute14, p_attribute15 => :$column$.sr_assign_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_SR_ASSIGNMENTS' and fdfcuv.application_column_name = 'ATTRIBUTE13' 56 SR_ASSIGN_ATTRIBUTE14 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_SR_ASSIGNMENTS', p_context_name => :$column$.assign_attribute_category, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.sr_assign_attribute1, p_attribute2 => :$column$.sr_assign_attribute2, p_attribute3 => :$column$.sr_assign_attribute3, p_attribute4 => :$column$.sr_assign_attribute4, p_attribute5 => :$column$.sr_assign_attribute5, p_attribute6 => :$column$.sr_assign_attribute6, p_attribute7 => :$column$.sr_assign_attribute7, p_attribute8 => :$column$.sr_assign_attribute8, p_attribute9 => :$column$.sr_assign_attribute9, p_attribute10 => :$column$.sr_assign_attribute10, p_attribute11 => :$column$.sr_assign_attribute11, p_attribute12 => :$column$.sr_assign_attribute12, p_attribute13 => :$column$.sr_assign_attribute13, p_attribute14 => :$column$.sr_assign_attribute14, p_attribute15 => :$column$.sr_assign_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_SR_ASSIGNMENTS' and fdfcuv.application_column_name = 'ATTRIBUTE14' 57 SR_ASSIGN_ATTRIBUTE15 LOV custom varchar2 Y 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 => 704, p_descriptive_flexfield_name => 'MRP_SR_ASSIGNMENTS', p_context_name => :$column$.assign_attribute_category, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.sr_assign_attribute1, p_attribute2 => :$column$.sr_assign_attribute2, p_attribute3 => :$column$.sr_assign_attribute3, p_attribute4 => :$column$.sr_assign_attribute4, p_attribute5 => :$column$.sr_assign_attribute5, p_attribute6 => :$column$.sr_assign_attribute6, p_attribute7 => :$column$.sr_assign_attribute7, p_attribute8 => :$column$.sr_assign_attribute8, p_attribute9 => :$column$.sr_assign_attribute9, p_attribute10 => :$column$.sr_assign_attribute10, p_attribute11 => :$column$.sr_assign_attribute11, p_attribute12 => :$column$.sr_assign_attribute12, p_attribute13 => :$column$.sr_assign_attribute13, p_attribute14 => :$column$.sr_assign_attribute14, p_attribute15 => :$column$.sr_assign_attribute15 ) ) lov order by value 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 = 704 and fdfv.descriptive_flexfield_name = 'MRP_SR_ASSIGNMENTS' and fdfcuv.application_column_name = 'ATTRIBUTE15' 58 DELETE_OPTION LOV custom varchar2 Y select value, description from ( select 'Assignment Set' value, 'Delete the Assignment Set' description from dual union all select 'Assignment' value, 'Delete the Assignment' description from dual ) order by value 59 ASSIGNMENT_SET_ID Number number Y 60 ASSIGNMENT_ID Number number Y 61 SOURCING_RULE_ID Number number Y 62 ASSIGNMENT_TYPE_ID Number number Y 63 MASTER_ORGANIZATION_ID Number number :$flex$.master_organization_id Y U 1 action_ in Char ACTION_CODE_ U 2 p_upload_mode in Char UPLOAD_MODE U 3 p_assignment_set_id in Number Y ASSIGNMENT_SET_ID U 4 p_assignment_set_name in Char Y ASSIGNMENT_SET U 5 p_assignment_set_description in Char Y ASSIGNMENT_SET_DESCRIPTION U 6 p_set_attribute_category in Char Y SET_ATTRIBUTE_CATEGORY U 7 p_set_attribute1 in Char Y SR_SET_ATTRIBUTE1 U 8 p_set_attribute2 in Char Y SR_SET_ATTRIBUTE2 U 9 p_set_attribute3 in Char Y SR_SET_ATTRIBUTE3 U 10 p_set_attribute4 in Char Y SR_SET_ATTRIBUTE4 U 11 p_set_attribute5 in Char Y SR_SET_ATTRIBUTE5 U 12 p_set_attribute6 in Char Y SR_SET_ATTRIBUTE6 U 13 p_set_attribute7 in Char Y SR_SET_ATTRIBUTE7 U 14 p_set_attribute8 in Char Y SR_SET_ATTRIBUTE8 U 15 p_set_attribute9 in Char Y SR_SET_ATTRIBUTE9 U 16 p_set_attribute10 in Char Y SR_SET_ATTRIBUTE10 U 17 p_set_attribute11 in Char Y SR_SET_ATTRIBUTE11 U 18 p_set_attribute12 in Char Y SR_SET_ATTRIBUTE12 U 19 p_set_attribute13 in Char Y SR_SET_ATTRIBUTE13 U 20 p_set_attribute14 in Char Y SR_SET_ATTRIBUTE14 U 21 p_set_attribute15 in Char Y SR_SET_ATTRIBUTE15 U 22 p_assignment_id in Number Y ASSIGNMENT_ID U 23 p_assignment_type in Number Y ASSIGNMENT_TYPE U 24 p_organization_id in Number Y ORGANIZATION U 25 p_item in Char Y ITEM U 26 p_inventory_item_id in Number Y U 27 p_category_set_id in Number Y U 28 p_category in Char Y CATEGORY U 29 p_category_id in Number Y U 30 p_customer_name in Char Y CUSTOMER_NAME U 31 p_customer_number in Char Y CUSTOMER_NUMBER U 32 p_customer_site in Char Y CUSTOMER_SITE U 33 p_customer_site_use in Char Y CUSTOMER_SITE_USE U 34 p_customer_site_ou in Char Y CUSTOMER_SITE_OU U 35 p_customer_id in Number Y U 36 p_customer_site_id in Number Y U 37 p_sourcing_rule_type in Number Y SOURCING_RULE_TYPE U 38 p_sourcing_rule_name in Char Y SOURCING_RULE_NAME U 39 p_sourcing_rule_org_id in Number Y SOURCING_RULE_ORG U 40 p_sourcing_rule_id in Number Y U 41 p_ass_attribute_category in Char Y ASSIGN_ATTRIBUTE_CATEGORY U 42 p_ass_attribute1 in Char Y SR_ASSIGN_ATTRIBUTE1 U 43 p_ass_attribute2 in Char Y SR_ASSIGN_ATTRIBUTE2 U 44 p_ass_attribute3 in Char Y SR_ASSIGN_ATTRIBUTE3 U 45 p_ass_attribute4 in Char Y SR_ASSIGN_ATTRIBUTE4 U 46 p_ass_attribute5 in Char Y SR_ASSIGN_ATTRIBUTE5 U 47 p_ass_attribute6 in Char Y SR_ASSIGN_ATTRIBUTE6 U 48 p_ass_attribute7 in Char Y SR_ASSIGN_ATTRIBUTE7 U 49 p_ass_attribute8 in Char Y SR_ASSIGN_ATTRIBUTE8 U 50 p_ass_attribute9 in Char Y SR_ASSIGN_ATTRIBUTE9 U 51 p_ass_attribute10 in Char Y SR_ASSIGN_ATTRIBUTE10 U 52 p_ass_attribute11 in Char Y SR_ASSIGN_ATTRIBUTE11 U 53 p_ass_attribute12 in Char Y SR_ASSIGN_ATTRIBUTE12 U 54 p_ass_attribute13 in Char Y SR_ASSIGN_ATTRIBUTE13 U 55 p_ass_attribute14 in Char Y SR_ASSIGN_ATTRIBUTE14 U 56 p_ass_attribute15 in Char Y SR_ASSIGN_ATTRIBUTE15 U 57 p_delete_option in Char DELETE_OPTION U 58 p_bypass_dff_validation in Char BYPASS_DFF_VALIDATION U 59 p_master_organization_id in Number MASTER_ORGANIZATION_ID U 60 p_set_row_id in/out Char SET_ROW_ID U 61 p_ass_row_id in/out Char ASS_ROW_ID U 62 request_id_ out Number REQUEST_ID_ U 63 status_ out Char STATUS_CODE_ U 64 message_ out Char MESSAGE_ Error SQL select xu.action_, xxen_upload.status_meaning(xxen_upload.status_error) status_, nvl (xu.message_, case when (xu.status_code_ = xxen_upload.status_success and xu.delete_option is null and sra.assignment_id is null) then 'Assignment has not been successfully created/updated' when (xu.status_code_ = xxen_upload.status_success and xu.delete_option is not null and sra.assignment_id is not null) then 'Assignment has not been successfully deleted' else null end ) message_, xu.request_id_, xu.modified_columns_, xu.set_row_id, xu.ass_row_id, xu.upload_mode, xu.bypass_dff_validation, -- assignment set xu.assignment_set, xu.assignment_set_description, -- assignment xu.assignment_type, xu.organization, xu.item, xu.category, xu.description, xu.customer_name, xu.customer_number, xu.customer_site, xu.customer_site_use, xu.customer_site_ou, xu.ship_to_address, xu.sourcing_rule_type, xu.sourcing_rule_name, xu.sourcing_rule_org, -- attributes xu.set_attribute_category, xu.sr_set_attribute1, xu.sr_set_attribute2, xu.sr_set_attribute3, xu.sr_set_attribute4, xu.sr_set_attribute5, xu.sr_set_attribute6, xu.sr_set_attribute7, xu.sr_set_attribute8, xu.sr_set_attribute9, xu.sr_set_attribute10, xu.sr_set_attribute11, xu.sr_set_attribute12, xu.sr_set_attribute13, xu.sr_set_attribute14, xu.sr_set_attribute15, -- xu.assign_attribute_category, xu.sr_assign_attribute1, xu.sr_assign_attribute2, xu.sr_assign_attribute3, xu.sr_assign_attribute4, xu.sr_assign_attribute5, xu.sr_assign_attribute6, xu.sr_assign_attribute7, xu.sr_assign_attribute8, xu.sr_assign_attribute9, xu.sr_assign_attribute10, xu.sr_assign_attribute11, xu.sr_assign_attribute12, xu.sr_assign_attribute13, xu.sr_assign_attribute14, xu.sr_assign_attribute15, -- xu.delete_option, -- ids xu.assignment_set_id, xu.assignment_id, xu.sourcing_rule_id, xu.assignment_type_id, xu.master_organization_id from xxen_mrp_sourcing_rule_8400_u xu, (select mrav.assignment_id from mrp_assignment_sets mas, mrp_sr_assignments_v mrav, mrp_sourcing_rules msr where mas.assignment_set_id = mrav.assignment_set_id and mrav.sourcing_rule_id = msr.sourcing_rule_id ) sra where to_number(xu.ass_row_id) = sra.assignment_id (+) and ( xu.status_code_ = xxen_upload.status_error or (xu.status_code_ = xxen_upload.status_success and xu.delete_option is null and sra.assignment_id is null) or (xu.status_code_ = xxen_upload.status_success and xu.delete_option is not null and sra.assignment_id is not null) ) Order By x.assignment_set, x.assignment_type_id, x.organization, nvl(x.item,x.category), x.customer_name, x.customer_site, x.sourcing_rule_name Success SQL select /*+ ordered */ xu.action_, xu.status_, case when xu.delete_option is not null then case when mrav.assignment_id is null and xu.delete_option = 'Assignment Set' then 'Assignment Set Deleted' when mrav.assignment_id is null and xu.delete_option = 'Assignment' then 'Assignment Deleted' else xu.message_ end else xu.message_ end message_, xu.request_id_, xu.modified_columns_, xu.set_row_id, xu.ass_row_id, xu.upload_mode, xu.bypass_dff_validation, -- assignment set nvl(mas.assignment_set_name,xu.assignment_set) assignment_set, nvl(mas.description,xu.assignment_set_description) assignment_set_description, -- assignment nvl( case mrav.assignment_type when 1 then 'Global' when 2 then 'Category' when 3 then 'Item' when 4 then 'Organization' when 5 then 'Category-Organization' when 6 then 'Item-Organization' end, xu.assignment_type) assignment_type, nvl(mrav.organization_code,xu.organization) organization, nvl(msiv.concatenated_segments,xu.item) item, nvl( case when mrav.assignment_type in (2,5) then mrav.entity_name else null end, xu.category) category, nvl( case when mrav.assignment_type in (3,6) then msiv.description else mrav.description end, xu.description) description, nvl(mrav.customer_name,xu.customer_name) customer_name, nvl(hca.account_number,xu.customer_number) customer_number, nvl(hcsua.location,xu.customer_site) customer_site, nvl(xxen_util.meaning(hcsua.site_use_code,'SITE_USE_CODE',222),xu.customer_site_use) customer_site_use, nvl(haouv.name,xu.customer_site_ou) customer_site_ou, nvl(mrav.ship_to_address,xu.ship_to_address) ship_to_address, nvl(mrav.sourcing_rule_type_text,xu.sourcing_rule_type) sourcing_rule_type, nvl(mrav.sourcing_rule_name,xu.sourcing_rule_name) sourcing_rule_name, nvl(mp.organization_code,xu.sourcing_rule_org) sourcing_rule_org, -- attributes xxen_util.display_flexfield_context(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category) set_attribute_category, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE1',mas.rowid,mas.attribute1) sr_set_attribute1, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE2',mas.rowid,mas.attribute2) sr_set_attribute2, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE3',mas.rowid,mas.attribute3) sr_set_attribute3, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE4',mas.rowid,mas.attribute4) sr_set_attribute4, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE5',mas.rowid,mas.attribute5) sr_set_attribute5, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE6',mas.rowid,mas.attribute6) sr_set_attribute6, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE7',mas.rowid,mas.attribute7) sr_set_attribute7, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE8',mas.rowid,mas.attribute8) sr_set_attribute8, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE9',mas.rowid,mas.attribute9) sr_set_attribute9, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE10',mas.rowid,mas.attribute10) sr_set_attribute10, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE11',mas.rowid,mas.attribute11) sr_set_attribute11, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE12',mas.rowid,mas.attribute12) sr_set_attribute12, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE13',mas.rowid,mas.attribute13) sr_set_attribute13, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE14',mas.rowid,mas.attribute14) sr_set_attribute14, xxen_util.display_flexfield_value(704,'MRP_ASSIGNMENT_SETS',mas.attribute_category,'ATTRIBUTE15',mas.rowid,mas.attribute15) sr_set_attribute15, -- xxen_util.display_flexfield_context(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category) assign_attribute_category, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE1',mrav.row_id,mrav.attribute1) sr_assign_attribute1, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE2',mrav.row_id,mrav.attribute2) sr_assign_attribute2, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE3',mrav.row_id,mrav.attribute3) sr_assign_attribute3, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE4',mrav.row_id,mrav.attribute4) sr_assign_attribute4, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE5',mrav.row_id,mrav.attribute5) sr_assign_attribute5, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE6',mrav.row_id,mrav.attribute6) sr_assign_attribute6, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE7',mrav.row_id,mrav.attribute7) sr_assign_attribute7, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE8',mrav.row_id,mrav.attribute8) sr_assign_attribute8, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE9',mrav.row_id,mrav.attribute9) sr_assign_attribute9, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE10',mrav.row_id,mrav.attribute10) sr_assign_attribute10, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE11',mrav.row_id,mrav.attribute11) sr_assign_attribute11, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE12',mrav.row_id,mrav.attribute12) sr_assign_attribute12, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE13',mrav.row_id,mrav.attribute13) sr_assign_attribute13, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE14',mrav.row_id,mrav.attribute14) sr_assign_attribute14, xxen_util.display_flexfield_value(704,'MRP_SR_ASSIGNMENTS',mrav.attribute_category,'ATTRIBUTE15',mrav.row_id,mrav.attribute15) sr_assign_attribute15, -- xu.delete_option, -- ids mas.assignment_set_id, mrav.assignment_id, mrav.sourcing_rule_id, mrav.assignment_type assignment_type_id, xu.master_organization_id from xxen_mrp_sourcing_rule_8400_u xu, mrp_sr_assignments_v mrav, mrp_assignment_sets mas, mrp_sourcing_rules msr, mtl_parameters mp, mtl_system_items_vl msiv, hz_cust_accounts hca, hz_cust_site_uses_all hcsua, hr_all_organization_units_vl haouv where xu.status_code_ = xxen_upload.status_success and to_number(xu.ass_row_id) = mrav.assignment_id(+) and mrav.assignment_set_id = mas.assignment_set_id (+) and mrav.sourcing_rule_id = msr.sourcing_rule_id(+) and msr.organization_id = mp.organization_id(+) and case when mrav.assignment_type in (3,6) then nvl(mrav.organization_id,:p_master_org_id) else null end = msiv.organization_id(+) and case when mrav.assignment_type in (3,6) then mrav.inventory_item_id else null end = msiv.inventory_item_id(+) and mrav.customer_id = hca.cust_account_id(+) and mrav.ship_to_site_id = hcsua.site_use_id(+) and hcsua.org_id = haouv.organization_id(+) and ( (xu.delete_option is null and mrav.assignment_id is not null) or (xu.delete_option is not null and mrav.assignment_id is null) )