ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 2BE639DC11BFE913E0630100007F3508Y select null action_, null status_, null message_, null request_id_, null modified_columns_, pav.acceptance_id, -- hou.name operating_unit, asu.vendor_name supplier, asu.segment1 supplier_number, assa.vendor_site_code supplier_site, nvl(pha2.segment1,pha.segment1) po_number, pra.release_num release, pav.revision_num revision, pav.action, pav.action_date, xxen_util.meaning(pav.accepted_flag,'YES_NO',0) accepted, pav.acceptance_type, xxen_util.meaning(pav.accepting_party,'ACCEPTANCE_PARTY',201) acceptance_party, case when pav.employee_id is not null then pav.full_name else po_inq_sv.get_party_vendor_name(pav.created_by) end accepted_by_employee, pav.employee_num accepted_by_employee_num, pav.role, &lp_note_column xxen_util.meaning(pav.signature_flag,'YES_NO',0) signature, -- not relevant for buyer acceptances pav.erecord_id, -- not relevant for buyer acceptances -- xxen_util.display_flexfield_context(201,'PO_ACCEPTANCES',pav.attribute_category) attribute_category, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE1',pav.row_id,pav.attribute1) po_acceptance_attribute1, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE2',pav.row_id,pav.attribute2) po_acceptance_attribute2, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE3',pav.row_id,pav.attribute3) po_acceptance_attribute3, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE4',pav.row_id,pav.attribute4) po_acceptance_attribute4, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE5',pav.row_id,pav.attribute5) po_acceptance_attribute5, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE6',pav.row_id,pav.attribute6) po_acceptance_attribute6, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE7',pav.row_id,pav.attribute7) po_acceptance_attribute7, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE8',pav.row_id,pav.attribute8) po_acceptance_attribute8, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE9',pav.row_id,pav.attribute9) po_acceptance_attribute9, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE10',pav.row_id,pav.attribute10) po_acceptance_attribute10, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE11',pav.row_id,pav.attribute11) po_acceptance_attribute11, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE12',pav.row_id,pav.attribute12) po_acceptance_attribute12, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE13',pav.row_id,pav.attribute13) po_acceptance_attribute13, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE14',pav.row_id,pav.attribute14) po_acceptance_attribute14, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE15',pav.row_id,pav.attribute15) po_acceptance_attribute15, -- :p_default_action default_action, :p_default_date default_action_date, 1 upload_row from po_acceptances_v pav, po_headers_all pha, po_releases_all pra, po_headers_all pha2, ap_suppliers asu, ap_supplier_sites_all assa, hr_operating_units hou where -- this upload only supports upload of new buyer acceptances 'X'='Y' and :p_upload_mode = :p_upload_mode and hou.name = :p_operating_unit and nvl(pav.accepting_party,'B') = 'B' and pav.po_header_id = pha.po_header_id (+) and pav.po_release_id = pra.po_release_id (+) and pra.po_header_id = pha2.po_header_id (+) and nvl(pha2.vendor_id,pha.vendor_id) = asu.vendor_id and nvl(pha2.vendor_site_id,pha.vendor_site_id) = assa.vendor_site_id and nvl(pha2.org_id,pha.org_id) = hou.organization_id Changed seq to upload_row U A xxen_po_upload.create_acceptance US PO Acceptance Upload This upload allows users to create new PO Acceptances (Acknowledgments) Enginatics Upload &lp_note_column :p_default_action :p_default_date :p_operating_unit :p_upload_mode 1 -20 &lp_note_column <parameter_value> comments, Char select case data_type when 'LONG' then 'dbms_lob.substr(xxen_util.long_to_clob(''PO_ACCEPTANCES'',''NOTE'',pav.row_id))' else 'dbms_lob.substr(pav.note)' end from dba_tab_columns where owner = 'PO' and table_name = 'PO_ACCEPTANCES' and column_name = 'NOTE' US Comment Column Lexical 2 -10 :p_upload_mode 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 10 :p_operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) US Operating Unit Selecting an Operating Unit will restrict the upload to acceptances for the specified operating unit. If not selected, acceptances can be uploaded for any accessible operating unit. 4 20 :p_default_action Char New Y US Default Action The default action will be used by the upload if the Action column is not included in, or not populated in, the upload template. 5 30 :p_default_date Date US Default Action Date The default action date will be used by the upload if the Action Date column is not included in, or not populated in, the upload template. If left blank the upload will use the current system date as the Action Date. 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 ACCEPTANCE_ID Number number Y 7 OPERATING_UNIT LOV custom varchar2 240 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) and (:$flex$.Operating_Unit is null or hou.name = :$flex$.Operating_Unit) order by hou.name select haouv.organization_id id, haouv.name value from hr_all_organization_units_vl haouv :$flex$.Operating_Unit Y 8 SUPPLIER LOV custom varchar2 240 Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where haouv.organization_id=assa.org_id and haouv.name = :$column$.operating_unit ) order by aps.vendor_name, aps.segment1 Supplier, Supplier Number, and Supplier Site are all optional and provided to assist with refiniing the PO Number List of Values. PO Numbers can be entered directly without the need to specify Supplier, Supplier Number, and Supplier Site. 9 SUPPLIER_NUMBER LOV custom varchar2 30 Y select aps.segment1 value, aps.vendor_name description from ap_suppliers aps where aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where haouv.organization_id=assa.org_id and haouv.name = :$column$.operating_unit ) and (:$column$.supplier is null or aps.vendor_name = :$column$.supplier) order by aps.segment1, aps.vendor_name select aps.segment1 from ap_suppliers aps where aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where haouv.organization_id=assa.org_id and haouv.name = :$column$.operating_unit ) and aps.vendor_name = :$column$.supplier Supplier, Supplier Number, and Supplier Site are all optional and provided to assist with refiniing the PO Number List of Values. PO Numbers can be entered directly without the need to specify Supplier, Supplier Number, and Supplier Site. 10 SUPPLIER_SITE LOV custom varchar2 15 Y select distinct assa.vendor_site_code value, assa.address_line1||', '||assa.city||', '||nvl(ftv.territory_short_name,assa.country) description from hr_all_organization_units_vl haouv, ap_suppliers aps, ap_supplier_sites_all assa, fnd_territories_vl ftv where aps.vendor_id=assa.vendor_id and assa.org_id=haouv.organization_id and assa.country=ftv.territory_code(+) and haouv.name = :$column$.operating_unit and (:$column$.supplier is not null or :$column$.supplier_number is not null) and (:$column$.supplier is null or aps.vendor_name = :$column$.supplier) and (:$column$.supplier_number is null or aps.segment1 = :$column$.supplier_number) order by assa.vendor_site_code select distinct assa.vendor_site_code from hr_all_organization_units_vl haouv, ap_suppliers aps, ap_supplier_sites_all assa, fnd_territories_vl ftv where aps.vendor_id=assa.vendor_id and assa.org_id=haouv.organization_id and assa.country=ftv.territory_code(+) and haouv.name = :$column$.operating_unit and (:$column$.supplier is not null or :$column$.supplier_number is not null) and (:$column$.supplier is null or aps.vendor_name = :$column$.supplier) and (:$column$.supplier_number is null or aps.segment1 = :$column$.supplier_number) Supplier, Supplier Number, and Supplier Site are all optional and provided to assist with refiniing the PO Number List of Values. PO Numbers can be entered directly without the need to specify Supplier, Supplier Number, and Supplier Site. 11 PO_NUMBER LOV custom varchar2 20 Y select pha.po_header_id id, pha.segment1 value, aps.vendor_name || ' / ' || assa.vendor_site_code || ' / ' || fnd_date.date_to_displaydate(pha.creation_date) || ' / ' || xxen_util.meaning(nvl(pha.authorization_status,'INCOMPLETE'),'AUTHORIZATION STATUS',201) description from po_headers_all pha, hr_all_organization_units_vl haouv, ap_suppliers aps, ap_supplier_sites_all assa where pha.org_id=haouv.organization_id and pha.vendor_id = aps.vendor_id and pha.vendor_id = assa.vendor_id and pha.vendor_site_id = assa.vendor_site_id and haouv.name = :$column$.operating_unit and (:$column$.supplier is null or aps.vendor_name = :$column$.supplier) and (:$column$.supplier_number is null or aps.segment1 = :$column$.supplier_number) and (:$column$.supplier_site is null or assa.vendor_site_code = :$column$.supplier_site) and -- pha.type_lookup_code in ('STANDARD', 'BLANKET', 'CONTRACT', 'PLANNED') and nvl(pha.closed_code, 'OPEN') != 'FINALLY CLOSED' and nvl(pha.authorization_status, 'INCOMPLETE') in ('APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') and nvl(pha.cancel_flag, 'N') = 'N' order by value Y 12 RELEASE LOV custom number Y select pra.po_release_id id, pra.release_num value, fnd_date.date_to_displaydate(pra.release_date)||' ('||xxen_util.meaning(pra.authorization_status,'AUTHORIZATION STATUS',201)||')' description from po_headers_all pha, po_releases_all pra, hr_all_organization_units_vl haouv, ap_suppliers aps, ap_supplier_sites_all assa where pha.po_header_id = pra.po_header_id and pha.org_id=haouv.organization_id and pha.vendor_id = aps.vendor_id and pha.vendor_id = assa.vendor_id and pha.vendor_site_id = assa.vendor_site_id and haouv.name = :$column$.operating_unit and pha.segment1 = :$column$.po_number and (:$column$.supplier is null or aps.vendor_name = :$column$.supplier) and (:$column$.supplier_number is null or aps.segment1 = :$column$.supplier_number) and (:$column$.supplier_site is null or assa.vendor_site_code = :$column$.supplier_site) and -- pha.type_lookup_code = 'BLANKET' and nvl(pra.closed_code, 'OPEN') != 'FINALLY CLOSED' and nvl(pra.authorization_status, 'INCOMPLETE') in ('APPROVED', 'REQUIRES REAPPROVAL', 'INCOMPLETE') and nvl(pra.cancel_flag, 'N') = 'N' order by value 13 REVISION LOV custom number Y select nvl(pra.revision_num,pha.revision_num) value, null description from po_headers_all pha, po_releases_all pra, hr_all_organization_units_vl haouv, ap_suppliers aps, ap_supplier_sites_all assa where pha.po_header_id = pra.po_header_id (+) and pha.org_id=haouv.organization_id and pha.vendor_id = aps.vendor_id and pha.vendor_id = assa.vendor_id and pha.vendor_site_id = assa.vendor_site_id and pha.type_lookup_code in ('STANDARD', 'BLANKET', 'CONTRACT', 'PLANNED') and haouv.name = :$column$.operating_unit and pha.segment1 = :$column$.po_number and pra.release_num (+) = :$column$.release and (:$column$.supplier is null or aps.vendor_name = :$column$.supplier) and (:$column$.supplier_number is null or aps.segment1 = :$column$.supplier_number) and (:$column$.supplier_site is null or assa.vendor_site_code = :$column$.supplier_site) order by value select nvl(pra.revision_num,pha.revision_num) from po_headers_all pha, po_releases_all pra, hr_all_organization_units_vl haouv, ap_suppliers aps, ap_supplier_sites_all assa where pha.po_header_id = pra.po_header_id (+) and pha.org_id=haouv.organization_id and pha.vendor_id = aps.vendor_id and pha.vendor_id = assa.vendor_id and pha.vendor_site_id = assa.vendor_site_id and pha.type_lookup_code in ('STANDARD', 'BLANKET', 'CONTRACT', 'PLANNED') and haouv.name = :$column$.operating_unit and pha.segment1 = :$column$.po_number and pra.release_num (+) = :$column$.release and (:$column$.supplier is null or aps.vendor_name = :$column$.supplier) and (:$column$.supplier_number is null or aps.segment1 = :$column$.supplier_number) and (:$column$.supplier_site is null or assa.vendor_site_code = :$column$.supplier_site) Optionally specify the document revision number. Only the current revision of the PO or Release is allowed. 14 ACTION Char varchar2 240 :$flex$.default_action Optionally enter the action being taken. If not included or populated in the upload template, the value specified in the Default Action report parameter will be used. 15 ACTION_DATE Date date :$flex$.default_action_date Optionally enter the action date. If not included or populated in the upload template, the value specified in the Default Action Date report parameter will be used. If the Action Date column is not included or not populated in the upload template, and the Default Action Date report parameter is left blank, then the upload will use the current system date as the Action Date. 16 ACCEPTED LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y 17 ACCEPTANCE_TYPE LOV custom varchar2 80 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type = 'ACCEPTANCE TYPE' and flvv.view_application_id = 201 and flvv.enabled_flag = 'Y' and sysdate between nvl(flvv.start_date_active,sysdate) and nvl(flvv.end_date_active,sysdate) order by flvv.meaning select flvv.lookup_code id, flvv.meaning value from fnd_lookup_values_vl flvv where flvv.lookup_type = 'ACCEPTANCE TYPE' and flvv.view_application_id = 201 and flvv.enabled_flag = 'Y' and sysdate between nvl(flvv.start_date_active,sysdate) and nvl(flvv.end_date_active,sysdate) Y 18 ACCEPTANCE_PARTY LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type = 'ACCEPTANCE_PARTY' and flvv.view_application_id = 201 and flvv.enabled_flag = 'Y' and sysdate between nvl(flvv.start_date_active,sysdate) and nvl(flvv.end_date_active,sysdate) and flvv.lookup_code = 'B' order by flvv.meaning select flvv.lookup_code id, flvv.meaning value from fnd_lookup_values_vl flvv where flvv.lookup_type = 'ACCEPTANCE_PARTY' and flvv.view_application_id = 201 and flvv.enabled_flag = 'Y' and sysdate between nvl(flvv.start_date_active,sysdate) and nvl(flvv.end_date_active,sysdate) xxen_util.meaning('B','ACCEPTANCE_PARTY',201) The Acceptance Party. Only Buyer Acceptances can be uploaded. Y 19 ACCEPTED_BY_EMPLOYEE LOV custom varchar2 Y select hr.employee_id id, hr.full_name value, hr.employee_num description from hr_employees_current_v hr, po_agents pa where pa.agent_id = hr.employee_id and nvl(xxen_util.lookup_code(:$column$.acceptance_party,'ACCEPTANCE_PARTY',201),'B') = 'B' order by value select hr.full_name from hr_employees_current_v hr, po_agents pa where pa.agent_id = hr.employee_id and nvl(xxen_util.lookup_code(:$column$.acceptance_party,'ACCEPTANCE_PARTY',201),'B') = 'B' and pa.agent_id in ( select nvl(pra.agent_id,pha.agent_id) from po_headers_all pha, po_releases_all pra, hr_all_organization_units_vl haouv, ap_suppliers aps, ap_supplier_sites_all assa where pha.po_header_id = pra.po_header_id (+) and pha.org_id=haouv.organization_id and pha.vendor_id = aps.vendor_id and pha.vendor_id = assa.vendor_id and pha.vendor_site_id = assa.vendor_site_id and pha.type_lookup_code in ('STANDARD', 'BLANKET', 'CONTRACT', 'PLANNED') and haouv.name = :$column$.operating_unit and pha.segment1 = :$column$.po_number and pra.release_num (+) = :$column$.release ) Optionally enter the Accepted By Employee Name and/or the Accepted By Employee Number. Either one or both can be specified. If the Employee Name does not uniquely identify an employee, the employee number should also be specified instead of or as well as. If both the Accepted By Employee Name/Employee Num columns are not included or populated in the upload template, then the upload will use the PO/Release Buyer as the Accepted By. 20 ACCEPTED_BY_EMPLOYEE_NUM LOV custom varchar2 30 Y select hr.employee_id id, hr.employee_num value, hr.full_name description from hr_employees_current_v hr, po_agents pa where pa.agent_id = hr.employee_id and nvl(xxen_util.lookup_code(:$column$.acceptance_party,'ACCEPTANCE_PARTY',201),'B') = 'B' and (:$column$.accepted_by_employee is null or hr.full_name = :$column$.accepted_by_employee) order by value select hr.employee_num from hr_employees_current_v hr, po_agents pa where pa.agent_id = hr.employee_id and nvl(xxen_util.lookup_code(:$column$.acceptance_party,'ACCEPTANCE_PARTY',201),'B') = 'B' and hr.full_name = :$column$.accepted_by_employee Optionally enter the Accepted By Employee Name and/or the Accepted By Employee Number. Either one or both can be specified. If the Employee Name does not uniquely identify an employee, the employee number should also be specified instead of or as well as. If both the Accepted By Employee Name/Employee Num columns are not included or populated in the upload template, then the upload will use the PO/Release Buyer as the Accepted By. 21 ROLE Char varchar2 240 Optionally enter the role of the Accepting Employee 22 COMMENTS Char varchar2 23 SIGNATURE LOV custom varchar2 Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' and nvl(xxen_util.lookup_code(:$column$.acceptance_party,'ACCEPTANCE_PARTY',201),'B') = 'S' order by value,description select lookup_code id, meaning value from fnd_lookups where fnd_lookups.lookup_type='YES_NO' Y 24 ERECORD_ID Number number Y 25 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 = 201 and fdfv.descriptive_flexfield_name = 'PO_ACCEPTANCES' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 26 PO_ACCEPTANCE_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 => 201, p_descriptive_flexfield_name => 'PO_ACCEPTANCES', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.po_acceptance_attribute1, p_attribute2 => :$column$.po_acceptance_attribute2, p_attribute3 => :$column$.po_acceptance_attribute3, p_attribute4 => :$column$.po_acceptance_attribute4, p_attribute5 => :$column$.po_acceptance_attribute5, p_attribute6 => :$column$.po_acceptance_attribute6, p_attribute7 => :$column$.po_acceptance_attribute7, p_attribute8 => :$column$.po_acceptance_attribute8, p_attribute9 => :$column$.po_acceptance_attribute9, p_attribute10 => :$column$.po_acceptance_attribute10, p_attribute11 => :$column$.po_acceptance_attribute11, p_attribute12 => :$column$.po_acceptance_attribute12, p_attribute13 => :$column$.po_acceptance_attribute13, p_attribute14 => :$column$.po_acceptance_attribute14, p_attribute15 => :$column$.po_acceptance_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 = 201 and fdfv.descriptive_flexfield_name = 'PO_ACCEPTANCES' and fdfcuv.application_column_name = 'ATTRIBUTE1' 27 PO_ACCEPTANCE_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 => 201, p_descriptive_flexfield_name => 'PO_ACCEPTANCES', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.po_acceptance_attribute1, p_attribute2 => :$column$.po_acceptance_attribute2, p_attribute3 => :$column$.po_acceptance_attribute3, p_attribute4 => :$column$.po_acceptance_attribute4, p_attribute5 => :$column$.po_acceptance_attribute5, p_attribute6 => :$column$.po_acceptance_attribute6, p_attribute7 => :$column$.po_acceptance_attribute7, p_attribute8 => :$column$.po_acceptance_attribute8, p_attribute9 => :$column$.po_acceptance_attribute9, p_attribute10 => :$column$.po_acceptance_attribute10, p_attribute11 => :$column$.po_acceptance_attribute11, p_attribute12 => :$column$.po_acceptance_attribute12, p_attribute13 => :$column$.po_acceptance_attribute13, p_attribute14 => :$column$.po_acceptance_attribute14, p_attribute15 => :$column$.po_acceptance_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 = 201 and fdfv.descriptive_flexfield_name = 'PO_ACCEPTANCES' and fdfcuv.application_column_name = 'ATTRIBUTE2' 28 PO_ACCEPTANCE_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 => 201, p_descriptive_flexfield_name => 'PO_ACCEPTANCES', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.po_acceptance_attribute1, p_attribute2 => :$column$.po_acceptance_attribute2, p_attribute3 => :$column$.po_acceptance_attribute3, p_attribute4 => :$column$.po_acceptance_attribute4, p_attribute5 => :$column$.po_acceptance_attribute5, p_attribute6 => :$column$.po_acceptance_attribute6, p_attribute7 => :$column$.po_acceptance_attribute7, p_attribute8 => :$column$.po_acceptance_attribute8, p_attribute9 => :$column$.po_acceptance_attribute9, p_attribute10 => :$column$.po_acceptance_attribute10, p_attribute11 => :$column$.po_acceptance_attribute11, p_attribute12 => :$column$.po_acceptance_attribute12, p_attribute13 => :$column$.po_acceptance_attribute13, p_attribute14 => :$column$.po_acceptance_attribute14, p_attribute15 => :$column$.po_acceptance_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 = 201 and fdfv.descriptive_flexfield_name = 'PO_ACCEPTANCES' and fdfcuv.application_column_name = 'ATTRIBUTE3' 29 PO_ACCEPTANCE_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 => 201, p_descriptive_flexfield_name => 'PO_ACCEPTANCES', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.po_acceptance_attribute1, p_attribute2 => :$column$.po_acceptance_attribute2, p_attribute3 => :$column$.po_acceptance_attribute3, p_attribute4 => :$column$.po_acceptance_attribute4, p_attribute5 => :$column$.po_acceptance_attribute5, p_attribute6 => :$column$.po_acceptance_attribute6, p_attribute7 => :$column$.po_acceptance_attribute7, p_attribute8 => :$column$.po_acceptance_attribute8, p_attribute9 => :$column$.po_acceptance_attribute9, p_attribute10 => :$column$.po_acceptance_attribute10, p_attribute11 => :$column$.po_acceptance_attribute11, p_attribute12 => :$column$.po_acceptance_attribute12, p_attribute13 => :$column$.po_acceptance_attribute13, p_attribute14 => :$column$.po_acceptance_attribute14, p_attribute15 => :$column$.po_acceptance_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 = 201 and fdfv.descriptive_flexfield_name = 'PO_ACCEPTANCES' and fdfcuv.application_column_name = 'ATTRIBUTE4' 30 PO_ACCEPTANCE_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 => 201, p_descriptive_flexfield_name => 'PO_ACCEPTANCES', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.po_acceptance_attribute1, p_attribute2 => :$column$.po_acceptance_attribute2, p_attribute3 => :$column$.po_acceptance_attribute3, p_attribute4 => :$column$.po_acceptance_attribute4, p_attribute5 => :$column$.po_acceptance_attribute5, p_attribute6 => :$column$.po_acceptance_attribute6, p_attribute7 => :$column$.po_acceptance_attribute7, p_attribute8 => :$column$.po_acceptance_attribute8, p_attribute9 => :$column$.po_acceptance_attribute9, p_attribute10 => :$column$.po_acceptance_attribute10, p_attribute11 => :$column$.po_acceptance_attribute11, p_attribute12 => :$column$.po_acceptance_attribute12, p_attribute13 => :$column$.po_acceptance_attribute13, p_attribute14 => :$column$.po_acceptance_attribute14, p_attribute15 => :$column$.po_acceptance_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 = 201 and fdfv.descriptive_flexfield_name = 'PO_ACCEPTANCES' and fdfcuv.application_column_name = 'ATTRIBUTE5' 31 PO_ACCEPTANCE_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 => 201, p_descriptive_flexfield_name => 'PO_ACCEPTANCES', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.po_acceptance_attribute1, p_attribute2 => :$column$.po_acceptance_attribute2, p_attribute3 => :$column$.po_acceptance_attribute3, p_attribute4 => :$column$.po_acceptance_attribute4, p_attribute5 => :$column$.po_acceptance_attribute5, p_attribute6 => :$column$.po_acceptance_attribute6, p_attribute7 => :$column$.po_acceptance_attribute7, p_attribute8 => :$column$.po_acceptance_attribute8, p_attribute9 => :$column$.po_acceptance_attribute9, p_attribute10 => :$column$.po_acceptance_attribute10, p_attribute11 => :$column$.po_acceptance_attribute11, p_attribute12 => :$column$.po_acceptance_attribute12, p_attribute13 => :$column$.po_acceptance_attribute13, p_attribute14 => :$column$.po_acceptance_attribute14, p_attribute15 => :$column$.po_acceptance_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 = 201 and fdfv.descriptive_flexfield_name = 'PO_ACCEPTANCES' and fdfcuv.application_column_name = 'ATTRIBUTE6' 32 PO_ACCEPTANCE_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 => 201, p_descriptive_flexfield_name => 'PO_ACCEPTANCES', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.po_acceptance_attribute1, p_attribute2 => :$column$.po_acceptance_attribute2, p_attribute3 => :$column$.po_acceptance_attribute3, p_attribute4 => :$column$.po_acceptance_attribute4, p_attribute5 => :$column$.po_acceptance_attribute5, p_attribute6 => :$column$.po_acceptance_attribute6, p_attribute7 => :$column$.po_acceptance_attribute7, p_attribute8 => :$column$.po_acceptance_attribute8, p_attribute9 => :$column$.po_acceptance_attribute9, p_attribute10 => :$column$.po_acceptance_attribute10, p_attribute11 => :$column$.po_acceptance_attribute11, p_attribute12 => :$column$.po_acceptance_attribute12, p_attribute13 => :$column$.po_acceptance_attribute13, p_attribute14 => :$column$.po_acceptance_attribute14, p_attribute15 => :$column$.po_acceptance_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 = 201 and fdfv.descriptive_flexfield_name = 'PO_ACCEPTANCES' and fdfcuv.application_column_name = 'ATTRIBUTE7' 33 PO_ACCEPTANCE_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 => 201, p_descriptive_flexfield_name => 'PO_ACCEPTANCES', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.po_acceptance_attribute1, p_attribute2 => :$column$.po_acceptance_attribute2, p_attribute3 => :$column$.po_acceptance_attribute3, p_attribute4 => :$column$.po_acceptance_attribute4, p_attribute5 => :$column$.po_acceptance_attribute5, p_attribute6 => :$column$.po_acceptance_attribute6, p_attribute7 => :$column$.po_acceptance_attribute7, p_attribute8 => :$column$.po_acceptance_attribute8, p_attribute9 => :$column$.po_acceptance_attribute9, p_attribute10 => :$column$.po_acceptance_attribute10, p_attribute11 => :$column$.po_acceptance_attribute11, p_attribute12 => :$column$.po_acceptance_attribute12, p_attribute13 => :$column$.po_acceptance_attribute13, p_attribute14 => :$column$.po_acceptance_attribute14, p_attribute15 => :$column$.po_acceptance_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 = 201 and fdfv.descriptive_flexfield_name = 'PO_ACCEPTANCES' and fdfcuv.application_column_name = 'ATTRIBUTE8' 34 PO_ACCEPTANCE_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 => 201, p_descriptive_flexfield_name => 'PO_ACCEPTANCES', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.po_acceptance_attribute1, p_attribute2 => :$column$.po_acceptance_attribute2, p_attribute3 => :$column$.po_acceptance_attribute3, p_attribute4 => :$column$.po_acceptance_attribute4, p_attribute5 => :$column$.po_acceptance_attribute5, p_attribute6 => :$column$.po_acceptance_attribute6, p_attribute7 => :$column$.po_acceptance_attribute7, p_attribute8 => :$column$.po_acceptance_attribute8, p_attribute9 => :$column$.po_acceptance_attribute9, p_attribute10 => :$column$.po_acceptance_attribute10, p_attribute11 => :$column$.po_acceptance_attribute11, p_attribute12 => :$column$.po_acceptance_attribute12, p_attribute13 => :$column$.po_acceptance_attribute13, p_attribute14 => :$column$.po_acceptance_attribute14, p_attribute15 => :$column$.po_acceptance_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 = 201 and fdfv.descriptive_flexfield_name = 'PO_ACCEPTANCES' and fdfcuv.application_column_name = 'ATTRIBUTE9' 35 PO_ACCEPTANCE_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 => 201, p_descriptive_flexfield_name => 'PO_ACCEPTANCES', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.po_acceptance_attribute1, p_attribute2 => :$column$.po_acceptance_attribute2, p_attribute3 => :$column$.po_acceptance_attribute3, p_attribute4 => :$column$.po_acceptance_attribute4, p_attribute5 => :$column$.po_acceptance_attribute5, p_attribute6 => :$column$.po_acceptance_attribute6, p_attribute7 => :$column$.po_acceptance_attribute7, p_attribute8 => :$column$.po_acceptance_attribute8, p_attribute9 => :$column$.po_acceptance_attribute9, p_attribute10 => :$column$.po_acceptance_attribute10, p_attribute11 => :$column$.po_acceptance_attribute11, p_attribute12 => :$column$.po_acceptance_attribute12, p_attribute13 => :$column$.po_acceptance_attribute13, p_attribute14 => :$column$.po_acceptance_attribute14, p_attribute15 => :$column$.po_acceptance_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 = 201 and fdfv.descriptive_flexfield_name = 'PO_ACCEPTANCES' and fdfcuv.application_column_name = 'ATTRIBUTE10' 36 PO_ACCEPTANCE_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 => 201, p_descriptive_flexfield_name => 'PO_ACCEPTANCES', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.po_acceptance_attribute1, p_attribute2 => :$column$.po_acceptance_attribute2, p_attribute3 => :$column$.po_acceptance_attribute3, p_attribute4 => :$column$.po_acceptance_attribute4, p_attribute5 => :$column$.po_acceptance_attribute5, p_attribute6 => :$column$.po_acceptance_attribute6, p_attribute7 => :$column$.po_acceptance_attribute7, p_attribute8 => :$column$.po_acceptance_attribute8, p_attribute9 => :$column$.po_acceptance_attribute9, p_attribute10 => :$column$.po_acceptance_attribute10, p_attribute11 => :$column$.po_acceptance_attribute11, p_attribute12 => :$column$.po_acceptance_attribute12, p_attribute13 => :$column$.po_acceptance_attribute13, p_attribute14 => :$column$.po_acceptance_attribute14, p_attribute15 => :$column$.po_acceptance_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 = 201 and fdfv.descriptive_flexfield_name = 'PO_ACCEPTANCES' and fdfcuv.application_column_name = 'ATTRIBUTE11' 37 PO_ACCEPTANCE_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 => 201, p_descriptive_flexfield_name => 'PO_ACCEPTANCES', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.po_acceptance_attribute1, p_attribute2 => :$column$.po_acceptance_attribute2, p_attribute3 => :$column$.po_acceptance_attribute3, p_attribute4 => :$column$.po_acceptance_attribute4, p_attribute5 => :$column$.po_acceptance_attribute5, p_attribute6 => :$column$.po_acceptance_attribute6, p_attribute7 => :$column$.po_acceptance_attribute7, p_attribute8 => :$column$.po_acceptance_attribute8, p_attribute9 => :$column$.po_acceptance_attribute9, p_attribute10 => :$column$.po_acceptance_attribute10, p_attribute11 => :$column$.po_acceptance_attribute11, p_attribute12 => :$column$.po_acceptance_attribute12, p_attribute13 => :$column$.po_acceptance_attribute13, p_attribute14 => :$column$.po_acceptance_attribute14, p_attribute15 => :$column$.po_acceptance_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 = 201 and fdfv.descriptive_flexfield_name = 'PO_ACCEPTANCES' and fdfcuv.application_column_name = 'ATTRIBUTE12' 38 PO_ACCEPTANCE_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 => 201, p_descriptive_flexfield_name => 'PO_ACCEPTANCES', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.po_acceptance_attribute1, p_attribute2 => :$column$.po_acceptance_attribute2, p_attribute3 => :$column$.po_acceptance_attribute3, p_attribute4 => :$column$.po_acceptance_attribute4, p_attribute5 => :$column$.po_acceptance_attribute5, p_attribute6 => :$column$.po_acceptance_attribute6, p_attribute7 => :$column$.po_acceptance_attribute7, p_attribute8 => :$column$.po_acceptance_attribute8, p_attribute9 => :$column$.po_acceptance_attribute9, p_attribute10 => :$column$.po_acceptance_attribute10, p_attribute11 => :$column$.po_acceptance_attribute11, p_attribute12 => :$column$.po_acceptance_attribute12, p_attribute13 => :$column$.po_acceptance_attribute13, p_attribute14 => :$column$.po_acceptance_attribute14, p_attribute15 => :$column$.po_acceptance_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 = 201 and fdfv.descriptive_flexfield_name = 'PO_ACCEPTANCES' and fdfcuv.application_column_name = 'ATTRIBUTE13' 39 PO_ACCEPTANCE_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 => 201, p_descriptive_flexfield_name => 'PO_ACCEPTANCES', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.po_acceptance_attribute1, p_attribute2 => :$column$.po_acceptance_attribute2, p_attribute3 => :$column$.po_acceptance_attribute3, p_attribute4 => :$column$.po_acceptance_attribute4, p_attribute5 => :$column$.po_acceptance_attribute5, p_attribute6 => :$column$.po_acceptance_attribute6, p_attribute7 => :$column$.po_acceptance_attribute7, p_attribute8 => :$column$.po_acceptance_attribute8, p_attribute9 => :$column$.po_acceptance_attribute9, p_attribute10 => :$column$.po_acceptance_attribute10, p_attribute11 => :$column$.po_acceptance_attribute11, p_attribute12 => :$column$.po_acceptance_attribute12, p_attribute13 => :$column$.po_acceptance_attribute13, p_attribute14 => :$column$.po_acceptance_attribute14, p_attribute15 => :$column$.po_acceptance_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 = 201 and fdfv.descriptive_flexfield_name = 'PO_ACCEPTANCES' and fdfcuv.application_column_name = 'ATTRIBUTE14' 40 PO_ACCEPTANCE_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 => 201, p_descriptive_flexfield_name => 'PO_ACCEPTANCES', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.po_acceptance_attribute1, p_attribute2 => :$column$.po_acceptance_attribute2, p_attribute3 => :$column$.po_acceptance_attribute3, p_attribute4 => :$column$.po_acceptance_attribute4, p_attribute5 => :$column$.po_acceptance_attribute5, p_attribute6 => :$column$.po_acceptance_attribute6, p_attribute7 => :$column$.po_acceptance_attribute7, p_attribute8 => :$column$.po_acceptance_attribute8, p_attribute9 => :$column$.po_acceptance_attribute9, p_attribute10 => :$column$.po_acceptance_attribute10, p_attribute11 => :$column$.po_acceptance_attribute11, p_attribute12 => :$column$.po_acceptance_attribute12, p_attribute13 => :$column$.po_acceptance_attribute13, p_attribute14 => :$column$.po_acceptance_attribute14, p_attribute15 => :$column$.po_acceptance_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 = 201 and fdfv.descriptive_flexfield_name = 'PO_ACCEPTANCES' and fdfcuv.application_column_name = 'ATTRIBUTE15' 41 DEFAULT_ACTION Char varchar2 2000 :$flex$.default_action Y 42 DEFAULT_ACTION_DATE Date date :$flex$.default_action_date Y 43 UPLOAD_ROW Number number U 1 p_org_id in Number OPERATING_UNIT U 2 p_po_number in Char PO_NUMBER value U 3 p_release_number in Char Y RELEASE value U 4 p_revision_number in Char Y REVISION U 8 p_action in Char Y ACTION U 9 p_action_date in Date Y ACTION_DATE U 10 p_accepting_party in Char Y ACCEPTANCE_PARTY U 11 p_employee_name in Char Y ACCEPTED_BY_EMPLOYEE value U 12 p_employee_num in Char Y ACCEPTED_BY_EMPLOYEE_NUM value U 13 p_employee_role in Char Y ROLE U 14 p_accepted_flag in Char ACCEPTED U 15 p_acceptance_type in Char ACCEPTANCE_TYPE U 16 p_notes in Char Y COMMENTS U 19 p_attribute_category in Char Y ATTRIBUTE_CATEGORY U 20 p_attribute1 in Char Y PO_ACCEPTANCE_ATTRIBUTE1 U 21 p_attribute2 in Char Y PO_ACCEPTANCE_ATTRIBUTE2 U 22 p_attribute3 in Char Y PO_ACCEPTANCE_ATTRIBUTE3 U 23 p_attribute4 in Char Y PO_ACCEPTANCE_ATTRIBUTE4 U 24 p_attribute5 in Char Y PO_ACCEPTANCE_ATTRIBUTE5 U 25 p_attribute6 in Char Y PO_ACCEPTANCE_ATTRIBUTE6 U 26 p_attribute7 in Char Y PO_ACCEPTANCE_ATTRIBUTE7 U 27 p_attribute8 in Char Y PO_ACCEPTANCE_ATTRIBUTE8 U 28 p_attribute9 in Char Y PO_ACCEPTANCE_ATTRIBUTE9 U 29 p_attribute10 in Char Y PO_ACCEPTANCE_ATTRIBUTE10 U 30 p_attribute11 in Char Y PO_ACCEPTANCE_ATTRIBUTE11 U 31 p_attribute12 in Char Y PO_ACCEPTANCE_ATTRIBUTE12 U 32 p_attribute13 in Char Y PO_ACCEPTANCE_ATTRIBUTE13 U 33 p_attribute14 in Char Y PO_ACCEPTANCE_ATTRIBUTE14 U 34 p_attribute15 in Char Y PO_ACCEPTANCE_ATTRIBUTE15 U 35 p_default_action in Char Y DEFAULT_ACTION U 36 p_default_action_date in Date Y DEFAULT_ACTION_DATE U 37 p_acceptance_id in/out Number ACCEPTANCE_ID U 39 status_ out Char STATUS_CODE_ U 40 message_ out Char MESSAGE_ U 41 request_id_ out Number REQUEST_ID_ Error SQL Order By upload_row Success SQL select xu.action_, xxen_upload.status_meaning(status_) status_, xu.message_, xu.request_id_, xu.modified_columns_, xu.acceptance_id, -- hou.name operating_unit, asu.vendor_name supplier, asu.segment1 supplier_number, assa.vendor_site_code supplier_site, nvl(pha2.segment1,pha.segment1) po_number, pra.release_num release, pav.revision_num revision, pav.action, pav.action_date, xxen_util.meaning(pav.accepted_flag,'YES_NO',0) accepted, pav.acceptance_type, xxen_util.meaning(pav.accepting_party,'ACCEPTANCE_PARTY',201) acceptance_party, case when pav.employee_id is not null then pav.full_name else po_inq_sv.get_party_vendor_name(pav.created_by) end accepted_by_employee, pav.employee_num accepted_by_employee_num, pav.role, &lp_note_column xxen_util.meaning(pav.signature_flag,'YES_NO',0) signature, pav.erecord_id, -- xxen_util.display_flexfield_context(201,'PO_ACCEPTANCES',pav.attribute_category) attribute_category, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE1',pav.row_id,pav.attribute1) po_acceptance_attribute1, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE2',pav.row_id,pav.attribute2) po_acceptance_attribute2, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE3',pav.row_id,pav.attribute3) po_acceptance_attribute3, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE4',pav.row_id,pav.attribute4) po_acceptance_attribute4, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE5',pav.row_id,pav.attribute5) po_acceptance_attribute5, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE6',pav.row_id,pav.attribute6) po_acceptance_attribute6, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE7',pav.row_id,pav.attribute7) po_acceptance_attribute7, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE8',pav.row_id,pav.attribute8) po_acceptance_attribute8, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE9',pav.row_id,pav.attribute9) po_acceptance_attribute9, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE10',pav.row_id,pav.attribute10) po_acceptance_attribute10, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE11',pav.row_id,pav.attribute11) po_acceptance_attribute11, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE12',pav.row_id,pav.attribute12) po_acceptance_attribute12, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE13',pav.row_id,pav.attribute13) po_acceptance_attribute13, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE14',pav.row_id,pav.attribute14) po_acceptance_attribute14, xxen_util.display_flexfield_value(201,'PO_ACCEPTANCES',pav.attribute_category,'ATTRIBUTE15',pav.row_id,pav.attribute15) po_acceptance_attribute15, -- xu.default_action, xu.default_action_date, xu.upload_row from xxen_po_acceptance_uplo_1343_u xu, po_acceptances_v pav, po_headers_all pha, po_releases_all pra, po_headers_all pha2, ap_suppliers asu, ap_supplier_sites_all assa, hr_operating_units hou where xu.acceptance_id = pav.acceptance_id and pav.po_header_id = pha.po_header_id (+) and pav.po_release_id = pra.po_release_id (+) and pra.po_header_id = pha2.po_header_id (+) and nvl(pha2.vendor_id,pha.vendor_id) = asu.vendor_id and nvl(pha2.vendor_site_id,pha.vendor_site_id) = assa.vendor_site_id and nvl(pha2.org_id,pha.org_id) = hou.organization_id and nvl(xu.status_code_,xxen_upload.status_error) = xxen_upload.status_success