ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 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 allocation_percent, mssov.rank rank, mssov.ship_method ship_method, mssov.intransit_time 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 oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) ) -- -- 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 from sr_query sr where :p_include_global = :p_include_global and 1=1 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 - Update Existing Sourcing Rules Enginatics Upload 1=1 :p_bypass_dff_validation :p_include_global :p_upload_mode 1 -10 :p_bypass_dff_validation LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Bypass DFF Validation 2 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C Y US Upload Mode 3 20 1=1 sr.rule_type = :p_rule_type LOV custom Y 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 Y 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 Y 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 oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and nvl(ood.disable_date,sysdate)>=sysdate 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 Y select mrs.sourcing_rule_name value, mrs.description || ' (' || xxen_util.meaning(mrs.sourcing_rule_type,'MRP_SOURCING_RULE_TYPE',700) || ')' || decode(mrs.sourcing_rule_type,1,' (' || nvl(mp.organization_code,'All Orgs') || ')') description from mrp_sourcing_rules mrs, mtl_parameters mp where mp.organization_id (+) = mrs.organization_id and (mrs.organization_id is null or mrs.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) and (:$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 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 Y select ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type = 'MRP_SOURCING_RULE_TYPE' and ml.lookup_code in (1,2) 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 Y 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 Y 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 Y 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 oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) or 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 Y 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 Y 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 Y 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 Y 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 Y 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 Y 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 Y 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 Y 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 Y 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 Y 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 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id = fdfv.application_id and fdfcv.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfcv.enabled_flag = 'Y' and fdfv.application_id = 704 and fdfv.descriptive_flexfield_name = 'MRP_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_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 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id = fdfv.application_id and fdfcv.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfcv.enabled_flag = 'Y' and fdfv.application_id = 704 and fdfv.descriptive_flexfield_name = 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id = fdfv.application_id and fdfcv.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfcv.enabled_flag = 'Y' and fdfv.application_id = 704 and fdfv.descriptive_flexfield_name = 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 704, p_descriptive_flexfield_name => 'MRP_SR_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 Y 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 Y 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 Y 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 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.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 xu.delete_option is not null then case when sr.sourcing_rule_id is null and xu.delete_option = 'Sourcing Rule' then 'Sourcing Rule Deleted' when sr.sourcing_rule_id is null and xu.delete_option = 'Shipping Org' then 'Shipping Org Entry Deleted' else xu.pmsg end 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 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