ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 0C5E0618CE7A256CE0636AFB0905B60AY with document_types_ as ( select /*+ inline */ case when pdtav.document_type_code='QUOTATION' then pdtav.document_type_code else pdtav.document_subtype end document_type, pdtav.type_name document_type_name from po_document_types_all_vl pdtav, hr_all_organization_units_vl haouv where 2=2 and 3=3 and pdtav.org_id=haouv.organization_id and pdtav.document_type_code in ('PO','PA','QUOTATION') and pdtav.document_subtype in ('BLANKET','CONTRACT','STANDARD') ), po_lines_ as ( select /*+ inline */ pla.po_line_id, pla.note_to_vendor, pla.line_reference_num, pla.po_header_id, pla.line_num, pltt.line_type, msiv.concatenated_segments item, pla.item_revision, pla.unit_meas_lookup_code unit_of_measure, pla.unit_price, xxen_util.meaning(pla.allow_price_override_flag,'YES_NO',0) allow_price_override, pla.not_to_exceed_price limit_price, pla.quantity line_quantity, pla.item_description description, pla.vendor_product_num supplier_item, mcv.category_concat_segs category, xxen_util.display_flexfield_context(201,'PO_LINES',pla.attribute_category) line_dff_context, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE1',pla.rowid,pla.attribute1) line_attribute1, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE2',pla.rowid,pla.attribute2) line_attribute2, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE3',pla.rowid,pla.attribute3) line_attribute3, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE4',pla.rowid,pla.attribute4) line_attribute4, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE5',pla.rowid,pla.attribute5) line_attribute5, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE6',pla.rowid,pla.attribute6) line_attribute6, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE7',pla.rowid,pla.attribute7) line_attribute7, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE8',pla.rowid,pla.attribute8) line_attribute8, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE9',pla.rowid,pla.attribute9) line_attribute9, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE10',pla.rowid,pla.attribute10) line_attribute10, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE11',pla.rowid,pla.attribute11) line_attribute11, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE12',pla.rowid,pla.attribute12) line_attribute12, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE13',pla.rowid,pla.attribute13) line_attribute13, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE14',pla.rowid,pla.attribute14) line_attribute14, xxen_util.display_flexfield_value(201,'PO_LINES',pla.attribute_category,'ATTRIBUTE15',pla.rowid,pla.attribute15) line_attribute15 from po_lines_all pla, po_line_types_tl pltt, mtl_categories_v mcv, mtl_system_items_vl msiv where nvl(pla.cancel_flag,'N')='N' and nvl(pla.closed_code,'OPEN')<>'FINALLY CLOSED' and pltt.language=userenv('lang') and pltt.line_type_id=pla.line_type_id and pla.category_id=mcv.category_id(+) and msiv.inventory_item_id(+) = pla.item_id and msiv.organization_id(+) = xxen_po_upload.get_inv_org_id(pla.org_id) ), po_line_locations_ as ( select /*+ inline */ plla.po_line_id, plla.line_location_id, plla.shipment_num, plla.quantity ship_quantity, plla.price_override break_price, plla.unit_meas_lookup_code break_unit_of_measure, plla.price_discount discount, mp.organization_code ship_to_organization_code, hla.location_code ship_to_location_code, plla.need_by_date, plla.promised_date, rrh.routing_name receipt_routing, plla.tax_name tax_classification_code, case when plla.inspection_required_flag='Y' then '4-Way' when plla.receipt_required_flag='Y' then '3-Way' else '2-Way' end match_approval_level, plla.start_date price_break_start_date, plla.end_date price_break_end_date, xxen_util.display_flexfield_context(201,'PO_LINE_LOCATIONS',plla.attribute_category) line_location_dff_context, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE1',plla.rowid,plla.attribute1) line_location_attribute1, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE2',plla.rowid,plla.attribute2) line_location_attribute2, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE3',plla.rowid,plla.attribute3) line_location_attribute3, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE4',plla.rowid,plla.attribute4) line_location_attribute4, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE5',plla.rowid,plla.attribute5) line_location_attribute5, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE6',plla.rowid,plla.attribute6) line_location_attribute6, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE7',plla.rowid,plla.attribute7) line_location_attribute7, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE8',plla.rowid,plla.attribute8) line_location_attribute8, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE9',plla.rowid,plla.attribute9) line_location_attribute9, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE10',plla.rowid,plla.attribute10) line_location_attribute10, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE11',plla.rowid,plla.attribute11) line_location_attribute11, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE12',plla.rowid,plla.attribute12) line_location_attribute12, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE13',plla.rowid,plla.attribute13) line_location_attribute13, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE14',plla.rowid,plla.attribute14) line_location_attribute14, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plla.attribute_category,'ATTRIBUTE15',plla.rowid,plla.attribute15) line_location_attribute15 from po_line_locations_all plla, mtl_parameters mp, hr_locations_all hla, rcv_routing_headers rrh where plla.ship_to_location_id=hla.location_id(+) and plla.ship_to_organization_id=mp.organization_id(+) and plla.receiving_routing_id=rrh.routing_header_id(+) and plla.po_release_id is null ) select null action_, null status_, null message_, null modified_columns_, pha.org_id, to_number(null) request_id_, to_number(null) interface_header_id, pha.po_header_id, pha.segment1 po_number, null group_, null document_number, pha.revision_num, pha.creation_date, pt.document_type_name document_type, po_headers_sv3.get_po_status(pha.po_header_id) document_status, pha.start_date effective_start_date, pha.end_date effective_end_date, pha.currency_code, gdct.user_conversion_type rate_type, pha.rate_date, pha.rate, pha.reference_num header_reference_num, pha.comments header_description, papf.full_name buyer, pv.vendor_name supplier_name, pvsa.vendor_site_code supplier_site, pha.blanket_total_amount amount_agreed, xxen_util.meaning(pha.global_agreement_flag,'YES_NO',0) global_agreement, xxen_util.meaning(pha.supply_agreement_flag,'YES_NO',0) supply_agreement, pha.quote_warning_delay, pha.note_to_vendor header_note_to_vendor, pha.note_to_receiver header_note_to_receiver, xxen_util.display_flexfield_context(201,'PO_HEADERS',pha.attribute_category) header_dff_context, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE1',pha.rowid,pha.attribute1) header_attribute1, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE2',pha.rowid,pha.attribute2) header_attribute2, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE3',pha.rowid,pha.attribute3) header_attribute3, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE4',pha.rowid,pha.attribute4) header_attribute4, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE5',pha.rowid,pha.attribute5) header_attribute5, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE6',pha.rowid,pha.attribute6) header_attribute6, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE7',pha.rowid,pha.attribute7) header_attribute7, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE8',pha.rowid,pha.attribute8) header_attribute8, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE9',pha.rowid,pha.attribute9) header_attribute9, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE10',pha.rowid,pha.attribute10) header_attribute10, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE11',pha.rowid,pha.attribute11) header_attribute11, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE12',pha.rowid,pha.attribute12) header_attribute12, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE13',pha.rowid,pha.attribute13) header_attribute13, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE14',pha.rowid,pha.attribute14) header_attribute14, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE15',pha.rowid,pha.attribute15) header_attribute15, hla2.location_code header_ship_to_location, hla1.location_code header_bill_to_location, case when pha.vendor_contact_id is not null then (select max(pvc.last_name||' '||pvc.first_name) from po_vendor_contacts pvc where pvc.vendor_contact_id=pha.vendor_contact_id) end supplier_contact, (select att.name from ap_terms_tl att where att.term_id=pha.terms_id and att.language=userenv('lang')) payment_terms, pha.freight_terms_lookup_code freight_terms, pha.fob_lookup_code fob, pha.ship_via_lookup_code carrier, to_number(null) interface_line_id, pl.po_line_id, pl.line_num, pl.line_reference_num, pl.line_type, pl.item, pl.item_revision, pl.category, pl.description, pl.unit_of_measure, pl.unit_price price, xxen_util.meaning(pl.allow_price_override,'YES_NO',0) allow_price_override, pl.limit_price, pl.line_quantity, pl.supplier_item, pl.note_to_vendor line_note_to_vendor, pl.line_dff_context, pl.line_attribute1, pl.line_attribute2, pl.line_attribute3, pl.line_attribute4, pl.line_attribute5, pl.line_attribute6, pl.line_attribute7, pl.line_attribute8, pl.line_attribute9, pl.line_attribute10, pl.line_attribute11, pl.line_attribute12, pl.line_attribute13, pl.line_attribute14, pl.line_attribute15, to_number(null) interface_line_location_id, pll.line_location_id, pll.shipment_num, pll.ship_quantity, pll.break_price, pll.break_unit_of_measure, --pll.discount, pll.ship_to_organization_code, pll.ship_to_location_code, pll.need_by_date, pll.promised_date, pll.receipt_routing, pll.tax_classification_code, pll.match_approval_level, pll.price_break_start_date, pll.price_break_end_date, pll.line_location_dff_context, pll.line_location_attribute1, pll.line_location_attribute2, pll.line_location_attribute3, pll.line_location_attribute4, pll.line_location_attribute5, pll.line_location_attribute6, pll.line_location_attribute7, pll.line_location_attribute8, pll.line_location_attribute9, pll.line_location_attribute10, pll.line_location_attribute11, pll.line_location_attribute12, pll.line_location_attribute13, pll.line_location_attribute14, pll.line_location_attribute15, to_number(null) interface_distribution_id, pda.po_distribution_id, pda.distribution_num, pda.quantity_ordered, gcck.concatenated_segments charge_account, case when pda.deliver_to_person_id is not null then (select papf.full_name from per_all_people_f papf where papf.person_id=pda.deliver_to_person_id and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date) end requestor, case when pda.destination_type_code is not null then (select plc.displayed_field from po_lookup_codes plc where plc.lookup_type='DESTINATION TYPE' and plc.lookup_code=pda.destination_type_code) end destination_type, case when pda.deliver_to_location_id is not null then (select hla.location_code from hr_locations_all hla where hla.location_id=pda.deliver_to_location_id) end deliver_to_location, case when pda.wip_entity_id is not null then (select we.wip_entity_name from wip_entities we where we.wip_entity_id=pda.wip_entity_id) end wip_job, pda.wip_operation_seq_num wip_operation_seq, pda.wip_resource_seq_num wip_resource_seq, case when pda.project_id is not null then (select ppa.segment1 from pa_projects_all ppa where pda.project_id=ppa.project_id) end project_number, case when pda.task_id is not null then (select ptaev.task_number from pa_tasks_all_expend_v ptaev where ptaev.task_id= pda.task_id and ptaev.expenditure_org_id=pda.org_id) end task_number, pda.expenditure_type, pda.expenditure_item_date expenditure_date, case when pda.expenditure_organization_id is not null then (select haouv_exp.name from hr_all_organization_units_vl haouv_exp where pda.expenditure_organization_id=haouv_exp.organization_id) end expenditure_org, xxen_util.display_flexfield_context(201,'PO_DISTRIBUTIONS',pda.attribute_category) distribution_dff_context, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE1',pda.rowid,pda.attribute1) distribution_attribute1, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE2',pda.rowid,pda.attribute2) distribution_attribute2, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE3',pda.rowid,pda.attribute3) distribution_attribute3, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE4',pda.rowid,pda.attribute4) distribution_attribute4, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE5',pda.rowid,pda.attribute5) distribution_attribute5, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE6',pda.rowid,pda.attribute6) distribution_attribute6, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE7',pda.rowid,pda.attribute7) distribution_attribute7, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE8',pda.rowid,pda.attribute8) distribution_attribute8, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE9',pda.rowid,pda.attribute9) distribution_attribute9, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE10',pda.rowid,pda.attribute10) distribution_attribute10, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE11',pda.rowid,pda.attribute11) distribution_attribute11, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE12',pda.rowid,pda.attribute12) distribution_attribute12, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE13',pda.rowid,pda.attribute13) distribution_attribute13, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE14',pda.rowid,pda.attribute14) distribution_attribute14, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE15',pda.rowid,pda.attribute15) distribution_attribute15, null approval_status, null create_or_update_items, null group_lines, null attachment_category_, null attachment_title_, null attachment_description_, null attachment_type_, null attachment_content_, null attachment_file_id_ from po_headers_all pha, gl_daily_conversion_types gdct, per_all_people_f papf, po_vendors pv, po_vendor_sites_all pvsa, hr_locations_all hla1, hr_locations_all hla2, po_distributions_all pda, gl_code_combinations_kfv gcck, hr_all_organization_units_vl haouv, document_types_ pt, po_lines_ pl, po_line_locations_ pll where nvl(:p_create_empty_file,'N')<>'Y' and 1=1 and 2=2 and pha.org_id=haouv.organization_id and pha.rate_type=gdct.conversion_type(+) and pha.type_lookup_code=pt.document_type and papf.person_id=pha.agent_id and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date and pha.vendor_id=pv.vendor_id(+) and pha.vendor_site_id=pvsa.vendor_site_id(+) and pha.bill_to_location_id=hla1.location_id(+) and pha.ship_to_location_id=hla2.location_id(+) and pha.po_header_id=pl.po_header_id(+) and pl.po_line_id=pll.po_line_id(+) and pll.line_location_id=pda.line_location_id(+) and (pll.price_break_end_date is null or pll.price_break_end_date >= trunc(sysdate) or :p_active_price_breaks_only is null) and pda.code_combination_id=gcck.code_combination_id(+) and nvl(pha.cancel_flag,'N')='N' and nvl(pha.closed_code,'OPEN')='OPEN' and nvl(pha.frozen_flag,'N')='N' and nvl(pha.user_hold_flag,'N')='N' Fix ORA-01427 in the download and result for a responsibility with access to several operating units: project and expenditure organization are looked up by id from pa_projects_all and hr_all_organization_units_vl. U PO A xxen_po_upload.create_update_purchase_docs xxen_po_upload.import_purchase_documents xxen_po_upload.validate_purchase_documents( p_org_id=>:$column$.org_id, p_action=>:$column$.action_, p_document_type=>:$column$.document_type, p_po_number=>:$column$.po_number, p_po_group=>:$column$.group_ ) US PO Purchasing Document Upload Upload to create and update purchase documents The buyer of an existing standard purchase order can be changed. An approved order then requires reapproval, which the upload submits with the new buyer as preparer. Enginatics Upload 1=1 2=2 3=3 :p_active_price_breaks_only :p_create_empty_file 1 10 2=2 haouv.name=: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)) Y US Operating Unit 2 20 1=1 :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 Y US Upload Mode 3 30 :p_create_empty_file LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual decode(:$flex$.upload_mode,'C','Y','N') US Create Empty File 4 40 3=3 case when pdtav.document_type_code='QUOTATION' then pdtav.document_type_code else pdtav.document_subtype end=:document_type LOV PO Document Type 14916BBA594D186AE0630100007FC96B Y select case when pdtav.document_type_code='QUOTATION' then pdtav.document_type_code else pdtav.document_subtype end id, pdtav.type_name value, null description from po_document_types_all_vl pdtav, hr_all_organization_units_vl haouv where haouv.name=:$flex$.operating_unit and pdtav.org_id=haouv.organization_id and pdtav.document_type_code in ('PO','PA','QUOTATION') and pdtav.document_subtype in ('BLANKET','CONTRACT','STANDARD') Y US Document Type 5 50 1=1 po_headers_sv3.get_po_status(pha.po_header_id) =:document_status LOV PO Document Status 14916BBA58FF186AE0630100007FC96B Y select plc.displayed_field value, null description from po_lookup_codes plc where plc.lookup_type ='DOCUMENT STATE' and plc.enabled_flag='Y' and plc.lookup_code in('APPROVED','IN PROCESS','INCOMPLETE','REQUIRES REAPPROVAL') and nvl(plc.inactive_date,sysdate+1)>sysdate US Document Status 6 60 :p_active_price_breaks_only LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Active Price Breaks Only 7 70 1=1 pha.segment1=:document_number LOV PO Document Number 14916BBA5911186AE0630100007FC96B Y Y select pha.segment1 value, null description from po_headers_all pha, hr_all_organization_units_vl haouv where :$flex$.operating_unit=haouv.name and pha.org_id=haouv.organization_id and :$flex$.upload_mode like '%' || xxen_upload.action_update and ( :$flex$.document_status is null or (po_headers_sv3.get_po_status(pha.po_header_id)=:$flex$.document_status)) and pha.type_lookup_code=:$flex$.document_type and nvl(pha.cancel_flag,'N')='N' and nvl(pha.closed_code,'OPEN')='OPEN' and nvl(pha.frozen_flag,'N')='N' and nvl(pha.user_hold_flag,'N')='N' US Document Number 8 80 1=1 pha.segment1>=:document_number_from LOV PO Document Number 14916BBA5911186AE0630100007FC96B Y Y select pha.segment1 value, null description from po_headers_all pha, hr_all_organization_units_vl haouv where :$flex$.operating_unit=haouv.name and pha.org_id=haouv.organization_id and :$flex$.upload_mode like '%' || xxen_upload.action_update and ( :$flex$.document_status is null or (po_headers_sv3.get_po_status(pha.po_header_id)=:$flex$.document_status)) and pha.type_lookup_code=:$flex$.document_type and nvl(pha.cancel_flag,'N')='N' and nvl(pha.closed_code,'OPEN')='OPEN' and nvl(pha.frozen_flag,'N')='N' and nvl(pha.user_hold_flag,'N')='N' US Document Number From 9 90 1=1 pha.segment1<=:document_number_to LOV PO Document Number 14916BBA5911186AE0630100007FC96B Y Y select pha.segment1 value, null description from po_headers_all pha, hr_all_organization_units_vl haouv where :$flex$.operating_unit=haouv.name and pha.org_id=haouv.organization_id and :$flex$.upload_mode like '%' || xxen_upload.action_update and ( :$flex$.document_status is null or (po_headers_sv3.get_po_status(pha.po_header_id)=:$flex$.document_status)) and pha.type_lookup_code=:$flex$.document_type and nvl(pha.cancel_flag,'N')='N' and nvl(pha.closed_code,'OPEN')='OPEN' and nvl(pha.frozen_flag,'N')='N' and nvl(pha.user_hold_flag,'N')='N' :$flex$.Document_Number_From US Document Number To 10 100 1=1 pv.vendor_name=:supplier LOV AP Supplier B9847D20A0E4742FE0538931640A6379 Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id US Supplier 11 110 1=1 pha.creation_date>=:creation_date_from Date US Creation Date From 12 120 1=1 pha.creation_date<:creation_date_to+1 Date last_day(:$flex$.creation_date_from) US Creation Date To 13 130 1=1 pll.need_by_date>=:need_by_date_from Date US Need By Date From 14 140 1=1 pll.need_by_date<:need_by_date_to+1 Date last_day(:$flex$.need_by_date_from) US Need By Date To 15 150 1=1 papf.full_name=:agent LOV custom Y select papf.full_name value, papf.full_name description from po_agents pa, per_all_people_f papf where papf.person_id=pa.agent_id and :$flex$.upload_mode like '%' || xxen_upload.action_update US Agent Name 16 160 1=1 pha.created_by in (select user_id from fnd_user where user_name=:created_by) LOV custom Y select fu.user_name value, coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address ) description from fnd_user fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf where :$flex$.upload_mode like '%' || xxen_upload.action_update and fu.employee_id=papf.person_id(+) order by fu.user_name US Created By 25975944829E7449BB8D3CE1019D94B9 Blanket Purchase Order SYSADMIN 28 ALLOW_PRICE_OVERRIDE 40 APPROVAL_STATUS 34 BREAK_PRICE Y 14 BUYER Y 24 CATEGORY Y Y 39 CHARGE_ACCOUNT Y 41 CREATE_OR_UPDATE_ITEMS 8 CURRENCY_CODE Y 25 DESCRIPTION Y Y 37 DISTRIBUTION_NUM 5 DOCUMENT_STATUS Y 7 EFFECTIVE_END_DATE 6 EFFECTIVE_START_DATE 2 GROUP_ Y 42 GROUP_LINES 18 HEADER_BILL_TO_LOCATION Y 13 HEADER_DESCRIPTION Y 12 HEADER_REFERENCE_NUM Y 17 HEADER_SHIP_TO_LOCATION Y 22 ITEM Y 23 ITEM_REVISION Y 29 LIMIT_PRICE 19 LINE_NUM Y 20 LINE_REFERENCE_NUM Y 21 LINE_TYPE Y Y 1 PO_NUMBER 27 PRICE 36 PRICE_BREAK_END_DATE Y 35 PRICE_BREAK_START_DATE Y 38 QUANTITY_ORDERED Y 11 RATE 10 RATE_DATE 9 RATE_TYPE -11.0012 REFERENCE_NUM 3 REVISION_NUM 30 SHIPMENT_NUM 31 SHIP_QUANTITY Y 33 SHIP_TO_LOCATION_CODE Y 32 SHIP_TO_ORGANIZATION_CODE Y 15 SUPPLIER_NAME Y Y 16 SUPPLIER_SITE Y Y 4 SUPPLY_AGREEMENT 26 UNIT_OF_MEASURE Y Y -17.0018 UNIT_PRICE Y Document Type BLANKET Operating Unit Vision Operations Upload Mode C,U S Site 074D5E62393C317FB24E2B55A7891391 Blanket Purchase Order(with attachment) ENGINATICS 38 APPROVAL_STATUS 41 ATTACHMENT_CATEGORY_ 45 ATTACHMENT_CONTENT_ 43 ATTACHMENT_DESCRIPTION_ 46 ATTACHMENT_FILE_ID_ 42 ATTACHMENT_TITLE_ 44 ATTACHMENT_TYPE_ 32 BREAK_PRICE Y 14 BUYER Y 24 CATEGORY Y Y 37 CHARGE_ACCOUNT Y 39 CREATE_OR_UPDATE_ITEMS 8 CURRENCY_CODE 25 DESCRIPTION Y Y 35 DISTRIBUTION_NUM 5 DOCUMENT_STATUS Y 7 EFFECTIVE_END_DATE 6 EFFECTIVE_START_DATE 2 GROUP_ 40 GROUP_LINES 18 HEADER_BILL_TO_LOCATION Y 13 HEADER_DESCRIPTION Y 12 HEADER_REFERENCE_NUM Y 17 HEADER_SHIP_TO_LOCATION Y 22 ITEM Y 23 ITEM_REVISION Y 19 LINE_NUM Y 20 LINE_REFERENCE_NUM Y 21 LINE_TYPE Y Y 1 PO_NUMBER 27 PRICE 34 PRICE_BREAK_END_DATE Y 33 PRICE_BREAK_START_DATE Y 36 QUANTITY_ORDERED Y 11 RATE 10 RATE_DATE 9 RATE_TYPE -11.0012 REFERENCE_NUM 3 REVISION_NUM 28 SHIPMENT_NUM 29 SHIP_QUANTITY Y 31 SHIP_TO_LOCATION_CODE Y 30 SHIP_TO_ORGANIZATION_CODE Y 15 SUPPLIER_NAME Y Y 16 SUPPLIER_SITE Y Y 4 SUPPLY_AGREEMENT 26 UNIT_OF_MEASURE Y Y -17.0018 UNIT_PRICE Y Document Type BLANKET Operating Unit Vision Operations Upload Mode C,U S Site 411834903EDA22760E8B3F6A12B14F82 Contract Purchase Order SYSADMIN 16 AMOUNT_AGREED Y 19 APPROVAL_STATUS Y 13 BUYER Y 20 CREATE_OR_UPDATE_ITEMS Y 7 CURRENCY_CODE Y 4 DOCUMENT_STATUS Y 6 EFFECTIVE_END_DATE 5 EFFECTIVE_START_DATE 2 GROUP_ Y 21 GROUP_LINES Y 18 HEADER_BILL_TO_LOCATION Y 12 HEADER_DESCRIPTION Y 11 HEADER_REFERENCE_NUM Y 17 HEADER_SHIP_TO_LOCATION Y 1 PO_NUMBER 10 RATE 9 RATE_DATE 8 RATE_TYPE -9.001 REFERENCE_NUM 3 REVISION_NUM 14 SUPPLIER_NAME Y Y 15 SUPPLIER_SITE Y Y Document Type CONTRACT Operating Unit Vision Operations Upload Mode C,U S Site E6300F19145D01D02FB7848B1C6EBD7D Contract Purchase Order(with attachment) ENGINATICS 16 AMOUNT_AGREED Y 19 APPROVAL_STATUS Y 22 ATTACHMENT_CATEGORY_ 26 ATTACHMENT_CONTENT_ 24 ATTACHMENT_DESCRIPTION_ 27 ATTACHMENT_FILE_ID_ 23 ATTACHMENT_TITLE_ 25 ATTACHMENT_TYPE_ 13 BUYER Y 20 CREATE_OR_UPDATE_ITEMS Y 7 CURRENCY_CODE 4 DOCUMENT_STATUS Y 6 EFFECTIVE_END_DATE 5 EFFECTIVE_START_DATE 2 GROUP_ 21 GROUP_LINES Y 18 HEADER_BILL_TO_LOCATION Y 12 HEADER_DESCRIPTION Y 11 HEADER_REFERENCE_NUM Y 17 HEADER_SHIP_TO_LOCATION Y 1 PO_NUMBER 10 RATE 9 RATE_DATE 8 RATE_TYPE -9.001 REFERENCE_NUM 3 REVISION_NUM 14 SUPPLIER_NAME Y Y 15 SUPPLIER_SITE Y Y Document Type CONTRACT Operating Unit Vision Operations Upload Mode C,U S Site 5044B3F80E686EE12C5E6AFB3C68B9A1 Standard Purchase Order SYSADMIN 49 APPROVAL_STATUS 11 BUYER 20 CARRIER 26 CATEGORY Y Y 42 CHARGE_ACCOUNT Y 50 CREATE_OR_UPDATE_ITEMS 5 CURRENCY_CODE Y 45 DELIVER_TO_LOCATION 27 DESCRIPTION Y 43 DESTINATION_TYPE 40 DISTRIBUTION_NUM 4 DOCUMENT_STATUS Y 19 FOB 18 FREIGHT_TERMS 2 GROUP_ Y 51 GROUP_LINES 16 HEADER_BILL_TO_LOCATION Y 10 HEADER_DESCRIPTION 9 HEADER_REFERENCE_NUM Y 15 HEADER_SHIP_TO_LOCATION Y 24 ITEM Y 25 ITEM_REVISION Y 21 LINE_NUM Y 29 LINE_QUANTITY Y Y 22 LINE_REFERENCE_NUM Y 23 LINE_TYPE Y Y 38 MATCH_APPROVAL_LEVEL 35 NEED_BY_DATE 17 PAYMENT_TERMS 1 PO_NUMBER 30 PRICE Y 36 PROMISED_DATE 41 QUANTITY_ORDERED 8 RATE 7 RATE_DATE 6 RATE_TYPE 39 RECEIPT_ROUTING -11.0012 REFERENCE_NUM 44 REQUESTOR 3 REVISION_NUM 31 SHIPMENT_NUM 32 SHIP_QUANTITY 34 SHIP_TO_LOCATION_CODE Y 33 SHIP_TO_ORGANIZATION_CODE Y 14 SUPPLIER_CONTACT 12 SUPPLIER_NAME Y Y 13 SUPPLIER_SITE Y Y 37 TAX_CLASSIFICATION_CODE 28 UNIT_OF_MEASURE Y Y -16.0017 UNIT_PRICE Y 46 WIP_JOB 47 WIP_OPERATION_SEQ 48 WIP_RESOURCE_SEQ Document Type STANDARD Operating Unit Vision Operations Upload Mode C,U S Site 51ECFE30EDA62661591391469F701D66 Standard Purchase Order(with attachment) ENGINATICS 49 APPROVAL_STATUS 52 ATTACHMENT_CATEGORY_ 56 ATTACHMENT_CONTENT_ 54 ATTACHMENT_DESCRIPTION_ 57 ATTACHMENT_FILE_ID_ 53 ATTACHMENT_TITLE_ 55 ATTACHMENT_TYPE_ 11 BUYER 20 CARRIER 26 CATEGORY Y Y 42 CHARGE_ACCOUNT Y 50 CREATE_OR_UPDATE_ITEMS 5 CURRENCY_CODE 45 DELIVER_TO_LOCATION 27 DESCRIPTION Y 43 DESTINATION_TYPE 40 DISTRIBUTION_NUM 4 DOCUMENT_STATUS Y 19 FOB 18 FREIGHT_TERMS 2 GROUP_ 51 GROUP_LINES 16 HEADER_BILL_TO_LOCATION Y 10 HEADER_DESCRIPTION 9 HEADER_REFERENCE_NUM Y 15 HEADER_SHIP_TO_LOCATION Y 24 ITEM Y 25 ITEM_REVISION Y 21 LINE_NUM Y 29 LINE_QUANTITY Y Y 22 LINE_REFERENCE_NUM Y 23 LINE_TYPE Y Y 38 MATCH_APPROVAL_LEVEL 35 NEED_BY_DATE 17 PAYMENT_TERMS 1 PO_NUMBER 30 PRICE Y 36 PROMISED_DATE 41 QUANTITY_ORDERED 8 RATE 7 RATE_DATE 6 RATE_TYPE 39 RECEIPT_ROUTING -11.0012 REFERENCE_NUM 44 REQUESTOR 3 REVISION_NUM 31 SHIPMENT_NUM 32 SHIP_QUANTITY 34 SHIP_TO_LOCATION_CODE Y 33 SHIP_TO_ORGANIZATION_CODE Y 14 SUPPLIER_CONTACT 12 SUPPLIER_NAME Y Y 13 SUPPLIER_SITE Y Y 37 TAX_CLASSIFICATION_CODE 28 UNIT_OF_MEASURE Y Y -16.0017 UNIT_PRICE Y 46 WIP_JOB 47 WIP_OPERATION_SEQ 48 WIP_RESOURCE_SEQ Document Type STANDARD Operating Unit Vision Operations Upload Mode C,U S Site 00B56EFD1517BE108B770E37DF69DEAA Standard Quotation SYSADMIN 34 APPROVAL_STATUS 31 BREAK_PRICE 30 BREAK_UNIT_OF_MEASURE 11 BUYER Y 22 CATEGORY Y Y 35 CREATE_OR_UPDATE_ITEMS 5 CURRENCY_CODE Y 23 DESCRIPTION Y Y 4 DOCUMENT_STATUS Y 2 GROUP_ Y 36 GROUP_LINES 16 HEADER_BILL_TO_LOCATION Y 10 HEADER_DESCRIPTION Y 9 HEADER_REFERENCE_NUM Y 15 HEADER_SHIP_TO_LOCATION Y 20 ITEM Y 21 ITEM_REVISION Y 17 LINE_NUM 18 LINE_REFERENCE_NUM Y 19 LINE_TYPE Y Y 1 PO_NUMBER 25 PRICE 33 PRICE_BREAK_END_DATE 32 PRICE_BREAK_START_DATE 14 QUOTE_WARNING_DELAY Y 8 RATE 7 RATE_DATE 6 RATE_TYPE -11.0012 REFERENCE_NUM 3 REVISION_NUM 26 SHIPMENT_NUM 27 SHIP_QUANTITY 29 SHIP_TO_LOCATION_CODE 28 SHIP_TO_ORGANIZATION_CODE 12 SUPPLIER_NAME Y Y 13 SUPPLIER_SITE Y Y 24 UNIT_OF_MEASURE Y Y -18.0019 UNIT_PRICE Y Document Type QUOTATION Operating Unit Vision Operations Upload Mode C,U S Site 139E79CA0C3DB8B7EE4D0B74ABEE23D6 Standard Quotation(with attachment) ENGINATICS 34 APPROVAL_STATUS 37 ATTACHMENT_CATEGORY_ 41 ATTACHMENT_CONTENT_ 39 ATTACHMENT_DESCRIPTION_ 42 ATTACHMENT_FILE_ID_ 38 ATTACHMENT_TITLE_ 40 ATTACHMENT_TYPE_ 31 BREAK_PRICE 30 BREAK_UNIT_OF_MEASURE 11 BUYER Y 22 CATEGORY Y Y 35 CREATE_OR_UPDATE_ITEMS 5 CURRENCY_CODE 23 DESCRIPTION Y Y 4 DOCUMENT_STATUS Y 2 GROUP_ 36 GROUP_LINES 16 HEADER_BILL_TO_LOCATION Y 10 HEADER_DESCRIPTION Y 9 HEADER_REFERENCE_NUM Y 15 HEADER_SHIP_TO_LOCATION Y 20 ITEM Y 21 ITEM_REVISION Y 17 LINE_NUM 18 LINE_REFERENCE_NUM Y 19 LINE_TYPE Y Y 1 PO_NUMBER 25 PRICE 33 PRICE_BREAK_END_DATE 32 PRICE_BREAK_START_DATE 14 QUOTE_WARNING_DELAY Y 8 RATE 7 RATE_DATE 6 RATE_TYPE -11.0012 REFERENCE_NUM 3 REVISION_NUM 26 SHIPMENT_NUM 27 SHIP_QUANTITY 29 SHIP_TO_LOCATION_CODE 28 SHIP_TO_ORGANIZATION_CODE 12 SUPPLIER_NAME Y Y 13 SUPPLIER_SITE Y Y 24 UNIT_OF_MEASURE Y Y -18.0019 UNIT_PRICE Y Document Type QUOTATION Operating Unit Vision Operations Upload Mode C,U S Site SYSADMIN 5044B3F80E686EE12C5E6AFB3C68B9A1 ENGINATICS 25975944829E7449BB8D3CE1019D94B9 MRUGESH.POOJARY_OLD 5044B3F80E686EE12C5E6AFB3C68B9A1 ASHISH.SAKLANI 51ECFE30EDA62661591391469F701D66 ANDY.HAACK 5044B3F80E686EE12C5E6AFB3C68B9A1 PIYUSH.KHANDELWAL 25975944829E7449BB8D3CE1019D94B9 MRUGESH.POOJARY 5044B3F80E686EE12C5E6AFB3C68B9A1 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 ORG_ID Number number select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$flex$.operating_unit Y 6 REQUEST_ID_ Number number Y 7 INTERFACE_HEADER_ID Number number Y 8 PO_HEADER_ID Number number Y 9 PO_NUMBER LOV varchar2 20 PO Number 8E2FF36EDEED79D2E0530100007F1FF2 Y Y select pha.segment1 value, xxen_util.meaning(pha.type_lookup_code,'PO TYPE',201)||nvl2(aps.vendor_name,': '||aps.vendor_name,null) description from po_headers_all pha, ap_suppliers aps where (:$flex$.operating_unit is null or pha.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') ) and pha.vendor_id=aps.vendor_id(+) order by pha.creation_date desc Enter an existing PO Number to add new lines, shipments or distributions to an existing PO. Y Y 10 GROUP_ Char varchar2 Enter a value based on which lines will be grouped into a PO Y Y 11 DOCUMENT_NUMBER Char varchar2 Only enter a value if you wish to provide your own PO Number instead of system generated one Y Y 12 REVISION_NUM Number number Y 13 CREATION_DATE Date date sysdate Y 14 DOCUMENT_TYPE LOV varchar2 80 PO Document Type 14916BBA594D186AE0630100007FC96B Y select case when pdtav.document_type_code='QUOTATION' then pdtav.document_type_code else pdtav.document_subtype end id, pdtav.type_name value, null description from po_document_types_all_vl pdtav, hr_all_organization_units_vl haouv where haouv.name=:$flex$.operating_unit and pdtav.org_id=haouv.organization_id and pdtav.document_type_code in ('PO','PA','QUOTATION') and pdtav.document_subtype in ('BLANKET','CONTRACT','STANDARD') select case when pdtav.document_type_code='QUOTATION' then pdtav.document_type_code else pdtav.document_subtype end id, pdtav.type_name value, null description from po_document_types_all_vl pdtav, hr_all_organization_units_vl haouv where haouv.name=:$flex$.operating_unit and pdtav.org_id=haouv.organization_id and pdtav.document_type_code in ('PO','PA','QUOTATION') and pdtav.document_subtype in ('BLANKET','CONTRACT','STANDARD') select pdtav.type_name value from po_document_types_all_vl pdtav, hr_all_organization_units_vl haouv where haouv.name=:$flex$.operating_unit and pdtav.org_id=haouv.organization_id and case when pdtav.document_type_code='QUOTATION' then pdtav.document_type_code else pdtav.document_subtype end = :$flex$.document_type and pdtav.document_type_code in ('PO','PA','QUOTATION') and pdtav.document_subtype in ('BLANKET','CONTRACT','STANDARD') Y Y Y Y 15 DOCUMENT_STATUS Char varchar2 16 EFFECTIVE_START_DATE Date date Y 17 EFFECTIVE_END_DATE Date date Y 18 CURRENCY_CODE LOV varchar2 15 FND Currency 8E2FF36EDE9079D2E0530100007F1FF2 Y select fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' order by fcv.currency_code Y 19 RATE_TYPE LOV varchar2 30 GL Currency Conversion Type 91D3167A335F1204E053BB6B63585EE3 Y select gdct.user_conversion_type value, gdct.description from gl_daily_conversion_types gdct order by 1 Y 20 RATE_DATE Date date Y 21 RATE Number number Y 22 HEADER_REFERENCE_NUM Char varchar2 25 23 HEADER_DESCRIPTION Char varchar2 240 24 BUYER LOV varchar2 240 PO Buyer 8E2FF36EDF2F79D2E0530100007F1FF2 Y Y select ppx.full_name value, ppx.employee_number description from per_people_x ppx where ppx.current_employee_flag='Y' and ppx.person_id in (select pa.agent_id from po_agents pa where sysdate between nvl(pa.start_date_active,sysdate) and nvl(pa.end_date_active,sysdate)) and ppx.person_id in ( select paaf.person_id from per_all_assignments_f paaf where trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date and (:$flex$.organization_code is null or paaf.business_group_id in (select ood.business_group_id from org_organization_definitions ood where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y') ) ) order by ppx.full_name Y 25 SUPPLIER_NAME LOV varchar2 240 AP Supplier B9847D20A0E4742FE0538931640A6379 Y Y select aps.vendor_name value, aps.segment1 description from ap_suppliers aps where (:$flex$.operating_unit is null or aps.vendor_id in (select assa.vendor_id from hr_all_organization_units_vl haouv, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=assa.org_id)) and (:$flex$.organization_code is null or aps.vendor_id in (select assa.vendor_id from org_organization_definitions ood, ap_supplier_sites_all assa where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' and ood.operating_unit=assa.org_id)) order by aps.vendor_name, aps.vendor_id 26 SUPPLIER_SITE LOV custom varchar2 60 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 :$column$.supplier_name=aps.vendor_name and :$flex$.operating_unit=haouv.name and haouv.organization_id=assa.org_id and aps.vendor_id=assa.vendor_id and assa.country=ftv.territory_code(+) order by assa.vendor_site_code 27 AMOUNT_AGREED Number number 28 GLOBAL_AGREEMENT 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 29 SUPPLY_AGREEMENT 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 30 QUOTE_WARNING_DELAY Number number 31 HEADER_NOTE_TO_VENDOR Char varchar2 480 32 HEADER_NOTE_TO_RECEIVER Char varchar2 480 33 HEADER_DFF_CONTEXT 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_HEADERS' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 34 HEADER_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_HEADERS', p_context_name => :$column$.header_dff_context, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_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_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE1' 35 HEADER_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_HEADERS', p_context_name => :$column$.header_dff_context, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_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_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE2' 36 HEADER_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_HEADERS', p_context_name => :$column$.header_dff_context, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_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_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE3' 37 HEADER_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_HEADERS', p_context_name => :$column$.header_dff_context, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_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_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE4' 38 HEADER_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_HEADERS', p_context_name => :$column$.header_dff_context, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_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_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE5' 39 HEADER_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_HEADERS', p_context_name => :$column$.header_dff_context, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_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_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE6' 40 HEADER_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_HEADERS', p_context_name => :$column$.header_dff_context, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_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_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE7' 41 HEADER_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_HEADERS', p_context_name => :$column$.header_dff_context, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_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_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE8' 42 HEADER_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_HEADERS', p_context_name => :$column$.header_dff_context, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_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_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE9' 43 HEADER_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_HEADERS', p_context_name => :$column$.header_dff_context, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_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_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE10' 44 HEADER_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_HEADERS', p_context_name => :$column$.header_dff_context, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_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_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE11' 45 HEADER_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_HEADERS', p_context_name => :$column$.header_dff_context, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_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_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE12' 46 HEADER_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_HEADERS', p_context_name => :$column$.header_dff_context, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_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_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE13' 47 HEADER_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_HEADERS', p_context_name => :$column$.header_dff_context, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_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_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE14' 48 HEADER_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_HEADERS', p_context_name => :$column$.header_dff_context, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.header_attribute1, p_attribute2 => :$column$.header_attribute2, p_attribute3 => :$column$.header_attribute3, p_attribute4 => :$column$.header_attribute4, p_attribute5 => :$column$.header_attribute5, p_attribute6 => :$column$.header_attribute6, p_attribute7 => :$column$.header_attribute7, p_attribute8 => :$column$.header_attribute8, p_attribute9 => :$column$.header_attribute9, p_attribute10 => :$column$.header_attribute10, p_attribute11 => :$column$.header_attribute11, p_attribute12 => :$column$.header_attribute12, p_attribute13 => :$column$.header_attribute13, p_attribute14 => :$column$.header_attribute14, p_attribute15 => :$column$.header_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_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE15' 49 HEADER_SHIP_TO_LOCATION LOV custom varchar2 60 Y select hlat.location_code value, hlat.description description from hr_locations_all hla, hr_locations_all_tl hlat where nvl (hla.business_group_id, nvl(hr_general.get_business_group_id, -99) )=nvl (hr_general.get_business_group_id, -99) and hla.location_id=hlat.location_id and hlat.language=userenv('lang') and sysdate<nvl(hla.inactive_date, sysdate + 1) and hla.ship_to_site_flag='Y' order by upper(hlat.location_code) 50 HEADER_BILL_TO_LOCATION LOV custom varchar2 60 Y select hlat.location_code value, hlat.description description from hr_locations_all hla, hr_locations_all_tl hlat where nvl (hla.business_group_id, nvl(hr_general.get_business_group_id, -99) )=nvl (hr_general.get_business_group_id, -99) and hla.location_id=hlat.location_id and hlat.language=userenv('lang') and sysdate<nvl(hla.inactive_date, sysdate + 1) and hla.bill_to_site_flag='Y' order by upper(hlat.location_code) 51 SUPPLIER_CONTACT LOV custom varchar2 Y select distinct pvc.last_name||' '||pvc.first_name value, null description from hr_all_organization_units_vl haouv, ap_suppliers aps, ap_supplier_sites_all assa, po_vendor_contacts pvc where :$column$.supplier_name=aps.vendor_name and :$column$.supplier_site=assa.vendor_site_code and :$flex$.operating_unit=haouv.name and haouv.organization_id=assa.org_id and aps.vendor_id=assa.vendor_id and assa.vendor_site_id=pvc.vendor_site_id and trunc(sysdate)<nvl(pvc.inactive_date,trunc(sysdate+1)) order by value 52 PAYMENT_TERMS LOV custom varchar2 Y select att.name value, att.description from ap_terms_tl att where att.language=userenv('lang') and att.enabled_flag='Y' and trunc(sysdate) between nvl(att.start_date_active,trunc(sysdate)) and nvl(att.end_date_active,trunc(sysdate)) order by att.name 53 FREIGHT_TERMS LOV custom varchar2 Y select plc.lookup_code value, plc.displayed_field description from po_lookup_codes plc where plc.lookup_type='FREIGHT TERMS' order by plc.lookup_code 54 FOB LOV custom varchar2 Y select plc.lookup_code value, plc.displayed_field description from po_lookup_codes plc where plc.lookup_type='FOB' order by plc.lookup_code 55 CARRIER LOV custom varchar2 Y select ofr.freight_code value, null description from hr_all_organization_units_vl haouv, financials_system_params_all fspa, org_freight ofr where haouv.name=:$flex$.operating_unit and fspa.org_id=haouv.organization_id and ofr.organization_id=fspa.inventory_organization_id and nvl(ofr.disable_date,sysdate+1)>sysdate order by ofr.freight_code 56 INTERFACE_LINE_ID Number number Y 57 PO_LINE_ID Number number Y 58 LINE_NUM Number number Y 59 LINE_REFERENCE_NUM Char varchar2 25 60 LINE_TYPE LOV varchar2 25 PO Requisition Line Type DD8B0AA9AE7A4B64E0530100007FB3B0 Y select pltt.line_type_id id, pltt.line_type value, pltt.description from po_line_types_tl pltt where pltt.language=userenv('lang') order by pltt.line_type 61 ITEM LOV custom varchar2 40 Y select msiv.inventory_item_id id, msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv, financials_system_params_all fspa, hr_all_organization_units_vl haouv where haouv.name=:$flex$.operating_unit and haouv.organization_id=fspa.org_id and msiv.purchasing_enabled_flag='Y' and msiv.purchasing_item_flag='Y' and msiv.organization_id=fspa.inventory_organization_id 62 ITEM_REVISION LOV custom varchar2 3 select mir.revision_id id, mir.revision value, mir.revision_label description from mtl_system_items_vl msiv, mtl_item_revisions_b mir, financials_system_params_all fspa, hr_all_organization_units_vl haouv where haouv.name=:$flex$.operating_unit and fspa.org_id=haouv.organization_id and mir.inventory_item_id=msiv.inventory_item_id and msiv.concatenated_segments=:$column$.item and msiv.organization_id=fspa.inventory_organization_id and mir.organization_id=fspa.inventory_organization_id 63 CATEGORY LOV custom varchar2 163 select mcv.category_id id, mcv.category_concat_segs value, mcv.category_concat_segs||'-'||mcv.description description from mtl_categories_v mcv where (:$column$.item is not null and mcv.category_id in ( select mic.category_id from mtl_system_items_vl msiv, mtl_item_categories mic where msiv.organization_id in (select fspa.inventory_organization_id from financials_system_params_all fspa, hr_all_organization_units_vl haouv where fspa.org_id=haouv.organization_id and haouv.name=:$flex$.operating_unit) and msiv.concatenated_segments=:$column$.item and msiv.inventory_item_id=mic.inventory_item_id and msiv.organization_id=mic.organization_id and mic.category_set_id=(select mdcs.category_set_id from mtl_default_category_sets mdcs where mdcs.functional_area_id=2) )) or (:$column$.item is null and nvl(mcv.enabled_flag,'N')='Y' ) 64 DESCRIPTION Char varchar2 240 select msiv.description from mtl_system_items_vl msiv, financials_system_params_all fspa, hr_all_organization_units_vl haouv where haouv.name=:$flex$.operating_unit and fspa.org_id=haouv.organization_id and msiv.concatenated_segments=:$column$.item and msiv.organization_id=fspa.inventory_organization_id 65 UNIT_OF_MEASURE LOV custom varchar2 25 select muomv.unit_of_measure value, null description from mtl_units_of_measure_vl muomv where (:$column$.item is null and trunc(nvl(muomv.disable_date,sysdate+1))>trunc(sysdate) ) or (:$column$.item is not null and muomv.uom_code in( select msiv.primary_uom_code from mtl_system_items_vl msiv, financials_system_params_all fspa, hr_all_organization_units_vl haouv where haouv.name=:$flex$.operating_unit and fspa.org_id=haouv.organization_id and msiv.concatenated_segments=:$column$.item and msiv.organization_id=fspa.inventory_organization_id ) ) 66 PRICE Number number select msiv.list_price_per_unit from mtl_system_items_vl msiv, financials_system_params_all fspa, hr_all_organization_units_vl haouv where haouv.name=:$flex$.operating_unit and fspa.org_id=haouv.organization_id and msiv.concatenated_segments=:$column$.item and msiv.organization_id=fspa.inventory_organization_id 67 ALLOW_PRICE_OVERRIDE 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 68 LIMIT_PRICE Number number Y 69 LINE_QUANTITY Number number 70 SUPPLIER_ITEM Char varchar2 25 71 LINE_NOTE_TO_VENDOR Char varchar2 480 72 LINE_DFF_CONTEXT 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_LINES' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 73 LINE_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_LINES', p_context_name => :$column$.line_dff_context, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_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_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE1' 74 LINE_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_LINES', p_context_name => :$column$.line_dff_context, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_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_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE2' 75 LINE_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_LINES', p_context_name => :$column$.line_dff_context, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_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_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE3' 76 LINE_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_LINES', p_context_name => :$column$.line_dff_context, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_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_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE4' 77 LINE_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_LINES', p_context_name => :$column$.line_dff_context, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_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_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE5' 78 LINE_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_LINES', p_context_name => :$column$.line_dff_context, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_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_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE6' 79 LINE_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_LINES', p_context_name => :$column$.line_dff_context, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_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_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE7' 80 LINE_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_LINES', p_context_name => :$column$.line_dff_context, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_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_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE8' 81 LINE_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_LINES', p_context_name => :$column$.line_dff_context, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_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_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE9' 82 LINE_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_LINES', p_context_name => :$column$.line_dff_context, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_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_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE10' 83 LINE_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_LINES', p_context_name => :$column$.line_dff_context, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_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_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE11' 84 LINE_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_LINES', p_context_name => :$column$.line_dff_context, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_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_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE12' 85 LINE_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_LINES', p_context_name => :$column$.line_dff_context, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_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_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE13' 86 LINE_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_LINES', p_context_name => :$column$.line_dff_context, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_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_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE14' 87 LINE_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_LINES', p_context_name => :$column$.line_dff_context, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.line_attribute1, p_attribute2 => :$column$.line_attribute2, p_attribute3 => :$column$.line_attribute3, p_attribute4 => :$column$.line_attribute4, p_attribute5 => :$column$.line_attribute5, p_attribute6 => :$column$.line_attribute6, p_attribute7 => :$column$.line_attribute7, p_attribute8 => :$column$.line_attribute8, p_attribute9 => :$column$.line_attribute9, p_attribute10 => :$column$.line_attribute10, p_attribute11 => :$column$.line_attribute11, p_attribute12 => :$column$.line_attribute12, p_attribute13 => :$column$.line_attribute13, p_attribute14 => :$column$.line_attribute14, p_attribute15 => :$column$.line_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_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE15' 88 INTERFACE_LINE_LOCATION_ID Number number Y 89 LINE_LOCATION_ID Number number Y 90 SHIPMENT_NUM Number number Y 91 SHIP_QUANTITY Number number 92 BREAK_PRICE Number number :$column$.price 93 BREAK_UNIT_OF_MEASURE LOV custom varchar2 25 Y select muomv.unit_of_measure value, null description from mtl_units_of_measure_vl muomv where trunc(nvl(muomv.disable_date,sysdate+1))>trunc(sysdate) :$column$.unit_of_measure 94 SHIP_TO_ORGANIZATION_CODE LOV custom varchar2 3 Y select mp.organization_id id, mp.organization_code value, mp.organization_code||'-'||haou.name description from hr_organization_information hoi, hr_organization_information hoi2, hr_all_organization_units haou, hr_all_organization_units_tl haout, mtl_parameters mp, financials_system_params_all fspa, hr_all_organization_units_vl haouv where haouv.name=:$flex$.operating_unit and fspa.org_id=haouv.organization_id and mp.organization_id=haou.organization_id and haou.organization_id=haout.organization_id and haout.language=userenv('LANG') and mp.organization_id=hoi2.organization_id and hoi2.org_information_context||''='CLASS' and hoi2.org_information1='INV' and hoi2.org_information2='Y' and mp.organization_id=hoi.organization_id and hoi.org_information_context||''='Accounting Information' and hoi.org_information1=to_char(fspa.set_of_books_id) and sysdate<nvl(haou.date_to, sysdate+1) 95 SHIP_TO_LOCATION_CODE LOV custom varchar2 60 Y select hl.location_id id, hl.location_code value, hl.location_code description, null lov from hr_locations hl, mtl_parameters mp where hl.inventory_organization_id=mp.organization_id and mp.organization_code=:$column$.ship_to_organization_code and hl.ship_to_site_flag='Y' 96 NEED_BY_DATE Date date 97 PROMISED_DATE Date date 98 RECEIPT_ROUTING LOV custom varchar2 80 Y select rrh.routing_header_id id, rrh.routing_name value, null description from rcv_routing_headers rrh where rrh.routing_header_id>0 order by rrh.routing_name 99 TAX_CLASSIFICATION_CODE LOV custom varchar2 Y select distinct zicv.lookup_code value, zicv.meaning description from hr_all_organization_units_vl haouv, zx_input_classifications_v zicv where haouv.name=:$flex$.operating_unit and (zicv.org_id is null or zicv.org_id=haouv.organization_id) and zicv.enabled_flag='Y' and trunc(sysdate) between nvl(zicv.start_date_active,trunc(sysdate)) and nvl(zicv.end_date_active,trunc(sysdate)) order by value 100 MATCH_APPROVAL_LEVEL LOV custom varchar2 Y select '2-Way' value, 'Purchase order and invoice quantities must match' description from dual union all select '3-Way' value, 'Purchase order, receipt, and invoice quantities must match' description from dual union all select '4-Way' value, 'Purchase order, receipt, inspection, and invoice quantities must match' description from dual 101 PRICE_BREAK_START_DATE Date date 102 PRICE_BREAK_END_DATE Date date 103 LINE_LOCATION_DFF_CONTEXT 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_LINE_LOCATIONS' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 104 LINE_LOCATION_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_LINE_LOCATIONS', p_context_name => :$column$.line_location_dff_context, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.line_location_attribute1, p_attribute2 => :$column$.line_location_attribute2, p_attribute3 => :$column$.line_location_attribute3, p_attribute4 => :$column$.line_location_attribute4, p_attribute5 => :$column$.line_location_attribute5, p_attribute6 => :$column$.line_location_attribute6, p_attribute7 => :$column$.line_location_attribute7, p_attribute8 => :$column$.line_location_attribute8, p_attribute9 => :$column$.line_location_attribute9, p_attribute10 => :$column$.line_location_attribute10, p_attribute11 => :$column$.line_location_attribute11, p_attribute12 => :$column$.line_location_attribute12, p_attribute13 => :$column$.line_location_attribute13, p_attribute14 => :$column$.line_location_attribute14, p_attribute15 => :$column$.line_location_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_LINE_LOCATIONS' and fdfcuv.application_column_name = 'ATTRIBUTE1' 105 LINE_LOCATION_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_LINE_LOCATIONS', p_context_name => :$column$.line_location_dff_context, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.line_location_attribute1, p_attribute2 => :$column$.line_location_attribute2, p_attribute3 => :$column$.line_location_attribute3, p_attribute4 => :$column$.line_location_attribute4, p_attribute5 => :$column$.line_location_attribute5, p_attribute6 => :$column$.line_location_attribute6, p_attribute7 => :$column$.line_location_attribute7, p_attribute8 => :$column$.line_location_attribute8, p_attribute9 => :$column$.line_location_attribute9, p_attribute10 => :$column$.line_location_attribute10, p_attribute11 => :$column$.line_location_attribute11, p_attribute12 => :$column$.line_location_attribute12, p_attribute13 => :$column$.line_location_attribute13, p_attribute14 => :$column$.line_location_attribute14, p_attribute15 => :$column$.line_location_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_LINE_LOCATIONS' and fdfcuv.application_column_name = 'ATTRIBUTE2' 106 LINE_LOCATION_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_LINE_LOCATIONS', p_context_name => :$column$.line_location_dff_context, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.line_location_attribute1, p_attribute2 => :$column$.line_location_attribute2, p_attribute3 => :$column$.line_location_attribute3, p_attribute4 => :$column$.line_location_attribute4, p_attribute5 => :$column$.line_location_attribute5, p_attribute6 => :$column$.line_location_attribute6, p_attribute7 => :$column$.line_location_attribute7, p_attribute8 => :$column$.line_location_attribute8, p_attribute9 => :$column$.line_location_attribute9, p_attribute10 => :$column$.line_location_attribute10, p_attribute11 => :$column$.line_location_attribute11, p_attribute12 => :$column$.line_location_attribute12, p_attribute13 => :$column$.line_location_attribute13, p_attribute14 => :$column$.line_location_attribute14, p_attribute15 => :$column$.line_location_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_LINE_LOCATIONS' and fdfcuv.application_column_name = 'ATTRIBUTE3' 107 LINE_LOCATION_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_LINE_LOCATIONS', p_context_name => :$column$.line_location_dff_context, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.line_location_attribute1, p_attribute2 => :$column$.line_location_attribute2, p_attribute3 => :$column$.line_location_attribute3, p_attribute4 => :$column$.line_location_attribute4, p_attribute5 => :$column$.line_location_attribute5, p_attribute6 => :$column$.line_location_attribute6, p_attribute7 => :$column$.line_location_attribute7, p_attribute8 => :$column$.line_location_attribute8, p_attribute9 => :$column$.line_location_attribute9, p_attribute10 => :$column$.line_location_attribute10, p_attribute11 => :$column$.line_location_attribute11, p_attribute12 => :$column$.line_location_attribute12, p_attribute13 => :$column$.line_location_attribute13, p_attribute14 => :$column$.line_location_attribute14, p_attribute15 => :$column$.line_location_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_LINE_LOCATIONS' and fdfcuv.application_column_name = 'ATTRIBUTE4' 108 LINE_LOCATION_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_LINE_LOCATIONS', p_context_name => :$column$.line_location_dff_context, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.line_location_attribute1, p_attribute2 => :$column$.line_location_attribute2, p_attribute3 => :$column$.line_location_attribute3, p_attribute4 => :$column$.line_location_attribute4, p_attribute5 => :$column$.line_location_attribute5, p_attribute6 => :$column$.line_location_attribute6, p_attribute7 => :$column$.line_location_attribute7, p_attribute8 => :$column$.line_location_attribute8, p_attribute9 => :$column$.line_location_attribute9, p_attribute10 => :$column$.line_location_attribute10, p_attribute11 => :$column$.line_location_attribute11, p_attribute12 => :$column$.line_location_attribute12, p_attribute13 => :$column$.line_location_attribute13, p_attribute14 => :$column$.line_location_attribute14, p_attribute15 => :$column$.line_location_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_LINE_LOCATIONS' and fdfcuv.application_column_name = 'ATTRIBUTE5' 109 LINE_LOCATION_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_LINE_LOCATIONS', p_context_name => :$column$.line_location_dff_context, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.line_location_attribute1, p_attribute2 => :$column$.line_location_attribute2, p_attribute3 => :$column$.line_location_attribute3, p_attribute4 => :$column$.line_location_attribute4, p_attribute5 => :$column$.line_location_attribute5, p_attribute6 => :$column$.line_location_attribute6, p_attribute7 => :$column$.line_location_attribute7, p_attribute8 => :$column$.line_location_attribute8, p_attribute9 => :$column$.line_location_attribute9, p_attribute10 => :$column$.line_location_attribute10, p_attribute11 => :$column$.line_location_attribute11, p_attribute12 => :$column$.line_location_attribute12, p_attribute13 => :$column$.line_location_attribute13, p_attribute14 => :$column$.line_location_attribute14, p_attribute15 => :$column$.line_location_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_LINE_LOCATIONS' and fdfcuv.application_column_name = 'ATTRIBUTE6' 110 LINE_LOCATION_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_LINE_LOCATIONS', p_context_name => :$column$.line_location_dff_context, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.line_location_attribute1, p_attribute2 => :$column$.line_location_attribute2, p_attribute3 => :$column$.line_location_attribute3, p_attribute4 => :$column$.line_location_attribute4, p_attribute5 => :$column$.line_location_attribute5, p_attribute6 => :$column$.line_location_attribute6, p_attribute7 => :$column$.line_location_attribute7, p_attribute8 => :$column$.line_location_attribute8, p_attribute9 => :$column$.line_location_attribute9, p_attribute10 => :$column$.line_location_attribute10, p_attribute11 => :$column$.line_location_attribute11, p_attribute12 => :$column$.line_location_attribute12, p_attribute13 => :$column$.line_location_attribute13, p_attribute14 => :$column$.line_location_attribute14, p_attribute15 => :$column$.line_location_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_LINE_LOCATIONS' and fdfcuv.application_column_name = 'ATTRIBUTE7' 111 LINE_LOCATION_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_LINE_LOCATIONS', p_context_name => :$column$.line_location_dff_context, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.line_location_attribute1, p_attribute2 => :$column$.line_location_attribute2, p_attribute3 => :$column$.line_location_attribute3, p_attribute4 => :$column$.line_location_attribute4, p_attribute5 => :$column$.line_location_attribute5, p_attribute6 => :$column$.line_location_attribute6, p_attribute7 => :$column$.line_location_attribute7, p_attribute8 => :$column$.line_location_attribute8, p_attribute9 => :$column$.line_location_attribute9, p_attribute10 => :$column$.line_location_attribute10, p_attribute11 => :$column$.line_location_attribute11, p_attribute12 => :$column$.line_location_attribute12, p_attribute13 => :$column$.line_location_attribute13, p_attribute14 => :$column$.line_location_attribute14, p_attribute15 => :$column$.line_location_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_LINE_LOCATIONS' and fdfcuv.application_column_name = 'ATTRIBUTE8' 112 LINE_LOCATION_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_LINE_LOCATIONS', p_context_name => :$column$.line_location_dff_context, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.line_location_attribute1, p_attribute2 => :$column$.line_location_attribute2, p_attribute3 => :$column$.line_location_attribute3, p_attribute4 => :$column$.line_location_attribute4, p_attribute5 => :$column$.line_location_attribute5, p_attribute6 => :$column$.line_location_attribute6, p_attribute7 => :$column$.line_location_attribute7, p_attribute8 => :$column$.line_location_attribute8, p_attribute9 => :$column$.line_location_attribute9, p_attribute10 => :$column$.line_location_attribute10, p_attribute11 => :$column$.line_location_attribute11, p_attribute12 => :$column$.line_location_attribute12, p_attribute13 => :$column$.line_location_attribute13, p_attribute14 => :$column$.line_location_attribute14, p_attribute15 => :$column$.line_location_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_LINE_LOCATIONS' and fdfcuv.application_column_name = 'ATTRIBUTE9' 113 LINE_LOCATION_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_LINE_LOCATIONS', p_context_name => :$column$.line_location_dff_context, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.line_location_attribute1, p_attribute2 => :$column$.line_location_attribute2, p_attribute3 => :$column$.line_location_attribute3, p_attribute4 => :$column$.line_location_attribute4, p_attribute5 => :$column$.line_location_attribute5, p_attribute6 => :$column$.line_location_attribute6, p_attribute7 => :$column$.line_location_attribute7, p_attribute8 => :$column$.line_location_attribute8, p_attribute9 => :$column$.line_location_attribute9, p_attribute10 => :$column$.line_location_attribute10, p_attribute11 => :$column$.line_location_attribute11, p_attribute12 => :$column$.line_location_attribute12, p_attribute13 => :$column$.line_location_attribute13, p_attribute14 => :$column$.line_location_attribute14, p_attribute15 => :$column$.line_location_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_LINE_LOCATIONS' and fdfcuv.application_column_name = 'ATTRIBUTE10' 114 LINE_LOCATION_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_LINE_LOCATIONS', p_context_name => :$column$.line_location_dff_context, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.line_location_attribute1, p_attribute2 => :$column$.line_location_attribute2, p_attribute3 => :$column$.line_location_attribute3, p_attribute4 => :$column$.line_location_attribute4, p_attribute5 => :$column$.line_location_attribute5, p_attribute6 => :$column$.line_location_attribute6, p_attribute7 => :$column$.line_location_attribute7, p_attribute8 => :$column$.line_location_attribute8, p_attribute9 => :$column$.line_location_attribute9, p_attribute10 => :$column$.line_location_attribute10, p_attribute11 => :$column$.line_location_attribute11, p_attribute12 => :$column$.line_location_attribute12, p_attribute13 => :$column$.line_location_attribute13, p_attribute14 => :$column$.line_location_attribute14, p_attribute15 => :$column$.line_location_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_LINE_LOCATIONS' and fdfcuv.application_column_name = 'ATTRIBUTE11' 115 LINE_LOCATION_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_LINE_LOCATIONS', p_context_name => :$column$.line_location_dff_context, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.line_location_attribute1, p_attribute2 => :$column$.line_location_attribute2, p_attribute3 => :$column$.line_location_attribute3, p_attribute4 => :$column$.line_location_attribute4, p_attribute5 => :$column$.line_location_attribute5, p_attribute6 => :$column$.line_location_attribute6, p_attribute7 => :$column$.line_location_attribute7, p_attribute8 => :$column$.line_location_attribute8, p_attribute9 => :$column$.line_location_attribute9, p_attribute10 => :$column$.line_location_attribute10, p_attribute11 => :$column$.line_location_attribute11, p_attribute12 => :$column$.line_location_attribute12, p_attribute13 => :$column$.line_location_attribute13, p_attribute14 => :$column$.line_location_attribute14, p_attribute15 => :$column$.line_location_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_LINE_LOCATIONS' and fdfcuv.application_column_name = 'ATTRIBUTE12' 116 LINE_LOCATION_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_LINE_LOCATIONS', p_context_name => :$column$.line_location_dff_context, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.line_location_attribute1, p_attribute2 => :$column$.line_location_attribute2, p_attribute3 => :$column$.line_location_attribute3, p_attribute4 => :$column$.line_location_attribute4, p_attribute5 => :$column$.line_location_attribute5, p_attribute6 => :$column$.line_location_attribute6, p_attribute7 => :$column$.line_location_attribute7, p_attribute8 => :$column$.line_location_attribute8, p_attribute9 => :$column$.line_location_attribute9, p_attribute10 => :$column$.line_location_attribute10, p_attribute11 => :$column$.line_location_attribute11, p_attribute12 => :$column$.line_location_attribute12, p_attribute13 => :$column$.line_location_attribute13, p_attribute14 => :$column$.line_location_attribute14, p_attribute15 => :$column$.line_location_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_LINE_LOCATIONS' and fdfcuv.application_column_name = 'ATTRIBUTE13' 117 LINE_LOCATION_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_LINE_LOCATIONS', p_context_name => :$column$.line_location_dff_context, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.line_location_attribute1, p_attribute2 => :$column$.line_location_attribute2, p_attribute3 => :$column$.line_location_attribute3, p_attribute4 => :$column$.line_location_attribute4, p_attribute5 => :$column$.line_location_attribute5, p_attribute6 => :$column$.line_location_attribute6, p_attribute7 => :$column$.line_location_attribute7, p_attribute8 => :$column$.line_location_attribute8, p_attribute9 => :$column$.line_location_attribute9, p_attribute10 => :$column$.line_location_attribute10, p_attribute11 => :$column$.line_location_attribute11, p_attribute12 => :$column$.line_location_attribute12, p_attribute13 => :$column$.line_location_attribute13, p_attribute14 => :$column$.line_location_attribute14, p_attribute15 => :$column$.line_location_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_LINE_LOCATIONS' and fdfcuv.application_column_name = 'ATTRIBUTE14' 118 LINE_LOCATION_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_LINE_LOCATIONS', p_context_name => :$column$.line_location_dff_context, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.line_location_attribute1, p_attribute2 => :$column$.line_location_attribute2, p_attribute3 => :$column$.line_location_attribute3, p_attribute4 => :$column$.line_location_attribute4, p_attribute5 => :$column$.line_location_attribute5, p_attribute6 => :$column$.line_location_attribute6, p_attribute7 => :$column$.line_location_attribute7, p_attribute8 => :$column$.line_location_attribute8, p_attribute9 => :$column$.line_location_attribute9, p_attribute10 => :$column$.line_location_attribute10, p_attribute11 => :$column$.line_location_attribute11, p_attribute12 => :$column$.line_location_attribute12, p_attribute13 => :$column$.line_location_attribute13, p_attribute14 => :$column$.line_location_attribute14, p_attribute15 => :$column$.line_location_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_LINE_LOCATIONS' and fdfcuv.application_column_name = 'ATTRIBUTE15' 119 INTERFACE_DISTRIBUTION_ID Number number Y 120 PO_DISTRIBUTION_ID Number number Y 121 DISTRIBUTION_NUM Number number Y 122 QUANTITY_ORDERED Number number 123 CHARGE_ACCOUNT LOV custom varchar2 311 Y Y select gcck.concatenated_segments value, xxen_util.segments_description(gcck.code_combination_id) || ' (' || flvv.description || ')' description from gl_code_combinations_kfv gcck, gl_ledgers gl, hr_operating_units hou, fnd_lookup_values_vl flvv where gcck.chart_of_accounts_id=gl.chart_of_accounts_id and gl.ledger_id=hou.set_of_books_id and hou.name=:$flex$.operating_unit and gcck.enabled_flag = 'Y' and gcck.summary_flag = 'N' and trunc(sysdate) between nvl(gcck.start_date_active,trunc(sysdate)) and nvl(gcck.end_date_active,trunc(sysdate)) and flvv.lookup_type = 'ACCOUNT TYPE' and flvv.view_application_id = 101 and flvv.lookup_code = gcck.gl_account_type order by value select gcck.code_combination_id id, gcck.concatenated_segments value from hr_operating_units hou, gl_ledgers gl, gl_code_combinations_kfv gcck where hou.name=:$flex$.operating_unit and hou.set_of_books_id=gl.ledger_id and gl.chart_of_accounts_id=gcck.chart_of_accounts_id and gcck.enabled_flag= 'Y' and gcck.summary_flag='N' and trunc(sysdate) between nvl(gcck.start_date_active,trunc(sysdate)) and nvl(gcck.end_date_active,trunc(sysdate)) 124 REQUESTOR LOV varchar2 240 PO Requestor (active) DD37AB84248C178DE0530100007FABF1 Y Y select pwcx.person_id id, pwcx.full_name value, pwcx.employee_number description from per_workforce_current_x pwcx where pwcx.assignment_type in ('E',decode(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'Y','C','E')) order by pwcx.full_name 125 DESTINATION_TYPE LOV custom varchar2 Y select plc.lookup_code id, plc.displayed_field value, null description from po_lookup_codes plc where plc.lookup_type='DESTINATION TYPE' order by plc.displayed_field 126 DELIVER_TO_LOCATION LOV custom varchar2 Y select hl.location_id id, hl.location_code value, hl.location_code description from hr_locations hl, mtl_parameters mp where hl.inventory_organization_id=mp.organization_id and mp.organization_code=:$column$.ship_to_organization_code and hl.ship_to_site_flag='Y' order by hl.location_code 127 WIP_JOB LOV custom varchar2 Y select we.wip_entity_name value, xxen_util.meaning(wdj.status_type,'WIP_JOB_STATUS',700) description from mtl_parameters mp, wip_discrete_jobs wdj, wip_entities we where mp.organization_code=:$column$.ship_to_organization_code and wdj.organization_id=mp.organization_id and wdj.status_type in (1,3) and wdj.wip_entity_id=we.wip_entity_id and (:$column$.destination_type is null or :$column$.destination_type=(select plc.displayed_field from po_lookup_codes plc where plc.lookup_type='DESTINATION TYPE' and plc.lookup_code='SHOP FLOOR')) order by we.wip_entity_name 128 WIP_OPERATION_SEQ LOV custom number Y select to_char(wo.operation_seq_num) value, bd.department_code description from mtl_parameters mp, wip_entities we, wip_operations wo, bom_departments bd where mp.organization_code=:$column$.ship_to_organization_code and we.organization_id=mp.organization_id and we.wip_entity_name=:$column$.wip_job and wo.wip_entity_id=we.wip_entity_id and wo.organization_id=we.organization_id and wo.department_id=bd.department_id(+) order by wo.operation_seq_num 129 WIP_RESOURCE_SEQ LOV custom number Y select to_char(wor.resource_seq_num) value, br.resource_code description from mtl_parameters mp, wip_entities we, wip_operation_resources wor, bom_resources br where mp.organization_code=:$column$.ship_to_organization_code and we.organization_id=mp.organization_id and we.wip_entity_name=:$column$.wip_job and wor.wip_entity_id=we.wip_entity_id and wor.organization_id=we.organization_id and wor.operation_seq_num=to_number(:$column$.wip_operation_seq) and wor.resource_id=br.resource_id order by wor.resource_seq_num 130 PROJECT_NUMBER LOV varchar2 25 PO Project DEC9ED99A17F5BE8E0530100007FC601 Y select ppev.project_id id, ppev.project_number value, ppev.project_name description from pa_projects_expend_v ppev select ppev.project_id id, ppev.project_number value from pa_projects_expend_v ppev 131 TASK_NUMBER LOV varchar2 25 PO Project Task DEC9ED99A1805BE8E0530100007FC601 Y select task_id id, ppa.task_number value, ppa.task_description description from pa_tasks_all_expend_v ppa, pa_projects_expend_v ppe, hr_all_organization_units_vl haouv where ppe.project_number=:$column$.project_number and ppa.project_id=ppe.project_id and ppa.expenditure_org_id=haouv.organization_id and haouv.name=:$flex$.operating_unit select ppa.task_id id, ppa.task_number value from pa_tasks_all_expend_v ppa, pa_projects_expend_v ppe, hr_all_organization_units_vl haouv where ppe.project_number=:$column$.project_number and ppa.project_id=ppe.project_id and ppa.expenditure_org_id=haouv.organization_id and haouv.name=:$flex$.operating_unit 132 EXPENDITURE_TYPE LOV custom varchar2 30 Y select petev.expenditure_type value, petev.description from pa_projects_expend_v ppev, pa_expenditure_types_expend_v petev where ppev.project_number=:$column$.project_number and ppev.project_id=petev.project_id and petev.system_linkage_function='VI' and trunc(sysdate) between nvl(petev.expnd_typ_start_date_active, trunc(sysdate)) and nvl(petev.expnd_typ_end_date_active, trunc(sysdate)) and trunc(sysdate) between nvl(petev.sys_link_start_date_active, trunc(sysdate)) and nvl(petev.sys_link_end_date_active, trunc(sysdate)) union select petev.expenditure_type value, petev.description from pa_expenditure_types_expend_v petev where petev.system_linkage_function='VI' and petev.project_id is null and trunc(sysdate) between nvl(petev.expnd_typ_start_date_active, trunc(sysdate)) and nvl(petev.expnd_typ_end_date_active, trunc(sysdate)) and trunc(sysdate) between nvl(petev.sys_link_start_date_active, trunc(sysdate)) and nvl(petev.sys_link_end_date_active, trunc(sysdate)) 133 EXPENDITURE_DATE Date date 134 EXPENDITURE_ORG LOV custom varchar2 240 Y select poaev.name value, null description from pa_organizations_expend_v poaev where poaev.active_flag='Y' and nvl(:$column$.expenditure_date, trunc(sysdate)) between trunc(poaev.date_from) and nvl(trunc(poaev.date_to), nvl(:$column$.expenditure_date, trunc(sysdate))) order by poaev.name select poaev.organization_id id, poaev.name value from pa_organizations_expend_v poaev 135 DISTRIBUTION_DFF_CONTEXT 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_DISTRIBUTIONS' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 136 DISTRIBUTION_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_DISTRIBUTIONS', p_context_name => :$column$.distribution_dff_context, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.distribution_attribute1, p_attribute2 => :$column$.distribution_attribute2, p_attribute3 => :$column$.distribution_attribute3, p_attribute4 => :$column$.distribution_attribute4, p_attribute5 => :$column$.distribution_attribute5, p_attribute6 => :$column$.distribution_attribute6, p_attribute7 => :$column$.distribution_attribute7, p_attribute8 => :$column$.distribution_attribute8, p_attribute9 => :$column$.distribution_attribute9, p_attribute10 => :$column$.distribution_attribute10, p_attribute11 => :$column$.distribution_attribute11, p_attribute12 => :$column$.distribution_attribute12, p_attribute13 => :$column$.distribution_attribute13, p_attribute14 => :$column$.distribution_attribute14, p_attribute15 => :$column$.distribution_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_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE1' 137 DISTRIBUTION_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_DISTRIBUTIONS', p_context_name => :$column$.distribution_dff_context, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.distribution_attribute1, p_attribute2 => :$column$.distribution_attribute2, p_attribute3 => :$column$.distribution_attribute3, p_attribute4 => :$column$.distribution_attribute4, p_attribute5 => :$column$.distribution_attribute5, p_attribute6 => :$column$.distribution_attribute6, p_attribute7 => :$column$.distribution_attribute7, p_attribute8 => :$column$.distribution_attribute8, p_attribute9 => :$column$.distribution_attribute9, p_attribute10 => :$column$.distribution_attribute10, p_attribute11 => :$column$.distribution_attribute11, p_attribute12 => :$column$.distribution_attribute12, p_attribute13 => :$column$.distribution_attribute13, p_attribute14 => :$column$.distribution_attribute14, p_attribute15 => :$column$.distribution_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_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE2' 138 DISTRIBUTION_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_DISTRIBUTIONS', p_context_name => :$column$.distribution_dff_context, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.distribution_attribute1, p_attribute2 => :$column$.distribution_attribute2, p_attribute3 => :$column$.distribution_attribute3, p_attribute4 => :$column$.distribution_attribute4, p_attribute5 => :$column$.distribution_attribute5, p_attribute6 => :$column$.distribution_attribute6, p_attribute7 => :$column$.distribution_attribute7, p_attribute8 => :$column$.distribution_attribute8, p_attribute9 => :$column$.distribution_attribute9, p_attribute10 => :$column$.distribution_attribute10, p_attribute11 => :$column$.distribution_attribute11, p_attribute12 => :$column$.distribution_attribute12, p_attribute13 => :$column$.distribution_attribute13, p_attribute14 => :$column$.distribution_attribute14, p_attribute15 => :$column$.distribution_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_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE3' 139 DISTRIBUTION_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_DISTRIBUTIONS', p_context_name => :$column$.distribution_dff_context, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.distribution_attribute1, p_attribute2 => :$column$.distribution_attribute2, p_attribute3 => :$column$.distribution_attribute3, p_attribute4 => :$column$.distribution_attribute4, p_attribute5 => :$column$.distribution_attribute5, p_attribute6 => :$column$.distribution_attribute6, p_attribute7 => :$column$.distribution_attribute7, p_attribute8 => :$column$.distribution_attribute8, p_attribute9 => :$column$.distribution_attribute9, p_attribute10 => :$column$.distribution_attribute10, p_attribute11 => :$column$.distribution_attribute11, p_attribute12 => :$column$.distribution_attribute12, p_attribute13 => :$column$.distribution_attribute13, p_attribute14 => :$column$.distribution_attribute14, p_attribute15 => :$column$.distribution_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_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE4' 140 DISTRIBUTION_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_DISTRIBUTIONS', p_context_name => :$column$.distribution_dff_context, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.distribution_attribute1, p_attribute2 => :$column$.distribution_attribute2, p_attribute3 => :$column$.distribution_attribute3, p_attribute4 => :$column$.distribution_attribute4, p_attribute5 => :$column$.distribution_attribute5, p_attribute6 => :$column$.distribution_attribute6, p_attribute7 => :$column$.distribution_attribute7, p_attribute8 => :$column$.distribution_attribute8, p_attribute9 => :$column$.distribution_attribute9, p_attribute10 => :$column$.distribution_attribute10, p_attribute11 => :$column$.distribution_attribute11, p_attribute12 => :$column$.distribution_attribute12, p_attribute13 => :$column$.distribution_attribute13, p_attribute14 => :$column$.distribution_attribute14, p_attribute15 => :$column$.distribution_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_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE5' 141 DISTRIBUTION_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_DISTRIBUTIONS', p_context_name => :$column$.distribution_dff_context, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.distribution_attribute1, p_attribute2 => :$column$.distribution_attribute2, p_attribute3 => :$column$.distribution_attribute3, p_attribute4 => :$column$.distribution_attribute4, p_attribute5 => :$column$.distribution_attribute5, p_attribute6 => :$column$.distribution_attribute6, p_attribute7 => :$column$.distribution_attribute7, p_attribute8 => :$column$.distribution_attribute8, p_attribute9 => :$column$.distribution_attribute9, p_attribute10 => :$column$.distribution_attribute10, p_attribute11 => :$column$.distribution_attribute11, p_attribute12 => :$column$.distribution_attribute12, p_attribute13 => :$column$.distribution_attribute13, p_attribute14 => :$column$.distribution_attribute14, p_attribute15 => :$column$.distribution_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_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE6' 142 DISTRIBUTION_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_DISTRIBUTIONS', p_context_name => :$column$.distribution_dff_context, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.distribution_attribute1, p_attribute2 => :$column$.distribution_attribute2, p_attribute3 => :$column$.distribution_attribute3, p_attribute4 => :$column$.distribution_attribute4, p_attribute5 => :$column$.distribution_attribute5, p_attribute6 => :$column$.distribution_attribute6, p_attribute7 => :$column$.distribution_attribute7, p_attribute8 => :$column$.distribution_attribute8, p_attribute9 => :$column$.distribution_attribute9, p_attribute10 => :$column$.distribution_attribute10, p_attribute11 => :$column$.distribution_attribute11, p_attribute12 => :$column$.distribution_attribute12, p_attribute13 => :$column$.distribution_attribute13, p_attribute14 => :$column$.distribution_attribute14, p_attribute15 => :$column$.distribution_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_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE7' 143 DISTRIBUTION_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_DISTRIBUTIONS', p_context_name => :$column$.distribution_dff_context, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.distribution_attribute1, p_attribute2 => :$column$.distribution_attribute2, p_attribute3 => :$column$.distribution_attribute3, p_attribute4 => :$column$.distribution_attribute4, p_attribute5 => :$column$.distribution_attribute5, p_attribute6 => :$column$.distribution_attribute6, p_attribute7 => :$column$.distribution_attribute7, p_attribute8 => :$column$.distribution_attribute8, p_attribute9 => :$column$.distribution_attribute9, p_attribute10 => :$column$.distribution_attribute10, p_attribute11 => :$column$.distribution_attribute11, p_attribute12 => :$column$.distribution_attribute12, p_attribute13 => :$column$.distribution_attribute13, p_attribute14 => :$column$.distribution_attribute14, p_attribute15 => :$column$.distribution_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_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE8' 144 DISTRIBUTION_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_DISTRIBUTIONS', p_context_name => :$column$.distribution_dff_context, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.distribution_attribute1, p_attribute2 => :$column$.distribution_attribute2, p_attribute3 => :$column$.distribution_attribute3, p_attribute4 => :$column$.distribution_attribute4, p_attribute5 => :$column$.distribution_attribute5, p_attribute6 => :$column$.distribution_attribute6, p_attribute7 => :$column$.distribution_attribute7, p_attribute8 => :$column$.distribution_attribute8, p_attribute9 => :$column$.distribution_attribute9, p_attribute10 => :$column$.distribution_attribute10, p_attribute11 => :$column$.distribution_attribute11, p_attribute12 => :$column$.distribution_attribute12, p_attribute13 => :$column$.distribution_attribute13, p_attribute14 => :$column$.distribution_attribute14, p_attribute15 => :$column$.distribution_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_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE9' 145 DISTRIBUTION_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_DISTRIBUTIONS', p_context_name => :$column$.distribution_dff_context, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.distribution_attribute1, p_attribute2 => :$column$.distribution_attribute2, p_attribute3 => :$column$.distribution_attribute3, p_attribute4 => :$column$.distribution_attribute4, p_attribute5 => :$column$.distribution_attribute5, p_attribute6 => :$column$.distribution_attribute6, p_attribute7 => :$column$.distribution_attribute7, p_attribute8 => :$column$.distribution_attribute8, p_attribute9 => :$column$.distribution_attribute9, p_attribute10 => :$column$.distribution_attribute10, p_attribute11 => :$column$.distribution_attribute11, p_attribute12 => :$column$.distribution_attribute12, p_attribute13 => :$column$.distribution_attribute13, p_attribute14 => :$column$.distribution_attribute14, p_attribute15 => :$column$.distribution_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_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE10' 146 DISTRIBUTION_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_DISTRIBUTIONS', p_context_name => :$column$.distribution_dff_context, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.distribution_attribute1, p_attribute2 => :$column$.distribution_attribute2, p_attribute3 => :$column$.distribution_attribute3, p_attribute4 => :$column$.distribution_attribute4, p_attribute5 => :$column$.distribution_attribute5, p_attribute6 => :$column$.distribution_attribute6, p_attribute7 => :$column$.distribution_attribute7, p_attribute8 => :$column$.distribution_attribute8, p_attribute9 => :$column$.distribution_attribute9, p_attribute10 => :$column$.distribution_attribute10, p_attribute11 => :$column$.distribution_attribute11, p_attribute12 => :$column$.distribution_attribute12, p_attribute13 => :$column$.distribution_attribute13, p_attribute14 => :$column$.distribution_attribute14, p_attribute15 => :$column$.distribution_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_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE11' 147 DISTRIBUTION_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_DISTRIBUTIONS', p_context_name => :$column$.distribution_dff_context, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.distribution_attribute1, p_attribute2 => :$column$.distribution_attribute2, p_attribute3 => :$column$.distribution_attribute3, p_attribute4 => :$column$.distribution_attribute4, p_attribute5 => :$column$.distribution_attribute5, p_attribute6 => :$column$.distribution_attribute6, p_attribute7 => :$column$.distribution_attribute7, p_attribute8 => :$column$.distribution_attribute8, p_attribute9 => :$column$.distribution_attribute9, p_attribute10 => :$column$.distribution_attribute10, p_attribute11 => :$column$.distribution_attribute11, p_attribute12 => :$column$.distribution_attribute12, p_attribute13 => :$column$.distribution_attribute13, p_attribute14 => :$column$.distribution_attribute14, p_attribute15 => :$column$.distribution_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_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE12' 148 DISTRIBUTION_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_DISTRIBUTIONS', p_context_name => :$column$.distribution_dff_context, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.distribution_attribute1, p_attribute2 => :$column$.distribution_attribute2, p_attribute3 => :$column$.distribution_attribute3, p_attribute4 => :$column$.distribution_attribute4, p_attribute5 => :$column$.distribution_attribute5, p_attribute6 => :$column$.distribution_attribute6, p_attribute7 => :$column$.distribution_attribute7, p_attribute8 => :$column$.distribution_attribute8, p_attribute9 => :$column$.distribution_attribute9, p_attribute10 => :$column$.distribution_attribute10, p_attribute11 => :$column$.distribution_attribute11, p_attribute12 => :$column$.distribution_attribute12, p_attribute13 => :$column$.distribution_attribute13, p_attribute14 => :$column$.distribution_attribute14, p_attribute15 => :$column$.distribution_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_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE13' 149 DISTRIBUTION_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_DISTRIBUTIONS', p_context_name => :$column$.distribution_dff_context, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.distribution_attribute1, p_attribute2 => :$column$.distribution_attribute2, p_attribute3 => :$column$.distribution_attribute3, p_attribute4 => :$column$.distribution_attribute4, p_attribute5 => :$column$.distribution_attribute5, p_attribute6 => :$column$.distribution_attribute6, p_attribute7 => :$column$.distribution_attribute7, p_attribute8 => :$column$.distribution_attribute8, p_attribute9 => :$column$.distribution_attribute9, p_attribute10 => :$column$.distribution_attribute10, p_attribute11 => :$column$.distribution_attribute11, p_attribute12 => :$column$.distribution_attribute12, p_attribute13 => :$column$.distribution_attribute13, p_attribute14 => :$column$.distribution_attribute14, p_attribute15 => :$column$.distribution_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_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE14' 150 DISTRIBUTION_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_DISTRIBUTIONS', p_context_name => :$column$.distribution_dff_context, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.distribution_attribute1, p_attribute2 => :$column$.distribution_attribute2, p_attribute3 => :$column$.distribution_attribute3, p_attribute4 => :$column$.distribution_attribute4, p_attribute5 => :$column$.distribution_attribute5, p_attribute6 => :$column$.distribution_attribute6, p_attribute7 => :$column$.distribution_attribute7, p_attribute8 => :$column$.distribution_attribute8, p_attribute9 => :$column$.distribution_attribute9, p_attribute10 => :$column$.distribution_attribute10, p_attribute11 => :$column$.distribution_attribute11, p_attribute12 => :$column$.distribution_attribute12, p_attribute13 => :$column$.distribution_attribute13, p_attribute14 => :$column$.distribution_attribute14, p_attribute15 => :$column$.distribution_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_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE15' 151 APPROVAL_STATUS LOV custom varchar2 Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from po_document_types_all_tl podt, po_document_types_all_b podb, hr_all_organization_units_vl haouv, fnd_flex_value_sets ffvs, fnd_flex_values_vl ffvv where (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') and podb.org_id=haouv.organization_id and podb.org_id=podt.org_id and podb.document_type_code in ('PO','PA','QUOTATION') and podb.document_subtype in ('BLANKET','CONTRACT','STANDARD') and podb.document_type_code=podt.document_type_code and podb.document_subtype=podt.document_subtype and podt.language=userenv ('LANG') and case when podb.document_type_code='QUOTATION' then podb.document_type_code else podb.document_subtype end=:$flex$.document_type and case when podt.document_type_code='QUOTATION' then 'PO_PDOI_CAT_APPROVAL_STATUSES' when podt.document_subtype='BLANKET' then 'PO_PDOI_CAT_APPROVAL_STATUSES' when podt.document_subtype in ('CONTRACT','STANDARD') then 'PO_PDOI_STDPO_APPROVAL_STATUS' end=ffvs.flex_value_set_name and case when podt.document_type_code='QUOTATION' then podt.document_type_code else podt.document_subtype end=nvl(upper(ffvv.parent_flex_value_low),case when podt.document_type_code='QUOTATION' then podt.document_type_code else podt.document_subtype end) and ffvs.flex_value_set_id=ffvv.flex_value_set_id and ffvv.enabled_flag='Y' and trunc(nvl(ffvv.end_date_active,sysdate+1))>trunc(sysdate) APPROVED Y 152 CREATE_OR_UPDATE_ITEMS 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 xxen_util.meaning('N','YES_NO',0) Y 153 GROUP_LINES 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 154 ATTACHMENT_CATEGORY_ LOV custom varchar2 Y select fdcuv.user_name value, null description from fnd_doc_category_usages_vl fdcuv, fnd_attachment_functions af, fnd_document_categories fdc where fdcuv.attachment_function_id=af.attachment_function_id and af.function_name='PO_POXPOEPO' and fdc.category_id=fdcuv.category_id and nvl(fdc.start_date_active,sysdate-1)<=sysdate and nvl(fdc.start_date_active,sysdate+1)>sysdate order by value Required for adding an attachment 155 ATTACHMENT_TITLE_ Char varchar2 156 ATTACHMENT_DESCRIPTION_ Char varchar2 157 ATTACHMENT_TYPE_ LOV custom varchar2 Y select user_name value, null description from fnd_document_datatypes_vl where name in ('SHORT_TEXT','FILE','WEB_PAGE') order by value Required for adding an attachment 158 ATTACHMENT_CONTENT_ Char varchar2 If the attachment type is File, double click will open the file explorer and allow the selection of file path, alternatively file path can be entered as free text as well 159 ATTACHMENT_FILE_ID_ Char varchar2 Autopopulated after clicking on Upload Attachments U 1 p_org_id in Number ORG_ID U 2 p_po_number in Char Y PO_NUMBER U 3 p_po_group_code in Char Y GROUP_ U 4 p_document_number in Char Y DOCUMENT_NUMBER U 5 p_revision_number in Char Y REVISION_NUM U 6 p_document_type_code in Char DOCUMENT_TYPE U 7 p_effective_start_date in Date EFFECTIVE_START_DATE U 8 p_effective_end_date in Date EFFECTIVE_END_DATE U 9 p_currency_code in Char CURRENCY_CODE U 10 p_agent_name in Char BUYER U 11 p_vendor_name in Char SUPPLIER_NAME U 12 p_vendor_site_code in Char SUPPLIER_SITE U 13 p_header_ship_to_location in Char HEADER_SHIP_TO_LOCATION U 14 p_header_bill_to_location in Char HEADER_BILL_TO_LOCATION U 15 p_supplier_contact in Char Y SUPPLIER_CONTACT U 16 p_payment_terms in Char Y PAYMENT_TERMS U 17 p_freight_terms in Char Y FREIGHT_TERMS U 18 p_fob in Char Y FOB U 19 p_carrier in Char Y CARRIER U 20 p_header_reference_num in Char HEADER_REFERENCE_NUM U 21 p_comments in Char HEADER_DESCRIPTION U 22 p_amount_agreed in Number AMOUNT_AGREED U 23 p_quote_warning_delay in Number QUOTE_WARNING_DELAY U 24 p_header_note_to_vendor in Char HEADER_NOTE_TO_VENDOR U 25 p_header_note_to_receiver in Char HEADER_NOTE_TO_RECEIVER U 26 p_rate_type in Char RATE_TYPE U 27 p_rate_date in Date RATE_DATE U 28 p_rate in Number RATE U 29 p_global_agreement in Char GLOBAL_AGREEMENT U 30 p_supply_agreement_flag in Char SUPPLY_AGREEMENT U 31 p_creation_date in Date CREATION_DATE U 32 p_header_dff_context in Char HEADER_DFF_CONTEXT U 33 p_header_attribute1 in Char HEADER_ATTRIBUTE1 U 34 p_header_attribute2 in Char HEADER_ATTRIBUTE2 U 35 p_header_attribute3 in Char HEADER_ATTRIBUTE3 U 36 p_header_attribute4 in Char HEADER_ATTRIBUTE4 U 37 p_header_attribute5 in Char HEADER_ATTRIBUTE5 U 38 p_header_attribute6 in Char HEADER_ATTRIBUTE6 U 39 p_header_attribute7 in Char HEADER_ATTRIBUTE7 U 40 p_header_attribute8 in Char HEADER_ATTRIBUTE8 U 41 p_header_attribute9 in Char HEADER_ATTRIBUTE9 U 42 p_header_attribute10 in Char HEADER_ATTRIBUTE10 U 43 p_header_attribute11 in Char HEADER_ATTRIBUTE11 U 44 p_header_attribute12 in Char HEADER_ATTRIBUTE12 U 45 p_header_attribute13 in Char HEADER_ATTRIBUTE13 U 46 p_header_attribute14 in Char HEADER_ATTRIBUTE14 U 47 p_header_attribute15 in Char HEADER_ATTRIBUTE15 U 48 p_line_num in Number LINE_NUM U 49 p_line_reference_num in Char LINE_REFERENCE_NUM U 50 p_shipment_num in Number SHIPMENT_NUM U 51 p_line_type in Char LINE_TYPE value U 52 p_item in Char ITEM value U 53 p_item_revision in Char ITEM_REVISION value U 54 p_item_category in Char CATEGORY value U 55 p_item_description in Char DESCRIPTION U 56 p_unit_of_measure in Char UNIT_OF_MEASURE U 57 p_supplier_item in Char SUPPLIER_ITEM U 58 p_quantity in Number LINE_QUANTITY U 59 p_unit_price in Number PRICE U 60 p_allow_price_override in Char ALLOW_PRICE_OVERRIDE U 61 p_limit_price in Number LIMIT_PRICE U 62 p_ship_to_organization in Char SHIP_TO_ORGANIZATION_CODE value U 63 p_ship_to_location in Char SHIP_TO_LOCATION_CODE value U 64 p_line_note_to_vendor in Char LINE_NOTE_TO_VENDOR U 65 p_line_dff_context in Char LINE_DFF_CONTEXT U 66 p_line_attribute1 in Char LINE_ATTRIBUTE1 U 67 p_line_attribute2 in Char LINE_ATTRIBUTE2 U 68 p_line_attribute3 in Char LINE_ATTRIBUTE3 U 69 p_line_attribute4 in Char LINE_ATTRIBUTE4 U 70 p_line_attribute5 in Char LINE_ATTRIBUTE5 U 71 p_line_attribute6 in Char LINE_ATTRIBUTE6 U 72 p_line_attribute7 in Char LINE_ATTRIBUTE7 U 73 p_line_attribute8 in Char LINE_ATTRIBUTE8 U 74 p_line_attribute9 in Char LINE_ATTRIBUTE9 U 75 p_line_attribute10 in Char LINE_ATTRIBUTE10 U 76 p_line_attribute11 in Char LINE_ATTRIBUTE11 U 77 p_line_attribute12 in Char LINE_ATTRIBUTE12 U 78 p_line_attribute13 in Char LINE_ATTRIBUTE13 U 79 p_line_attribute14 in Char LINE_ATTRIBUTE14 U 80 p_line_attribute15 in Char LINE_ATTRIBUTE15 U 81 p_need_by_date in Date NEED_BY_DATE U 82 p_promised_date in Date PROMISED_DATE U 83 p_ship_quantity in Number SHIP_QUANTITY U 84 p_price_override in Number BREAK_PRICE U 85 p_price_break_uom in Char BREAK_UNIT_OF_MEASURE U 86 p_price_break_start_date in Date PRICE_BREAK_START_DATE U 87 p_price_break_end_date in Date PRICE_BREAK_END_DATE U 88 p_tax_classification_code in Char Y TAX_CLASSIFICATION_CODE U 89 p_match_approval_level in Char Y MATCH_APPROVAL_LEVEL U 90 p_line_location_dff_context in Char LINE_LOCATION_DFF_CONTEXT U 91 p_line_location_attribute1 in Char LINE_LOCATION_ATTRIBUTE1 U 92 p_line_location_attribute2 in Char LINE_LOCATION_ATTRIBUTE2 U 93 p_line_location_attribute3 in Char LINE_LOCATION_ATTRIBUTE3 U 94 p_line_location_attribute4 in Char LINE_LOCATION_ATTRIBUTE4 U 95 p_line_location_attribute5 in Char LINE_LOCATION_ATTRIBUTE5 U 96 p_line_location_attribute6 in Char LINE_LOCATION_ATTRIBUTE6 U 97 p_line_location_attribute7 in Char LINE_LOCATION_ATTRIBUTE7 U 98 p_line_location_attribute8 in Char LINE_LOCATION_ATTRIBUTE8 U 99 p_line_location_attribute9 in Char LINE_LOCATION_ATTRIBUTE9 U 100 p_line_location_attribute10 in Char LINE_LOCATION_ATTRIBUTE10 U 101 p_line_location_attribute11 in Char LINE_LOCATION_ATTRIBUTE11 U 102 p_line_location_attribute12 in Char LINE_LOCATION_ATTRIBUTE12 U 103 p_line_location_attribute13 in Char LINE_LOCATION_ATTRIBUTE13 U 104 p_line_location_attribute14 in Char LINE_LOCATION_ATTRIBUTE14 U 105 p_line_location_attribute15 in Char LINE_LOCATION_ATTRIBUTE15 U 106 p_distribution_num in Number DISTRIBUTION_NUM U 107 p_quantity_ordered in Number QUANTITY_ORDERED U 108 p_charge_account_id in Number CHARGE_ACCOUNT U 109 p_deliver_to_person in Char REQUESTOR value U 110 p_destination_type in Char Y DESTINATION_TYPE U 111 p_deliver_to_location in Char Y DELIVER_TO_LOCATION value U 112 p_wip_job in Char Y WIP_JOB U 113 p_wip_operation_seq in Number Y WIP_OPERATION_SEQ U 114 p_wip_resource_seq in Number Y WIP_RESOURCE_SEQ U 115 p_project_id in Number PROJECT_NUMBER U 116 p_task_id in Number TASK_NUMBER U 117 p_award_number in Char U 118 p_expenditure_type in Char EXPENDITURE_TYPE U 119 p_expenditure_organization_id in Number EXPENDITURE_ORG U 120 p_expenditure_item_date in Date EXPENDITURE_DATE U 121 p_project_related_flag in Char U 122 p_oke_contract_line_num in Char U 123 p_oke_contract_deliverable_num in Char U 124 p_end_item_unit_number in Char U 125 p_distribution_dff_context in Char DISTRIBUTION_DFF_CONTEXT U 126 p_distribution_attribute1 in Char DISTRIBUTION_ATTRIBUTE1 U 127 p_distribution_attribute2 in Char DISTRIBUTION_ATTRIBUTE2 U 128 p_distribution_attribute3 in Char DISTRIBUTION_ATTRIBUTE3 U 129 p_distribution_attribute4 in Char DISTRIBUTION_ATTRIBUTE4 U 130 p_distribution_attribute5 in Char DISTRIBUTION_ATTRIBUTE5 U 131 p_distribution_attribute6 in Char DISTRIBUTION_ATTRIBUTE6 U 132 p_distribution_attribute7 in Char DISTRIBUTION_ATTRIBUTE7 U 133 p_distribution_attribute8 in Char DISTRIBUTION_ATTRIBUTE8 U 134 p_distribution_attribute9 in Char DISTRIBUTION_ATTRIBUTE9 U 135 p_distribution_attribute10 in Char DISTRIBUTION_ATTRIBUTE10 U 136 p_distribution_attribute11 in Char DISTRIBUTION_ATTRIBUTE11 U 137 p_distribution_attribute12 in Char DISTRIBUTION_ATTRIBUTE12 U 138 p_distribution_attribute13 in Char DISTRIBUTION_ATTRIBUTE13 U 139 p_distribution_attribute14 in Char DISTRIBUTION_ATTRIBUTE14 U 140 p_distribution_attribute15 in Char DISTRIBUTION_ATTRIBUTE15 U 141 p_receiving_routing_id in Number Y RECEIPT_ROUTING U 142 p_interface_header_id in/out Number INTERFACE_HEADER_ID U 143 p_interface_line_id in/out Number INTERFACE_LINE_ID U 144 p_interface_line_location_id in/out Number INTERFACE_LINE_LOCATION_ID U 145 p_interface_distribution_id in/out Number INTERFACE_DISTRIBUTION_ID U 146 p_po_header_id in/out Number PO_HEADER_ID U 147 p_po_line_id in/out Number PO_LINE_ID U 148 p_line_location_id in/out Number LINE_LOCATION_ID U 149 p_po_distribution_id in/out Number PO_DISTRIBUTION_ID U 150 status_ out Char STATUS_CODE_ U 151 message_ out Char MESSAGE_ P 152 p_org_id in Number ORG_ID P 153 p_document_type in Char DOCUMENT_TYPE P 154 p_create_or_update_items in Char CREATE_OR_UPDATE_ITEMS P 155 p_approval_status in Char APPROVAL_STATUS P 156 p_group_lines in Char GROUP_LINES P 157 x_request_id out Number REQUEST_ID_ P 158 status_ out Char STATUS_CODE_ P 159 message_ out Char MESSAGE_ Error SQL select /*+ use_nl(xu phi) use_nl(xu pli) use_nl(xu plli) use_nl(xu pdi) */ --process-- xu.action_, xxen_upload.status_meaning(xxen_upload.status_error) status_, nvl((select listagg(pie.error_message,',') within group(order by 1) error_code from po_interface_errors pie where pie.interface_header_id=xu.interface_header_id and pie.interface_type='PO_DOCS_OPEN_INTERFACE') ,xu.message_ ) message_, xu.modified_columns_, xu.org_id, xu.request_id_, xu.interface_header_id, phi.po_header_id, xu.po_number, nvl(phi.group_code,xu.group_) group_, nvl(phi.document_num,xu.document_number) document_number, xu.revision_num, null creation_date, xu.document_type, xu.document_status, nvl(phi.effective_date, xu.effective_start_date) effective_start_date, nvl(phi.expiration_date, xu.effective_end_date) effective_end_date, nvl(phi.currency_code, xu.currency_code) currency_code, nvl(phi.rate_type, xu.rate_type) rate_type, nvl(phi.rate_date, xu.rate_date) rate_date, nvl(phi.rate, xu.rate) rate, nvl(phi.reference_num,xu.header_reference_num) header_reference_num, nvl(phi.comments,xu.header_description) header_description, nvl(phi.agent_name,xu.buyer) buyer, nvl(phi.vendor_name,xu.supplier_name) supplier_name, nvl(phi.vendor_site_code,xu.supplier_site) supplier_site, nvl(phi.amount_agreed,xu.amount_agreed) amount_agreed, nvl(xxen_util.meaning(phi.global_agreement_flag,'YES_NO',0),xu.global_agreement) global_agreement, xu.supply_agreement, nvl(phi.quote_warning_delay,xu.quote_warning_delay) quote_warning_delay, nvl(phi.note_to_vendor,xu.header_note_to_vendor) header_note_to_vendor, nvl(phi.note_to_receiver,xu.header_note_to_receiver) header_note_to_receiver, xxen_util.display_flexfield_context(201,'PO_HEADERS',phi.attribute_category) header_dff_context, xxen_util.display_flexfield_value(201,'PO_HEADERS',phi.attribute_category,'ATTRIBUTE1',phi.rowid,phi.attribute1) header_attribute1, xxen_util.display_flexfield_value(201,'PO_HEADERS',phi.attribute_category,'ATTRIBUTE2',phi.rowid,phi.attribute2) header_attribute2, xxen_util.display_flexfield_value(201,'PO_HEADERS',phi.attribute_category,'ATTRIBUTE3',phi.rowid,phi.attribute3) header_attribute3, xxen_util.display_flexfield_value(201,'PO_HEADERS',phi.attribute_category,'ATTRIBUTE4',phi.rowid,phi.attribute4) header_attribute4, xxen_util.display_flexfield_value(201,'PO_HEADERS',phi.attribute_category,'ATTRIBUTE5',phi.rowid,phi.attribute5) header_attribute5, xxen_util.display_flexfield_value(201,'PO_HEADERS',phi.attribute_category,'ATTRIBUTE6',phi.rowid,phi.attribute6) header_attribute6, xxen_util.display_flexfield_value(201,'PO_HEADERS',phi.attribute_category,'ATTRIBUTE7',phi.rowid,phi.attribute7) header_attribute7, xxen_util.display_flexfield_value(201,'PO_HEADERS',phi.attribute_category,'ATTRIBUTE8',phi.rowid,phi.attribute8) header_attribute8, xxen_util.display_flexfield_value(201,'PO_HEADERS',phi.attribute_category,'ATTRIBUTE9',phi.rowid,phi.attribute9) header_attribute9, xxen_util.display_flexfield_value(201,'PO_HEADERS',phi.attribute_category,'ATTRIBUTE10',phi.rowid,phi.attribute10) header_attribute10, xxen_util.display_flexfield_value(201,'PO_HEADERS',phi.attribute_category,'ATTRIBUTE11',phi.rowid,phi.attribute11) header_attribute11, xxen_util.display_flexfield_value(201,'PO_HEADERS',phi.attribute_category,'ATTRIBUTE12',phi.rowid,phi.attribute12) header_attribute12, xxen_util.display_flexfield_value(201,'PO_HEADERS',phi.attribute_category,'ATTRIBUTE13',phi.rowid,phi.attribute13) header_attribute13, xxen_util.display_flexfield_value(201,'PO_HEADERS',phi.attribute_category,'ATTRIBUTE14',phi.rowid,phi.attribute14) header_attribute14, xxen_util.display_flexfield_value(201,'PO_HEADERS',phi.attribute_category,'ATTRIBUTE15',phi.rowid,phi.attribute15) header_attribute15, nvl(phi.ship_to_location,xu.header_ship_to_location) ship_to_location, nvl(phi.bill_to_location,xu.header_bill_to_location) bill_to_location, nvl(phi.vendor_contact,xu.supplier_contact) supplier_contact, nvl(phi.payment_terms,xu.payment_terms) payment_terms, nvl(phi.freight_terms,xu.freight_terms) freight_terms, nvl(phi.fob,xu.fob) fob, nvl(phi.freight_carrier,xu.carrier) carrier, xu.interface_line_id, nvl(pli.po_line_id,xu.po_line_id) po_line_id, nvl(pli.line_num,xu.line_num) line_num, nvl(pli.line_reference_num,xu.line_reference_num) line_reference_num, nvl(pli.line_type,xu.line_type) line_type, nvl(pli.item,xu.item) item, nvl(pli.item_revision,xu.item_revision) item_revision, nvl(pli.category,xu.category) category, nvl(pli.item_description,xu.description) description, nvl(pli.unit_of_measure,xu.unit_of_measure) unit_of_measure, nvl(pli.unit_price,xu.price) price, nvl(xxen_util.meaning(pli.allow_price_override_flag,'YES_NO',0),xu.allow_price_override) allow_price_override, nvl(pli.not_to_exceed_price,xu.limit_price) limit_price, nvl(pli.quantity,xu.line_quantity) line_quantity, nvl(pli.vendor_product_num,xu.supplier_item) supplier_item, nvl(pli.note_to_vendor,xu.line_note_to_vendor) line_note_to_vendor, xxen_util.display_flexfield_context(201,'PO_LINES',pli.line_attribute_category_lines) line_dff_context, xxen_util.display_flexfield_value(201,'PO_LINES',pli.line_attribute_category_lines,'ATTRIBUTE1',pli.rowid,pli.line_attribute1) line_attribute1, xxen_util.display_flexfield_value(201,'PO_LINES',pli.line_attribute_category_lines,'ATTRIBUTE2',pli.rowid,pli.line_attribute2) line_attribute2, xxen_util.display_flexfield_value(201,'PO_LINES',pli.line_attribute_category_lines,'ATTRIBUTE3',pli.rowid,pli.line_attribute3) line_attribute3, xxen_util.display_flexfield_value(201,'PO_LINES',pli.line_attribute_category_lines,'ATTRIBUTE4',pli.rowid,pli.line_attribute4) line_attribute4, xxen_util.display_flexfield_value(201,'PO_LINES',pli.line_attribute_category_lines,'ATTRIBUTE5',pli.rowid,pli.line_attribute5) line_attribute5, xxen_util.display_flexfield_value(201,'PO_LINES',pli.line_attribute_category_lines,'ATTRIBUTE6',pli.rowid,pli.line_attribute6) line_attribute6, xxen_util.display_flexfield_value(201,'PO_LINES',pli.line_attribute_category_lines,'ATTRIBUTE7',pli.rowid,pli.line_attribute7) line_attribute7, xxen_util.display_flexfield_value(201,'PO_LINES',pli.line_attribute_category_lines,'ATTRIBUTE8',pli.rowid,pli.line_attribute8) line_attribute8, xxen_util.display_flexfield_value(201,'PO_LINES',pli.line_attribute_category_lines,'ATTRIBUTE9',pli.rowid,pli.line_attribute9) line_attribute9, xxen_util.display_flexfield_value(201,'PO_LINES',pli.line_attribute_category_lines,'ATTRIBUTE10',pli.rowid,pli.line_attribute10) line_attribute10, xxen_util.display_flexfield_value(201,'PO_LINES',pli.line_attribute_category_lines,'ATTRIBUTE11',pli.rowid,pli.line_attribute11) line_attribute11, xxen_util.display_flexfield_value(201,'PO_LINES',pli.line_attribute_category_lines,'ATTRIBUTE12',pli.rowid,pli.line_attribute12) line_attribute12, xxen_util.display_flexfield_value(201,'PO_LINES',pli.line_attribute_category_lines,'ATTRIBUTE13',pli.rowid,pli.line_attribute13) line_attribute13, xxen_util.display_flexfield_value(201,'PO_LINES',pli.line_attribute_category_lines,'ATTRIBUTE14',pli.rowid,pli.line_attribute14) line_attribute14, xxen_util.display_flexfield_value(201,'PO_LINES',pli.line_attribute_category_lines,'ATTRIBUTE15',pli.rowid,pli.line_attribute15) line_attribute15, xu.interface_line_location_id, nvl(plli.line_location_id,xu.line_location_id) line_location_id, nvl(plli.shipment_num,xu.shipment_num) shipment_num, nvl(plli.quantity,xu.ship_quantity) ship_quantity, nvl(plli.price_override,xu.break_price) break_price, nvl(plli.unit_of_measure,xu.break_unit_of_measure) break_unit_of_measure, nvl(plli.ship_to_organization_code,xu.ship_to_organization_code) ship_to_organization_code, nvl(plli.ship_to_location,xu.ship_to_location_code) ship_to_location_code, nvl(plli.need_by_date,xu.need_by_date) need_by_date, nvl(plli.promised_date,xu.promised_date) promised_date, nvl((select rrh.routing_name from rcv_routing_headers rrh where rrh.routing_header_id=plli.receiving_routing_id),xu.receipt_routing) receipt_routing, nvl(plli.tax_name,xu.tax_classification_code) tax_classification_code, nvl(case when plli.inspection_required_flag='Y' then '4-Way' when plli.receipt_required_flag='Y' then '3-Way' when plli.receipt_required_flag='N' then '2-Way' end,xu.match_approval_level) match_approval_level, nvl(plli.start_date,xu.price_break_start_date) price_break_start_date, nvl(plli.end_date,xu.price_break_end_date) price_break_end_date, xxen_util.display_flexfield_context(201,'PO_LINE_LOCATIONS',plli.attribute_category) line_location_dff_context, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plli.attribute_category,'ATTRIBUTE1',plli.rowid,plli.attribute1) line_location_attribute1, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plli.attribute_category,'ATTRIBUTE2',plli.rowid,plli.attribute2) line_location_attribute2, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plli.attribute_category,'ATTRIBUTE3',plli.rowid,plli.attribute3) line_location_attribute3, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plli.attribute_category,'ATTRIBUTE4',plli.rowid,plli.attribute4) line_location_attribute4, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plli.attribute_category,'ATTRIBUTE5',plli.rowid,plli.attribute5) line_location_attribute5, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plli.attribute_category,'ATTRIBUTE6',plli.rowid,plli.attribute6) line_location_attribute6, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plli.attribute_category,'ATTRIBUTE7',plli.rowid,plli.attribute7) line_location_attribute7, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plli.attribute_category,'ATTRIBUTE8',plli.rowid,plli.attribute8) line_location_attribute8, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plli.attribute_category,'ATTRIBUTE9',plli.rowid,plli.attribute9) line_location_attribute9, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plli.attribute_category,'ATTRIBUTE10',plli.rowid,plli.attribute10) line_location_attribute10, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plli.attribute_category,'ATTRIBUTE11',plli.rowid,plli.attribute11) line_location_attribute11, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plli.attribute_category,'ATTRIBUTE12',plli.rowid,plli.attribute12) line_location_attribute12, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plli.attribute_category,'ATTRIBUTE13',plli.rowid,plli.attribute13) line_location_attribute13, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plli.attribute_category,'ATTRIBUTE14',plli.rowid,plli.attribute14) line_location_attribute14, xxen_util.display_flexfield_value(201,'PO_LINE_LOCATIONS',plli.attribute_category,'ATTRIBUTE15',plli.rowid,plli.attribute15) line_location_attribute15, xu.interface_distribution_id, pdi.po_distribution_id, nvl(pdi.distribution_num,xu.distribution_num) distribution_num, nvl(pdi.quantity_ordered,xu.quantity_ordered) quantity_ordered, xu.charge_account, xu.requestor, nvl(case when pdi.destination_type_code is not null then (select plc.displayed_field from po_lookup_codes plc where plc.lookup_type='DESTINATION TYPE' and plc.lookup_code=pdi.destination_type_code) end,xu.destination_type) destination_type, nvl(pdi.deliver_to_location,xu.deliver_to_location) deliver_to_location, nvl(pdi.wip_entity,xu.wip_job) wip_job, nvl(pdi.wip_operation_seq_num,xu.wip_operation_seq) wip_operation_seq, nvl(pdi.wip_resource_seq_num,xu.wip_resource_seq) wip_resource_seq, nvl(case when pdi.project_id is not null then (select ppa.segment1 from pa_projects_all ppa where pdi.project_id=ppa.project_id) end,xu.project_number) project_number, nvl(case when pdi.task_id is not null then (select ptaev.task_number from pa_tasks_all_expend_v ptaev where ptaev.task_id= pdi.task_id and ptaev.expenditure_org_id=pdi.org_id) end,xu.task_number) task_number, nvl(pdi.expenditure_type,xu.expenditure_type) expenditure_type, nvl(pdi.expenditure_item_date,xu.expenditure_date) expenditure_date, nvl(case when pdi.expenditure_organization_id is not null then (select haouv_exp.name from hr_all_organization_units_vl haouv_exp where pdi.expenditure_organization_id=haouv_exp.organization_id) end,xu.expenditure_org) expenditure_org, xxen_util.display_flexfield_context(201,'PO_DISTRIBUTIONS',pdi.attribute_category) distribution_dff_context, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pdi.attribute_category,'ATTRIBUTE1',pdi.rowid,pdi.attribute1) distribution_attribute1, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pdi.attribute_category,'ATTRIBUTE2',pdi.rowid,pdi.attribute2) distribution_attribute2, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pdi.attribute_category,'ATTRIBUTE3',pdi.rowid,pdi.attribute3) distribution_attribute3, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pdi.attribute_category,'ATTRIBUTE4',pdi.rowid,pdi.attribute4) distribution_attribute4, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pdi.attribute_category,'ATTRIBUTE5',pdi.rowid,pdi.attribute5) distribution_attribute5, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pdi.attribute_category,'ATTRIBUTE6',pdi.rowid,pdi.attribute6) distribution_attribute6, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pdi.attribute_category,'ATTRIBUTE7',pdi.rowid,pdi.attribute7) distribution_attribute7, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pdi.attribute_category,'ATTRIBUTE8',pdi.rowid,pdi.attribute8) distribution_attribute8, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pdi.attribute_category,'ATTRIBUTE9',pdi.rowid,pdi.attribute9) distribution_attribute9, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pdi.attribute_category,'ATTRIBUTE10',pdi.rowid,pdi.attribute10) distribution_attribute10, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pdi.attribute_category,'ATTRIBUTE11',pdi.rowid,pdi.attribute11) distribution_attribute11, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pdi.attribute_category,'ATTRIBUTE12',pdi.rowid,pdi.attribute12) distribution_attribute12, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pdi.attribute_category,'ATTRIBUTE13',pdi.rowid,pdi.attribute13) distribution_attribute13, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pdi.attribute_category,'ATTRIBUTE14',pdi.rowid,pdi.attribute14) distribution_attribute14, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pdi.attribute_category,'ATTRIBUTE15',pdi.rowid,pdi.attribute15) distribution_attribute15, xu.approval_status, xu.create_or_update_items, xu.group_lines, xu.attachment_category_, xu.attachment_title_, xu.attachment_description_, xu.attachment_type_, xu.attachment_content_, xu.attachment_file_id_ from xxen_po_purchasing_docu_6421_u xu, po_headers_interface phi, po_lines_interface pli, po_line_locations_interface plli, po_distributions_interface pdi where (xu.status_code_ = xxen_upload.status_error or exists (select 1 from po_interface_errors pie where pie.interface_header_id=xu.interface_header_id and pie.interface_type='PO_DOCS_OPEN_INTERFACE') ) and xu.interface_header_id=phi.interface_header_id(+) and xu.interface_line_id=pli.interface_line_id(+) and xu.interface_line_location_id=plli.interface_line_location_id(+) and xu.interface_distribution_id=pdi.interface_distribution_id(+) Order By creation_date desc, po_number, line_num, shipment_num, distribution_num Success SQL select pha.action_, xxen_upload.status_meaning(xxen_upload.status_success) status_, 'Purchase document processed: '||pha.segment1 message_, pha.modified_columns_, pha.org_id, to_number(null) request_id_, to_number(null) interface_header_id, pha.po_header_id, pha.segment1 po_number, null group_, null document_number, pha.revision_num, pha.creation_date, pt.document_type_name document_type, po_headers_sv3.get_po_status(pha.po_header_id) document_status, pha.start_date effective_start_date, pha.end_date effective_end_date, pha.currency_code, pha.rate_type, pha.rate_date, pha.rate, pha.reference_num header_reference_num, pha.comments header_description, papf.full_name buyer, pv.vendor_name supplier_name, pvsa.vendor_site_code supplier_site, pha.blanket_total_amount amount_agreed, xxen_util.meaning(pha.global_agreement_flag,'YES_NO',0) global_agreement, xxen_util.meaning(pha.supply_agreement_flag,'YES_NO',0) supply_agreement, pha.quote_warning_delay, pha.note_to_vendor header_note_to_vendor, pha.note_to_receiver header_note_to_receiver, pha.header_dff_context, pha.header_attribute1, pha.header_attribute2, pha.header_attribute3, pha.header_attribute4, pha.header_attribute5, pha.header_attribute6, pha.header_attribute7, pha.header_attribute8, pha.header_attribute9, pha.header_attribute10, pha.header_attribute11, pha.header_attribute12, pha.header_attribute13, pha.header_attribute14, pha.header_attribute15, hla2.location_code header_ship_to_location, hla1.location_code header_bill_to_location, case when pha.vendor_contact_id is not null then (select max(pvc.last_name||' '||pvc.first_name) from po_vendor_contacts pvc where pvc.vendor_contact_id=pha.vendor_contact_id) end supplier_contact, (select att.name from ap_terms_tl att where att.term_id=pha.terms_id and att.language=userenv('lang')) payment_terms, pha.freight_terms_lookup_code freight_terms, pha.fob_lookup_code fob, pha.ship_via_lookup_code carrier, to_number(null) interface_line_id, pl.po_line_id, pl.line_num, pl.line_reference_num, pl.line_type, pl.item, pl.item_revision, pl.category, pl.description, pl.unit_of_measure, pl.unit_price price, xxen_util.meaning(pl.allow_price_override,'YES_NO',0) allow_price_override, pl.limit_price, pl.line_quantity, pl.supplier_item, pl.note_to_vendor line_note_to_vendor, pl.line_dff_context, pl.line_attribute1, pl.line_attribute2, pl.line_attribute3, pl.line_attribute4, pl.line_attribute5, pl.line_attribute6, pl.line_attribute7, pl.line_attribute8, pl.line_attribute9, pl.line_attribute10, pl.line_attribute11, pl.line_attribute12, pl.line_attribute13, pl.line_attribute14, pl.line_attribute15, to_number(null) interface_line_location_id, pll.line_location_id, pll.shipment_num, pll.ship_quantity, pll.break_price, pll.break_unit_of_measure, pll.ship_to_organization_code, pll.ship_to_location_code, pll.need_by_date, pll.promised_date, pll.receipt_routing, pll.tax_classification_code, pll.match_approval_level, pll.price_break_start_date, pll.price_break_end_date, pll.line_location_dff_context, pll.line_location_attribute1, pll.line_location_attribute2, pll.line_location_attribute3, pll.line_location_attribute4, pll.line_location_attribute5, pll.line_location_attribute6, pll.line_location_attribute7, pll.line_location_attribute8, pll.line_location_attribute9, pll.line_location_attribute10, pll.line_location_attribute11, pll.line_location_attribute12, pll.line_location_attribute13, pll.line_location_attribute14, pll.line_location_attribute15, to_number(null) interface_distribution_id, pda.po_distribution_id, pda.distribution_num, pda.quantity_ordered, gcck.concatenated_segments charge_account, case when pda.deliver_to_person_id is not null then (select papf.full_name from per_all_people_f papf where papf.person_id=pda.deliver_to_person_id and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date) end requestor, case when pda.destination_type_code is not null then (select plc.displayed_field from po_lookup_codes plc where plc.lookup_type='DESTINATION TYPE' and plc.lookup_code=pda.destination_type_code) end destination_type, case when pda.deliver_to_location_id is not null then (select hla.location_code from hr_locations_all hla where hla.location_id=pda.deliver_to_location_id) end deliver_to_location, case when pda.wip_entity_id is not null then (select we.wip_entity_name from wip_entities we where we.wip_entity_id=pda.wip_entity_id) end wip_job, pda.wip_operation_seq_num wip_operation_seq, pda.wip_resource_seq_num wip_resource_seq, case when pda.project_id is not null then (select ppa.segment1 from pa_projects_all ppa where pda.project_id=ppa.project_id) end project_number, case when pda.task_id is not null then (select ptaev.task_number from pa_tasks_all_expend_v ptaev where ptaev.task_id= pda.task_id and ptaev.expenditure_org_id=pda.org_id) end task_number, pda.expenditure_type, pda.expenditure_item_date expenditure_date, case when pda.expenditure_organization_id is not null then (select haouv_exp.name from hr_all_organization_units_vl haouv_exp where pda.expenditure_organization_id=haouv_exp.organization_id) end expenditure_org, xxen_util.display_flexfield_context(201,'PO_DISTRIBUTIONS',pda.attribute_category) distribution_dff_context, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE1',pda.rowid,pda.attribute1) distribution_attribute1, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE2',pda.rowid,pda.attribute2) distribution_attribute2, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE3',pda.rowid,pda.attribute3) distribution_attribute3, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE4',pda.rowid,pda.attribute4) distribution_attribute4, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE5',pda.rowid,pda.attribute5) distribution_attribute5, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE6',pda.rowid,pda.attribute6) distribution_attribute6, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE7',pda.rowid,pda.attribute7) distribution_attribute7, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE8',pda.rowid,pda.attribute8) distribution_attribute8, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE9',pda.rowid,pda.attribute9) distribution_attribute9, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE10',pda.rowid,pda.attribute10) distribution_attribute10, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE11',pda.rowid,pda.attribute11) distribution_attribute11, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE12',pda.rowid,pda.attribute12) distribution_attribute12, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE13',pda.rowid,pda.attribute13) distribution_attribute13, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE14',pda.rowid,pda.attribute14) distribution_attribute14, xxen_util.display_flexfield_value(201,'PO_DISTRIBUTIONS',pda.attribute_category,'ATTRIBUTE15',pda.rowid,pda.attribute15) distribution_attribute15, null approval_status, null create_or_update_items, null group_lines, pha.attachment_category_, pha.attachment_title_, pha.attachment_description_, pha.attachment_type_, pha.attachment_content_, pha.attachment_file_id_ from ( select /*+ use_nl(pha pda) */ pha.segment1, pha.revision_num, pha.creation_date, pha.type_lookup_code, pha.agent_id, pha.org_id, pha.vendor_id, pha.vendor_site_id, pha.bill_to_location_id, pha.ship_to_location_id, pha.vendor_contact_id, pha.terms_id, pha.freight_terms_lookup_code, pha.fob_lookup_code, pha.ship_via_lookup_code, pha.global_agreement_flag, pha.supply_agreement_flag, pha.authorization_status, pha.start_date, pha.end_date, pha.currency_code, gdct.user_conversion_type rate_type, pha.rate_date, pha.rate, pha.reference_num, pha.blanket_total_amount, pha.quote_warning_delay, pha.comments, pha.note_to_vendor, pha.note_to_receiver, xxen_util.display_flexfield_context(201,'PO_HEADERS',pha.attribute_category) header_dff_context, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE1',pha.rowid,pha.attribute1) header_attribute1, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE2',pha.rowid,pha.attribute2) header_attribute2, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE3',pha.rowid,pha.attribute3) header_attribute3, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE4',pha.rowid,pha.attribute4) header_attribute4, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE5',pha.rowid,pha.attribute5) header_attribute5, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE6',pha.rowid,pha.attribute6) header_attribute6, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE7',pha.rowid,pha.attribute7) header_attribute7, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE8',pha.rowid,pha.attribute8) header_attribute8, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE9',pha.rowid,pha.attribute9) header_attribute9, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE10',pha.rowid,pha.attribute10) header_attribute10, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE11',pha.rowid,pha.attribute11) header_attribute11, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE12',pha.rowid,pha.attribute12) header_attribute12, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE13',pha.rowid,pha.attribute13) header_attribute13, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE14',pha.rowid,pha.attribute14) header_attribute14, xxen_util.display_flexfield_value(201,'PO_HEADERS',pha.attribute_category,'ATTRIBUTE15',pha.rowid,pha.attribute15) header_attribute15, nvl(xu_pha.po_header_id,nvl(xu_pla.po_header_id,xu_plla.po_header_id)) po_header_id, nvl(xu_pla.po_line_id,xu_plla.po_line_id) po_line_id, xu_plla.line_location_id, pda.po_distribution_id, xu.action_, xu.modified_columns_, xu.attachment_category_, xu.attachment_title_, xu.attachment_description_, xu.attachment_type_, xxen_upload.check_and_add_attachment( p_function_name=>'PO_POXPOEPO', p_function_type=>'F', p_category_name=>xu.attachment_category_, p_entity_name=>'PO_HEADERS', p_data_type=>xu.attachment_type_, p_title=>xu.attachment_title_, p_description=>xu.attachment_description_, p_text=>xu.attachment_content_, p_file_id=>xu.attachment_file_id_, p_pk1_value=>pha.po_header_id ) attachment_content_, xu.attachment_file_id_ from xxen_po_purchasing_docu_6421_u xu, ( select /*+ use_nl(xu pha) */ xu.rowid row_id,pha.po_header_id from xxen_po_purchasing_docu_6421_u xu, po_headers_all pha where xu.interface_header_id=pha.from_header_id and pha.last_update_date>sysdate-.25 union select /*+ use_nl(xu pha) */ xu.rowid row_id,pha.po_header_id from xxen_po_purchasing_docu_6421_u xu, po_headers_all pha where xu.po_header_id=pha.po_header_id ) xu_pha, ( select /*+ use_nl(xu pla) */ xu.rowid row_id,pla.po_line_id,pla.po_header_id from xxen_po_purchasing_docu_6421_u xu, po_lines_all pla where xu.interface_line_id=pla.from_line_id and pla.last_update_date>sysdate-.25 union select /*+ use_nl(xu pla) */ xu.rowid row_id,pla.po_line_id,pla.po_header_id from xxen_po_purchasing_docu_6421_u xu, po_lines_all pla where xu.po_line_id=pla.po_line_id ) xu_pla, ( select /*+ use_nl(xu plla) */ xu.rowid row_id,plla.line_location_id,plla.po_line_id,plla.po_header_id from xxen_po_purchasing_docu_6421_u xu, po_line_locations_all plla where xu.interface_line_location_id=plla.from_line_location_id and plla.last_update_date>sysdate-.25 union select /*+ use_nl(xu plla) */ xu.rowid row_id,plla.line_location_id,plla.po_line_id,plla.po_header_id from xxen_po_purchasing_docu_6421_u xu, po_line_locations_all plla where xu.line_location_id=plla.line_location_id union select /*+ use_nl(xu plla) */ xu.rowid row_id,plla.line_location_id,plla.po_line_id,plla.po_header_id from xxen_po_purchasing_docu_6421_u xu, po_line_locations_all plla where xu.line_location_id is null and xu.po_line_id=plla.po_line_id and xu.shipment_num=plla.shipment_num and plla.last_update_date>sysdate-.25 ) xu_plla, po_headers_all pha, po_distributions_all pda, gl_daily_conversion_types gdct where xu.status_code_=xxen_upload.status_success and xu.rowid=xu_pha.row_id(+) and xu.rowid=xu_pla.row_id(+) and xu.rowid=xu_plla.row_id(+) and pha.po_header_id=nvl(xu_plla.po_header_id,nvl(xu_pla.po_header_id,xu_pha.po_header_id)) and xu_plla.line_location_id=pda.line_location_id(+) and pha.rate_type=gdct.conversion_type(+) and not exists (select 1 from po_interface_errors pie where pie.interface_header_id=xu.interface_header_id and pie.table_name='PO_HEADERS_INTERFACE' and pie.interface_type='PO_DOCS_OPEN_INTERFACE') and not exists (select 1 from po_interface_errors pie where pie.interface_header_id=xu.interface_header_id and pie.interface_line_id=xu.interface_line_id and pie.table_name='PO_LINES_INTERFACE' and pie.interface_type='PO_DOCS_OPEN_INTERFACE') and not exists (select 1 from po_interface_errors pie where pie.interface_header_id=xu.interface_header_id and pie.interface_line_location_id=xu.interface_line_location_id and pie.table_name='PO_LINE_LOCATIONS_INTERFACE' and pie.interface_type='PO_DOCS_OPEN_INTERFACE') and not exists (select 1 from po_interface_errors pie where pie.interface_header_id=xu.interface_header_id and pie.interface_distribution_id=xu.interface_distribution_id and pie.table_name='PO_DISTRIBUTIONS_INTERFACE' and pie.interface_type='PO_DOCS_OPEN_INTERFACE') ) pha, per_all_people_f papf, po_vendors pv, po_vendor_sites_all pvsa, hr_locations_all hla1, hr_locations_all hla2, po_distributions_all pda, gl_code_combinations_kfv gcck, document_types_ pt, po_lines_ pl, po_line_locations_ pll where pha.type_lookup_code=pt.document_type and papf.person_id=pha.agent_id and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date and pha.vendor_id=pv.vendor_id(+) and pha.vendor_site_id=pvsa.vendor_site_id(+) and pha.bill_to_location_id=hla1.location_id(+) and pha.ship_to_location_id=hla2.location_id(+) and pha.po_line_id=pl.po_line_id(+) and pha.line_location_id=pll.line_location_id(+) and pha.po_distribution_id=pda.po_distribution_id(+) and pda.code_combination_id=gcck.code_combination_id(+)