ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E4245C1F11BB560FE0530100007F2E66Y select --process-- null action_, null status_, null message_, null request_id_, null modified_columns_, to_char(null) row_id, --header-- null group_code, prha.creation_date, prha.requisition_header_id, prha.segment1 requisition_number, papf3.full_name preparer, prha.note_to_authorizer, --prh.type_lookup_disp requisition_type, prha.description header_description, xxen_util.display_flexfield_context(201,'PO_REQUISITION_HEADERS',prha.attribute_category) header_attribute_category, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE1',prha.rowid,prha.attribute1) header_attribute1, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE2',prha.rowid,prha.attribute2) header_attribute2, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE3',prha.rowid,prha.attribute3) header_attribute3, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE4',prha.rowid,prha.attribute4) header_attribute4, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE5',prha.rowid,prha.attribute5) header_attribute5, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE6',prha.rowid,prha.attribute6) header_attribute6, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE7',prha.rowid,prha.attribute7) header_attribute7, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE8',prha.rowid,prha.attribute8) header_attribute8, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE9',prha.rowid,prha.attribute9) header_attribute9, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE10',prha.rowid,prha.attribute10) header_attribute10, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE11',prha.rowid,prha.attribute11) header_attribute11, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE12',prha.rowid,prha.attribute12) header_attribute12, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE13',prha.rowid,prha.attribute13) header_attribute13, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE14',prha.rowid,prha.attribute14) header_attribute14, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE15',prha.rowid,prha.attribute15) header_attribute15, prla.requisition_line_id, prla.line_num, pltt.line_type, plc2.displayed_field destination_type, mpd.organization_code destination_organization, prla.destination_subinventory, hlat.location_code deliver_to_location, papf2.full_name deliver_to_requestor, plc1.displayed_field source_type, mps.organization_code source_organization, prla.source_subinventory, msiv.concatenated_segments item, prla.item_description, prla.item_revision, mcv.category_concat_segs category, prla.unit_meas_lookup_code unit_of_measure, prla.quantity, prla.unit_price, prla.need_by_date, prla.reference_num reference_number, --source-- prla.suggested_vendor_name supplier, prla.suggested_vendor_location supplier_site, prla.suggested_vendor_contact supplier_contact, prla.suggested_vendor_product_code supplier_item, --source details-- papf1.full_name buyer, prla.note_to_agent note_to_buyer, --currency-- prla.currency_code currency, prla.rate_type conversion_type, prla.rate_date conversion_date, prla.rate conversion_rate, prla.currency_unit_price, -- xxen_util.display_flexfield_context(201,'PO_REQUISITION_LINES',prla.attribute_category) line_attribute_category, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE1',prla.rowid,prla.attribute1) line_attribute1, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE2',prla.rowid,prla.attribute2) line_attribute2, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE3',prla.rowid,prla.attribute3) line_attribute3, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE4',prla.rowid,prla.attribute4) line_attribute4, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE5',prla.rowid,prla.attribute5) line_attribute5, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE6',prla.rowid,prla.attribute6) line_attribute6, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE7',prla.rowid,prla.attribute7) line_attribute7, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE8',prla.rowid,prla.attribute8) line_attribute8, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE9',prla.rowid,prla.attribute9) line_attribute9, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE10',prla.rowid,prla.attribute10) line_attribute10, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE11',prla.rowid,prla.attribute11) line_attribute11, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE12',prla.rowid,prla.attribute12) line_attribute12, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE13',prla.rowid,prla.attribute13) line_attribute13, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE14',prla.rowid,prla.attribute14) line_attribute14, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE15',prla.rowid,prla.attribute15) line_attribute15, --distribution accounts-- prda.distribution_id, prda.distribution_num, gcc.segment1 charge_account_segment1, gcc.segment2 charge_account_segment2, gcc.segment3 charge_account_segment3, gcc.segment4 charge_account_segment4, gcc.segment5 charge_account_segment5, gcc.segment6 charge_account_segment6, gcc.segment7 charge_account_segment7, gcc.segment8 charge_account_segment8, gcc.segment9 charge_account_segment9, gcc.segment10 charge_account_segment10, --distribution projects-- prda.project_accounting_context project_accounting, ppv.segment1 project_number, ptv.task_number, prda.expenditure_type, haouve.name expenditure_organization, prda.expenditure_item_date, xxen_util.display_flexfield_context(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category) dist_attribute_category, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE1',prda.rowid,prda.attribute1) dist_attribute1, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE2',prda.rowid,prda.attribute2) dist_attribute2, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE3',prda.rowid,prda.attribute3) dist_attribute3, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE4',prda.rowid,prda.attribute4) dist_attribute4, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE5',prda.rowid,prda.attribute5) dist_attribute5, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE6',prda.rowid,prda.attribute6) dist_attribute6, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE7',prda.rowid,prda.attribute7) dist_attribute7, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE8',prda.rowid,prda.attribute8) dist_attribute8, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE9',prda.rowid,prda.attribute9) dist_attribute9, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE10',prda.rowid,prda.attribute10) dist_attribute10, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE11',prda.rowid,prda.attribute11) dist_attribute11, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE12',prda.rowid,prda.attribute12) dist_attribute12, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE13',prda.rowid,prda.attribute13) dist_attribute13, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE14',prda.rowid,prda.attribute14) dist_attribute14, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE15',prda.rowid,prda.attribute15) dist_attribute15, -- defaults to_char(null) group_by, to_char(null) initiate_reqappr_after_imp, to_char(null) interface_source_code, to_char(null) multi_distributions, to_char(null) allow_dynamic_ccid, to_char(null) authorization_status, to_char(null) preparer_id, prha.type_lookup_code requisition_type, --attachments null attachment_category_, null attachment_title_, null attachment_description_, null attachment_type_, null attachment_content_, null attachment_file_id_, to_number(null) upload_row from po_requisition_headers_all prha, po_requisition_lines_all prla, po_req_distributions_all prda, mtl_categories_v mcv, gl_code_combinations gcc, pa_projects_all ppv, pa_tasks_v ptv, hr_all_organization_units_vl haouve, mtl_parameters mps, mtl_parameters mpd, mtl_system_items_vl msiv, hr_all_organization_units_vl haouv, per_all_people_f papf1, per_all_people_f papf2, per_all_people_f papf3, po_lookup_codes plc1, po_lookup_codes plc2, hr_locations_all_tl hlat, po_line_types_tl pltt, po_document_types_all_vl pdtav where 1=1 and :p_group_by=:p_group_by and prha.org_id=haouv.organization_id and prha.requisition_header_id=prla.requisition_header_id and prla.requisition_line_id=prda.requisition_line_id and papf1.person_id(+) = prla.suggested_buyer_id and trunc (sysdate) between papf1.effective_start_date (+) and papf1.effective_end_date (+) and plc1.lookup_code = prla.source_type_code and plc1.lookup_type = 'REQUISITION SOURCE TYPE' and plc2.lookup_code = prla.destination_type_code and plc2.lookup_type = 'DESTINATION TYPE' and pdtav.document_type_code='REQUISITION' and pdtav.document_subtype=prha.type_lookup_code and pdtav.org_id=prha.org_id and papf2.person_id = prla.to_person_id and trunc (sysdate) between papf2.effective_start_date and papf2.effective_end_date and papf3.person_id = prha.preparer_id and trunc (sysdate) between papf3.effective_start_date and papf3.effective_end_date and pltt.line_type_id=prla.line_type_id and pltt.language=userenv ('LANG') and hlat.location_id(+) = prla.deliver_to_location_id and hlat.language(+) = userenv ('LANG') and nvl(prla.transferred_to_oe_flag,'N')<>'Y' and nvl(prha.closed_code,'!')<>'FINALLY CLOSED' and prha.authorization_status not in ('CANCELLED','PRE-APPROVED','IN PROCESS','SYSTEM_SAVED') and not exists ( select 1 from po_distributions_all pda, po_req_distributions_all prda where pda.req_distribution_id = prda.distribution_id and prda.requisition_line_id = prla.requisition_line_id ) and prla.item_id=msiv.inventory_item_id(+) and xxen_po_upload.get_inv_org_id(prla.org_id)=msiv.organization_id(+) and prla.destination_organization_id=mpd.organization_id(+) and prla.source_organization_id=mps.organization_id(+) and prla.category_id=mcv.category_id(+) and prda.code_combination_id=gcc.code_combination_id(+) and prda.project_id=ppv.project_id(+) and prda.task_id=ptv.task_id(+) and prda.expenditure_organization_id=haouve.organization_id(+) Hidden Upload Row column added, Upload Mode bound as :p_upload_mode, redundant column aliases removed, document types read from po_document_types_all_vl. U PO REQIMPORT A xxen_po_upload.create_update_requisition xxen_po_upload.submit_req_import F PO Requisition Upload Téléchargez pour créer et mettre à jour des demandes d'achat. Dans l'Excel généré, l'utilisateur peut modifier les colonnes suivantes pour une demande d'achat existante. - Description de l'en-tête - Quantité - Prix unitaire - Besoin par date - Numéro de réference - Article fournisseur - Acheteur - Note à l'acheteur - Devise - Type de conversion - Taux de conversion - Date de conversion De plus, l'utilisateur peut créer une demande d'achat en saisissant les champs obligatoires ci-dessous. - Type de ligne - Type de Source - Article - Description de l'article - Catégorie - Unité de mesure - Quantité - Besoin par date - Type de destination - Livrer au demandeur - Organisation des destinations - Livrer sur place US PO Requisition Upload Upload to create and update requisitions. New rows always create new requisitions through Requisition Import: lines cannot be added to an existing requisition, and requisitions and lines are not deleted or cancelled. In the generated Excel, the user can amend the following columns for an existing requisition. - Header Description - Quantity - Unit Price - Need By Date - Reference Number - Supplier Item - Buyer - Note To Buyer - Currency - Conversion Type - Conversion Rate - Conversion Date Additionally, the user can create a requisition by entering the below required fields. - Line Type - Source Type - Item - Item Description - Category - Unit of Measure - Quantity - Need By Date - Destination Type - Deliver To Requestor - Destination Organization - Deliver To Location Enginatics Upload 1=1 :operating_unit :p_group_by 1 -10 1=1 :ledger=:ledger Char xxen_util.default_ledger US Ledger 2 10 1=1 haouv.name=:operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 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 xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) Y US Operating Unit 3 20 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create||','||xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual Y US Upload Mode 4 25 1=1 :p_init_approval=:p_init_approval LOV Oracle Yes_No select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y Y US Initiate Approval on Import 5 30 1=1 pdtav.document_subtype=:requisition_type LOV PO Requisition Type E8261147D2435465E0530100007F7AB4 select pdtav.document_subtype id, pdtav.type_name value, pdtav.type_name description from po_document_types_all_vl pdtav, hr_all_organization_units_vl haouv where (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') and pdtav.org_id=haouv.organization_id and pdtav.document_type_code='REQUISITION' Y US Requisition Type 6 35 :p_group_by LOV custom select flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type = 'REQIMPORT GROUP BY' and flvv.view_application_id = 201 and flvv.security_group_id = fnd_global.security_group_id and flvv.enabled_flag = 'Y' and sysdate between nvl(flvv.start_date_active,sysdate) and nvl(flvv.end_date_active,sysdate) order by value xxen_util.meaning('ITEM' ,'REQIMPORT GROUP BY',201) Y US Group By 7 40 1=1 prha.segment1>=:requisition_number_from LOV custom select prha.segment1 value, prha.description from po_requisition_headers_all prha, hr_all_organization_units_vl haouv, po_document_types_all_vl pdtav where (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') and (:$flex$.requisition_type is null or xxen_util.contains(:$flex$.requisition_type,pdtav.document_subtype)='Y') and (:$flex$.upload_mode is null or :$flex$.upload_mode like '%' || xxen_upload.action_update) and pdtav.document_type_code='REQUISITION' and pdtav.document_subtype=prha.type_lookup_code and pdtav.org_id=prha.org_id and haouv.organization_id=prha.org_id and nvl (prha.closed_code, '!') <> 'FINALLY CLOSED' and prha.authorization_status not in ('CANCELLED', 'PRE-APPROVED', 'IN PROCESS', 'SYSTEM_SAVED') and exists( select 1 from po_requisition_lines_all prla where prla.requisition_header_id=prha.requisition_header_id and nvl(prla.transferred_to_oe_flag,'N')<>'Y' and not exists ( select 1 from po_distributions_all pda, po_req_distributions_all prda where pda.req_distribution_id = prda.distribution_id and prda.requisition_line_id = prla.requisition_line_id ) ) US Requisition Number From 8 50 1=1 prha.segment1<=:requisition_number_to LOV custom select prha.segment1 value, prha.description from po_requisition_headers_all prha, hr_all_organization_units_vl haouv, po_document_types_all_vl pdtav where (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') and (:$flex$.requisition_type is null or xxen_util.contains(:$flex$.requisition_type,pdtav.document_subtype)='Y') and (:$flex$.upload_mode is null or :$flex$.upload_mode like '%' || xxen_upload.action_update) and pdtav.document_type_code='REQUISITION' and pdtav.document_subtype=prha.type_lookup_code and pdtav.org_id=prha.org_id and haouv.organization_id=prha.org_id and nvl (prha.closed_code, '!') <> 'FINALLY CLOSED' and prha.authorization_status not in ('CANCELLED', 'PRE-APPROVED', 'IN PROCESS', 'SYSTEM_SAVED') and exists( select 1 from po_requisition_lines_all prla where prla.requisition_header_id=prha.requisition_header_id and nvl(prla.transferred_to_oe_flag,'N')<>'Y' and not exists ( select 1 from po_distributions_all pda, po_req_distributions_all prda where pda.req_distribution_id = prda.distribution_id and prda.requisition_line_id = prla.requisition_line_id ) ) :$flex$.Requisition_Number_From US Requisition Number To 9 60 1=1 prha.creation_date>=:creation_date_from Date US Creation Date From 10 70 1=1 prha.creation_date<:creation_date_to+1 Date last_day(:$flex$.creation_date_from) US Creation Date To 11 80 1=1 prla.need_by_date>=:need_by_date_from Date US Need By Date From 12 90 1=1 prla.need_by_date<:need_by_date_to+1 Date last_day(:$flex$.need_by_date_from) US Need By Date To 13 100 1=1 papf2.full_name=:requestor_name LOV HR Employee 0092EAD2F4F36C61E0630100007FAB89 select he.full_name value, he.employee_num description from hr_employees he order by he.full_name US Requestor Name 14 110 1=1 papf1.full_name=:buyer LOV custom 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 Buyer Name 15 120 1=1 prha.created_by in (select user_id from fnd_user where user_name=:created_by) LOV FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name US Created By 16 130 1=1 prha.authorization_status=:authorization_status LOV custom select 'APPROVED' value, 'Approved' description from dual where :$flex$.upload_mode like '%' || xxen_upload.action_update union all select 'INCOMPLETE' value, ' Incomplete' description from dual where :$flex$.upload_mode like '%' || xxen_upload.action_update union all select 'REJECTED' value, ' Rejected' description from dual where :$flex$.upload_mode like '%' || xxen_upload.action_update US Authorization Status F05C47B8D90F3F0E1405BA0BC680D763 Create Internal Requisition ASHISH.SAKLANI 27 BUYER 14 CATEGORY Y 34 CHARGE_ACCOUNT_SEGMENT1 43 CHARGE_ACCOUNT_SEGMENT10 35 CHARGE_ACCOUNT_SEGMENT2 36 CHARGE_ACCOUNT_SEGMENT3 37 CHARGE_ACCOUNT_SEGMENT4 38 CHARGE_ACCOUNT_SEGMENT5 39 CHARGE_ACCOUNT_SEGMENT6 40 CHARGE_ACCOUNT_SEGMENT7 41 CHARGE_ACCOUNT_SEGMENT8 42 CHARGE_ACCOUNT_SEGMENT9 31 CONVERSION_DATE 32 CONVERSION_RATE 30 CONVERSION_TYPE 29 CURRENCY 8 DELIVER_TO_LOCATION Y 5 DELIVER_TO_REQUESTOR Y 6 DESTINATION_ORGANIZATION Y 7 DESTINATION_SUBINVENTORY 4 DESTINATION_TYPE Y 33 DISTRIBUTION_NUM 49 EXPENDITURE_ITEM_DATE 48 EXPENDITURE_ORGANIZATION 47 EXPENDITURE_TYPE 2 GROUP_CODE 3 HEADER_DESCRIPTION Y 11 ITEM 12 ITEM_DESCRIPTION Y 13 ITEM_REVISION 9 LINE_NUM 10 LINE_TYPE Y 18 NEED_BY_DATE Y 28 NOTE_TO_BUYER 44 PROJECT_ACCOUNTING 45 PROJECT_NUMBER 16 QUANTITY Y 19 REFERENCE_NUMBER 1 REQUISITION_NUMBER 21 SOURCE_ORGANIZATION 22 SOURCE_SUBINVENTORY 20 SOURCE_TYPE Y 23 SUPPLIER 25 SUPPLIER_CONTACT 26 SUPPLIER_ITEM 24 SUPPLIER_SITE 46 TASK_NUMBER 15 UNIT_OF_MEASURE Y 17 UNIT_PRICE Y Group By All Requisition Type INTERNAL Upload Mode C S Site A83FFFB2F755AD37F501F9D746C60C49 Create Internal Requisition (with attachment) ASHISH.SAKLANI 50 ATTACHMENT_CATEGORY_ 54 ATTACHMENT_CONTENT_ 52 ATTACHMENT_DESCRIPTION_ 55 ATTACHMENT_FILE_ID_ 51 ATTACHMENT_TITLE_ 53 ATTACHMENT_TYPE_ 27 BUYER 14 CATEGORY Y 34 CHARGE_ACCOUNT_SEGMENT1 43 CHARGE_ACCOUNT_SEGMENT10 35 CHARGE_ACCOUNT_SEGMENT2 36 CHARGE_ACCOUNT_SEGMENT3 37 CHARGE_ACCOUNT_SEGMENT4 38 CHARGE_ACCOUNT_SEGMENT5 39 CHARGE_ACCOUNT_SEGMENT6 40 CHARGE_ACCOUNT_SEGMENT7 41 CHARGE_ACCOUNT_SEGMENT8 42 CHARGE_ACCOUNT_SEGMENT9 31 CONVERSION_DATE 32 CONVERSION_RATE 30 CONVERSION_TYPE 29 CURRENCY 8 DELIVER_TO_LOCATION Y 5 DELIVER_TO_REQUESTOR Y 6 DESTINATION_ORGANIZATION Y 7 DESTINATION_SUBINVENTORY 4 DESTINATION_TYPE Y 33 DISTRIBUTION_NUM 49 EXPENDITURE_ITEM_DATE 48 EXPENDITURE_ORGANIZATION 47 EXPENDITURE_TYPE 2 GROUP_CODE 3 HEADER_DESCRIPTION Y 11 ITEM 12 ITEM_DESCRIPTION Y 13 ITEM_REVISION 9 LINE_NUM 10 LINE_TYPE Y 18 NEED_BY_DATE Y 28 NOTE_TO_BUYER 44 PROJECT_ACCOUNTING 45 PROJECT_NUMBER 16 QUANTITY Y 19 REFERENCE_NUMBER 1 REQUISITION_NUMBER 21 SOURCE_ORGANIZATION 22 SOURCE_SUBINVENTORY 20 SOURCE_TYPE Y 23 SUPPLIER 25 SUPPLIER_CONTACT 26 SUPPLIER_ITEM 24 SUPPLIER_SITE 46 TASK_NUMBER 15 UNIT_OF_MEASURE Y 17 UNIT_PRICE Y Group By All Requisition Type INTERNAL Upload Mode C S Site 1AB7ABF99F1D7671BB463FA9FA9CDD3A Create Purchase Requisition ENGINATICS 27 BUYER 14 CATEGORY Y 34 CHARGE_ACCOUNT_SEGMENT1 43 CHARGE_ACCOUNT_SEGMENT10 35 CHARGE_ACCOUNT_SEGMENT2 36 CHARGE_ACCOUNT_SEGMENT3 37 CHARGE_ACCOUNT_SEGMENT4 38 CHARGE_ACCOUNT_SEGMENT5 39 CHARGE_ACCOUNT_SEGMENT6 40 CHARGE_ACCOUNT_SEGMENT7 41 CHARGE_ACCOUNT_SEGMENT8 42 CHARGE_ACCOUNT_SEGMENT9 31 CONVERSION_DATE 32 CONVERSION_RATE 30 CONVERSION_TYPE 29 CURRENCY 8 DELIVER_TO_LOCATION Y 5 DELIVER_TO_REQUESTOR Y 6 DESTINATION_ORGANIZATION Y 7 DESTINATION_SUBINVENTORY 4 DESTINATION_TYPE Y 33 DISTRIBUTION_NUM 49 EXPENDITURE_ITEM_DATE 48 EXPENDITURE_ORGANIZATION 47 EXPENDITURE_TYPE 2 GROUP_CODE Y 3 HEADER_DESCRIPTION Y 11 ITEM 12 ITEM_DESCRIPTION Y 13 ITEM_REVISION 9 LINE_NUM 10 LINE_TYPE Y 18 NEED_BY_DATE Y 28 NOTE_TO_BUYER 44 PROJECT_ACCOUNTING 45 PROJECT_NUMBER 16 QUANTITY Y 19 REFERENCE_NUMBER 1 REQUISITION_NUMBER 21 SOURCE_ORGANIZATION 22 SOURCE_SUBINVENTORY 20 SOURCE_TYPE Y 23 SUPPLIER 25 SUPPLIER_CONTACT 26 SUPPLIER_ITEM 24 SUPPLIER_SITE 46 TASK_NUMBER 15 UNIT_OF_MEASURE Y 17 UNIT_PRICE Y Group By All Requisition Type PURCHASE Upload Mode C S Site 5EC7C403E55F779E75DF724B8A99DD5A Create Purchase Requisition (with attachment) ASHISH.SAKLANI 50 ATTACHMENT_CATEGORY_ 54 ATTACHMENT_CONTENT_ 52 ATTACHMENT_DESCRIPTION_ 55 ATTACHMENT_FILE_ID_ 51 ATTACHMENT_TITLE_ 53 ATTACHMENT_TYPE_ 27 BUYER 14 CATEGORY Y 34 CHARGE_ACCOUNT_SEGMENT1 43 CHARGE_ACCOUNT_SEGMENT10 35 CHARGE_ACCOUNT_SEGMENT2 36 CHARGE_ACCOUNT_SEGMENT3 37 CHARGE_ACCOUNT_SEGMENT4 38 CHARGE_ACCOUNT_SEGMENT5 39 CHARGE_ACCOUNT_SEGMENT6 40 CHARGE_ACCOUNT_SEGMENT7 41 CHARGE_ACCOUNT_SEGMENT8 42 CHARGE_ACCOUNT_SEGMENT9 31 CONVERSION_DATE 32 CONVERSION_RATE 30 CONVERSION_TYPE 29 CURRENCY 8 DELIVER_TO_LOCATION Y 5 DELIVER_TO_REQUESTOR Y 6 DESTINATION_ORGANIZATION Y 7 DESTINATION_SUBINVENTORY 4 DESTINATION_TYPE Y 33 DISTRIBUTION_NUM 49 EXPENDITURE_ITEM_DATE 48 EXPENDITURE_ORGANIZATION 47 EXPENDITURE_TYPE 2 GROUP_CODE 3 HEADER_DESCRIPTION Y 11 ITEM 12 ITEM_DESCRIPTION Y 13 ITEM_REVISION 9 LINE_NUM 10 LINE_TYPE Y 18 NEED_BY_DATE Y 28 NOTE_TO_BUYER 44 PROJECT_ACCOUNTING 45 PROJECT_NUMBER 16 QUANTITY Y 19 REFERENCE_NUMBER 1 REQUISITION_NUMBER 21 SOURCE_ORGANIZATION 22 SOURCE_SUBINVENTORY 20 SOURCE_TYPE Y 23 SUPPLIER 25 SUPPLIER_CONTACT 26 SUPPLIER_ITEM 24 SUPPLIER_SITE 46 TASK_NUMBER 15 UNIT_OF_MEASURE Y 17 UNIT_PRICE Y Group By All Requisition Type PURCHASE Upload Mode C S Site SYSADMIN 1AB7ABF99F1D7671BB463FA9FA9CDD3A ENGINATICS 1AB7ABF99F1D7671BB463FA9FA9CDD3A ALEXANDER.PAVLIK 1AB7ABF99F1D7671BB463FA9FA9CDD3A ASHISH.SAKLANI 5EC7C403E55F779E75DF724B8A99DD5A ERIC.CLEGG A83FFFB2F755AD37F501F9D746C60C49 ANDY.HAACK 1AB7ABF99F1D7671BB463FA9FA9CDD3A NITIN JAIN 1AB7ABF99F1D7671BB463FA9FA9CDD3A PIYUSH.KHANDELWAL 1AB7ABF99F1D7671BB463FA9FA9CDD3A MRUGESH.POOJARY 5EC7C403E55F779E75DF724B8A99DD5A 1AB7ABF99F1D7671BB463FA9FA9CDD3A 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 REQUEST_ID_ Char varchar2 Y Y 5 MODIFIED_COLUMNS_ Char varchar2 Y 6 ROW_ID Char varchar2 Y Y 7 GROUP_CODE Char varchar2 On new rows, enter a value based on which lines will be grouped into a Requisition Y Y 8 CREATION_DATE Date date 9 REQUISITION_HEADER_ID Number number Y Y 10 REQUISITION_NUMBER Char varchar2 20 Y Y 11 PREPARER LOV varchar2 240 PO Requestor (active) DD37AB84248C178DE0530100007FABF1 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 Y 12 NOTE_TO_AUTHORIZER Char varchar2 13 HEADER_DESCRIPTION Char varchar2 240 14 HEADER_ATTRIBUTE_CATEGORY LOV custom varchar2 select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id = fdfv.application_id and fdfcv.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfcv.enabled_flag = 'Y' and fdfv.application_id = 201 and fdfv.descriptive_flexfield_name = 'PO_REQUISITION_HEADERS' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 15 HEADER_ATTRIBUTE1 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_HEADERS', p_context_name => :$column$.header_attribute_category, 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_REQUISITION_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE1' 16 HEADER_ATTRIBUTE2 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_HEADERS', p_context_name => :$column$.header_attribute_category, 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_REQUISITION_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE2' 17 HEADER_ATTRIBUTE3 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_HEADERS', p_context_name => :$column$.header_attribute_category, 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_REQUISITION_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE3' 18 HEADER_ATTRIBUTE4 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_HEADERS', p_context_name => :$column$.header_attribute_category, 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_REQUISITION_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE4' 19 HEADER_ATTRIBUTE5 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_HEADERS', p_context_name => :$column$.header_attribute_category, 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_REQUISITION_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE5' 20 HEADER_ATTRIBUTE6 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_HEADERS', p_context_name => :$column$.header_attribute_category, 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_REQUISITION_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE6' 21 HEADER_ATTRIBUTE7 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_HEADERS', p_context_name => :$column$.header_attribute_category, 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_REQUISITION_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE7' 22 HEADER_ATTRIBUTE8 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_HEADERS', p_context_name => :$column$.header_attribute_category, 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_REQUISITION_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE8' 23 HEADER_ATTRIBUTE9 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_HEADERS', p_context_name => :$column$.header_attribute_category, 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_REQUISITION_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE9' 24 HEADER_ATTRIBUTE10 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_HEADERS', p_context_name => :$column$.header_attribute_category, 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_REQUISITION_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE10' 25 HEADER_ATTRIBUTE11 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_HEADERS', p_context_name => :$column$.header_attribute_category, 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_REQUISITION_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE11' 26 HEADER_ATTRIBUTE12 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_HEADERS', p_context_name => :$column$.header_attribute_category, 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_REQUISITION_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE12' 27 HEADER_ATTRIBUTE13 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_HEADERS', p_context_name => :$column$.header_attribute_category, 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_REQUISITION_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE13' 28 HEADER_ATTRIBUTE14 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_HEADERS', p_context_name => :$column$.header_attribute_category, 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_REQUISITION_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE14' 29 HEADER_ATTRIBUTE15 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_HEADERS', p_context_name => :$column$.header_attribute_category, 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_REQUISITION_HEADERS' and fdfcuv.application_column_name = 'ATTRIBUTE15' 30 REQUISITION_LINE_ID Number number Y Y 31 LINE_NUM Number number Y 32 LINE_TYPE LOV varchar2 25 PO Requisition Line Type DD8B0AA9AE7A4B64E0530100007FB3B0 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 Y Y 33 DESTINATION_TYPE LOV varchar2 80 PO Requisition Destination Type E0E902FE6FE5309CE0530100007F091E select plc.lookup_code id, plc.displayed_field value, plc.displayed_field description from po_lookup_codes plc where plc.lookup_type='DESTINATION TYPE' order by value select plc.lookup_code id, plc.displayed_field value, plc.displayed_field description from po_lookup_codes plc where plc.lookup_type='DESTINATION TYPE' Y Y 34 DESTINATION_ORGANIZATION LOV varchar2 3 PO Requisition Deliver To Organization DEDE5D48397D1326E0530100007F5A29 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) Y Y 35 DESTINATION_SUBINVENTORY LOV varchar2 10 PO Requisition Destination Subinventory EA972A718AD3530EE0530100007F1911 select msi.secondary_inventory_name id, msi.secondary_inventory_name value, msi.secondary_inventory_name description, null lov from mtl_secondary_inventories msi, org_organization_definitions ood where msi.organization_id=ood.organization_id and ood.organization_code=:$column$.destination_organization order by msi.secondary_inventory_name 36 DELIVER_TO_LOCATION LOV varchar2 60 PO Requisition Deliver To Location (active) 3975A844BE25FC26E0630100007F5868 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 trunc(nvl(hl.inactive_date,sysdate+1))>trunc(sysdate) and nvl(hl.business_group_id,nvl(hr_general.get_business_group_id,-99)) = nvl(hr_general.get_business_group_id,-99) and (hl.inventory_organization_id is null or mp.organization_code=:$column$.destination_organization or :$column$.destination_organization is null) order by value Y Y 37 DELIVER_TO_REQUESTOR LOV varchar2 240 PO Requestor (active) DD37AB84248C178DE0530100007FABF1 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 Y Y 38 SOURCE_TYPE LOV varchar2 80 PO Requisition Source Type E916F60CF0DE3AB6E0530100007F7147 select plc.lookup_code id, plc.displayed_field value, plc.displayed_field description from po_lookup_codes plc where plc.lookup_type='REQUISITION SOURCE TYPE' order by value select plc.lookup_code id, plc.displayed_field value, plc.displayed_field description from po_lookup_codes plc where plc.lookup_type='REQUISITION SOURCE TYPE' Y Y 39 SOURCE_ORGANIZATION LOV varchar2 3 PO Requisition Source Organization E916F60CF0DF3AB6E0530100007F7147 select ood.organization_id id, ood.organization_code value, ood.organization_code||'-'||ood.organization_name description from org_organization_definitions ood where trunc(nvl(ood.disable_date, sysdate+1))>trunc(sysdate) and ood.inventory_enabled_flag='Y' and :$column$.source_type = xxen_util.meaning('INVENTORY','REQUISITION SOURCE TYPE',201) Y 40 SOURCE_SUBINVENTORY LOV varchar2 10 PO Requisition Source Subinventory EA95342AA01D35ACE0530100007FB4A2 select msi.secondary_inventory_name id, msi.secondary_inventory_name value, msi.secondary_inventory_name description from mtl_secondary_inventories msi, org_organization_definitions ood where msi.organization_id=ood.organization_id and ood.organization_code=:$column$.source_organization order by value 41 ITEM LOV varchar2 40 PO Requisition Item DD77801CEAD916AAE0530100007FF8DC 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 Y 42 ITEM_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 Y Y 43 ITEM_REVISION LOV custom varchar2 3 select mir.revision value, mir.description from mtl_system_items_vl msiv, mtl_parameters mp, mtl_item_revisions_b mir where mp.organization_code = :$column$.destination_organization and mp.organization_id = msiv.organization_id and msiv.concatenated_segments=:$column$.item and msiv.inventory_item_id=mir.inventory_item_id and msiv.organization_id=mir.organization_id and mir.effectivity_date = (select max(mir2.effectivity_date) from mtl_item_revisions_b mir2 where mir2.organization_id = msiv.organization_id and mir2.inventory_item_id = msiv.inventory_item_id) Y 44 CATEGORY LOV varchar2 163 PO Requisition Item Category E07146A84D3F1AACE0530100007F467B 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' ) select mcv.category_id id, mcv.category_concat_segs value from mtl_categories_v mcv, mtl_category_sets mcs where mcv.structure_id=mcs.structure_id and mcs.category_set_id=(select mdcs.category_set_id from mtl_default_category_sets mdcs where mdcs.functional_area_id=2) Y Y 45 UNIT_OF_MEASURE LOV varchar2 25 PO Requisition Item UOM DD77801CEADA16AAE0530100007FF8DC 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 ) ) Y Y 46 QUANTITY Number number Y 47 UNIT_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 and :$column$.currency_unit_price is null 48 NEED_BY_DATE Date date Y 49 REFERENCE_NUMBER Char varchar2 25 50 SUPPLIER LOV varchar2 240 PO Requisition Vendor DD2EF3BCFE9045B3E0530100007F1BC2 select aps.vendor_id id, aps.vendor_name value, aps.vendor_name||'-'||aps.segment1 description from ap_suppliers aps where exists(select 1 from ap_supplier_sites_all assa,hr_all_organization_units_vl haouv where assa.org_id=haouv.organization_id and haouv.name=:$flex$.operating_unit and assa.vendor_id=aps.vendor_id and assa.purchasing_site_flag='Y') and :$column$.source_type = xxen_util.meaning('VENDOR','REQUISITION SOURCE TYPE',201) Y 51 SUPPLIER_SITE LOV varchar2 240 PO Requisition Vendor Sites DD2EF3BCFE9145B3E0530100007F1BC2 select assa.vendor_site_id id, assa.vendor_site_code value, assa.vendor_site_code description from ap_supplier_sites_all assa, ap_suppliers aps, hr_all_organization_units_vl haouv where assa.vendor_id=aps.vendor_id and aps.vendor_name=:$column$.supplier and assa.purchasing_site_flag='Y' and assa.org_id=haouv.organization_id and haouv.name=:$flex$.operating_unit order by value Y 52 SUPPLIER_CONTACT LOV varchar2 150 PO Requisition Vendor Contact DEDE5D48397F1326E0530100007F5A29 select apc.vendor_contact_id id, apc.last_name||', '||apc.first_name value, apc.last_name||', '||apc.first_name description from ap_supplier_contacts apc, ap_supplier_sites_all assa where apc.vendor_site_id=assa.vendor_site_id and assa.vendor_site_code=:$column$.supplier_site and rtrim(apc.last_name || apc.first_name) is not null order by value Y 53 SUPPLIER_ITEM Char varchar2 25 54 BUYER LOV varchar2 240 PO Buyer 8E2FF36EDF2F79D2E0530100007F1FF2 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 select pa.agent_id id, papf.full_name value from po_agents pa, per_all_people_f papf where papf.person_id=pa.agent_id and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date 55 NOTE_TO_BUYER Char varchar2 480 56 CURRENCY LOV varchar2 15 FND Currency Codes DD3BDFF9582F51D0E0530100007FEDB0 select fct.currency_code id, fct.currency_code value, fct.description from fnd_currencies_tl fct where fct.source_lang=userenv('LANG') order by fct.currency_code 57 CONVERSION_TYPE LOV varchar2 30 GL Currency Conversion Type 91D3167A335F1204E053BB6B63585EE3 select gdct.conversion_type id, gdct.user_conversion_type value, gdct.description from gl_daily_conversion_types gdct order by gdct.user_conversion_type Only required for non-functional currencies 58 CONVERSION_DATE Date date Only required for non-functional currencies 59 CONVERSION_RATE Number number select gdr.conversion_rate from gl_ledgers gl, gl_daily_conversion_types gdct, gl_daily_rates gdr where gl.name=:$flex$.ledger and gdct.user_conversion_type=:$column$.conversion_type and gdr.from_currency=:$column$.currency and gdr.to_currency=gl.currency_code and gdr.conversion_type=gdct.conversion_type and gdr.conversion_date=trunc(nvl(:$column$.conversion_date,sysdate)) and :$column$.currency<>gl.currency_code and :$column$.conversion_type<>'User' Only required for non-functional currencies 60 CURRENCY_UNIT_PRICE Number number For non-functional currencies only. Optionally enter the foreign currency unit price. This takes precedence over the functional currency unit price. 61 LINE_ATTRIBUTE_CATEGORY LOV custom varchar2 select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id = fdfv.application_id and fdfcv.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfcv.enabled_flag = 'Y' and fdfv.application_id = 201 and fdfv.descriptive_flexfield_name = 'PO_REQUISITION_LINES' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 62 LINE_ATTRIBUTE1 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_LINES', p_context_name => :$column$.line_attribute_category, 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_REQUISITION_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE1' 63 LINE_ATTRIBUTE2 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_LINES', p_context_name => :$column$.line_attribute_category, 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_REQUISITION_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE2' 64 LINE_ATTRIBUTE3 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_LINES', p_context_name => :$column$.line_attribute_category, 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_REQUISITION_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE3' 65 LINE_ATTRIBUTE4 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_LINES', p_context_name => :$column$.line_attribute_category, 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_REQUISITION_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE4' 66 LINE_ATTRIBUTE5 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_LINES', p_context_name => :$column$.line_attribute_category, 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_REQUISITION_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE5' 67 LINE_ATTRIBUTE6 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_LINES', p_context_name => :$column$.line_attribute_category, 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_REQUISITION_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE6' 68 LINE_ATTRIBUTE7 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_LINES', p_context_name => :$column$.line_attribute_category, 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_REQUISITION_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE7' 69 LINE_ATTRIBUTE8 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_LINES', p_context_name => :$column$.line_attribute_category, 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_REQUISITION_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE8' 70 LINE_ATTRIBUTE9 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_LINES', p_context_name => :$column$.line_attribute_category, 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_REQUISITION_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE9' 71 LINE_ATTRIBUTE10 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_LINES', p_context_name => :$column$.line_attribute_category, 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_REQUISITION_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE10' 72 LINE_ATTRIBUTE11 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_LINES', p_context_name => :$column$.line_attribute_category, 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_REQUISITION_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE11' 73 LINE_ATTRIBUTE12 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_LINES', p_context_name => :$column$.line_attribute_category, 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_REQUISITION_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE12' 74 LINE_ATTRIBUTE13 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_LINES', p_context_name => :$column$.line_attribute_category, 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_REQUISITION_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE13' 75 LINE_ATTRIBUTE14 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_LINES', p_context_name => :$column$.line_attribute_category, 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_REQUISITION_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE14' 76 LINE_ATTRIBUTE15 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQUISITION_LINES', p_context_name => :$column$.line_attribute_category, 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_REQUISITION_LINES' and fdfcuv.application_column_name = 'ATTRIBUTE15' 77 DISTRIBUTION_ID Number number Y Y 78 DISTRIBUTION_NUM Number number Y 79 CHARGE_ACCOUNT_SEGMENT1 LOV varchar2 25 GL Journal Segment 1 DE3CC97BB32D69CCE0530100007F0E9D select substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1) id, substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value, substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description from ( select /*+ no_merge*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl,hr_operating_units hou,hr_all_organization_units_vl haouv where gl.ledger_id=hou.set_of_books_id and haouv.name=:$flex$.operating_unit and haouv.organization_id=hou.organization_id) ) s, table(xxen_util.kff_segment_lov( p_application_id=>101, p_id_flex_code=>'GL#', p_id_flex_num=>s.id_flex_num, p_application_column_name=>'SEGMENT1' )) l order by 2 select distinct fifsv.form_left_prompt value from fnd_id_flex_segments_vl fifsv, gl_ledgers gl where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num =gl.chart_of_accounts_id and gl.name=:$flex$.ledger and fifsv.application_column_name ='SEGMENT1' Y 80 CHARGE_ACCOUNT_SEGMENT2 LOV varchar2 25 GL Journal Segment 2 DE3CC97BB32E69CCE0530100007F0E9D select substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1) id, substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value, substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description from ( select /*+ no_merge*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl,hr_operating_units hou,hr_all_organization_units_vl haouv where gl.ledger_id=hou.set_of_books_id and haouv.name=:$flex$.operating_unit and haouv.organization_id=hou.organization_id) ) s, table(xxen_util.kff_segment_lov( p_application_id=>101, p_id_flex_code=>'GL#', p_id_flex_num=>s.id_flex_num, p_application_column_name=>'SEGMENT2' )) l order by 2 select distinct fifsv.form_left_prompt value from fnd_id_flex_segments_vl fifsv, gl_ledgers gl where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num =gl.chart_of_accounts_id and gl.name=:$flex$.ledger and fifsv.application_column_name ='SEGMENT2' Y 81 CHARGE_ACCOUNT_SEGMENT3 LOV varchar2 25 GL Journal Segment 3 DE3CC97BB32F69CCE0530100007F0E9D select substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1) id, substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value, substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description from ( select /*+ no_merge*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl,hr_operating_units hou,hr_all_organization_units_vl haouv where gl.ledger_id=hou.set_of_books_id and haouv.name=:$flex$.operating_unit and haouv.organization_id=hou.organization_id) ) s, table(xxen_util.kff_segment_lov( p_application_id=>101, p_id_flex_code=>'GL#', p_id_flex_num=>s.id_flex_num, p_application_column_name=>'SEGMENT3' )) l order by 2 select distinct fifsv.form_left_prompt value from fnd_id_flex_segments_vl fifsv, gl_ledgers gl where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num =gl.chart_of_accounts_id and gl.name=:$flex$.ledger and fifsv.application_column_name ='SEGMENT3' Y 82 CHARGE_ACCOUNT_SEGMENT4 LOV varchar2 25 GL Journal Segment 4 DE3CC97BB33069CCE0530100007F0E9D select substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1) id, substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value, substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description from ( select /*+ no_merge*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl,hr_operating_units hou,hr_all_organization_units_vl haouv where gl.ledger_id=hou.set_of_books_id and haouv.name=:$flex$.operating_unit and haouv.organization_id=hou.organization_id) ) s, table(xxen_util.kff_segment_lov( p_application_id=>101, p_id_flex_code=>'GL#', p_id_flex_num=>s.id_flex_num, p_application_column_name=>'SEGMENT4' )) l order by 2 select distinct fifsv.form_left_prompt value from fnd_id_flex_segments_vl fifsv, gl_ledgers gl where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num =gl.chart_of_accounts_id and gl.name=:$flex$.ledger and fifsv.application_column_name ='SEGMENT4' Y 83 CHARGE_ACCOUNT_SEGMENT5 LOV varchar2 25 GL Journal Segment 5 DE3CC97BB33169CCE0530100007F0E9D select substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1) id, substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value, substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description from ( select /*+ no_merge*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl,hr_operating_units hou,hr_all_organization_units_vl haouv where gl.ledger_id=hou.set_of_books_id and haouv.name=:$flex$.operating_unit and haouv.organization_id=hou.organization_id) ) s, table(xxen_util.kff_segment_lov( p_application_id=>101, p_id_flex_code=>'GL#', p_id_flex_num=>s.id_flex_num, p_application_column_name=>'SEGMENT5' )) l order by 2 select distinct fifsv.form_left_prompt value from fnd_id_flex_segments_vl fifsv, gl_ledgers gl where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num =gl.chart_of_accounts_id and gl.name=:$flex$.ledger and fifsv.application_column_name ='SEGMENT5' Y 84 CHARGE_ACCOUNT_SEGMENT6 LOV varchar2 25 GL Journal Segment 6 DEC9ED99A17A5BE8E0530100007FC601 select substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1) id, substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value, substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description from ( select /*+ no_merge*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl,hr_operating_units hou,hr_all_organization_units_vl haouv where gl.ledger_id=hou.set_of_books_id and haouv.name=:$flex$.operating_unit and haouv.organization_id=hou.organization_id) ) s, table(xxen_util.kff_segment_lov( p_application_id=>101, p_id_flex_code=>'GL#', p_id_flex_num=>s.id_flex_num, p_application_column_name=>'SEGMENT6' )) l order by 2 select distinct fifsv.form_left_prompt value from fnd_id_flex_segments_vl fifsv, gl_ledgers gl where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num =gl.chart_of_accounts_id and gl.name=:$flex$.ledger and fifsv.application_column_name ='SEGMENT6' Y 85 CHARGE_ACCOUNT_SEGMENT7 LOV varchar2 25 GL Journal Segment 7 DEC9ED99A17C5BE8E0530100007FC601 select substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1) id, substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value, substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description from ( select /*+ no_merge*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl,hr_operating_units hou,hr_all_organization_units_vl haouv where gl.ledger_id=hou.set_of_books_id and haouv.name=:$flex$.operating_unit and haouv.organization_id=hou.organization_id) ) s, table(xxen_util.kff_segment_lov( p_application_id=>101, p_id_flex_code=>'GL#', p_id_flex_num=>s.id_flex_num, p_application_column_name=>'SEGMENT7' )) l order by 2 select distinct fifsv.form_left_prompt value from fnd_id_flex_segments_vl fifsv, gl_ledgers gl where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num =gl.chart_of_accounts_id and gl.name=:$flex$.ledger and fifsv.application_column_name ='SEGMENT7' Y 86 CHARGE_ACCOUNT_SEGMENT8 LOV varchar2 25 GL Journal Segment 8 DEC9ED99A17B5BE8E0530100007FC601 select substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1) id, substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value, substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description from ( select /*+ no_merge*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl,hr_operating_units hou,hr_all_organization_units_vl haouv where gl.ledger_id=hou.set_of_books_id and haouv.name=:$flex$.operating_unit and haouv.organization_id=hou.organization_id) ) s, table(xxen_util.kff_segment_lov( p_application_id=>101, p_id_flex_code=>'GL#', p_id_flex_num=>s.id_flex_num, p_application_column_name=>'SEGMENT8' )) l order by 2 select distinct fifsv.form_left_prompt value from fnd_id_flex_segments_vl fifsv, gl_ledgers gl where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num =gl.chart_of_accounts_id and gl.name=:$flex$.ledger and fifsv.application_column_name ='SEGMENT8' Y 87 CHARGE_ACCOUNT_SEGMENT9 LOV varchar2 25 GL Journal Segment 9 DEC9ED99A17D5BE8E0530100007FC601 select substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1) id, substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value, substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description from ( select /*+ no_merge*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl,hr_operating_units hou,hr_all_organization_units_vl haouv where gl.ledger_id=hou.set_of_books_id and haouv.name=:$flex$.operating_unit and haouv.organization_id=hou.organization_id) ) s, table(xxen_util.kff_segment_lov( p_application_id=>101, p_id_flex_code=>'GL#', p_id_flex_num=>s.id_flex_num, p_application_column_name=>'SEGMENT9' )) l order by 2 select distinct fifsv.form_left_prompt value from fnd_id_flex_segments_vl fifsv, gl_ledgers gl where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num =gl.chart_of_accounts_id and gl.name=:$flex$.ledger and fifsv.application_column_name ='SEGMENT9' Y 88 CHARGE_ACCOUNT_SEGMENT10 LOV varchar2 25 GL Journal Segment 10 DEC9ED99A1795BE8E0530100007FC601 select substrb(l.column_value,1,instrb(l.column_value,'~',1,1)-1) id, substrb(l.column_value,instrb(l.column_value,'~',1,1)+1,instrb(l.column_value,'~',1,2)-instrb(l.column_value,'~',1,1)-1) value, substrb(l.column_value,instrb(l.column_value,'~',1,2)+1) description from ( select /*+ no_merge*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num in (select gl.chart_of_accounts_id from gl_ledgers gl,hr_operating_units hou,hr_all_organization_units_vl haouv where gl.ledger_id=hou.set_of_books_id and haouv.name=:$flex$.operating_unit and haouv.organization_id=hou.organization_id) ) s, table(xxen_util.kff_segment_lov( p_application_id=>101, p_id_flex_code=>'GL#', p_id_flex_num=>s.id_flex_num, p_application_column_name=>'SEGMENT10' )) l order by 2 select distinct fifsv.form_left_prompt value from fnd_id_flex_segments_vl fifsv, gl_ledgers gl where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num =gl.chart_of_accounts_id and gl.name=:$flex$.ledger and fifsv.application_column_name ='SEGMENT10' Y 89 PROJECT_ACCOUNTING LOV Oracle varchar2 30 Yes_No select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Project Accounting Y 90 PROJECT_NUMBER LOV varchar2 25 PO Project DEC9ED99A17F5BE8E0530100007FC601 select ppev.project_id id, ppev.project_number value, ppev.project_name description from pa_projects_expend_v ppev Required only if Project Accounting is Yes Y 91 TASK_NUMBER LOV varchar2 25 PO Project Task DEC9ED99A1805BE8E0530100007FC601 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 Required only if Project Accounting is Y Y 92 EXPENDITURE_TYPE LOV varchar2 30 PO Requisition Expenditure Type E05E7FE830055F46E0530100007FED24 select petev.expenditure_type id, petev.expenditure_type value, petev.description from pa_expenditure_types_expend_v petev where petev.system_linkage_function='VI' and trunc(petev.expnd_typ_start_date_active)<=trunc(sysdate) and trunc(nvl(petev.expnd_typ_end_date_active,sysdate))>=trunc(sysdate) Required only if Project Accounting is Y Y 93 EXPENDITURE_ORGANIZATION LOV varchar2 240 PO Requisition Expenditure Organization E05E7FE830045F46E0530100007FED24 select hou.organization_id id, hou.name value, hou.name description from hr_organization_units hou, pa_all_organizations pao, hr_all_organization_units_vl haouv where pao.organization_id=hou.organization_id and pao.pa_org_use_type='EXPENDITURES' and pao.inactive_date is null and pao.org_id=haouv.organization_id and haouv.name=:$flex$.operating_unit select hou.organization_id id, hou.name value from hr_organization_units hou Required only if Project Accounting is Y Y 94 EXPENDITURE_ITEM_DATE Date date Required only if Project Accounting is Y Y 95 DIST_ATTRIBUTE_CATEGORY LOV custom varchar2 select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id = fdfv.application_id and fdfcv.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfcv.enabled_flag = 'Y' and fdfv.application_id = 201 and fdfv.descriptive_flexfield_name = 'PO_REQ_DISTRIBUTIONS' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 96 DIST_ATTRIBUTE1 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQ_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.dist_attribute1, p_attribute2 => :$column$.dist_attribute2, p_attribute3 => :$column$.dist_attribute3, p_attribute4 => :$column$.dist_attribute4, p_attribute5 => :$column$.dist_attribute5, p_attribute6 => :$column$.dist_attribute6, p_attribute7 => :$column$.dist_attribute7, p_attribute8 => :$column$.dist_attribute8, p_attribute9 => :$column$.dist_attribute9, p_attribute10 => :$column$.dist_attribute10, p_attribute11 => :$column$.dist_attribute11, p_attribute12 => :$column$.dist_attribute12, p_attribute13 => :$column$.dist_attribute13, p_attribute14 => :$column$.dist_attribute14, p_attribute15 => :$column$.dist_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_REQ_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE1' 97 DIST_ATTRIBUTE2 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQ_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.dist_attribute1, p_attribute2 => :$column$.dist_attribute2, p_attribute3 => :$column$.dist_attribute3, p_attribute4 => :$column$.dist_attribute4, p_attribute5 => :$column$.dist_attribute5, p_attribute6 => :$column$.dist_attribute6, p_attribute7 => :$column$.dist_attribute7, p_attribute8 => :$column$.dist_attribute8, p_attribute9 => :$column$.dist_attribute9, p_attribute10 => :$column$.dist_attribute10, p_attribute11 => :$column$.dist_attribute11, p_attribute12 => :$column$.dist_attribute12, p_attribute13 => :$column$.dist_attribute13, p_attribute14 => :$column$.dist_attribute14, p_attribute15 => :$column$.dist_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_REQ_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE2' 98 DIST_ATTRIBUTE3 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQ_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.dist_attribute1, p_attribute2 => :$column$.dist_attribute2, p_attribute3 => :$column$.dist_attribute3, p_attribute4 => :$column$.dist_attribute4, p_attribute5 => :$column$.dist_attribute5, p_attribute6 => :$column$.dist_attribute6, p_attribute7 => :$column$.dist_attribute7, p_attribute8 => :$column$.dist_attribute8, p_attribute9 => :$column$.dist_attribute9, p_attribute10 => :$column$.dist_attribute10, p_attribute11 => :$column$.dist_attribute11, p_attribute12 => :$column$.dist_attribute12, p_attribute13 => :$column$.dist_attribute13, p_attribute14 => :$column$.dist_attribute14, p_attribute15 => :$column$.dist_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_REQ_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE3' 99 DIST_ATTRIBUTE4 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQ_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.dist_attribute1, p_attribute2 => :$column$.dist_attribute2, p_attribute3 => :$column$.dist_attribute3, p_attribute4 => :$column$.dist_attribute4, p_attribute5 => :$column$.dist_attribute5, p_attribute6 => :$column$.dist_attribute6, p_attribute7 => :$column$.dist_attribute7, p_attribute8 => :$column$.dist_attribute8, p_attribute9 => :$column$.dist_attribute9, p_attribute10 => :$column$.dist_attribute10, p_attribute11 => :$column$.dist_attribute11, p_attribute12 => :$column$.dist_attribute12, p_attribute13 => :$column$.dist_attribute13, p_attribute14 => :$column$.dist_attribute14, p_attribute15 => :$column$.dist_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_REQ_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE4' 100 DIST_ATTRIBUTE5 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQ_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.dist_attribute1, p_attribute2 => :$column$.dist_attribute2, p_attribute3 => :$column$.dist_attribute3, p_attribute4 => :$column$.dist_attribute4, p_attribute5 => :$column$.dist_attribute5, p_attribute6 => :$column$.dist_attribute6, p_attribute7 => :$column$.dist_attribute7, p_attribute8 => :$column$.dist_attribute8, p_attribute9 => :$column$.dist_attribute9, p_attribute10 => :$column$.dist_attribute10, p_attribute11 => :$column$.dist_attribute11, p_attribute12 => :$column$.dist_attribute12, p_attribute13 => :$column$.dist_attribute13, p_attribute14 => :$column$.dist_attribute14, p_attribute15 => :$column$.dist_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_REQ_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE5' 101 DIST_ATTRIBUTE6 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQ_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.dist_attribute1, p_attribute2 => :$column$.dist_attribute2, p_attribute3 => :$column$.dist_attribute3, p_attribute4 => :$column$.dist_attribute4, p_attribute5 => :$column$.dist_attribute5, p_attribute6 => :$column$.dist_attribute6, p_attribute7 => :$column$.dist_attribute7, p_attribute8 => :$column$.dist_attribute8, p_attribute9 => :$column$.dist_attribute9, p_attribute10 => :$column$.dist_attribute10, p_attribute11 => :$column$.dist_attribute11, p_attribute12 => :$column$.dist_attribute12, p_attribute13 => :$column$.dist_attribute13, p_attribute14 => :$column$.dist_attribute14, p_attribute15 => :$column$.dist_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_REQ_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE6' 102 DIST_ATTRIBUTE7 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQ_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.dist_attribute1, p_attribute2 => :$column$.dist_attribute2, p_attribute3 => :$column$.dist_attribute3, p_attribute4 => :$column$.dist_attribute4, p_attribute5 => :$column$.dist_attribute5, p_attribute6 => :$column$.dist_attribute6, p_attribute7 => :$column$.dist_attribute7, p_attribute8 => :$column$.dist_attribute8, p_attribute9 => :$column$.dist_attribute9, p_attribute10 => :$column$.dist_attribute10, p_attribute11 => :$column$.dist_attribute11, p_attribute12 => :$column$.dist_attribute12, p_attribute13 => :$column$.dist_attribute13, p_attribute14 => :$column$.dist_attribute14, p_attribute15 => :$column$.dist_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_REQ_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE7' 103 DIST_ATTRIBUTE8 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQ_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.dist_attribute1, p_attribute2 => :$column$.dist_attribute2, p_attribute3 => :$column$.dist_attribute3, p_attribute4 => :$column$.dist_attribute4, p_attribute5 => :$column$.dist_attribute5, p_attribute6 => :$column$.dist_attribute6, p_attribute7 => :$column$.dist_attribute7, p_attribute8 => :$column$.dist_attribute8, p_attribute9 => :$column$.dist_attribute9, p_attribute10 => :$column$.dist_attribute10, p_attribute11 => :$column$.dist_attribute11, p_attribute12 => :$column$.dist_attribute12, p_attribute13 => :$column$.dist_attribute13, p_attribute14 => :$column$.dist_attribute14, p_attribute15 => :$column$.dist_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_REQ_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE8' 104 DIST_ATTRIBUTE9 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQ_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.dist_attribute1, p_attribute2 => :$column$.dist_attribute2, p_attribute3 => :$column$.dist_attribute3, p_attribute4 => :$column$.dist_attribute4, p_attribute5 => :$column$.dist_attribute5, p_attribute6 => :$column$.dist_attribute6, p_attribute7 => :$column$.dist_attribute7, p_attribute8 => :$column$.dist_attribute8, p_attribute9 => :$column$.dist_attribute9, p_attribute10 => :$column$.dist_attribute10, p_attribute11 => :$column$.dist_attribute11, p_attribute12 => :$column$.dist_attribute12, p_attribute13 => :$column$.dist_attribute13, p_attribute14 => :$column$.dist_attribute14, p_attribute15 => :$column$.dist_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_REQ_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE9' 105 DIST_ATTRIBUTE10 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQ_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.dist_attribute1, p_attribute2 => :$column$.dist_attribute2, p_attribute3 => :$column$.dist_attribute3, p_attribute4 => :$column$.dist_attribute4, p_attribute5 => :$column$.dist_attribute5, p_attribute6 => :$column$.dist_attribute6, p_attribute7 => :$column$.dist_attribute7, p_attribute8 => :$column$.dist_attribute8, p_attribute9 => :$column$.dist_attribute9, p_attribute10 => :$column$.dist_attribute10, p_attribute11 => :$column$.dist_attribute11, p_attribute12 => :$column$.dist_attribute12, p_attribute13 => :$column$.dist_attribute13, p_attribute14 => :$column$.dist_attribute14, p_attribute15 => :$column$.dist_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_REQ_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE10' 106 DIST_ATTRIBUTE11 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQ_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.dist_attribute1, p_attribute2 => :$column$.dist_attribute2, p_attribute3 => :$column$.dist_attribute3, p_attribute4 => :$column$.dist_attribute4, p_attribute5 => :$column$.dist_attribute5, p_attribute6 => :$column$.dist_attribute6, p_attribute7 => :$column$.dist_attribute7, p_attribute8 => :$column$.dist_attribute8, p_attribute9 => :$column$.dist_attribute9, p_attribute10 => :$column$.dist_attribute10, p_attribute11 => :$column$.dist_attribute11, p_attribute12 => :$column$.dist_attribute12, p_attribute13 => :$column$.dist_attribute13, p_attribute14 => :$column$.dist_attribute14, p_attribute15 => :$column$.dist_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_REQ_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE11' 107 DIST_ATTRIBUTE12 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQ_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.dist_attribute1, p_attribute2 => :$column$.dist_attribute2, p_attribute3 => :$column$.dist_attribute3, p_attribute4 => :$column$.dist_attribute4, p_attribute5 => :$column$.dist_attribute5, p_attribute6 => :$column$.dist_attribute6, p_attribute7 => :$column$.dist_attribute7, p_attribute8 => :$column$.dist_attribute8, p_attribute9 => :$column$.dist_attribute9, p_attribute10 => :$column$.dist_attribute10, p_attribute11 => :$column$.dist_attribute11, p_attribute12 => :$column$.dist_attribute12, p_attribute13 => :$column$.dist_attribute13, p_attribute14 => :$column$.dist_attribute14, p_attribute15 => :$column$.dist_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_REQ_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE12' 108 DIST_ATTRIBUTE13 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQ_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.dist_attribute1, p_attribute2 => :$column$.dist_attribute2, p_attribute3 => :$column$.dist_attribute3, p_attribute4 => :$column$.dist_attribute4, p_attribute5 => :$column$.dist_attribute5, p_attribute6 => :$column$.dist_attribute6, p_attribute7 => :$column$.dist_attribute7, p_attribute8 => :$column$.dist_attribute8, p_attribute9 => :$column$.dist_attribute9, p_attribute10 => :$column$.dist_attribute10, p_attribute11 => :$column$.dist_attribute11, p_attribute12 => :$column$.dist_attribute12, p_attribute13 => :$column$.dist_attribute13, p_attribute14 => :$column$.dist_attribute14, p_attribute15 => :$column$.dist_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_REQ_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE13' 109 DIST_ATTRIBUTE14 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQ_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.dist_attribute1, p_attribute2 => :$column$.dist_attribute2, p_attribute3 => :$column$.dist_attribute3, p_attribute4 => :$column$.dist_attribute4, p_attribute5 => :$column$.dist_attribute5, p_attribute6 => :$column$.dist_attribute6, p_attribute7 => :$column$.dist_attribute7, p_attribute8 => :$column$.dist_attribute8, p_attribute9 => :$column$.dist_attribute9, p_attribute10 => :$column$.dist_attribute10, p_attribute11 => :$column$.dist_attribute11, p_attribute12 => :$column$.dist_attribute12, p_attribute13 => :$column$.dist_attribute13, p_attribute14 => :$column$.dist_attribute14, p_attribute15 => :$column$.dist_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_REQ_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE14' 110 DIST_ATTRIBUTE15 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 201, p_descriptive_flexfield_name => 'PO_REQ_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.dist_attribute1, p_attribute2 => :$column$.dist_attribute2, p_attribute3 => :$column$.dist_attribute3, p_attribute4 => :$column$.dist_attribute4, p_attribute5 => :$column$.dist_attribute5, p_attribute6 => :$column$.dist_attribute6, p_attribute7 => :$column$.dist_attribute7, p_attribute8 => :$column$.dist_attribute8, p_attribute9 => :$column$.dist_attribute9, p_attribute10 => :$column$.dist_attribute10, p_attribute11 => :$column$.dist_attribute11, p_attribute12 => :$column$.dist_attribute12, p_attribute13 => :$column$.dist_attribute13, p_attribute14 => :$column$.dist_attribute14, p_attribute15 => :$column$.dist_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_REQ_DISTRIBUTIONS' and fdfcuv.application_column_name = 'ATTRIBUTE15' 111 GROUP_BY Char varchar2 xxen_util.lookup_code(:$flex$.group_by,'REQIMPORT GROUP BY',201) Y 112 INITIATE_REQAPPR_AFTER_IMP Char varchar2 :$flex$.Initiate_Approval_on_Import Y 113 INTERFACE_SOURCE_CODE Char varchar2 IMPORT_REQ Y 114 MULTI_DISTRIBUTIONS Char varchar2 N Y 115 ALLOW_DYNAMIC_CCID Char varchar2 N 116 AUTHORIZATION_STATUS Char varchar2 INCOMPLETE Y 117 PREPARER_ID Char varchar2 Y 118 REQUISITION_TYPE Char varchar2 25 :$flex$.requisition_type Y Y 119 ATTACHMENT_CATEGORY_ LOV custom varchar2 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_POXRQERQ' and fdc.category_id=fdcuv.category_id and nvl(fdc.start_date_active,sysdate-1)<=sysdate and nvl(fdc.end_date_active,sysdate+1)>sysdate order by value Required for adding an attachment 120 ATTACHMENT_TITLE_ Char varchar2 121 ATTACHMENT_DESCRIPTION_ Char varchar2 122 ATTACHMENT_TYPE_ LOV varchar2 FND Attachment Type B9AF5DAEAF9247899FE9F668B4D79A46 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 123 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 124 ATTACHMENT_FILE_ID_ Char varchar2 Autopopulated after clicking on Upload Attachments 125 UPLOAD_ROW Number number Y U 1 action_ in Char ACTION_CODE_ U 2 p_group_code in Char GROUP_CODE U 3 p_requisition_header_id in Number REQUISITION_HEADER_ID U 4 p_requisition_number in Char REQUISITION_NUMBER U 5 p_requisition_type in Char REQUISITION_TYPE U 6 p_authorization_status in Char AUTHORIZATION_STATUS U 7 p_header_description in Char HEADER_DESCRIPTION U 8 p_requisition_line_id in Number REQUISITION_LINE_ID U 9 p_line_number in Number LINE_NUM U 10 p_line_type in Char LINE_TYPE value U 11 p_item in Char ITEM value U 12 p_item_description in Char ITEM_DESCRIPTION U 13 p_item_revision in Char ITEM_REVISION U 14 p_item_category in Number CATEGORY U 15 p_unit_of_measure in Char UNIT_OF_MEASURE U 16 p_quantity in Number QUANTITY U 17 p_unit_price in Number UNIT_PRICE U 18 p_need_by_date in Date NEED_BY_DATE U 19 p_reference_number in Char REFERENCE_NUMBER U 20 p_destination_type in Char DESTINATION_TYPE U 21 p_deliver_to_requestor in Char U 22 p_deliver_to_requestor_id in Number Y DELIVER_TO_REQUESTOR U 23 p_destination_organization in Char DESTINATION_ORGANIZATION value U 24 p_deliver_to_location in Char DELIVER_TO_LOCATION value U 25 p_source_type in Char SOURCE_TYPE U 26 p_supplier in Char SUPPLIER value U 27 p_preparer_id in Number PREPARER U 28 p_supplier_site in Char SUPPLIER_SITE value U 30 p_supplier_contact in Char SUPPLIER_CONTACT value U 31 p_supplier_item in Char SUPPLIER_ITEM U 32 p_buyer in Char U 33 p_buyer_id in Number Y BUYER U 34 p_note_to_buyer in Char NOTE_TO_BUYER U 35 p_currency in Char CURRENCY U 36 p_process_flag in Char U 37 p_conversion_type in Char CONVERSION_TYPE value U 38 p_conversion_date in Date CONVERSION_DATE U 39 p_conversion_rate in Number CONVERSION_RATE U 40 p_currency_unit_price in Number CURRENCY_UNIT_PRICE U 41 p_distribution_id in Number DISTRIBUTION_ID U 43 p_charge_account_concat_segs in Char Y U 44 p_charge_account_segment1 in Char CHARGE_ACCOUNT_SEGMENT1 U 45 p_charge_account_segment2 in Char CHARGE_ACCOUNT_SEGMENT2 U 46 p_charge_account_segment3 in Char CHARGE_ACCOUNT_SEGMENT3 U 47 p_charge_account_segment4 in Char CHARGE_ACCOUNT_SEGMENT4 U 48 p_charge_account_segment5 in Char CHARGE_ACCOUNT_SEGMENT5 U 49 p_charge_account_segment6 in Char CHARGE_ACCOUNT_SEGMENT6 U 50 p_charge_account_segment7 in Char CHARGE_ACCOUNT_SEGMENT7 U 51 p_charge_account_segment8 in Char CHARGE_ACCOUNT_SEGMENT8 U 52 p_charge_account_segment9 in Char CHARGE_ACCOUNT_SEGMENT9 U 53 p_charge_account_segment10 in Char CHARGE_ACCOUNT_SEGMENT10 U 54 p_project_accounting in Char PROJECT_ACCOUNTING U 55 p_project_number in Char PROJECT_NUMBER value U 56 p_task_number in Char TASK_NUMBER value U 57 p_expenditure_type in Char EXPENDITURE_TYPE U 58 p_expenditure_organization in Char EXPENDITURE_ORGANIZATION U 59 p_expenditure_item_date in Date EXPENDITURE_ITEM_DATE U 60 p_interface_source_code in Char INTERFACE_SOURCE_CODE U 61 p_source_organization_code in Char SOURCE_ORGANIZATION value U 62 p_source_subinventory in Char SOURCE_SUBINVENTORY U 63 p_hdr_attribute_category in Char HEADER_ATTRIBUTE_CATEGORY U 64 p_hdr_attribute1 in Char HEADER_ATTRIBUTE1 U 65 p_hdr_attribute2 in Char HEADER_ATTRIBUTE2 U 66 p_hdr_attribute3 in Char HEADER_ATTRIBUTE3 U 67 p_hdr_attribute4 in Char HEADER_ATTRIBUTE4 U 68 p_hdr_attribute5 in Char HEADER_ATTRIBUTE5 U 69 p_hdr_attribute6 in Char HEADER_ATTRIBUTE6 U 70 p_hdr_attribute7 in Char HEADER_ATTRIBUTE7 U 71 p_hdr_attribute8 in Char HEADER_ATTRIBUTE8 U 72 p_hdr_attribute9 in Char HEADER_ATTRIBUTE9 U 73 p_hdr_attribute10 in Char HEADER_ATTRIBUTE10 U 74 p_hdr_attribute11 in Char HEADER_ATTRIBUTE11 U 75 p_hdr_attribute12 in Char HEADER_ATTRIBUTE12 U 76 p_hdr_attribute13 in Char HEADER_ATTRIBUTE13 U 77 p_hdr_attribute14 in Char HEADER_ATTRIBUTE14 U 78 p_hdr_attribute15 in Char HEADER_ATTRIBUTE15 U 79 p_line_attribute_category in Char LINE_ATTRIBUTE_CATEGORY U 80 p_line_attribute1 in Char LINE_ATTRIBUTE1 U 81 p_line_attribute2 in Char LINE_ATTRIBUTE2 U 82 p_line_attribute3 in Char LINE_ATTRIBUTE3 U 83 p_line_attribute4 in Char LINE_ATTRIBUTE4 U 84 p_line_attribute5 in Char LINE_ATTRIBUTE5 U 85 p_line_attribute6 in Char LINE_ATTRIBUTE6 U 86 p_line_attribute7 in Char LINE_ATTRIBUTE7 U 87 p_line_attribute8 in Char LINE_ATTRIBUTE8 U 88 p_line_attribute9 in Char LINE_ATTRIBUTE9 U 89 p_line_attribute10 in Char LINE_ATTRIBUTE10 U 90 p_line_attribute11 in Char LINE_ATTRIBUTE11 U 91 p_line_attribute12 in Char LINE_ATTRIBUTE12 U 92 p_line_attribute13 in Char LINE_ATTRIBUTE13 U 93 p_line_attribute14 in Char LINE_ATTRIBUTE14 U 94 p_line_attribute15 in Char LINE_ATTRIBUTE15 U 95 p_dist_attribute_category in Char DIST_ATTRIBUTE_CATEGORY U 96 p_dist_attribute1 in Char DIST_ATTRIBUTE1 U 97 p_dist_attribute2 in Char DIST_ATTRIBUTE2 U 98 p_dist_attribute3 in Char DIST_ATTRIBUTE3 U 99 p_dist_attribute4 in Char DIST_ATTRIBUTE4 U 100 p_dist_attribute5 in Char DIST_ATTRIBUTE5 U 101 p_dist_attribute6 in Char DIST_ATTRIBUTE6 U 102 p_dist_attribute7 in Char DIST_ATTRIBUTE7 U 103 p_dist_attribute8 in Char DIST_ATTRIBUTE8 U 104 p_dist_attribute9 in Char DIST_ATTRIBUTE9 U 105 p_dist_attribute10 in Char DIST_ATTRIBUTE10 U 106 p_dist_attribute11 in Char DIST_ATTRIBUTE11 U 107 p_dist_attribute12 in Char DIST_ATTRIBUTE12 U 108 p_dist_attribute13 in Char DIST_ATTRIBUTE13 U 109 p_dist_attribute14 in Char DIST_ATTRIBUTE14 U 110 p_dist_attribute15 in Char DIST_ATTRIBUTE15 U 111 p_destination_subinventory in Char DESTINATION_SUBINVENTORY U 112 p_operating_unit in Char U 113 p_justification in Char Y U 115 p_note_to_authorizer in Char Y NOTE_TO_AUTHORIZER U 116 p_attachment_category in Char Y ATTACHMENT_CATEGORY_ U 117 p_attachment_type in Char Y ATTACHMENT_TYPE_ U 118 p_attachment_title in Char Y ATTACHMENT_TITLE_ U 119 p_attachment_description in Char Y ATTACHMENT_DESCRIPTION_ U 120 p_attachment_content in Char Y ATTACHMENT_CONTENT_ U 121 p_attachment_file_id in Number Y ATTACHMENT_FILE_ID_ U 122 p_row_id in/out Char ROW_ID U 123 request_id_ out Number REQUEST_ID_ U 124 status_ out Char STATUS_CODE_ U 125 message_ out Char MESSAGE_ P 1 p_interface_source_code in Char INTERFACE_SOURCE_CODE P 2 p_group_by in Char GROUP_BY P 3 p_last_requisition_number in Number P 4 p_multi_distributions in Char MULTI_DISTRIBUTIONS P 5 p_initiate_reqappr_after_imp in Char INITIATE_REQAPPR_AFTER_IMP P 6 p_allow_dynamic_ccid in Char Y ALLOW_DYNAMIC_CCID P 7 request_id_ out Number REQUEST_ID_ P 8 status_ out Char STATUS_CODE_ P 9 message_ out Char MESSAGE_ Error SQL select --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_transaction_id=pri.transaction_id and pie.interface_type='REQIMPORT') ,xu.message_ ) message_, pri.request_id request_id_, xu.modified_columns_, xu.row_id, xu.group_code, xu.creation_date, nvl(pri.requisition_header_id,xu.requisition_header_id)requisition_header_id, nvl(pri.req_number_segment1,xu.requisition_number)requisition_number, coalesce(pri.preparer_name, (select papf.full_name from per_all_people_f papf where papf.person_id=pri.preparer_id and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date and rownum <= 1), xu.preparer ) preparer, xu.note_to_authorizer, --pri.requisition_type, nvl(pri.header_description,xu.header_description)header_description, nvl(xxen_util.display_flexfield_context(201,'PO_REQUISITION_HEADERS',pri.header_attribute_category),xu.header_attribute_category) header_attribute_category, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',pri.header_attribute_category,'ATTRIBUTE1',pri.rowid,pri.header_attribute1),xu.header_attribute1) header_attribute1, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',pri.header_attribute_category,'ATTRIBUTE2',pri.rowid,pri.header_attribute2),xu.header_attribute2) header_attribute2, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',pri.header_attribute_category,'ATTRIBUTE3',pri.rowid,pri.header_attribute3),xu.header_attribute3) header_attribute3, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',pri.header_attribute_category,'ATTRIBUTE4',pri.rowid,pri.header_attribute4),xu.header_attribute4) header_attribute4, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',pri.header_attribute_category,'ATTRIBUTE5',pri.rowid,pri.header_attribute5),xu.header_attribute5) header_attribute5, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',pri.header_attribute_category,'ATTRIBUTE6',pri.rowid,pri.header_attribute6),xu.header_attribute6) header_attribute6, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',pri.header_attribute_category,'ATTRIBUTE7',pri.rowid,pri.header_attribute7),xu.header_attribute7) header_attribute7, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',pri.header_attribute_category,'ATTRIBUTE8',pri.rowid,pri.header_attribute8),xu.header_attribute8) header_attribute8, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',pri.header_attribute_category,'ATTRIBUTE9',pri.rowid,pri.header_attribute9),xu.header_attribute9) header_attribute9, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',pri.header_attribute_category,'ATTRIBUTE10',pri.rowid,pri.header_attribute10),xu.header_attribute10) header_attribute10, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',pri.header_attribute_category,'ATTRIBUTE11',pri.rowid,pri.header_attribute11),xu.header_attribute11) header_attribute11, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',pri.header_attribute_category,'ATTRIBUTE12',pri.rowid,pri.header_attribute12),xu.header_attribute12) header_attribute12, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',pri.header_attribute_category,'ATTRIBUTE13',pri.rowid,pri.header_attribute13),xu.header_attribute13) header_attribute13, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',pri.header_attribute_category,'ATTRIBUTE14',pri.rowid,pri.header_attribute14),xu.header_attribute14) header_attribute14, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',pri.header_attribute_category,'ATTRIBUTE15',pri.rowid,pri.header_attribute15),xu.header_attribute15) header_attribute15, nvl(pri.requisition_line_id,xu.requisition_line_id)requisition_line_id, nvl(pri.line_num,xu.line_num)line_num, nvl(pri.line_type,xu.line_type)line_type, nvl(plcd.displayed_field ,xu.destination_type)destination_type, nvl(pri.destination_organization_code ,xu.destination_organization)destination_organization, nvl(pri.destination_subinventory,xu.destination_subinventory) destination_subinventory, nvl(pri.deliver_to_location_code ,xu.deliver_to_location)deliver_to_location, coalesce(pri.deliver_to_requestor_name, (select papf.full_name from per_all_people_f papf where papf.person_id=pri.deliver_to_requestor_id and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date and rownum <= 1), xu.deliver_to_requestor ) deliver_to_requestor, nvl(plcs.displayed_field,xu.source_type) source_type, nvl(pri.source_organization_code,xu.source_organization) source_organization, nvl(pri.source_subinventory,xu.source_subinventory) source_subinventory, nvl(msiv.concatenated_segments,xu.item ) item, nvl(pri.item_description,xu.item_description)item_description, nvl(pri.item_revision,xu.item_revision)item_revision, xu.category, nvl(pri.unit_of_measure,xu.unit_of_measure)unit_of_measure, nvl(pri.quantity,xu.quantity)quantity, nvl(pri.unit_price,xu.unit_price)unit_price, nvl(pri.need_by_date,xu.need_by_date) need_by_date, xu.reference_number, nvl(pri.suggested_vendor_name ,xu.supplier)supplier, nvl(pri.suggested_vendor_site ,xu.supplier_site)supplier_site, nvl(pri.suggested_vendor_contact ,xu.supplier_contact)supplier_contact, nvl(pri.suggested_vendor_item_num ,xu.supplier_item)supplier_item, coalesce(pri.suggested_buyer_name, (select papf.full_name from per_all_people_f papf where papf.person_id=pri.suggested_buyer_id and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date and rownum <= 1), xu.buyer ) buyer, nvl(pri.note_to_buyer,xu.note_to_buyer)note_to_buyer, nvl(pri.currency_code ,xu.currency)currency, nvl(pri.rate_type ,xu.conversion_type)conversion_type, nvl(pri.rate_date,xu.conversion_date) conversion_date, nvl(pri.rate,xu.conversion_rate)conversion_rate, nvl(pri.currency_unit_price,xu.currency_unit_price) currency_unit_price, -- nvl(xxen_util.display_flexfield_context(201,'PO_REQUISITION_LINES',pri.line_attribute_category),xu.line_attribute_category) line_attribute_category, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',pri.line_attribute_category,'ATTRIBUTE1',pri.rowid,pri.line_attribute1),xu.line_attribute1) line_attribute1, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',pri.line_attribute_category,'ATTRIBUTE2',pri.rowid,pri.line_attribute2),xu.line_attribute2) line_attribute2, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',pri.line_attribute_category,'ATTRIBUTE3',pri.rowid,pri.line_attribute3),xu.line_attribute3) line_attribute3, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',pri.line_attribute_category,'ATTRIBUTE4',pri.rowid,pri.line_attribute4),xu.line_attribute4) line_attribute4, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',pri.line_attribute_category,'ATTRIBUTE5',pri.rowid,pri.line_attribute5),xu.line_attribute5) line_attribute5, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',pri.line_attribute_category,'ATTRIBUTE6',pri.rowid,pri.line_attribute6),xu.line_attribute6) line_attribute6, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',pri.line_attribute_category,'ATTRIBUTE7',pri.rowid,pri.line_attribute7),xu.line_attribute7) line_attribute7, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',pri.line_attribute_category,'ATTRIBUTE8',pri.rowid,pri.line_attribute8),xu.line_attribute8) line_attribute8, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',pri.line_attribute_category,'ATTRIBUTE9',pri.rowid,pri.line_attribute9),xu.line_attribute9) line_attribute9, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',pri.line_attribute_category,'ATTRIBUTE10',pri.rowid,pri.line_attribute10),xu.line_attribute10) line_attribute10, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',pri.line_attribute_category,'ATTRIBUTE11',pri.rowid,pri.line_attribute11),xu.line_attribute11) line_attribute11, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',pri.line_attribute_category,'ATTRIBUTE12',pri.rowid,pri.line_attribute12),xu.line_attribute12) line_attribute12, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',pri.line_attribute_category,'ATTRIBUTE13',pri.rowid,pri.line_attribute13),xu.line_attribute13) line_attribute13, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',pri.line_attribute_category,'ATTRIBUTE14',pri.rowid,pri.line_attribute14),xu.line_attribute14) line_attribute14, nvl(xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',pri.line_attribute_category,'ATTRIBUTE15',pri.rowid,pri.line_attribute15),xu.line_attribute15) line_attribute15, nvl(pri.req_distribution_id,xu.distribution_id) distribution_id, to_number(xu.distribution_num) distribution_num, nvl(pri.charge_account_segment1,xu.charge_account_segment1)charge_account_segment1, nvl(pri.charge_account_segment2,xu.charge_account_segment2)charge_account_segment2, nvl(pri.charge_account_segment3,xu.charge_account_segment3)charge_account_segment3, nvl(pri.charge_account_segment4,xu.charge_account_segment4)charge_account_segment4, nvl(pri.charge_account_segment5,xu.charge_account_segment5)charge_account_segment5, nvl(pri.charge_account_segment6,xu.charge_account_segment6)charge_account_segment6, nvl(pri.charge_account_segment7,xu.charge_account_segment7)charge_account_segment7, nvl(pri.charge_account_segment8,xu.charge_account_segment8)charge_account_segment8, nvl(pri.charge_account_segment9,xu.charge_account_segment9)charge_account_segment9, nvl(pri.charge_account_segment10,xu.charge_account_segment10)charge_account_segment10, nvl(xxen_util.meaning(pri.project_accounting_context,'YES_NO',0),xu.project_accounting)project_accounting, nvl(pri.project_num,xu.project_number)project_number, nvl(pri.task_num,xu.task_number)task_number, nvl(pri.expenditure_type,xu.expenditure_type)expenditure_type, nvl(haouve.name ,xu.expenditure_organization)expenditure_organization, nvl(pri.expenditure_item_date,xu.expenditure_item_date) expenditure_item_date, nvl(xxen_util.display_flexfield_context(201,'PO_REQ_DISTRIBUTIONS',pri.dist_attribute_category),xu.dist_attribute_category) dist_attribute_category, nvl(xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',pri.dist_attribute_category,'ATTRIBUTE1',pri.rowid,pri.distribution_attribute1),xu.dist_attribute1) dist_attribute1, nvl(xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',pri.dist_attribute_category,'ATTRIBUTE2',pri.rowid,pri.distribution_attribute2),xu.dist_attribute2) dist_attribute2, nvl(xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',pri.dist_attribute_category,'ATTRIBUTE3',pri.rowid,pri.distribution_attribute3),xu.dist_attribute3) dist_attribute3, nvl(xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',pri.dist_attribute_category,'ATTRIBUTE4',pri.rowid,pri.distribution_attribute4),xu.dist_attribute4) dist_attribute4, nvl(xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',pri.dist_attribute_category,'ATTRIBUTE5',pri.rowid,pri.distribution_attribute5),xu.dist_attribute5) dist_attribute5, nvl(xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',pri.dist_attribute_category,'ATTRIBUTE6',pri.rowid,pri.distribution_attribute6),xu.dist_attribute6) dist_attribute6, nvl(xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',pri.dist_attribute_category,'ATTRIBUTE7',pri.rowid,pri.distribution_attribute7),xu.dist_attribute7) dist_attribute7, nvl(xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',pri.dist_attribute_category,'ATTRIBUTE8',pri.rowid,pri.distribution_attribute8),xu.dist_attribute8) dist_attribute8, nvl(xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',pri.dist_attribute_category,'ATTRIBUTE9',pri.rowid,pri.distribution_attribute9),xu.dist_attribute9) dist_attribute9, nvl(xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',pri.dist_attribute_category,'ATTRIBUTE10',pri.rowid,pri.distribution_attribute10),xu.dist_attribute10) dist_attribute10, nvl(xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',pri.dist_attribute_category,'ATTRIBUTE11',pri.rowid,pri.distribution_attribute11),xu.dist_attribute11) dist_attribute11, nvl(xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',pri.dist_attribute_category,'ATTRIBUTE12',pri.rowid,pri.distribution_attribute12),xu.dist_attribute12) dist_attribute12, nvl(xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',pri.dist_attribute_category,'ATTRIBUTE13',pri.rowid,pri.distribution_attribute13),xu.dist_attribute13) dist_attribute13, nvl(xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',pri.dist_attribute_category,'ATTRIBUTE14',pri.rowid,pri.distribution_attribute14),xu.dist_attribute14) dist_attribute14, nvl(xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',pri.dist_attribute_category,'ATTRIBUTE15',pri.rowid,pri.distribution_attribute15),xu.dist_attribute15) dist_attribute15, -- defaults xu.group_by, xu.initiate_reqappr_after_imp, xu.interface_source_code, xu.multi_distributions, xu.allow_dynamic_ccid, xu.authorization_status, xu.preparer_id, xu.requisition_type, --attachments xu.attachment_category_, xu.attachment_title_, xu.attachment_description_, xu.attachment_type_, xu.attachment_content_, xu.attachment_file_id_, xu.upload_row from xxen_po_requisition_upl_9261_u xu, po_requisitions_interface_all pri, hr_all_organization_units_vl haouv, hr_all_organization_units_vl haouve, mtl_system_items_vl msiv, (select plc.lookup_code,plc.displayed_field from po_lookup_codes plc where plc.lookup_type='REQUISITION SOURCE TYPE') plcs, (select plc.lookup_code,plc.displayed_field from po_lookup_codes plc where plc.lookup_type='DESTINATION TYPE') plcd where (xu.status_code_ = xxen_upload.status_error or exists (select 1 from po_interface_errors pie where pie.interface_transaction_id(+)=pri.transaction_id and pie.interface_type(+)='REQIMPORT' and xu.action_code_=xxen_upload.action_create) ) and pri.org_id=haouv.organization_id(+) and pri.expenditure_organization_id=haouve.organization_id(+) and pri.item_id = msiv.inventory_item_id (+) and xxen_po_upload.get_inv_org_id(pri.org_id)=msiv.organization_id(+) and xu.row_id=pri.rowid(+) and pri.destination_type_code=plcd.lookup_code(+) and pri.source_type_code=plcs.lookup_code(+) Order By creation_date desc, requisition_number, line_num, distribution_num Success SQL select --process-- xxen_upload.action_meaning(xur.action_code_) action_, xxen_upload.status_meaning(xxen_upload.status_success) status_, case when xur.action_code_=xxen_upload.action_create then 'Requisition created: 'else 'Requisition updated: ' end ||prha.segment1 message_, prha.request_id request_id_, null modified_columns_, to_char(null) row_id, --header-- null group_code, prha.creation_date, prha.requisition_header_id, prha.segment1 requisition_number, papf3.full_name preparer, prha.note_to_authorizer, --prh.type_lookup_disp requisition_type, prha.description header_description, xxen_util.display_flexfield_context(201,'PO_REQUISITION_HEADERS',prha.attribute_category) header_attribute_category, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE1',prha.rowid,prha.attribute1) header_attribute1, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE2',prha.rowid,prha.attribute2) header_attribute2, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE3',prha.rowid,prha.attribute3) header_attribute3, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE4',prha.rowid,prha.attribute4) header_attribute4, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE5',prha.rowid,prha.attribute5) header_attribute5, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE6',prha.rowid,prha.attribute6) header_attribute6, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE7',prha.rowid,prha.attribute7) header_attribute7, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE8',prha.rowid,prha.attribute8) header_attribute8, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE9',prha.rowid,prha.attribute9) header_attribute9, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE10',prha.rowid,prha.attribute10) header_attribute10, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE11',prha.rowid,prha.attribute11) header_attribute11, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE12',prha.rowid,prha.attribute12) header_attribute12, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE13',prha.rowid,prha.attribute13) header_attribute13, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE14',prha.rowid,prha.attribute14) header_attribute14, xxen_util.display_flexfield_value(201,'PO_REQUISITION_HEADERS',prha.attribute_category,'ATTRIBUTE15',prha.rowid,prha.attribute15) header_attribute15, prla.requisition_line_id, prla.line_num, pltt.line_type, plc2.displayed_field destination_type, mpd.organization_code destination_organization, prla.destination_subinventory, hlat.location_code deliver_to_location, papf2.full_name deliver_to_requestor, plc1.displayed_field source_type, mps.organization_code source_organization, prla.source_subinventory, msiv.concatenated_segments item, prla.item_description, prla.item_revision, mcv.category_concat_segs category, prla.unit_meas_lookup_code unit_of_measure, prla.quantity, prla.unit_price, prla.need_by_date, prla.reference_num reference_number, --source-- prla.suggested_vendor_name supplier, prla.suggested_vendor_location supplier_site, prla.suggested_vendor_contact supplier_contact, prla.suggested_vendor_product_code supplier_item, --source details-- papf1.full_name buyer, prla.note_to_agent note_to_buyer, --currency-- prla.currency_code currency, prla.rate_type conversion_type, prla.rate_date conversion_date, prla.rate conversion_rate, prla.currency_unit_price, -- xxen_util.display_flexfield_context(201,'PO_REQUISITION_LINES',prla.attribute_category) line_attribute_category, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE1',prla.rowid,prla.attribute1) line_attribute1, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE2',prla.rowid,prla.attribute2) line_attribute2, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE3',prla.rowid,prla.attribute3) line_attribute3, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE4',prla.rowid,prla.attribute4) line_attribute4, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE5',prla.rowid,prla.attribute5) line_attribute5, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE6',prla.rowid,prla.attribute6) line_attribute6, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE7',prla.rowid,prla.attribute7) line_attribute7, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE8',prla.rowid,prla.attribute8) line_attribute8, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE9',prla.rowid,prla.attribute9) line_attribute9, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE10',prla.rowid,prla.attribute10) line_attribute10, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE11',prla.rowid,prla.attribute11) line_attribute11, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE12',prla.rowid,prla.attribute12) line_attribute12, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE13',prla.rowid,prla.attribute13) line_attribute13, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE14',prla.rowid,prla.attribute14) line_attribute14, xxen_util.display_flexfield_value(201,'PO_REQUISITION_LINES',prla.attribute_category,'ATTRIBUTE15',prla.rowid,prla.attribute15) line_attribute15, --distribution accounts-- prda.distribution_id, prda.distribution_num, gcc.segment1 charge_account_segment1, gcc.segment2 charge_account_segment2, gcc.segment3 charge_account_segment3, gcc.segment4 charge_account_segment4, gcc.segment5 charge_account_segment5, gcc.segment6 charge_account_segment6, gcc.segment7 charge_account_segment7, gcc.segment8 charge_account_segment8, gcc.segment9 charge_account_segment9, gcc.segment10 charge_account_segment10, --distribution projects-- prda.project_accounting_context project_accounting, ppv.segment1 project_number, ptv.task_number, prda.expenditure_type, haouve.name expenditure_organization, prda.expenditure_item_date, xxen_util.display_flexfield_context(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category) dist_attribute_category, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE1',prda.rowid,prda.attribute1) dist_attribute1, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE2',prda.rowid,prda.attribute2) dist_attribute2, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE3',prda.rowid,prda.attribute3) dist_attribute3, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE4',prda.rowid,prda.attribute4) dist_attribute4, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE5',prda.rowid,prda.attribute5) dist_attribute5, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE6',prda.rowid,prda.attribute6) dist_attribute6, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE7',prda.rowid,prda.attribute7) dist_attribute7, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE8',prda.rowid,prda.attribute8) dist_attribute8, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE9',prda.rowid,prda.attribute9) dist_attribute9, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE10',prda.rowid,prda.attribute10) dist_attribute10, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE11',prda.rowid,prda.attribute11) dist_attribute11, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE12',prda.rowid,prda.attribute12) dist_attribute12, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE13',prda.rowid,prda.attribute13) dist_attribute13, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE14',prda.rowid,prda.attribute14) dist_attribute14, xxen_util.display_flexfield_value(201,'PO_REQ_DISTRIBUTIONS',prda.attribute_category,'ATTRIBUTE15',prda.rowid,prda.attribute15) dist_attribute15, -- defaults to_char(null) group_by, to_char(null) initiate_reqappr_after_imp, to_char(null) interface_source_code, to_char(null) multi_distributions, to_char(null) allow_dynamic_ccid, to_char(null) authorization_status, to_char(null) preparer_id, prha.type_lookup_code requisition_type, --attachments null attachment_category_, null attachment_title_, null attachment_description_, null attachment_type_, null attachment_content_, null attachment_file_id_, xur.upload_row from ( select xu.action_code_, to_number(xu.requisition_line_id) requisition_line_id, to_number(xu.requisition_header_id) requisition_header_id, min(xu.upload_row) upload_row from xxen_po_requisition_upl_9261_u xu where xu.action_code_ = xxen_upload.action_update and xu.status_code_ = xxen_upload.status_success group by xu.action_code_, xu.requisition_line_id, xu.requisition_header_id union select xu.action_code_, to_number(null) requisition_line_id, prha.requisition_header_id, min(xu.upload_row) upload_row from xxen_po_requisition_upl_9261_u xu, po_requisition_headers_all prha where prha.interface_source_code='IMPORT_REQ' and trunc(prha.interface_source_line_id,0) = to_number(xu.request_id_) and prha.creation_date >= sysdate-0.25 and -- for index usage xu.action_code_=xxen_upload.action_create group by xu.action_code_, prha.requisition_header_id ) xur, po_requisition_headers_all prha, po_requisition_lines_all prla, po_req_distributions_all prda, mtl_categories_v mcv, gl_code_combinations gcc, pa_projects_all ppv, pa_tasks_v ptv, hr_all_organization_units_vl haouve, mtl_parameters mps, mtl_parameters mpd, mtl_system_items_vl msiv, hr_all_organization_units_vl haouv, per_all_people_f papf1, per_all_people_f papf2, per_all_people_f papf3, po_lookup_codes plc1, po_lookup_codes plc2, hr_locations_all_tl hlat, po_line_types_tl pltt, po_document_types_all_vl pdtav where prha.org_id=haouv.organization_id and prha.requisition_header_id=xur.requisition_header_id and prha.requisition_header_id=prla.requisition_header_id and prla.requisition_line_id=nvl(xur.requisition_line_id,prla.requisition_line_id) and prla.requisition_line_id=prda.requisition_line_id and papf1.person_id(+) = prla.suggested_buyer_id and trunc (sysdate) between papf1.effective_start_date (+) and papf1.effective_end_date (+) and trunc (sysdate)>=papf1.effective_start_date(+) and trunc (sysdate)<= papf1.effective_end_date(+) and plc1.lookup_code = prla.source_type_code and plc1.lookup_type = 'REQUISITION SOURCE TYPE' and plc2.lookup_code = prla.destination_type_code and plc2.lookup_type = 'DESTINATION TYPE' and pdtav.document_type_code='REQUISITION' and pdtav.document_subtype=prha.type_lookup_code and pdtav.org_id=prha.org_id and papf2.person_id = prla.to_person_id and trunc (sysdate) between papf2.effective_start_date and papf2.effective_end_date and papf3.person_id = prha.preparer_id and trunc (sysdate) between papf3.effective_start_date and papf3.effective_end_date and pltt.line_type_id=prla.line_type_id and pltt.language=userenv ('LANG') and hlat.location_id(+) = prla.deliver_to_location_id and hlat.language(+) = userenv ('LANG') and prla.item_id=msiv.inventory_item_id(+) and xxen_po_upload.get_inv_org_id(prla.org_id)=msiv.organization_id(+) and prla.destination_organization_id=mpd.organization_id(+) and prla.source_organization_id=mps.organization_id(+) and prla.category_id=mcv.category_id(+) and prda.code_combination_id=gcc.code_combination_id(+) and prda.project_id=ppv.project_id(+) and prda.task_id=ptv.task_id(+) and prda.expenditure_organization_id=haouve.organization_id(+)