ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 0BDB97CF103D6724E06362FB090508F8Y with sr_query as ( select -- -- sourcing rule xxen_util.meaning(mrs.sourcing_rule_type,'MRP_SOURCING_RULE_TYPE',700) rule_type, mrs.sourcing_rule_name rule_name, mrs.description rule_description, xxen_util.meaning(nvl2(mp.organization_code,'2','1'),'INV_YES_NO',3) all_orgs, mp.organization_code organization, xxen_util.meaning(mrs.status,'INV_YES_NO',3) active, xxen_util.meaning(decode(mrs.planning_active,1,1,null),'INV_YES_NO',3) planning_active, -- receiving organizations msrov.organization_code receipt_organization, msrov.customer receipt_customer, msrov.address receipt_address, msrov.effective_date effective_date_from, msrov.disable_date effective_date_to, -- shipping organization xxen_util.meaning(mssov.source_type,'MRP_SOURCE_TYPE',700) source_type, mssov.source_organization_code source_organization, asu.vendor_name supplier, asu.segment1 supplier_number, mssov.vendor_site supplier_site, haouv.name supplier_site_op_unit, mssov.allocation_percent, mssov.rank, mssov.ship_method, mssov.intransit_time, -- attributes xxen_util.display_flexfield_context(704,'MRP_SOURCING_RULES',mrs.attribute_category) rule_attribute_category, xxen_util.display_flexfield_value(704,'MRP_SOURCING_RULES',mrs.attribute_category,'ATTRIBUTE1',mrs.rowid,mrs.attribute1) sr_rule_attribute1, xxen_util.display_flexfield_value(704,'MRP_SOURCING_RULES',mrs.attribute_category,'ATTRIBUTE2',mrs.rowid,mrs.attribute2) sr_rule_attribute2, xxen_util.display_flexfield_value(704,'MRP_SOURCING_RULES',mrs.attribute_category,'ATTRIBUTE3',mrs.rowid,mrs.attribute3) sr_rule_attribute3, xxen_util.display_flexfield_value(704,'MRP_SOURCING_RULES',mrs.attribute_category,'ATTRIBUTE4',mrs.rowid,mrs.attribute4) sr_rule_attribute4, xxen_util.display_flexfield_value(704,'MRP_SOURCING_RULES',mrs.attribute_category,'ATTRIBUTE5',mrs.rowid,mrs.attribute5) sr_rule_attribute5, xxen_util.display_flexfield_value(704,'MRP_SOURCING_RULES',mrs.attribute_category,'ATTRIBUTE6',mrs.rowid,mrs.attribute6) sr_rule_attribute6, xxen_util.display_flexfield_value(704,'MRP_SOURCING_RULES',mrs.attribute_category,'ATTRIBUTE7',mrs.rowid,mrs.attribute7) sr_rule_attribute7, xxen_util.display_flexfield_value(704,'MRP_SOURCING_RULES',mrs.attribute_category,'ATTRIBUTE8',mrs.rowid,mrs.attribute8) sr_rule_attribute8, xxen_util.display_flexfield_value(704,'MRP_SOURCING_RULES',mrs.attribute_category,'ATTRIBUTE9',mrs.rowid,mrs.attribute9) sr_rule_attribute9, xxen_util.display_flexfield_value(704,'MRP_SOURCING_RULES',mrs.attribute_category,'ATTRIBUTE10',mrs.rowid,mrs.attribute10) sr_rule_attribute10, xxen_util.display_flexfield_value(704,'MRP_SOURCING_RULES',mrs.attribute_category,'ATTRIBUTE11',mrs.rowid,mrs.attribute11) sr_rule_attribute11, xxen_util.display_flexfield_value(704,'MRP_SOURCING_RULES',mrs.attribute_category,'ATTRIBUTE12',mrs.rowid,mrs.attribute12) sr_rule_attribute12, xxen_util.display_flexfield_value(704,'MRP_SOURCING_RULES',mrs.attribute_category,'ATTRIBUTE13',mrs.rowid,mrs.attribute13) sr_rule_attribute13, xxen_util.display_flexfield_value(704,'MRP_SOURCING_RULES',mrs.attribute_category,'ATTRIBUTE14',mrs.rowid,mrs.attribute14) sr_rule_attribute14, xxen_util.display_flexfield_value(704,'MRP_SOURCING_RULES',mrs.attribute_category,'ATTRIBUTE15',mrs.rowid,mrs.attribute15) sr_rule_attribute15, -- xxen_util.display_flexfield_context(704,'MRP_SR_RECEIPT_ORG',msrov.attribute_category) receipt_attribute_category, xxen_util.display_flexfield_value(704,'MRP_SR_RECEIPT_ORG',msrov.attribute_category,'ATTRIBUTE1',msrov.row_id,msrov.attribute1) sr_receipt_attribute1, xxen_util.display_flexfield_value(704,'MRP_SR_RECEIPT_ORG',msrov.attribute_category,'ATTRIBUTE2',msrov.row_id,msrov.attribute2) sr_receipt_attribute2, xxen_util.display_flexfield_value(704,'MRP_SR_RECEIPT_ORG',msrov.attribute_category,'ATTRIBUTE3',msrov.row_id,msrov.attribute3) sr_receipt_attribute3, xxen_util.display_flexfield_value(704,'MRP_SR_RECEIPT_ORG',msrov.attribute_category,'ATTRIBUTE4',msrov.row_id,msrov.attribute4) sr_receipt_attribute4, xxen_util.display_flexfield_value(704,'MRP_SR_RECEIPT_ORG',msrov.attribute_category,'ATTRIBUTE5',msrov.row_id,msrov.attribute5) sr_receipt_attribute5, xxen_util.display_flexfield_value(704,'MRP_SR_RECEIPT_ORG',msrov.attribute_category,'ATTRIBUTE6',msrov.row_id,msrov.attribute6) sr_receipt_attribute6, xxen_util.display_flexfield_value(704,'MRP_SR_RECEIPT_ORG',msrov.attribute_category,'ATTRIBUTE7',msrov.row_id,msrov.attribute7) sr_receipt_attribute7, xxen_util.display_flexfield_value(704,'MRP_SR_RECEIPT_ORG',msrov.attribute_category,'ATTRIBUTE8',msrov.row_id,msrov.attribute8) sr_receipt_attribute8, xxen_util.display_flexfield_value(704,'MRP_SR_RECEIPT_ORG',msrov.attribute_category,'ATTRIBUTE9',msrov.row_id,msrov.attribute9) sr_receipt_attribute9, xxen_util.display_flexfield_value(704,'MRP_SR_RECEIPT_ORG',msrov.attribute_category,'ATTRIBUTE10',msrov.row_id,msrov.attribute10) sr_receipt_attribute10, xxen_util.display_flexfield_value(704,'MRP_SR_RECEIPT_ORG',msrov.attribute_category,'ATTRIBUTE11',msrov.row_id,msrov.attribute11) sr_receipt_attribute11, xxen_util.display_flexfield_value(704,'MRP_SR_RECEIPT_ORG',msrov.attribute_category,'ATTRIBUTE12',msrov.row_id,msrov.attribute12) sr_receipt_attribute12, xxen_util.display_flexfield_value(704,'MRP_SR_RECEIPT_ORG',msrov.attribute_category,'ATTRIBUTE13',msrov.row_id,msrov.attribute13) sr_receipt_attribute13, xxen_util.display_flexfield_value(704,'MRP_SR_RECEIPT_ORG',msrov.attribute_category,'ATTRIBUTE14',msrov.row_id,msrov.attribute14) sr_receipt_attribute14, xxen_util.display_flexfield_value(704,'MRP_SR_RECEIPT_ORG',msrov.attribute_category,'ATTRIBUTE15',msrov.row_id,msrov.attribute15) sr_receipt_attribute15, -- xxen_util.display_flexfield_context(704,'MRP_SR_SOURCE_ORG',mssov.attribute_category) ship_attribute_category, xxen_util.display_flexfield_value(704,'MRP_SR_SOURCE_ORG',mssov.attribute_category,'ATTRIBUTE1',mssov.row_id,mssov.attribute1) sr_ship_attribute1, xxen_util.display_flexfield_value(704,'MRP_SR_SOURCE_ORG',mssov.attribute_category,'ATTRIBUTE2',mssov.row_id,mssov.attribute2) sr_ship_attribute2, xxen_util.display_flexfield_value(704,'MRP_SR_SOURCE_ORG',mssov.attribute_category,'ATTRIBUTE3',mssov.row_id,mssov.attribute3) sr_ship_attribute3, xxen_util.display_flexfield_value(704,'MRP_SR_SOURCE_ORG',mssov.attribute_category,'ATTRIBUTE4',mssov.row_id,mssov.attribute4) sr_ship_attribute4, xxen_util.display_flexfield_value(704,'MRP_SR_SOURCE_ORG',mssov.attribute_category,'ATTRIBUTE5',mssov.row_id,mssov.attribute5) sr_ship_attribute5, xxen_util.display_flexfield_value(704,'MRP_SR_SOURCE_ORG',mssov.attribute_category,'ATTRIBUTE6',mssov.row_id,mssov.attribute6) sr_ship_attribute6, xxen_util.display_flexfield_value(704,'MRP_SR_SOURCE_ORG',mssov.attribute_category,'ATTRIBUTE7',mssov.row_id,mssov.attribute7) sr_ship_attribute7, xxen_util.display_flexfield_value(704,'MRP_SR_SOURCE_ORG',mssov.attribute_category,'ATTRIBUTE8',mssov.row_id,mssov.attribute8) sr_ship_attribute8, xxen_util.display_flexfield_value(704,'MRP_SR_SOURCE_ORG',mssov.attribute_category,'ATTRIBUTE9',mssov.row_id,mssov.attribute9) sr_ship_attribute9, xxen_util.display_flexfield_value(704,'MRP_SR_SOURCE_ORG',mssov.attribute_category,'ATTRIBUTE10',mssov.row_id,mssov.attribute10) sr_ship_attribute10, xxen_util.display_flexfield_value(704,'MRP_SR_SOURCE_ORG',mssov.attribute_category,'ATTRIBUTE11',mssov.row_id,mssov.attribute11) sr_ship_attribute11, xxen_util.display_flexfield_value(704,'MRP_SR_SOURCE_ORG',mssov.attribute_category,'ATTRIBUTE12',mssov.row_id,mssov.attribute12) sr_ship_attribute12, xxen_util.display_flexfield_value(704,'MRP_SR_SOURCE_ORG',mssov.attribute_category,'ATTRIBUTE13',mssov.row_id,mssov.attribute13) sr_ship_attribute13, xxen_util.display_flexfield_value(704,'MRP_SR_SOURCE_ORG',mssov.attribute_category,'ATTRIBUTE14',mssov.row_id,mssov.attribute14) sr_ship_attribute14, xxen_util.display_flexfield_value(704,'MRP_SR_SOURCE_ORG',mssov.attribute_category,'ATTRIBUTE15',mssov.row_id,mssov.attribute15) sr_ship_attribute15, -- ids mrs.sourcing_rule_id, msrov.sr_receipt_id, mssov.sr_source_id, -- mssov.last_updated_by, mssov.last_update_date from mrp_sourcing_rules mrs, mtl_parameters mp, mrp_sr_receipt_org_v msrov, mrp_sr_source_org_v mssov, ap_suppliers asu, ap_supplier_sites_all assa, hr_all_organization_units_vl haouv where mp.organization_id (+) = mrs.organization_id and msrov.sourcing_rule_id (+) = mrs.sourcing_rule_id and mssov.sr_receipt_id (+) = msrov.sr_receipt_id and asu.vendor_id (+) = mssov.vendor_id and assa.vendor_site_id (+) = mssov.vendor_site_id and haouv.organization_id (+) = assa.org_id and (mrs.organization_id is null or mrs.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') ) ) -- -- Main Query Starts Here -- select /*+ push_pred(sr) */ null action_, null status_, null message_, null request_id_, null modified_columns_, null sr_row_id, null ro_row_id, null so_row_id, :p_upload_mode upload_mode, :p_bypass_dff_validation bypass_dff_validation, -- sourcing rule sr.rule_name, sr.rule_description, sr.rule_type, sr.planning_active, sr.all_orgs, -- receiving organizations sr.receipt_organization, sr.receipt_customer, sr.receipt_address, sr.effective_date_from, sr.effective_date_to, -- shipping organization sr.source_type, sr.source_organization, sr.supplier, sr.supplier_number, sr.supplier_site, sr.supplier_site_op_unit, sr.allocation_percent, sr.rank, sr.ship_method, sr.intransit_time, -- attributes sr.rule_attribute_category, sr.sr_rule_attribute1, sr.sr_rule_attribute2, sr.sr_rule_attribute3, sr.sr_rule_attribute4, sr.sr_rule_attribute5, sr.sr_rule_attribute6, sr.sr_rule_attribute7, sr.sr_rule_attribute8, sr.sr_rule_attribute9, sr.sr_rule_attribute10, sr.sr_rule_attribute11, sr.sr_rule_attribute12, sr.sr_rule_attribute13, sr.sr_rule_attribute14, sr.sr_rule_attribute15, -- sr.receipt_attribute_category, sr.sr_receipt_attribute1, sr.sr_receipt_attribute2, sr.sr_receipt_attribute3, sr.sr_receipt_attribute4, sr.sr_receipt_attribute5, sr.sr_receipt_attribute6, sr.sr_receipt_attribute7, sr.sr_receipt_attribute8, sr.sr_receipt_attribute9, sr.sr_receipt_attribute10, sr.sr_receipt_attribute11, sr.sr_receipt_attribute12, sr.sr_receipt_attribute13, sr.sr_receipt_attribute14, sr.sr_receipt_attribute15, -- sr.ship_attribute_category, sr.sr_ship_attribute1, sr.sr_ship_attribute2, sr.sr_ship_attribute3, sr.sr_ship_attribute4, sr.sr_ship_attribute5, sr.sr_ship_attribute6, sr.sr_ship_attribute7, sr.sr_ship_attribute8, sr.sr_ship_attribute9, sr.sr_ship_attribute10, sr.sr_ship_attribute11, sr.sr_ship_attribute12, sr.sr_ship_attribute13, sr.sr_ship_attribute14, sr.sr_ship_attribute15, -- null delete_option, -- ids sr.organization, sr.active, sr.sourcing_rule_id, sr.sr_receipt_id, sr.sr_source_id, to_number(null) group_id, to_number(null) upload_row from sr_query sr where :p_include_global = :p_include_global and 1=1 Code style: redundant column aliases removed; hidden upload_row column added and the result ordered by upload row first. U A xxen_mrp_upload.upload_sourcing_rule xxen_mrp_upload.do_sourcing_rule_import US MRP Sourcing Rule Upload MRP Sourcing Rule Upload ======================== - Upload new Sourcing Rules and Bills of Distribution - Download, update and delete existing Sourcing Rules, their receiving organizations and their sources Each row is one source (a shipping organization or a supplier) of one receiving organization of a sourcing rule. The rule and receiving organization columns repeat on every row of the rule. All rows of a rule are saved together through the Oracle sourcing rule API, so an error on one row rejects the whole rule. Planning Active is set by the upload: Yes when the allocation percentages of each rank of each receiving organization add up to 100. Delete Option - Sourcing Rule: deletes the whole rule - Shipping Org: deletes the source of the row A receiving organization entry cannot be deleted by the upload, as the Oracle API rejects it; delete its sources, delete the whole rule, or remove it in the Sourcing Rule form. Use Sourcing Rule Type, Sourcing Rule Organization and Include Global Sourcing Rules to select the rules to download. Enginatics Upload 1=1 :p_bypass_dff_validation :p_include_global :p_upload_mode 1 -10 :p_bypass_dff_validation LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Bypass DFF Validation 2 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create||','||xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C Y US Upload Mode 3 20 1=1 sr.rule_type = :p_rule_type LOV custom select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type = 'MRP_SOURCING_RULE_TYPE' and flvv.view_application_id = 700 and flvv.security_group_id = fnd_global.security_group_id and flvv.lookup_code in (1,2) order by value xxen_util.meaning(1,'MRP_SOURCING_RULE_TYPE',700) US Sourcing Rule Type 4 25 :p_include_global LOV custom select fl.lookup_code id, fl.meaning value, null description from fnd_lookups fl where fl.lookup_type='YES_NO' and (nvl(xxen_util.lookup_code(:$flex$.sourcing_rule_type,'MRP_SOURCING_RULE_TYPE',700),'1') = '1' or fl.lookup_code = 'Y' ) order by value Y Y US Include Global Sourcing Rules 5 1=1 sr.organization is not null N US Include Global Sourcing Rules 6 30 1=1 (sr.organization = :p_organization or (sr.organization is null and :p_include_global = 'Y' ) ) LOV custom select x.value, x.description from ( select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where ood.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') and nvl(ood.disable_date,sysdate)>=sysdate and (:$flex$.Sourcing_Rule_Type is null or xxen_util.lookup_code(:$flex$.Sourcing_Rule_Type,'MRP_SOURCING_RULE_TYPE',700) = 1) ) x order by x.value select mp.organization_code from mtl_parameters mp where mp.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') and xxen_util.lookup_code(:$flex$.Sourcing_Rule_Type,'MRP_SOURCING_RULE_TYPE',700) = 1 US Sourcing Rule Organization 7 50 1=1 sr.rule_name = :p_rule_name LOV custom 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 (mrs.organization_id is null or mrs.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') ) 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,nvl(mp.organization_code,'*All Orgs*')) = 'Y' ) order by value US Sourcing Rule Name 8 60 1=1 lower(sr.rule_name) like lower(:p_rule_name_like) Char US Sourcing Rule Name Like 1DABEDDB582AA51BABA1B2EBF529774C Default SYSADMIN 14 ALLOCATION_PERCENT 5 ALL_ORGS 18 DELETE_OPTION 7 EFFECTIVE_DATE_FROM 8 EFFECTIVE_DATE_TO 17 INTRANSIT_TIME 4 PLANNING_ACTIVE 15 RANK 6 RECEIPT_ORGANIZATION 2 RULE_DESCRIPTION Y 1 RULE_NAME 3 RULE_TYPE 16 SHIP_METHOD 10 SOURCE_ORGANIZATION 9 SOURCE_TYPE 11 SUPPLIER 12 SUPPLIER_SITE 13 SUPPLIER_SITE_OP_UNIT S Site 1DABEDDB582AA51BABA1B2EBF529774C 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 SR_ROW_ID Char varchar2 Y 7 RO_ROW_ID Char varchar2 Y 8 SO_ROW_ID Char varchar2 Y 9 UPLOAD_MODE Char varchar2 2000 :$flex$.Upload_Mode Y 10 BYPASS_DFF_VALIDATION Char varchar2 2000 :$flex$.Bypass_DFF_Validation Y Y 11 RULE_NAME Char varchar2 50 Y 12 RULE_DESCRIPTION Char varchar2 80 13 RULE_TYPE LOV custom varchar2 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) order by value select lookup_code id, meaning value from mfg_lookups where lookup_type = 'MRP_SOURCING_RULE_TYPE' :$flex$.Sourcing_Rule_Type Y Y 14 PLANNING_ACTIVE LOV custom varchar2 select flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type = 'INV_YES_NO' and flvv.view_application_id = 3 and flvv.security_group_id = fnd_global.security_group_id and flvv.lookup_code = 1 order by value This column is display only. It will be updated automatically by the upload. Y 15 ALL_ORGS LOV custom varchar2 select flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type = 'INV_YES_NO' and flvv.view_application_id = 3 and flvv.security_group_id = fnd_global.security_group_id and (flvv.lookup_code = '1' or xxen_util.lookup_code(:$column$.rule_type,'MRP_SOURCING_RULE_TYPE',700) = '1' ) order by value select lookup_code id, meaning value from fnd_lookup_values_vl where lookup_type = 'INV_YES_NO' and view_application_id = 3 and security_group_id = fnd_global.security_group_id Y Y 16 RECEIPT_ORGANIZATION LOV custom varchar2 3 select x.value, x.description from ( select mp.organization_code value, mrp_manager_pk.get_customer_name(hoi.org_information1) || nvl2(mrp_manager_pk.get_ship_address(hoi.org_information2),' (' || mrp_manager_pk.get_ship_address(hoi.org_information2) || ')',null) description from mtl_parameters mp, hr_organization_information hoi where hoi.organization_id (+)= mp.organization_id and hoi.org_information_context(+) = 'Customer/Supplier Association' and ( (xxen_util.lookup_code(:$column$.rule_type,'MRP_SOURCING_RULE_TYPE',700) = '1' and xxen_util.lookup_code(:$column$.all_orgs,'INV_YES_NO',3) = '2' and mp.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') ) or xxen_util.lookup_code(:$column$.rule_type,'MRP_SOURCING_RULE_TYPE',700) = '2' ) ) x order by x.value select organization_id id, organization_code value from mtl_parameters Y 17 RECEIPT_CUSTOMER LOV custom varchar2 360 select mrp_manager_pk.get_customer_name(hoi.org_information1) value, null description from mtl_parameters mp, hr_organization_information hoi where mp.organization_code = :$column$.receipt_organization and hoi.organization_id = mp.organization_id and hoi.org_information_context = 'Customer/Supplier Association' select mrp_manager_pk.get_customer_name(hoi.org_information1) from mtl_parameters mp, hr_organization_information hoi where mp.organization_code = :$column$.receipt_organization and hoi.organization_id = mp.organization_id and hoi.org_information_context = 'Customer/Supplier Association' Y 18 RECEIPT_ADDRESS LOV custom varchar2 240 select mrp_manager_pk.get_ship_address(hoi.org_information2) value, null description from mtl_parameters mp, hr_organization_information hoi where mp.organization_code = :$column$.receipt_organization and hoi.organization_id = mp.organization_id and hoi.org_information_context = 'Customer/Supplier Association' select mrp_manager_pk.get_ship_address(hoi.org_information2) from mtl_parameters mp, hr_organization_information hoi where mp.organization_code = :$column$.receipt_organization and hoi.organization_id = mp.organization_id and hoi.org_information_context = 'Customer/Supplier Association' Y 19 EFFECTIVE_DATE_FROM Date date trunc(sysdate) Y 20 EFFECTIVE_DATE_TO Date date 21 SOURCE_TYPE LOV custom varchar2 select ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type = 'MRP_SOURCE_TYPE' and (ml.lookup_code in (1,3) or (ml.lookup_code = 2 and (xxen_util.lookup_code(:$column$.rule_type,'MRP_SOURCING_RULE_TYPE',700) = 2 or :$column$.receipt_organization != '*All Orgs*' ) ) ) order by value select lookup_code id, meaning value from mfg_lookups where lookup_type = 'MRP_SOURCE_TYPE' Y Y 22 SOURCE_ORGANIZATION LOV custom varchar2 3 select x.value, null description from ( select mps.organization_code value from mtl_parameters mpr, mtl_parameters mps, mtl_interorg_parameters mip where mip.to_organization_id = mpr.organization_id and mip.from_organization_id = mps.organization_id and mpr.organization_code = :$column$.receipt_organization and xxen_util.lookup_code(:$column$.source_type,'MRP_SOURCE_TYPE',700) = 1 and -- transfer from xxen_util.lookup_code(:$column$.all_orgs,'INV_YES_NO',3) = '2' union select mp.organization_code value from mtl_parameters mp where ( xxen_util.lookup_code(:$column$.all_orgs,'INV_YES_NO',3) = '1' or (mp.organization_code = :$column$.receipt_organization and xxen_util.lookup_code(:$column$.source_type,'MRP_SOURCE_TYPE',700) = 2 -- make at ) ) and xxen_util.lookup_code(:$column$.source_type,'MRP_SOURCE_TYPE',700) != 3 -- buy from ) x order by x.value select organization_id id, organization_code value from mtl_parameters select :$column$.receipt_organization from dual where xxen_util.lookup_code(:$column$.source_type,'MRP_SOURCE_TYPE',700) = 2 and xxen_util.lookup_code(:$column$.all_orgs,'INV_YES_NO',3) = '2' 23 SUPPLIER LOV custom varchar2 240 select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where nvl(aps.enabled_flag,'N') = 'Y' and sysdate between nvl(aps.start_date_active, sysdate-1) and nvl(aps.end_date_active, sysdate+1) and xxen_util.lookup_code(:$column$.source_type,'MRP_SOURCE_TYPE',700) = 3 -- buy from order by value 24 SUPPLIER_NUMBER LOV custom varchar2 30 select aps.segment1 value, aps.vendor_name description from ap_suppliers aps where nvl(aps.enabled_flag,'N') = 'Y' and sysdate between nvl(aps.start_date_active, sysdate-1) and nvl(aps.end_date_active, sysdate+1) and aps.vendor_name = :$column$.supplier order by value select aps.segment1 from ap_suppliers aps where nvl(aps.enabled_flag,'N') = 'Y' and sysdate between nvl(aps.start_date_active, sysdate-1) and nvl(aps.end_date_active, sysdate+1) and aps.vendor_name = :$column$.supplier 25 SUPPLIER_SITE LOV custom varchar2 60 select distinct assa.vendor_site_code value, hou.name description from ap_suppliers aps, ap_supplier_sites_all assa, hr_operating_units hou where aps.vendor_id = assa.vendor_id and nvl(aps.enabled_flag,'N') = 'Y' and sysdate between nvl(aps.start_date_active, sysdate-1) and nvl(aps.end_date_active, sysdate+1) and sysdate < nvl(assa.inactive_date, sysdate + 1) and assa.purchasing_site_flag = 'Y' and nvl(assa.rfq_only_site_flag,'N') != 'Y' and assa.org_id = hou.organization_id (+) and aps.vendor_name = :$column$.supplier and aps.segment1 = nvl(:$column$.supplier_number,aps.segment1) order by value select x.value from ( select assa.vendor_site_code value, count(distinct assa.vendor_site_code) over () cnt from ap_suppliers aps, ap_supplier_sites_all assa, hr_operating_units hou where aps.vendor_id = assa.vendor_id and nvl(aps.enabled_flag,'N') = 'Y' and sysdate between nvl(aps.start_date_active, sysdate-1) and nvl(aps.end_date_active, sysdate+1) and sysdate < nvl(assa.inactive_date, sysdate + 1) and assa.purchasing_site_flag = 'Y' and nvl(assa.rfq_only_site_flag,'N') != 'Y' and assa.org_id = hou.organization_id (+) and aps.vendor_name = :$column$.supplier and aps.segment1 = nvl(:$column$.supplier_number,aps.segment1) ) x where x.cnt = 1 26 SUPPLIER_SITE_OP_UNIT LOV custom varchar2 240 select distinct hou.name value, null description from ap_suppliers aps, ap_supplier_sites_all assa, hr_operating_units hou where aps.vendor_id = assa.vendor_id and nvl(aps.enabled_flag,'N') = 'Y' and sysdate between nvl(aps.start_date_active, sysdate-1) and nvl(aps.end_date_active, sysdate+1) and sysdate < nvl(assa.inactive_date, sysdate + 1) and assa.purchasing_site_flag = 'Y' and nvl(assa.rfq_only_site_flag,'N') != 'Y' and assa.org_id = hou.organization_id (+) and aps.vendor_name = :$column$.supplier and aps.segment1 = nvl(:$column$.supplier_number,aps.segment1) and assa.vendor_site_code = :$column$.supplier_site order by value select x.value from ( select hou.name value, count(*) over () cnt from ap_suppliers aps, ap_supplier_sites_all assa, hr_operating_units hou where aps.vendor_id = assa.vendor_id and nvl(aps.enabled_flag,'N') = 'Y' and sysdate between nvl(aps.start_date_active, sysdate-1) and nvl(aps.end_date_active, sysdate+1) and sysdate < nvl(assa.inactive_date, sysdate + 1) and assa.purchasing_site_flag = 'Y' and nvl(assa.rfq_only_site_flag,'N') != 'Y' and assa.org_id = hou.organization_id (+) and aps.vendor_name = :$column$.supplier and aps.segment1 = nvl(:$column$.supplier_number,aps.segment1) and assa.vendor_site_code = :$column$.supplier_site ) x where x.cnt = 1 27 ALLOCATION_PERCENT Number number Y 28 RANK Number number Y 29 SHIP_METHOD LOV custom varchar2 30 select mism.ship_method value, null description from mtl_interorg_ship_methods mism, mtl_parameters mpr, mtl_parameters mps where mism.to_organization_id = mpr.organization_id and mism.from_organization_id = mps.organization_id and mpr.organization_code = :$column$.receipt_organization and mps.organization_code = :$column$.source_organization and xxen_util.lookup_code(:$column$.source_type,'MRP_SOURCE_TYPE',700) != 2 -- make at order by value 30 INTRANSIT_TIME LOV custom number select mism.intransit_time value, null description from mtl_interorg_ship_methods mism, mtl_parameters mpr, mtl_parameters mps where mism.to_organization_id = mpr.organization_id and mism.from_organization_id = mps.organization_id and mpr.organization_code = :$column$.receipt_organization and mps.organization_code = :$column$.source_organization and mism.ship_method = :$column$.ship_method order by value select mism.intransit_time from mtl_interorg_ship_methods mism, mtl_parameters mpr, mtl_parameters mps where mism.to_organization_id = mpr.organization_id and mism.from_organization_id = mps.organization_id and mpr.organization_code = :$column$.receipt_organization and mps.organization_code = :$column$.source_organization and mism.ship_method = :$column$.ship_method 31 RULE_ATTRIBUTE_CATEGORY LOV custom varchar2 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_SOURCING_RULES' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 32 SR_RULE_ATTRIBUTE1 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SOURCING_RULES', p_context_name => :$column$.rule_attribute_category, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.sr_rule_attribute1, p_attribute2 => :$column$.sr_rule_attribute2, p_attribute3 => :$column$.sr_rule_attribute3, p_attribute4 => :$column$.sr_rule_attribute4, p_attribute5 => :$column$.sr_rule_attribute5, p_attribute6 => :$column$.sr_rule_attribute6, p_attribute7 => :$column$.sr_rule_attribute7, p_attribute8 => :$column$.sr_rule_attribute8, p_attribute9 => :$column$.sr_rule_attribute9, p_attribute10 => :$column$.sr_rule_attribute10, p_attribute11 => :$column$.sr_rule_attribute11, p_attribute12 => :$column$.sr_rule_attribute12, p_attribute13 => :$column$.sr_rule_attribute13, p_attribute14 => :$column$.sr_rule_attribute14, p_attribute15 => :$column$.sr_rule_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_SOURCING_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE1' 33 SR_RULE_ATTRIBUTE2 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SOURCING_RULES', p_context_name => :$column$.rule_attribute_category, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.sr_rule_attribute1, p_attribute2 => :$column$.sr_rule_attribute2, p_attribute3 => :$column$.sr_rule_attribute3, p_attribute4 => :$column$.sr_rule_attribute4, p_attribute5 => :$column$.sr_rule_attribute5, p_attribute6 => :$column$.sr_rule_attribute6, p_attribute7 => :$column$.sr_rule_attribute7, p_attribute8 => :$column$.sr_rule_attribute8, p_attribute9 => :$column$.sr_rule_attribute9, p_attribute10 => :$column$.sr_rule_attribute10, p_attribute11 => :$column$.sr_rule_attribute11, p_attribute12 => :$column$.sr_rule_attribute12, p_attribute13 => :$column$.sr_rule_attribute13, p_attribute14 => :$column$.sr_rule_attribute14, p_attribute15 => :$column$.sr_rule_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_SOURCING_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE2' 34 SR_RULE_ATTRIBUTE3 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SOURCING_RULES', p_context_name => :$column$.rule_attribute_category, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.sr_rule_attribute1, p_attribute2 => :$column$.sr_rule_attribute2, p_attribute3 => :$column$.sr_rule_attribute3, p_attribute4 => :$column$.sr_rule_attribute4, p_attribute5 => :$column$.sr_rule_attribute5, p_attribute6 => :$column$.sr_rule_attribute6, p_attribute7 => :$column$.sr_rule_attribute7, p_attribute8 => :$column$.sr_rule_attribute8, p_attribute9 => :$column$.sr_rule_attribute9, p_attribute10 => :$column$.sr_rule_attribute10, p_attribute11 => :$column$.sr_rule_attribute11, p_attribute12 => :$column$.sr_rule_attribute12, p_attribute13 => :$column$.sr_rule_attribute13, p_attribute14 => :$column$.sr_rule_attribute14, p_attribute15 => :$column$.sr_rule_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_SOURCING_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE3' 35 SR_RULE_ATTRIBUTE4 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SOURCING_RULES', p_context_name => :$column$.rule_attribute_category, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.sr_rule_attribute1, p_attribute2 => :$column$.sr_rule_attribute2, p_attribute3 => :$column$.sr_rule_attribute3, p_attribute4 => :$column$.sr_rule_attribute4, p_attribute5 => :$column$.sr_rule_attribute5, p_attribute6 => :$column$.sr_rule_attribute6, p_attribute7 => :$column$.sr_rule_attribute7, p_attribute8 => :$column$.sr_rule_attribute8, p_attribute9 => :$column$.sr_rule_attribute9, p_attribute10 => :$column$.sr_rule_attribute10, p_attribute11 => :$column$.sr_rule_attribute11, p_attribute12 => :$column$.sr_rule_attribute12, p_attribute13 => :$column$.sr_rule_attribute13, p_attribute14 => :$column$.sr_rule_attribute14, p_attribute15 => :$column$.sr_rule_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_SOURCING_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE4' 36 SR_RULE_ATTRIBUTE5 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SOURCING_RULES', p_context_name => :$column$.rule_attribute_category, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.sr_rule_attribute1, p_attribute2 => :$column$.sr_rule_attribute2, p_attribute3 => :$column$.sr_rule_attribute3, p_attribute4 => :$column$.sr_rule_attribute4, p_attribute5 => :$column$.sr_rule_attribute5, p_attribute6 => :$column$.sr_rule_attribute6, p_attribute7 => :$column$.sr_rule_attribute7, p_attribute8 => :$column$.sr_rule_attribute8, p_attribute9 => :$column$.sr_rule_attribute9, p_attribute10 => :$column$.sr_rule_attribute10, p_attribute11 => :$column$.sr_rule_attribute11, p_attribute12 => :$column$.sr_rule_attribute12, p_attribute13 => :$column$.sr_rule_attribute13, p_attribute14 => :$column$.sr_rule_attribute14, p_attribute15 => :$column$.sr_rule_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_SOURCING_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE5' 37 SR_RULE_ATTRIBUTE6 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SOURCING_RULES', p_context_name => :$column$.rule_attribute_category, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.sr_rule_attribute1, p_attribute2 => :$column$.sr_rule_attribute2, p_attribute3 => :$column$.sr_rule_attribute3, p_attribute4 => :$column$.sr_rule_attribute4, p_attribute5 => :$column$.sr_rule_attribute5, p_attribute6 => :$column$.sr_rule_attribute6, p_attribute7 => :$column$.sr_rule_attribute7, p_attribute8 => :$column$.sr_rule_attribute8, p_attribute9 => :$column$.sr_rule_attribute9, p_attribute10 => :$column$.sr_rule_attribute10, p_attribute11 => :$column$.sr_rule_attribute11, p_attribute12 => :$column$.sr_rule_attribute12, p_attribute13 => :$column$.sr_rule_attribute13, p_attribute14 => :$column$.sr_rule_attribute14, p_attribute15 => :$column$.sr_rule_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_SOURCING_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE6' 38 SR_RULE_ATTRIBUTE7 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SOURCING_RULES', p_context_name => :$column$.rule_attribute_category, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.sr_rule_attribute1, p_attribute2 => :$column$.sr_rule_attribute2, p_attribute3 => :$column$.sr_rule_attribute3, p_attribute4 => :$column$.sr_rule_attribute4, p_attribute5 => :$column$.sr_rule_attribute5, p_attribute6 => :$column$.sr_rule_attribute6, p_attribute7 => :$column$.sr_rule_attribute7, p_attribute8 => :$column$.sr_rule_attribute8, p_attribute9 => :$column$.sr_rule_attribute9, p_attribute10 => :$column$.sr_rule_attribute10, p_attribute11 => :$column$.sr_rule_attribute11, p_attribute12 => :$column$.sr_rule_attribute12, p_attribute13 => :$column$.sr_rule_attribute13, p_attribute14 => :$column$.sr_rule_attribute14, p_attribute15 => :$column$.sr_rule_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_SOURCING_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE7' 39 SR_RULE_ATTRIBUTE8 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SOURCING_RULES', p_context_name => :$column$.rule_attribute_category, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.sr_rule_attribute1, p_attribute2 => :$column$.sr_rule_attribute2, p_attribute3 => :$column$.sr_rule_attribute3, p_attribute4 => :$column$.sr_rule_attribute4, p_attribute5 => :$column$.sr_rule_attribute5, p_attribute6 => :$column$.sr_rule_attribute6, p_attribute7 => :$column$.sr_rule_attribute7, p_attribute8 => :$column$.sr_rule_attribute8, p_attribute9 => :$column$.sr_rule_attribute9, p_attribute10 => :$column$.sr_rule_attribute10, p_attribute11 => :$column$.sr_rule_attribute11, p_attribute12 => :$column$.sr_rule_attribute12, p_attribute13 => :$column$.sr_rule_attribute13, p_attribute14 => :$column$.sr_rule_attribute14, p_attribute15 => :$column$.sr_rule_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_SOURCING_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE8' 40 SR_RULE_ATTRIBUTE9 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SOURCING_RULES', p_context_name => :$column$.rule_attribute_category, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.sr_rule_attribute1, p_attribute2 => :$column$.sr_rule_attribute2, p_attribute3 => :$column$.sr_rule_attribute3, p_attribute4 => :$column$.sr_rule_attribute4, p_attribute5 => :$column$.sr_rule_attribute5, p_attribute6 => :$column$.sr_rule_attribute6, p_attribute7 => :$column$.sr_rule_attribute7, p_attribute8 => :$column$.sr_rule_attribute8, p_attribute9 => :$column$.sr_rule_attribute9, p_attribute10 => :$column$.sr_rule_attribute10, p_attribute11 => :$column$.sr_rule_attribute11, p_attribute12 => :$column$.sr_rule_attribute12, p_attribute13 => :$column$.sr_rule_attribute13, p_attribute14 => :$column$.sr_rule_attribute14, p_attribute15 => :$column$.sr_rule_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_SOURCING_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE9' 41 SR_RULE_ATTRIBUTE10 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SOURCING_RULES', p_context_name => :$column$.rule_attribute_category, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.sr_rule_attribute1, p_attribute2 => :$column$.sr_rule_attribute2, p_attribute3 => :$column$.sr_rule_attribute3, p_attribute4 => :$column$.sr_rule_attribute4, p_attribute5 => :$column$.sr_rule_attribute5, p_attribute6 => :$column$.sr_rule_attribute6, p_attribute7 => :$column$.sr_rule_attribute7, p_attribute8 => :$column$.sr_rule_attribute8, p_attribute9 => :$column$.sr_rule_attribute9, p_attribute10 => :$column$.sr_rule_attribute10, p_attribute11 => :$column$.sr_rule_attribute11, p_attribute12 => :$column$.sr_rule_attribute12, p_attribute13 => :$column$.sr_rule_attribute13, p_attribute14 => :$column$.sr_rule_attribute14, p_attribute15 => :$column$.sr_rule_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_SOURCING_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE10' 42 SR_RULE_ATTRIBUTE11 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SOURCING_RULES', p_context_name => :$column$.rule_attribute_category, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.sr_rule_attribute1, p_attribute2 => :$column$.sr_rule_attribute2, p_attribute3 => :$column$.sr_rule_attribute3, p_attribute4 => :$column$.sr_rule_attribute4, p_attribute5 => :$column$.sr_rule_attribute5, p_attribute6 => :$column$.sr_rule_attribute6, p_attribute7 => :$column$.sr_rule_attribute7, p_attribute8 => :$column$.sr_rule_attribute8, p_attribute9 => :$column$.sr_rule_attribute9, p_attribute10 => :$column$.sr_rule_attribute10, p_attribute11 => :$column$.sr_rule_attribute11, p_attribute12 => :$column$.sr_rule_attribute12, p_attribute13 => :$column$.sr_rule_attribute13, p_attribute14 => :$column$.sr_rule_attribute14, p_attribute15 => :$column$.sr_rule_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_SOURCING_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE11' 43 SR_RULE_ATTRIBUTE12 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SOURCING_RULES', p_context_name => :$column$.rule_attribute_category, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.sr_rule_attribute1, p_attribute2 => :$column$.sr_rule_attribute2, p_attribute3 => :$column$.sr_rule_attribute3, p_attribute4 => :$column$.sr_rule_attribute4, p_attribute5 => :$column$.sr_rule_attribute5, p_attribute6 => :$column$.sr_rule_attribute6, p_attribute7 => :$column$.sr_rule_attribute7, p_attribute8 => :$column$.sr_rule_attribute8, p_attribute9 => :$column$.sr_rule_attribute9, p_attribute10 => :$column$.sr_rule_attribute10, p_attribute11 => :$column$.sr_rule_attribute11, p_attribute12 => :$column$.sr_rule_attribute12, p_attribute13 => :$column$.sr_rule_attribute13, p_attribute14 => :$column$.sr_rule_attribute14, p_attribute15 => :$column$.sr_rule_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_SOURCING_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE12' 44 SR_RULE_ATTRIBUTE13 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SOURCING_RULES', p_context_name => :$column$.rule_attribute_category, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.sr_rule_attribute1, p_attribute2 => :$column$.sr_rule_attribute2, p_attribute3 => :$column$.sr_rule_attribute3, p_attribute4 => :$column$.sr_rule_attribute4, p_attribute5 => :$column$.sr_rule_attribute5, p_attribute6 => :$column$.sr_rule_attribute6, p_attribute7 => :$column$.sr_rule_attribute7, p_attribute8 => :$column$.sr_rule_attribute8, p_attribute9 => :$column$.sr_rule_attribute9, p_attribute10 => :$column$.sr_rule_attribute10, p_attribute11 => :$column$.sr_rule_attribute11, p_attribute12 => :$column$.sr_rule_attribute12, p_attribute13 => :$column$.sr_rule_attribute13, p_attribute14 => :$column$.sr_rule_attribute14, p_attribute15 => :$column$.sr_rule_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_SOURCING_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE13' 45 SR_RULE_ATTRIBUTE14 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SOURCING_RULES', p_context_name => :$column$.rule_attribute_category, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.sr_rule_attribute1, p_attribute2 => :$column$.sr_rule_attribute2, p_attribute3 => :$column$.sr_rule_attribute3, p_attribute4 => :$column$.sr_rule_attribute4, p_attribute5 => :$column$.sr_rule_attribute5, p_attribute6 => :$column$.sr_rule_attribute6, p_attribute7 => :$column$.sr_rule_attribute7, p_attribute8 => :$column$.sr_rule_attribute8, p_attribute9 => :$column$.sr_rule_attribute9, p_attribute10 => :$column$.sr_rule_attribute10, p_attribute11 => :$column$.sr_rule_attribute11, p_attribute12 => :$column$.sr_rule_attribute12, p_attribute13 => :$column$.sr_rule_attribute13, p_attribute14 => :$column$.sr_rule_attribute14, p_attribute15 => :$column$.sr_rule_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_SOURCING_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE14' 46 SR_RULE_ATTRIBUTE15 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SOURCING_RULES', p_context_name => :$column$.rule_attribute_category, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.sr_rule_attribute1, p_attribute2 => :$column$.sr_rule_attribute2, p_attribute3 => :$column$.sr_rule_attribute3, p_attribute4 => :$column$.sr_rule_attribute4, p_attribute5 => :$column$.sr_rule_attribute5, p_attribute6 => :$column$.sr_rule_attribute6, p_attribute7 => :$column$.sr_rule_attribute7, p_attribute8 => :$column$.sr_rule_attribute8, p_attribute9 => :$column$.sr_rule_attribute9, p_attribute10 => :$column$.sr_rule_attribute10, p_attribute11 => :$column$.sr_rule_attribute11, p_attribute12 => :$column$.sr_rule_attribute12, p_attribute13 => :$column$.sr_rule_attribute13, p_attribute14 => :$column$.sr_rule_attribute14, p_attribute15 => :$column$.sr_rule_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_SOURCING_RULES' and fdfcuv.application_column_name = 'ATTRIBUTE15' 47 RECEIPT_ATTRIBUTE_CATEGORY LOV custom varchar2 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_RECEIPT_ORG' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 48 SR_RECEIPT_ATTRIBUTE1 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_RECEIPT_ORG', p_context_name => :$column$.receipt_attribute_category, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.sr_receipt_attribute1, p_attribute2 => :$column$.sr_receipt_attribute2, p_attribute3 => :$column$.sr_receipt_attribute3, p_attribute4 => :$column$.sr_receipt_attribute4, p_attribute5 => :$column$.sr_receipt_attribute5, p_attribute6 => :$column$.sr_receipt_attribute6, p_attribute7 => :$column$.sr_receipt_attribute7, p_attribute8 => :$column$.sr_receipt_attribute8, p_attribute9 => :$column$.sr_receipt_attribute9, p_attribute10 => :$column$.sr_receipt_attribute10, p_attribute11 => :$column$.sr_receipt_attribute11, p_attribute12 => :$column$.sr_receipt_attribute12, p_attribute13 => :$column$.sr_receipt_attribute13, p_attribute14 => :$column$.sr_receipt_attribute14, p_attribute15 => :$column$.sr_receipt_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_RECEIPT_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE1' 49 SR_RECEIPT_ATTRIBUTE2 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_RECEIPT_ORG', p_context_name => :$column$.receipt_attribute_category, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.sr_receipt_attribute1, p_attribute2 => :$column$.sr_receipt_attribute2, p_attribute3 => :$column$.sr_receipt_attribute3, p_attribute4 => :$column$.sr_receipt_attribute4, p_attribute5 => :$column$.sr_receipt_attribute5, p_attribute6 => :$column$.sr_receipt_attribute6, p_attribute7 => :$column$.sr_receipt_attribute7, p_attribute8 => :$column$.sr_receipt_attribute8, p_attribute9 => :$column$.sr_receipt_attribute9, p_attribute10 => :$column$.sr_receipt_attribute10, p_attribute11 => :$column$.sr_receipt_attribute11, p_attribute12 => :$column$.sr_receipt_attribute12, p_attribute13 => :$column$.sr_receipt_attribute13, p_attribute14 => :$column$.sr_receipt_attribute14, p_attribute15 => :$column$.sr_receipt_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_RECEIPT_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE2' 50 SR_RECEIPT_ATTRIBUTE3 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_RECEIPT_ORG', p_context_name => :$column$.receipt_attribute_category, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.sr_receipt_attribute1, p_attribute2 => :$column$.sr_receipt_attribute2, p_attribute3 => :$column$.sr_receipt_attribute3, p_attribute4 => :$column$.sr_receipt_attribute4, p_attribute5 => :$column$.sr_receipt_attribute5, p_attribute6 => :$column$.sr_receipt_attribute6, p_attribute7 => :$column$.sr_receipt_attribute7, p_attribute8 => :$column$.sr_receipt_attribute8, p_attribute9 => :$column$.sr_receipt_attribute9, p_attribute10 => :$column$.sr_receipt_attribute10, p_attribute11 => :$column$.sr_receipt_attribute11, p_attribute12 => :$column$.sr_receipt_attribute12, p_attribute13 => :$column$.sr_receipt_attribute13, p_attribute14 => :$column$.sr_receipt_attribute14, p_attribute15 => :$column$.sr_receipt_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_RECEIPT_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE3' 51 SR_RECEIPT_ATTRIBUTE4 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_RECEIPT_ORG', p_context_name => :$column$.receipt_attribute_category, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.sr_receipt_attribute1, p_attribute2 => :$column$.sr_receipt_attribute2, p_attribute3 => :$column$.sr_receipt_attribute3, p_attribute4 => :$column$.sr_receipt_attribute4, p_attribute5 => :$column$.sr_receipt_attribute5, p_attribute6 => :$column$.sr_receipt_attribute6, p_attribute7 => :$column$.sr_receipt_attribute7, p_attribute8 => :$column$.sr_receipt_attribute8, p_attribute9 => :$column$.sr_receipt_attribute9, p_attribute10 => :$column$.sr_receipt_attribute10, p_attribute11 => :$column$.sr_receipt_attribute11, p_attribute12 => :$column$.sr_receipt_attribute12, p_attribute13 => :$column$.sr_receipt_attribute13, p_attribute14 => :$column$.sr_receipt_attribute14, p_attribute15 => :$column$.sr_receipt_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_RECEIPT_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE4' 52 SR_RECEIPT_ATTRIBUTE5 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_RECEIPT_ORG', p_context_name => :$column$.receipt_attribute_category, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.sr_receipt_attribute1, p_attribute2 => :$column$.sr_receipt_attribute2, p_attribute3 => :$column$.sr_receipt_attribute3, p_attribute4 => :$column$.sr_receipt_attribute4, p_attribute5 => :$column$.sr_receipt_attribute5, p_attribute6 => :$column$.sr_receipt_attribute6, p_attribute7 => :$column$.sr_receipt_attribute7, p_attribute8 => :$column$.sr_receipt_attribute8, p_attribute9 => :$column$.sr_receipt_attribute9, p_attribute10 => :$column$.sr_receipt_attribute10, p_attribute11 => :$column$.sr_receipt_attribute11, p_attribute12 => :$column$.sr_receipt_attribute12, p_attribute13 => :$column$.sr_receipt_attribute13, p_attribute14 => :$column$.sr_receipt_attribute14, p_attribute15 => :$column$.sr_receipt_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_RECEIPT_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE5' 53 SR_RECEIPT_ATTRIBUTE6 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_RECEIPT_ORG', p_context_name => :$column$.receipt_attribute_category, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.sr_receipt_attribute1, p_attribute2 => :$column$.sr_receipt_attribute2, p_attribute3 => :$column$.sr_receipt_attribute3, p_attribute4 => :$column$.sr_receipt_attribute4, p_attribute5 => :$column$.sr_receipt_attribute5, p_attribute6 => :$column$.sr_receipt_attribute6, p_attribute7 => :$column$.sr_receipt_attribute7, p_attribute8 => :$column$.sr_receipt_attribute8, p_attribute9 => :$column$.sr_receipt_attribute9, p_attribute10 => :$column$.sr_receipt_attribute10, p_attribute11 => :$column$.sr_receipt_attribute11, p_attribute12 => :$column$.sr_receipt_attribute12, p_attribute13 => :$column$.sr_receipt_attribute13, p_attribute14 => :$column$.sr_receipt_attribute14, p_attribute15 => :$column$.sr_receipt_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_RECEIPT_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE6' 54 SR_RECEIPT_ATTRIBUTE7 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_RECEIPT_ORG', p_context_name => :$column$.receipt_attribute_category, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.sr_receipt_attribute1, p_attribute2 => :$column$.sr_receipt_attribute2, p_attribute3 => :$column$.sr_receipt_attribute3, p_attribute4 => :$column$.sr_receipt_attribute4, p_attribute5 => :$column$.sr_receipt_attribute5, p_attribute6 => :$column$.sr_receipt_attribute6, p_attribute7 => :$column$.sr_receipt_attribute7, p_attribute8 => :$column$.sr_receipt_attribute8, p_attribute9 => :$column$.sr_receipt_attribute9, p_attribute10 => :$column$.sr_receipt_attribute10, p_attribute11 => :$column$.sr_receipt_attribute11, p_attribute12 => :$column$.sr_receipt_attribute12, p_attribute13 => :$column$.sr_receipt_attribute13, p_attribute14 => :$column$.sr_receipt_attribute14, p_attribute15 => :$column$.sr_receipt_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_RECEIPT_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE7' 55 SR_RECEIPT_ATTRIBUTE8 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_RECEIPT_ORG', p_context_name => :$column$.receipt_attribute_category, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.sr_receipt_attribute1, p_attribute2 => :$column$.sr_receipt_attribute2, p_attribute3 => :$column$.sr_receipt_attribute3, p_attribute4 => :$column$.sr_receipt_attribute4, p_attribute5 => :$column$.sr_receipt_attribute5, p_attribute6 => :$column$.sr_receipt_attribute6, p_attribute7 => :$column$.sr_receipt_attribute7, p_attribute8 => :$column$.sr_receipt_attribute8, p_attribute9 => :$column$.sr_receipt_attribute9, p_attribute10 => :$column$.sr_receipt_attribute10, p_attribute11 => :$column$.sr_receipt_attribute11, p_attribute12 => :$column$.sr_receipt_attribute12, p_attribute13 => :$column$.sr_receipt_attribute13, p_attribute14 => :$column$.sr_receipt_attribute14, p_attribute15 => :$column$.sr_receipt_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_RECEIPT_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE8' 56 SR_RECEIPT_ATTRIBUTE9 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_RECEIPT_ORG', p_context_name => :$column$.receipt_attribute_category, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.sr_receipt_attribute1, p_attribute2 => :$column$.sr_receipt_attribute2, p_attribute3 => :$column$.sr_receipt_attribute3, p_attribute4 => :$column$.sr_receipt_attribute4, p_attribute5 => :$column$.sr_receipt_attribute5, p_attribute6 => :$column$.sr_receipt_attribute6, p_attribute7 => :$column$.sr_receipt_attribute7, p_attribute8 => :$column$.sr_receipt_attribute8, p_attribute9 => :$column$.sr_receipt_attribute9, p_attribute10 => :$column$.sr_receipt_attribute10, p_attribute11 => :$column$.sr_receipt_attribute11, p_attribute12 => :$column$.sr_receipt_attribute12, p_attribute13 => :$column$.sr_receipt_attribute13, p_attribute14 => :$column$.sr_receipt_attribute14, p_attribute15 => :$column$.sr_receipt_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_RECEIPT_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE9' 57 SR_RECEIPT_ATTRIBUTE10 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_RECEIPT_ORG', p_context_name => :$column$.receipt_attribute_category, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.sr_receipt_attribute1, p_attribute2 => :$column$.sr_receipt_attribute2, p_attribute3 => :$column$.sr_receipt_attribute3, p_attribute4 => :$column$.sr_receipt_attribute4, p_attribute5 => :$column$.sr_receipt_attribute5, p_attribute6 => :$column$.sr_receipt_attribute6, p_attribute7 => :$column$.sr_receipt_attribute7, p_attribute8 => :$column$.sr_receipt_attribute8, p_attribute9 => :$column$.sr_receipt_attribute9, p_attribute10 => :$column$.sr_receipt_attribute10, p_attribute11 => :$column$.sr_receipt_attribute11, p_attribute12 => :$column$.sr_receipt_attribute12, p_attribute13 => :$column$.sr_receipt_attribute13, p_attribute14 => :$column$.sr_receipt_attribute14, p_attribute15 => :$column$.sr_receipt_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_RECEIPT_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE10' 58 SR_RECEIPT_ATTRIBUTE11 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_RECEIPT_ORG', p_context_name => :$column$.receipt_attribute_category, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.sr_receipt_attribute1, p_attribute2 => :$column$.sr_receipt_attribute2, p_attribute3 => :$column$.sr_receipt_attribute3, p_attribute4 => :$column$.sr_receipt_attribute4, p_attribute5 => :$column$.sr_receipt_attribute5, p_attribute6 => :$column$.sr_receipt_attribute6, p_attribute7 => :$column$.sr_receipt_attribute7, p_attribute8 => :$column$.sr_receipt_attribute8, p_attribute9 => :$column$.sr_receipt_attribute9, p_attribute10 => :$column$.sr_receipt_attribute10, p_attribute11 => :$column$.sr_receipt_attribute11, p_attribute12 => :$column$.sr_receipt_attribute12, p_attribute13 => :$column$.sr_receipt_attribute13, p_attribute14 => :$column$.sr_receipt_attribute14, p_attribute15 => :$column$.sr_receipt_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_RECEIPT_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE11' 59 SR_RECEIPT_ATTRIBUTE12 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_RECEIPT_ORG', p_context_name => :$column$.receipt_attribute_category, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.sr_receipt_attribute1, p_attribute2 => :$column$.sr_receipt_attribute2, p_attribute3 => :$column$.sr_receipt_attribute3, p_attribute4 => :$column$.sr_receipt_attribute4, p_attribute5 => :$column$.sr_receipt_attribute5, p_attribute6 => :$column$.sr_receipt_attribute6, p_attribute7 => :$column$.sr_receipt_attribute7, p_attribute8 => :$column$.sr_receipt_attribute8, p_attribute9 => :$column$.sr_receipt_attribute9, p_attribute10 => :$column$.sr_receipt_attribute10, p_attribute11 => :$column$.sr_receipt_attribute11, p_attribute12 => :$column$.sr_receipt_attribute12, p_attribute13 => :$column$.sr_receipt_attribute13, p_attribute14 => :$column$.sr_receipt_attribute14, p_attribute15 => :$column$.sr_receipt_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_RECEIPT_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE12' 60 SR_RECEIPT_ATTRIBUTE13 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_RECEIPT_ORG', p_context_name => :$column$.receipt_attribute_category, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.sr_receipt_attribute1, p_attribute2 => :$column$.sr_receipt_attribute2, p_attribute3 => :$column$.sr_receipt_attribute3, p_attribute4 => :$column$.sr_receipt_attribute4, p_attribute5 => :$column$.sr_receipt_attribute5, p_attribute6 => :$column$.sr_receipt_attribute6, p_attribute7 => :$column$.sr_receipt_attribute7, p_attribute8 => :$column$.sr_receipt_attribute8, p_attribute9 => :$column$.sr_receipt_attribute9, p_attribute10 => :$column$.sr_receipt_attribute10, p_attribute11 => :$column$.sr_receipt_attribute11, p_attribute12 => :$column$.sr_receipt_attribute12, p_attribute13 => :$column$.sr_receipt_attribute13, p_attribute14 => :$column$.sr_receipt_attribute14, p_attribute15 => :$column$.sr_receipt_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_RECEIPT_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE13' 61 SR_RECEIPT_ATTRIBUTE14 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_RECEIPT_ORG', p_context_name => :$column$.receipt_attribute_category, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.sr_receipt_attribute1, p_attribute2 => :$column$.sr_receipt_attribute2, p_attribute3 => :$column$.sr_receipt_attribute3, p_attribute4 => :$column$.sr_receipt_attribute4, p_attribute5 => :$column$.sr_receipt_attribute5, p_attribute6 => :$column$.sr_receipt_attribute6, p_attribute7 => :$column$.sr_receipt_attribute7, p_attribute8 => :$column$.sr_receipt_attribute8, p_attribute9 => :$column$.sr_receipt_attribute9, p_attribute10 => :$column$.sr_receipt_attribute10, p_attribute11 => :$column$.sr_receipt_attribute11, p_attribute12 => :$column$.sr_receipt_attribute12, p_attribute13 => :$column$.sr_receipt_attribute13, p_attribute14 => :$column$.sr_receipt_attribute14, p_attribute15 => :$column$.sr_receipt_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_RECEIPT_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE14' 62 SR_RECEIPT_ATTRIBUTE15 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_RECEIPT_ORG', p_context_name => :$column$.receipt_attribute_category, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.sr_receipt_attribute1, p_attribute2 => :$column$.sr_receipt_attribute2, p_attribute3 => :$column$.sr_receipt_attribute3, p_attribute4 => :$column$.sr_receipt_attribute4, p_attribute5 => :$column$.sr_receipt_attribute5, p_attribute6 => :$column$.sr_receipt_attribute6, p_attribute7 => :$column$.sr_receipt_attribute7, p_attribute8 => :$column$.sr_receipt_attribute8, p_attribute9 => :$column$.sr_receipt_attribute9, p_attribute10 => :$column$.sr_receipt_attribute10, p_attribute11 => :$column$.sr_receipt_attribute11, p_attribute12 => :$column$.sr_receipt_attribute12, p_attribute13 => :$column$.sr_receipt_attribute13, p_attribute14 => :$column$.sr_receipt_attribute14, p_attribute15 => :$column$.sr_receipt_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_RECEIPT_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE15' 63 SHIP_ATTRIBUTE_CATEGORY LOV custom varchar2 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_SOURCE_ORG' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 64 SR_SHIP_ATTRIBUTE1 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_SOURCE_ORG', p_context_name => :$column$.ship_attribute_category, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.sr_ship_attribute1, p_attribute2 => :$column$.sr_ship_attribute2, p_attribute3 => :$column$.sr_ship_attribute3, p_attribute4 => :$column$.sr_ship_attribute4, p_attribute5 => :$column$.sr_ship_attribute5, p_attribute6 => :$column$.sr_ship_attribute6, p_attribute7 => :$column$.sr_ship_attribute7, p_attribute8 => :$column$.sr_ship_attribute8, p_attribute9 => :$column$.sr_ship_attribute9, p_attribute10 => :$column$.sr_ship_attribute10, p_attribute11 => :$column$.sr_ship_attribute11, p_attribute12 => :$column$.sr_ship_attribute12, p_attribute13 => :$column$.sr_ship_attribute13, p_attribute14 => :$column$.sr_ship_attribute14, p_attribute15 => :$column$.sr_ship_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_SOURCE_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE1' 65 SR_SHIP_ATTRIBUTE2 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_SOURCE_ORG', p_context_name => :$column$.ship_attribute_category, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.sr_ship_attribute1, p_attribute2 => :$column$.sr_ship_attribute2, p_attribute3 => :$column$.sr_ship_attribute3, p_attribute4 => :$column$.sr_ship_attribute4, p_attribute5 => :$column$.sr_ship_attribute5, p_attribute6 => :$column$.sr_ship_attribute6, p_attribute7 => :$column$.sr_ship_attribute7, p_attribute8 => :$column$.sr_ship_attribute8, p_attribute9 => :$column$.sr_ship_attribute9, p_attribute10 => :$column$.sr_ship_attribute10, p_attribute11 => :$column$.sr_ship_attribute11, p_attribute12 => :$column$.sr_ship_attribute12, p_attribute13 => :$column$.sr_ship_attribute13, p_attribute14 => :$column$.sr_ship_attribute14, p_attribute15 => :$column$.sr_ship_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_SOURCE_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE2' 66 SR_SHIP_ATTRIBUTE3 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_SOURCE_ORG', p_context_name => :$column$.ship_attribute_category, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.sr_ship_attribute1, p_attribute2 => :$column$.sr_ship_attribute2, p_attribute3 => :$column$.sr_ship_attribute3, p_attribute4 => :$column$.sr_ship_attribute4, p_attribute5 => :$column$.sr_ship_attribute5, p_attribute6 => :$column$.sr_ship_attribute6, p_attribute7 => :$column$.sr_ship_attribute7, p_attribute8 => :$column$.sr_ship_attribute8, p_attribute9 => :$column$.sr_ship_attribute9, p_attribute10 => :$column$.sr_ship_attribute10, p_attribute11 => :$column$.sr_ship_attribute11, p_attribute12 => :$column$.sr_ship_attribute12, p_attribute13 => :$column$.sr_ship_attribute13, p_attribute14 => :$column$.sr_ship_attribute14, p_attribute15 => :$column$.sr_ship_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_SOURCE_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE3' 67 SR_SHIP_ATTRIBUTE4 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_SOURCE_ORG', p_context_name => :$column$.ship_attribute_category, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.sr_ship_attribute1, p_attribute2 => :$column$.sr_ship_attribute2, p_attribute3 => :$column$.sr_ship_attribute3, p_attribute4 => :$column$.sr_ship_attribute4, p_attribute5 => :$column$.sr_ship_attribute5, p_attribute6 => :$column$.sr_ship_attribute6, p_attribute7 => :$column$.sr_ship_attribute7, p_attribute8 => :$column$.sr_ship_attribute8, p_attribute9 => :$column$.sr_ship_attribute9, p_attribute10 => :$column$.sr_ship_attribute10, p_attribute11 => :$column$.sr_ship_attribute11, p_attribute12 => :$column$.sr_ship_attribute12, p_attribute13 => :$column$.sr_ship_attribute13, p_attribute14 => :$column$.sr_ship_attribute14, p_attribute15 => :$column$.sr_ship_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_SOURCE_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE4' 68 SR_SHIP_ATTRIBUTE5 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_SOURCE_ORG', p_context_name => :$column$.ship_attribute_category, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.sr_ship_attribute1, p_attribute2 => :$column$.sr_ship_attribute2, p_attribute3 => :$column$.sr_ship_attribute3, p_attribute4 => :$column$.sr_ship_attribute4, p_attribute5 => :$column$.sr_ship_attribute5, p_attribute6 => :$column$.sr_ship_attribute6, p_attribute7 => :$column$.sr_ship_attribute7, p_attribute8 => :$column$.sr_ship_attribute8, p_attribute9 => :$column$.sr_ship_attribute9, p_attribute10 => :$column$.sr_ship_attribute10, p_attribute11 => :$column$.sr_ship_attribute11, p_attribute12 => :$column$.sr_ship_attribute12, p_attribute13 => :$column$.sr_ship_attribute13, p_attribute14 => :$column$.sr_ship_attribute14, p_attribute15 => :$column$.sr_ship_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_SOURCE_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE5' 69 SR_SHIP_ATTRIBUTE6 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_SOURCE_ORG', p_context_name => :$column$.ship_attribute_category, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.sr_ship_attribute1, p_attribute2 => :$column$.sr_ship_attribute2, p_attribute3 => :$column$.sr_ship_attribute3, p_attribute4 => :$column$.sr_ship_attribute4, p_attribute5 => :$column$.sr_ship_attribute5, p_attribute6 => :$column$.sr_ship_attribute6, p_attribute7 => :$column$.sr_ship_attribute7, p_attribute8 => :$column$.sr_ship_attribute8, p_attribute9 => :$column$.sr_ship_attribute9, p_attribute10 => :$column$.sr_ship_attribute10, p_attribute11 => :$column$.sr_ship_attribute11, p_attribute12 => :$column$.sr_ship_attribute12, p_attribute13 => :$column$.sr_ship_attribute13, p_attribute14 => :$column$.sr_ship_attribute14, p_attribute15 => :$column$.sr_ship_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_SOURCE_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE6' 70 SR_SHIP_ATTRIBUTE7 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_SOURCE_ORG', p_context_name => :$column$.ship_attribute_category, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.sr_ship_attribute1, p_attribute2 => :$column$.sr_ship_attribute2, p_attribute3 => :$column$.sr_ship_attribute3, p_attribute4 => :$column$.sr_ship_attribute4, p_attribute5 => :$column$.sr_ship_attribute5, p_attribute6 => :$column$.sr_ship_attribute6, p_attribute7 => :$column$.sr_ship_attribute7, p_attribute8 => :$column$.sr_ship_attribute8, p_attribute9 => :$column$.sr_ship_attribute9, p_attribute10 => :$column$.sr_ship_attribute10, p_attribute11 => :$column$.sr_ship_attribute11, p_attribute12 => :$column$.sr_ship_attribute12, p_attribute13 => :$column$.sr_ship_attribute13, p_attribute14 => :$column$.sr_ship_attribute14, p_attribute15 => :$column$.sr_ship_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_SOURCE_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE7' 71 SR_SHIP_ATTRIBUTE8 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_SOURCE_ORG', p_context_name => :$column$.ship_attribute_category, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.sr_ship_attribute1, p_attribute2 => :$column$.sr_ship_attribute2, p_attribute3 => :$column$.sr_ship_attribute3, p_attribute4 => :$column$.sr_ship_attribute4, p_attribute5 => :$column$.sr_ship_attribute5, p_attribute6 => :$column$.sr_ship_attribute6, p_attribute7 => :$column$.sr_ship_attribute7, p_attribute8 => :$column$.sr_ship_attribute8, p_attribute9 => :$column$.sr_ship_attribute9, p_attribute10 => :$column$.sr_ship_attribute10, p_attribute11 => :$column$.sr_ship_attribute11, p_attribute12 => :$column$.sr_ship_attribute12, p_attribute13 => :$column$.sr_ship_attribute13, p_attribute14 => :$column$.sr_ship_attribute14, p_attribute15 => :$column$.sr_ship_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_SOURCE_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE8' 72 SR_SHIP_ATTRIBUTE9 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_SOURCE_ORG', p_context_name => :$column$.ship_attribute_category, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.sr_ship_attribute1, p_attribute2 => :$column$.sr_ship_attribute2, p_attribute3 => :$column$.sr_ship_attribute3, p_attribute4 => :$column$.sr_ship_attribute4, p_attribute5 => :$column$.sr_ship_attribute5, p_attribute6 => :$column$.sr_ship_attribute6, p_attribute7 => :$column$.sr_ship_attribute7, p_attribute8 => :$column$.sr_ship_attribute8, p_attribute9 => :$column$.sr_ship_attribute9, p_attribute10 => :$column$.sr_ship_attribute10, p_attribute11 => :$column$.sr_ship_attribute11, p_attribute12 => :$column$.sr_ship_attribute12, p_attribute13 => :$column$.sr_ship_attribute13, p_attribute14 => :$column$.sr_ship_attribute14, p_attribute15 => :$column$.sr_ship_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_SOURCE_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE9' 73 SR_SHIP_ATTRIBUTE10 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_SOURCE_ORG', p_context_name => :$column$.ship_attribute_category, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.sr_ship_attribute1, p_attribute2 => :$column$.sr_ship_attribute2, p_attribute3 => :$column$.sr_ship_attribute3, p_attribute4 => :$column$.sr_ship_attribute4, p_attribute5 => :$column$.sr_ship_attribute5, p_attribute6 => :$column$.sr_ship_attribute6, p_attribute7 => :$column$.sr_ship_attribute7, p_attribute8 => :$column$.sr_ship_attribute8, p_attribute9 => :$column$.sr_ship_attribute9, p_attribute10 => :$column$.sr_ship_attribute10, p_attribute11 => :$column$.sr_ship_attribute11, p_attribute12 => :$column$.sr_ship_attribute12, p_attribute13 => :$column$.sr_ship_attribute13, p_attribute14 => :$column$.sr_ship_attribute14, p_attribute15 => :$column$.sr_ship_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_SOURCE_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE10' 74 SR_SHIP_ATTRIBUTE11 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_SOURCE_ORG', p_context_name => :$column$.ship_attribute_category, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.sr_ship_attribute1, p_attribute2 => :$column$.sr_ship_attribute2, p_attribute3 => :$column$.sr_ship_attribute3, p_attribute4 => :$column$.sr_ship_attribute4, p_attribute5 => :$column$.sr_ship_attribute5, p_attribute6 => :$column$.sr_ship_attribute6, p_attribute7 => :$column$.sr_ship_attribute7, p_attribute8 => :$column$.sr_ship_attribute8, p_attribute9 => :$column$.sr_ship_attribute9, p_attribute10 => :$column$.sr_ship_attribute10, p_attribute11 => :$column$.sr_ship_attribute11, p_attribute12 => :$column$.sr_ship_attribute12, p_attribute13 => :$column$.sr_ship_attribute13, p_attribute14 => :$column$.sr_ship_attribute14, p_attribute15 => :$column$.sr_ship_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_SOURCE_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE11' 75 SR_SHIP_ATTRIBUTE12 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_SOURCE_ORG', p_context_name => :$column$.ship_attribute_category, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.sr_ship_attribute1, p_attribute2 => :$column$.sr_ship_attribute2, p_attribute3 => :$column$.sr_ship_attribute3, p_attribute4 => :$column$.sr_ship_attribute4, p_attribute5 => :$column$.sr_ship_attribute5, p_attribute6 => :$column$.sr_ship_attribute6, p_attribute7 => :$column$.sr_ship_attribute7, p_attribute8 => :$column$.sr_ship_attribute8, p_attribute9 => :$column$.sr_ship_attribute9, p_attribute10 => :$column$.sr_ship_attribute10, p_attribute11 => :$column$.sr_ship_attribute11, p_attribute12 => :$column$.sr_ship_attribute12, p_attribute13 => :$column$.sr_ship_attribute13, p_attribute14 => :$column$.sr_ship_attribute14, p_attribute15 => :$column$.sr_ship_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_SOURCE_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE12' 76 SR_SHIP_ATTRIBUTE13 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_SOURCE_ORG', p_context_name => :$column$.ship_attribute_category, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.sr_ship_attribute1, p_attribute2 => :$column$.sr_ship_attribute2, p_attribute3 => :$column$.sr_ship_attribute3, p_attribute4 => :$column$.sr_ship_attribute4, p_attribute5 => :$column$.sr_ship_attribute5, p_attribute6 => :$column$.sr_ship_attribute6, p_attribute7 => :$column$.sr_ship_attribute7, p_attribute8 => :$column$.sr_ship_attribute8, p_attribute9 => :$column$.sr_ship_attribute9, p_attribute10 => :$column$.sr_ship_attribute10, p_attribute11 => :$column$.sr_ship_attribute11, p_attribute12 => :$column$.sr_ship_attribute12, p_attribute13 => :$column$.sr_ship_attribute13, p_attribute14 => :$column$.sr_ship_attribute14, p_attribute15 => :$column$.sr_ship_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_SOURCE_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE13' 77 SR_SHIP_ATTRIBUTE14 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_SOURCE_ORG', p_context_name => :$column$.ship_attribute_category, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.sr_ship_attribute1, p_attribute2 => :$column$.sr_ship_attribute2, p_attribute3 => :$column$.sr_ship_attribute3, p_attribute4 => :$column$.sr_ship_attribute4, p_attribute5 => :$column$.sr_ship_attribute5, p_attribute6 => :$column$.sr_ship_attribute6, p_attribute7 => :$column$.sr_ship_attribute7, p_attribute8 => :$column$.sr_ship_attribute8, p_attribute9 => :$column$.sr_ship_attribute9, p_attribute10 => :$column$.sr_ship_attribute10, p_attribute11 => :$column$.sr_ship_attribute11, p_attribute12 => :$column$.sr_ship_attribute12, p_attribute13 => :$column$.sr_ship_attribute13, p_attribute14 => :$column$.sr_ship_attribute14, p_attribute15 => :$column$.sr_ship_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_SOURCE_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE14' 78 SR_SHIP_ATTRIBUTE15 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_SOURCE_ORG', p_context_name => :$column$.ship_attribute_category, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.sr_ship_attribute1, p_attribute2 => :$column$.sr_ship_attribute2, p_attribute3 => :$column$.sr_ship_attribute3, p_attribute4 => :$column$.sr_ship_attribute4, p_attribute5 => :$column$.sr_ship_attribute5, p_attribute6 => :$column$.sr_ship_attribute6, p_attribute7 => :$column$.sr_ship_attribute7, p_attribute8 => :$column$.sr_ship_attribute8, p_attribute9 => :$column$.sr_ship_attribute9, p_attribute10 => :$column$.sr_ship_attribute10, p_attribute11 => :$column$.sr_ship_attribute11, p_attribute12 => :$column$.sr_ship_attribute12, p_attribute13 => :$column$.sr_ship_attribute13, p_attribute14 => :$column$.sr_ship_attribute14, p_attribute15 => :$column$.sr_ship_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_SOURCE_ORG' and fdfcuv.application_column_name = 'ATTRIBUTE15' 79 DELETE_OPTION LOV custom varchar2 select value, description from ( select 'Sourcing Rule' value, 'Delete the Sourcing Rule' description from dual --union all --#Due to a bug not allowing Receiving Org Delete Option. --#The API will throw as error as it checks for the the existance of Source Org lines even for a deleted Receiving Org --#in MRP_SOURCING_RULE_PVT.PROCESS_SOURCING_RULE line Step 6. Perform Object group logic --select 'Receiving Org' value, 'Delete the Receiving Org entry' description from dual union all select 'Shipping Org' value, 'Delete the Shipping Org entry' description from dual ) order by value 80 ORGANIZATION LOV custom varchar2 3 select x.value, x.description from ( select mp.organization_code value, mrp_manager_pk.get_customer_name(hoi.org_information1) || nvl2(mrp_manager_pk.get_ship_address(hoi.org_information2),' (' || mrp_manager_pk.get_ship_address(hoi.org_information2) || ')',null) description from mtl_parameters mp, hr_organization_information hoi where hoi.organization_id (+)= mp.organization_id and hoi.org_information_context(+) = 'Customer/Supplier Association' and xxen_util.lookup_code(:$column$.rule_type,'MRP_SOURCING_RULE_TYPE',700) = '1' and mp.organization_code = :$column$.receipt_organization ) x order by x.value select organization_id id, organization_code value from mtl_parameters case when xxen_util.lookup_code(:$column$.rule_type,'MRP_SOURCING_RULE_TYPE',700)='1' then :$column$.receipt_organization end Y 81 ACTIVE LOV custom varchar2 select flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type = 'INV_YES_NO' and flvv.view_application_id = 3 and flvv.security_group_id = fnd_global.security_group_id and flvv.lookup_code = 1 order by value select lookup_code id, meaning value from fnd_lookup_values_vl where lookup_type = 'INV_YES_NO' and view_application_id = 3 and security_group_id = fnd_global.security_group_id xxen_util.meaning(1,'INV_YES_NO',3) Y 82 SOURCING_RULE_ID Number number Y 83 SR_RECEIPT_ID Number number Y 84 SR_SOURCE_ID Number number Y 85 GROUP_ID Number number Y 86 UPLOAD_ROW Number number Y U 1 action_ in Char ACTION_CODE_ U 2 p_upload_mode in Char UPLOAD_MODE U 3 p_sourcing_rule_id in Number Y SOURCING_RULE_ID U 4 p_rule_type in Number Y RULE_TYPE U 5 p_rule_name in Char Y RULE_NAME U 6 p_rule_description in Char Y RULE_DESCRIPTION U 7 p_all_orgs in Number Y ALL_ORGS U 8 p_rule_organization_id in Number Y ORGANIZATION U 9 p_rule_planning_active in Number Y U 10 p_rule_status in Number Y ACTIVE U 11 p_rule_attribute_category in Char Y RULE_ATTRIBUTE_CATEGORY U 12 p_rule_attribute1 in Char Y SR_RULE_ATTRIBUTE1 U 13 p_rule_attribute2 in Char Y SR_RULE_ATTRIBUTE2 U 14 p_rule_attribute3 in Char Y SR_RULE_ATTRIBUTE3 U 15 p_rule_attribute4 in Char Y SR_RULE_ATTRIBUTE4 U 16 p_rule_attribute5 in Char Y SR_RULE_ATTRIBUTE5 U 17 p_rule_attribute6 in Char Y SR_RULE_ATTRIBUTE6 U 18 p_rule_attribute7 in Char Y SR_RULE_ATTRIBUTE7 U 19 p_rule_attribute8 in Char Y SR_RULE_ATTRIBUTE8 U 20 p_rule_attribute9 in Char Y SR_RULE_ATTRIBUTE9 U 21 p_rule_attribute10 in Char Y SR_RULE_ATTRIBUTE10 U 22 p_rule_attribute11 in Char Y SR_RULE_ATTRIBUTE11 U 23 p_rule_attribute12 in Char Y SR_RULE_ATTRIBUTE12 U 24 p_rule_attribute13 in Char Y SR_RULE_ATTRIBUTE13 U 25 p_rule_attribute14 in Char Y SR_RULE_ATTRIBUTE14 U 26 p_rule_attribute15 in Char Y SR_RULE_ATTRIBUTE15 U 27 p_sr_receipt_id in Number Y SR_RECEIPT_ID U 28 p_ro_effective_date in Date Y EFFECTIVE_DATE_FROM U 29 p_ro_disable_date in Date Y EFFECTIVE_DATE_TO U 30 p_ro_organization_id in Number Y RECEIPT_ORGANIZATION U 31 p_ro_attribute_category in Char Y RECEIPT_ATTRIBUTE_CATEGORY U 32 p_ro_attribute1 in Char Y SR_RECEIPT_ATTRIBUTE1 U 33 p_ro_attribute2 in Char Y SR_RECEIPT_ATTRIBUTE2 U 34 p_ro_attribute3 in Char Y SR_RECEIPT_ATTRIBUTE3 U 35 p_ro_attribute4 in Char Y SR_RECEIPT_ATTRIBUTE4 U 36 p_ro_attribute5 in Char Y SR_RECEIPT_ATTRIBUTE5 U 37 p_ro_attribute6 in Char Y SR_RECEIPT_ATTRIBUTE6 U 38 p_ro_attribute7 in Char Y SR_RECEIPT_ATTRIBUTE7 U 39 p_ro_attribute8 in Char Y SR_RECEIPT_ATTRIBUTE8 U 40 p_ro_attribute9 in Char Y SR_RECEIPT_ATTRIBUTE9 U 41 p_ro_attribute10 in Char Y SR_RECEIPT_ATTRIBUTE10 U 42 p_ro_attribute11 in Char Y SR_RECEIPT_ATTRIBUTE11 U 43 p_ro_attribute12 in Char Y SR_RECEIPT_ATTRIBUTE12 U 44 p_ro_attribute13 in Char Y SR_RECEIPT_ATTRIBUTE13 U 45 p_ro_attribute14 in Char Y SR_RECEIPT_ATTRIBUTE14 U 46 p_ro_attribute15 in Char Y SR_RECEIPT_ATTRIBUTE15 U 47 p_sr_source_id in Number Y SR_SOURCE_ID U 48 p_so_source_type in Number Y SOURCE_TYPE U 49 p_so_organization_id in Number Y SOURCE_ORGANIZATION U 50 p_so_secondary_inventory in Char Y U 51 p_so_supplier_name in Char Y SUPPLIER U 52 p_so_supplier_number in Char Y SUPPLIER_NUMBER U 53 p_so_supplier_site in Char Y SUPPLIER_SITE U 54 p_so_supplier_site_ou in Char Y SUPPLIER_SITE_OP_UNIT U 55 p_so_vendor_id in Number Y U 56 p_so_vendor_site_id in Number Y U 57 p_so_allocation_percent in Number Y ALLOCATION_PERCENT U 58 p_so_rank in Number Y RANK U 59 p_so_ship_method in Char Y SHIP_METHOD U 60 p_so_attribute_category in Char Y SHIP_ATTRIBUTE_CATEGORY U 61 p_so_attribute1 in Char Y SR_SHIP_ATTRIBUTE1 U 62 p_so_attribute2 in Char Y SR_SHIP_ATTRIBUTE2 U 63 p_so_attribute3 in Char Y SR_SHIP_ATTRIBUTE3 U 64 p_so_attribute4 in Char Y SR_SHIP_ATTRIBUTE4 U 65 p_so_attribute5 in Char Y SR_SHIP_ATTRIBUTE5 U 66 p_so_attribute6 in Char Y SR_SHIP_ATTRIBUTE6 U 67 p_so_attribute7 in Char Y SR_SHIP_ATTRIBUTE7 U 68 p_so_attribute8 in Char Y SR_SHIP_ATTRIBUTE8 U 69 p_so_attribute9 in Char Y SR_SHIP_ATTRIBUTE9 U 70 p_so_attribute10 in Char Y SR_SHIP_ATTRIBUTE10 U 71 p_so_attribute11 in Char Y SR_SHIP_ATTRIBUTE11 U 72 p_so_attribute12 in Char Y SR_SHIP_ATTRIBUTE12 U 73 p_so_attribute13 in Char Y SR_SHIP_ATTRIBUTE13 U 74 p_so_attribute14 in Char Y SR_SHIP_ATTRIBUTE14 U 75 p_so_attribute15 in Char Y SR_SHIP_ATTRIBUTE15 U 76 p_delete_option in Char DELETE_OPTION U 77 p_bypass_dff_validation in Char BYPASS_DFF_VALIDATION U 78 p_sr_row_id in/out Char SR_ROW_ID U 79 p_ro_row_id in/out Char RO_ROW_ID U 80 p_so_row_id in/out Char SO_ROW_ID U 81 request_id_ out Number REQUEST_ID_ U 82 status_ out Char STATUS_CODE_ U 83 message_ out Char MESSAGE_ P 1 p_group_id in Number GROUP_ID P 2 request_id_ out Number REQUEST_ID_ P 3 status_ out Char STATUS_CODE_ P 4 message_ out Char MESSAGE_ Order By x.upload_row, x.rule_type, x.rule_name, nvl2(x.organization,2,1), x.organization, x.receipt_organization, x.rank, x.source_organization, x.supplier Success SQL select /*+ ordered push_pred(sr) */ xu.action_, case when xu.pstatus = xxen_upload.status_success then case when xu.delete_option is not null and sr.sourcing_rule_id is null then xxen_upload.status_meaning(xxen_upload.status_success) when sr.sourcing_rule_id is null then xxen_upload.status_meaning(xxen_upload.status_error) else xxen_upload.status_meaning(xu.pstatus) end else xxen_upload.status_meaning(xu.pstatus) end status_, case when xu.pstatus=xxen_upload.status_success and sr.sourcing_rule_id is null and xu.delete_option='Sourcing Rule' then 'Sourcing rule deleted.' when xu.pstatus=xxen_upload.status_success and sr.sourcing_rule_id is null and xu.delete_option='Shipping Org' then 'Shipping org entry deleted.' when xu.pstatus=xxen_upload.status_success and sr.sourcing_rule_id is not null and xu.delete_option is null then decode(xu.action_code_,xxen_upload.action_create,'Shipping org entry created.','Shipping org entry updated.') else xu.pmsg end message_, xu.request_id_, xu.modified_columns_, xu.sr_row_id, xu.ro_row_id, xu.so_row_id, xu.upload_mode, xu.bypass_dff_validation, -- sourcing rule case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.rule_name else sr.rule_name end rule_name, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.rule_description else sr.rule_description end rule_description, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.rule_type else sr.rule_type end rule_type, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.planning_active else sr.planning_active end planning_active, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.all_orgs else xu.all_orgs end all_orgs, -- receiving organizations case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.receipt_organization else sr.receipt_organization end receipt_organization, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.receipt_customer else sr.receipt_customer end receipt_customer, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.receipt_address else sr.receipt_address end receipt_address, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.effective_date_from else sr.effective_date_from end effective_date_from, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.effective_date_to else sr.effective_date_to end effective_date_to, -- shipping organization case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.source_type else sr.source_type end source_type, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.source_organization else sr.source_organization end source_organization, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.supplier else sr.supplier end supplier, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.supplier_number else sr.supplier_number end supplier_number, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.supplier_site else sr.supplier_site end supplier_site, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.supplier_site_op_unit else sr.supplier_site_op_unit end supplier_site_op_unit, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.allocation_percent else sr.allocation_percent end allocation_percent, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.rank else sr.rank end rank, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.ship_method else sr.ship_method end ship_method, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.intransit_time else sr.intransit_time end intransit_time, -- attributes case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.rule_attribute_category else sr.rule_attribute_category end rule_attribute_category, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_rule_attribute1 else sr.sr_rule_attribute1 end sr_rule_attribute1, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_rule_attribute2 else sr.sr_rule_attribute2 end sr_rule_attribute2, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_rule_attribute3 else sr.sr_rule_attribute3 end sr_rule_attribute3, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_rule_attribute4 else sr.sr_rule_attribute4 end sr_rule_attribute4, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_rule_attribute5 else sr.sr_rule_attribute5 end sr_rule_attribute5, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_rule_attribute6 else sr.sr_rule_attribute6 end sr_rule_attribute6, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_rule_attribute7 else sr.sr_rule_attribute7 end sr_rule_attribute7, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_rule_attribute8 else sr.sr_rule_attribute8 end sr_rule_attribute8, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_rule_attribute9 else sr.sr_rule_attribute9 end sr_rule_attribute9, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_rule_attribute10 else sr.sr_rule_attribute10 end sr_rule_attribute10, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_rule_attribute11 else sr.sr_rule_attribute11 end sr_rule_attribute11, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_rule_attribute12 else sr.sr_rule_attribute12 end sr_rule_attribute12, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_rule_attribute13 else sr.sr_rule_attribute13 end sr_rule_attribute13, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_rule_attribute14 else sr.sr_rule_attribute14 end sr_rule_attribute14, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_rule_attribute15 else sr.sr_rule_attribute15 end sr_rule_attribute15, -- case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.receipt_attribute_category else sr.receipt_attribute_category end receipt_attribute_category, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_receipt_attribute1 else sr.sr_receipt_attribute1 end sr_receipt_attribute1, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_receipt_attribute2 else sr.sr_receipt_attribute2 end sr_receipt_attribute2, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_receipt_attribute3 else sr.sr_receipt_attribute3 end sr_receipt_attribute3, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_receipt_attribute4 else sr.sr_receipt_attribute4 end sr_receipt_attribute4, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_receipt_attribute5 else sr.sr_receipt_attribute5 end sr_receipt_attribute5, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_receipt_attribute6 else sr.sr_receipt_attribute6 end sr_receipt_attribute6, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_receipt_attribute7 else sr.sr_receipt_attribute7 end sr_receipt_attribute7, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_receipt_attribute8 else sr.sr_receipt_attribute8 end sr_receipt_attribute8, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_receipt_attribute9 else sr.sr_receipt_attribute9 end sr_receipt_attribute9, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_receipt_attribute10 else sr.sr_receipt_attribute10 end sr_receipt_attribute10, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_receipt_attribute11 else sr.sr_receipt_attribute11 end sr_receipt_attribute11, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_receipt_attribute12 else sr.sr_receipt_attribute12 end sr_receipt_attribute12, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_receipt_attribute13 else sr.sr_receipt_attribute13 end sr_receipt_attribute13, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_receipt_attribute14 else sr.sr_receipt_attribute14 end sr_receipt_attribute14, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_receipt_attribute15 else sr.sr_receipt_attribute15 end sr_receipt_attribute15, -- case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.ship_attribute_category else sr.ship_attribute_category end ship_attribute_category, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_ship_attribute1 else sr.sr_ship_attribute1 end sr_ship_attribute1, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_ship_attribute2 else sr.sr_ship_attribute2 end sr_ship_attribute2, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_ship_attribute3 else sr.sr_ship_attribute3 end sr_ship_attribute3, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_ship_attribute4 else sr.sr_ship_attribute4 end sr_ship_attribute4, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_ship_attribute5 else sr.sr_ship_attribute5 end sr_ship_attribute5, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_ship_attribute6 else sr.sr_ship_attribute6 end sr_ship_attribute6, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_ship_attribute7 else sr.sr_ship_attribute7 end sr_ship_attribute7, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_ship_attribute8 else sr.sr_ship_attribute8 end sr_ship_attribute8, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_ship_attribute9 else sr.sr_ship_attribute9 end sr_ship_attribute9, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_ship_attribute10 else sr.sr_ship_attribute10 end sr_ship_attribute10, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_ship_attribute11 else sr.sr_ship_attribute11 end sr_ship_attribute11, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_ship_attribute12 else sr.sr_ship_attribute12 end sr_ship_attribute12, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_ship_attribute13 else sr.sr_ship_attribute13 end sr_ship_attribute13, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_ship_attribute14 else sr.sr_ship_attribute14 end sr_ship_attribute14, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_ship_attribute15 else sr.sr_ship_attribute15 end sr_ship_attribute15, -- xu.delete_option, -- ids case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.organization else sr.organization end organization, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.active else sr.active end active, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sourcing_rule_id else sr.sourcing_rule_id end sourcing_rule_id, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_receipt_id else sr.sr_receipt_id end sr_receipt_id, case when xu.pstatus = xxen_upload.status_error or sr.sourcing_rule_id is null then xu.sr_source_id else sr.sr_source_id end sr_source_id, xu.group_id, xu.upload_row from (select case when xu.status_code_ in (xxen_upload.status_error,xxen_upload.status_valid) then xxen_upload.status_error when xxen_mrp_upload.get_status_(xu.request_id_,xu.sr_row_id) = xxen_upload.status_error or xxen_mrp_upload.get_status_(xu.request_id_,xu.ro_row_id) = xxen_upload.status_error or xxen_mrp_upload.get_status_(xu.request_id_,xu.so_row_id) = xxen_upload.status_error then xxen_upload.status_error else xxen_upload.status_success end pstatus, case when xu.status_code_ = xxen_upload.status_error then xu.message_ when xu.status_code_ = xxen_upload.status_valid then 'Post Processing Failed' else coalesce(xxen_mrp_upload.get_message_(xu.request_id_,xu.so_row_id), xxen_mrp_upload.get_message_(xu.request_id_,xu.ro_row_id), xxen_mrp_upload.get_message_(xu.request_id_,xu.sr_row_id) ) end pmsg, xu.* from xxen_mrp_sourcing_rule_2203_u xu ) xu, sr_query sr where -- rule sr.rule_name (+) = xu.rule_name and nvl(sr.organization (+),'*All Orgs*') = case xxen_util.lookup_code(xu.rule_type,'MRP_SOURCING_RULE_TYPE',700) when '1' then coalesce(xu.organization,xu.receipt_organization,'*All Orgs*') else '*All Orgs*' end and -- rcv org nvl(sr.receipt_organization (+),'*All Orgs*') = nvl(xu.receipt_organization,'*All Orgs*') and sr.effective_date_from (+) = trunc(xu.effective_date_from) and -- shp org nvl(sr.source_organization (+),'#null#') = nvl(xu.source_organization,'#null#') and nvl(sr.supplier (+),'#null#') = nvl(xu.supplier,'#null#') and nvl(sr.supplier_number,nvl(xu.supplier_number,'#null#')) = nvl(xu.supplier_number,nvl(sr.supplier_number,'#null#')) and nvl(sr.supplier_site (+),'#null#') = nvl(xu.supplier_site,'#null#') and -- -- sr.last_updated_by (+) = fnd_global.user_id and sr.last_update_date (+) >= sysdate - 0.08