ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN F263DDA3FBF50F8FE0530100007F75CD AP Invoice Interface Source Y select alc.displayed_field value, null description from ap_lookup_codes alc where alc.lookup_type = 'SOURCE' and alc.lookup_code not in ('XpenseXpress' , 'SelfService') and trunc(sysdate) between nvl(alc.start_date_active,sysdate -1 ) and nvl(alc.inactive_date , sysdate + 1) and enabled_flag = 'Y' order by value US 8E2FF36EDE9079D2E0530100007F1FF2 FND Currency Y select fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' order by fcv.currency_code US 91D3167A335F1204E053BB6B63585EE3 GL Currency Conversion Type Y select gdct.user_conversion_type value, gdct.description from gl_daily_conversion_types gdct order by 1 US 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 F263DDA3FBF60F8FE0530100007F75CD HR Operating Unit for Upload Y select hou.organization_id id, hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.operating_unit is null or hou.name=:$flex$.operating_unit) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication US Operating unit restricted by multi org access control (MOAC) 20E7C106F62F390EE0630100007F6E3C /* &report_table_name */ select x.* from ( with q_dual as (select * from dual) -- dummy to allow the lexical to follow &error_with_query &success_with_query select null action_, null status_, null message_, null request_id_, null modified_columns_, null row_id, null batch_name, null submit_validation, -- alc.displayed_field source, haouv.name operating_unit, pv.vendor_name supplier_name, pv.segment1 supplier_number, pvsa.vendor_site_code supplier_site, xxen_util.meaning(aia.invoice_type_lookup_code,'INVOICE TYPE',200) invoice_type, aia.invoice_num invoice_number, aia.description invoice_description, (select pha.segment1 from po_headers_all pha where pha.po_header_id = aia.po_header_id) invoice_po_number, aia.invoice_date, aia.gl_date, aia.invoice_amount, aia.amount_applicable_to_discount, aia.invoice_currency_code invoice_currency, (select gdct.user_conversion_type from gl_daily_conversion_types gdct where gdct.conversion_type = aia.exchange_rate_type) exchange_rate_type, aia.exchange_date, aia.exchange_rate, (select ate.name from ap_terms ate where ate.term_id = aia.terms_id) terms, aia.terms_date, aia.goods_received_date, aia.invoice_received_date, xxen_util.meaning(aia.exclusive_payment_flag,'YES_NO',0) exclusive_payment_flag, aia.payment_currency_code payment_currency, (select gdct.user_conversion_type from gl_daily_conversion_types gdct where gdct.conversion_type = aia.payment_cross_rate_type) payment_cross_rate_type, aia.payment_cross_rate_date, aia.payment_cross_rate, nvl(xxen_util.meaning(apsa.payment_method_lookup_code,'PAYMENT METHOD',200),apsa.payment_method_lookup_code) payment_method, (select flvv.meaning from fnd_lookup_values_vl flvv where flvv.lookup_type='PAY GROUP' and flvv.view_application_id = 201 and flvv.lookup_code = aia.pay_group_lookup_code) payment_group, --apsa.payment_priority, -- only applicable for payment request invoice type (select aag.name from ap_awt_groups aag where aag.group_id = aia.awt_group_id) invoice_awt_group, --aia.ussgl_transaction_code, -- not imported by the Payables Import process -- aida.distribution_line_number line_number, xxen_util.meaning(aida.line_type_lookup_code,'INVOICE DISTRIBUTION TYPE',200) line_type, aida.amount line_amount, aida.description line_description, aida.quantity_invoiced quantity, aida.unit_price, -- (select fsfa.alias_name from fnd_shorthand_flex_aliases fsfa where fsfa.application_id = 101 and fsfa.id_flex_code = 'GL#' and fsfa.id_flex_num = gcck.chart_of_accounts_id and fsfa.concatenated_segments = gcck.concatenated_segments and fsfa.enabled_flag = 'Y' and trunc(sysdate) between nvl(fsfa.start_date_active,trunc(sysdate)) and nvl(fsfa.end_date_active,trunc(sysdate)) and rownum <= 1 ) distribution_account_alias, gcck.concatenated_segments distribution_account, --(select adsa.distribution_set_name from ap_distribution_sets_all adsa where adsa.distribution_set_id = pvsa.distribution_set_id and adsa.org_id = aida.org_id) distribution_set, null distribution_set, -- No destination in base table in 11i, -- (select hecv.full_name || ' (' || hecv.employee_num || ')' from hr_employees_current_v hecv where hecv.employee_id = aia.requester_id) requester, -- (select pha.segment1 from po_headers_all pha where pha.po_header_id = pda.po_header_id) po_number, (select pra.release_num from po_releases_all pra,po_line_locations_all plla where pra.po_release_id = plla.po_release_id and plla.line_location_id = pda.line_location_id) po_release_num, (select pla.line_num from po_lines_all pla where pla.po_line_id = pda.po_line_id) po_line_num, (select plla.shipment_num from po_line_locations_all plla where plla.line_location_id = pda.line_location_id) po_shipment_num, pda.distribution_num po_distribution_num, (select rsh.receipt_num from rcv_shipment_headers rsh,rcv_shipment_lines rsl,rcv_transactions rtxns where rsl.shipment_line_id = rtxns.shipment_line_id and aida.rcv_transaction_id = rtxns.transaction_id and rsl.shipment_header_id = rsh.shipment_header_id) po_receipt_num, (select rsl.line_num from rcv_shipment_lines rsl,rcv_transactions rtxns where rsl.shipment_line_id = rtxns.shipment_line_id and aida.rcv_transaction_id = rtxns.transaction_id) po_receipt_line_num, -- xxen_util.meaning(aida.assets_tracking_flag,'YES_NO',0) track_as_asset, -- (select pap.segment1 from pa_projects_all pap where pap.project_id = aida.project_id) project, (select pat.task_number from pa_tasks pat where pat.task_id = aida.task_id) task, aida.expenditure_item_date, aida.expenditure_type, (select hou.name from hr_organization_units hou where hou.organization_id = aida.expenditure_organization_id) expenditure_organization, aida.pa_quantity project_quantity, -- tax aida.type_1099 income_tax_type, aida.income_tax_region, aida.amount_includes_tax_flag, (select atc.name from ap_tax_codes atc where atc.tax_id=aida.tax_code_id ) tax_code, (select aag.name from ap_awt_groups aag where aag.group_id = aida.awt_group_id) line_invoice_awt_group, -- aida.reference_1 line_reference_1, aida.reference_2 line_reference_2, -- xxen_util.display_flexfield_context(200,'AP_INVOICES',aia.attribute_category) invoice_attribute_category, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE1',aia.rowid,aia.attribute1) ap_inv_attribute1, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE2',aia.rowid,aia.attribute2) ap_inv_attribute2, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE3',aia.rowid,aia.attribute3) ap_inv_attribute3, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE4',aia.rowid,aia.attribute4) ap_inv_attribute4, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE5',aia.rowid,aia.attribute5) ap_inv_attribute5, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE6',aia.rowid,aia.attribute6) ap_inv_attribute6, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE7',aia.rowid,aia.attribute7) ap_inv_attribute7, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE8',aia.rowid,aia.attribute8) ap_inv_attribute8, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE9',aia.rowid,aia.attribute9) ap_inv_attribute9, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE10',aia.rowid,aia.attribute10) ap_inv_attribute10, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE11',aia.rowid,aia.attribute11) ap_inv_attribute11, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE12',aia.rowid,aia.attribute12) ap_inv_attribute12, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE13',aia.rowid,aia.attribute13) ap_inv_attribute13, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE14',aia.rowid,aia.attribute14) ap_inv_attribute14, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE15',aia.rowid,aia.attribute15) ap_inv_attribute15, aida.attribute_category line_attribute_category, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE1',aida.rowid,aida.attribute1) ap_inv_line_attribute1, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE2',aida.rowid,aida.attribute2) ap_inv_line_attribute2, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE3',aida.rowid,aida.attribute3) ap_inv_line_attribute3, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE4',aida.rowid,aida.attribute4) ap_inv_line_attribute4, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE5',aida.rowid,aida.attribute5) ap_inv_line_attribute5, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE6',aida.rowid,aida.attribute6) ap_inv_line_attribute6, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE7',aida.rowid,aida.attribute7) ap_inv_line_attribute7, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE8',aida.rowid,aida.attribute8) ap_inv_line_attribute8, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE9',aida.rowid,aida.attribute9) ap_inv_line_attribute9, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE10',aida.rowid,aida.attribute10) ap_inv_line_attribute10, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE11',aida.rowid,aida.attribute11) ap_inv_line_attribute11, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE12',aida.rowid,aida.attribute12) ap_inv_line_attribute12, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE13',aida.rowid,aida.attribute13) ap_inv_line_attribute13, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE14',aida.rowid,aida.attribute14) ap_inv_line_attribute14, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE15',aida.rowid,aida.attribute15) ap_inv_line_attribute15, null attachment_category_, null attachment_title_, null attachment_description_, null attachment_type_, null attachment_content_, null attachment_file_id_ from ap_invoices_all aia, ap_payment_schedules_all apsa, ap_invoice_distributions_all aida, po_distributions_all pda, hr_all_organization_units_vl haouv, po_vendors pv, po_vendor_sites_all pvsa, gl_code_combinations_kfv gcck, ap_lookup_codes alc where aia.invoice_id = apsa.invoice_id (+) and aia.invoice_id = aida.invoice_id and aia.vendor_id = pv.vendor_id and aia.vendor_site_id = pvsa.vendor_site_id and aia.org_id = haouv.organization_id and aida.po_distribution_id=pda.po_distribution_id(+) and aida.dist_code_combination_id = gcck.code_combination_id (+) and alc.lookup_type = 'SOURCE' and alc.lookup_code = aia.source and haouv.name = :p_operating_unit and alc.displayed_field = :p_source and :p_batch_name = :p_batch_name and nvl(:p_gl_date,sysdate) = nvl(:p_gl_date,sysdate) and nvl(:p_submit_validation,'N') = nvl(:p_submit_validation,'N') and 1=0 &not_use_first_block &processed_run_query &processed_run ) x order by x.operating_unit, x.invoice_date, x.supplier_name, x.invoice_number, x.line_number Y U A xxen_ap_upload_11i.insert_ap_inv_interface xxen_ap_upload_11i.submit_ap_inv_import US AP Invoice Upload 11i AP Invoice Upload which uses Payables Open Interface Import as a standard program to create invoices. This upload also triggers Standard "Invoice Validation" program as a post processor. Enginatics Upload &error_with_query &not_use_first_block &processed_run &processed_run_query &report_table_name &success_with_query :p_batch_name :p_gl_date :p_operating_unit :p_source :p_submit_validation 1 10 :p_operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) Y US Operating Unit 2 20 :p_source LOV AP Invoice Interface Source F263DDA3FBF50F8FE0530100007F75CD Y select alc.displayed_field value, null description from ap_lookup_codes alc where alc.lookup_type = 'SOURCE' and alc.lookup_code not in ('XpenseXpress' , 'SelfService') and trunc(sysdate) between nvl(alc.start_date_active,sysdate -1 ) and nvl(alc.inactive_date , sysdate + 1) and enabled_flag = 'Y' order by value select alc.displayed_field from ap_lookup_codes alc where alc.lookup_type = 'SOURCE' and alc.lookup_code not in ('XpenseXpress' , 'SelfService') and trunc(sysdate) between nvl(alc.start_date_active,sysdate -1 ) and nvl(alc.inactive_date , sysdate + 1) and enabled_flag = 'Y' and alc.lookup_code='IMPORTACAO' Y US Invoice Source 3 30 :p_batch_name Char select decode(nvl(fnd_profile.value('AP_USE_INV_BATCH_CONTROLS'),'N') , 'N', alc.displayed_field) from ap_lookup_codes alc where alc.lookup_type ='NLS REPORT PARAMETER' and alc.lookup_code = 'NA' Y US Batch Name 4 40 :p_gl_date Date US GL Date 5 50 :p_submit_validation LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y US Submit Invoice Validation Default ENGINATICS 11 AMOUNT_APPLICABLE_TO_DISCOUNT 51 AMOUNT_INCLUDES_TAX_FLAG 56 AP_INV_ATTRIBUTE1 65 AP_INV_ATTRIBUTE10 66 AP_INV_ATTRIBUTE11 67 AP_INV_ATTRIBUTE12 68 AP_INV_ATTRIBUTE13 69 AP_INV_ATTRIBUTE14 70 AP_INV_ATTRIBUTE15 57 AP_INV_ATTRIBUTE2 58 AP_INV_ATTRIBUTE3 59 AP_INV_ATTRIBUTE4 60 AP_INV_ATTRIBUTE5 61 AP_INV_ATTRIBUTE6 62 AP_INV_ATTRIBUTE7 63 AP_INV_ATTRIBUTE8 64 AP_INV_ATTRIBUTE9 72 AP_INV_LINE_ATTRIBUTE1 81 AP_INV_LINE_ATTRIBUTE10 82 AP_INV_LINE_ATTRIBUTE11 83 AP_INV_LINE_ATTRIBUTE12 84 AP_INV_LINE_ATTRIBUTE13 85 AP_INV_LINE_ATTRIBUTE14 86 AP_INV_LINE_ATTRIBUTE15 73 AP_INV_LINE_ATTRIBUTE2 74 AP_INV_LINE_ATTRIBUTE3 75 AP_INV_LINE_ATTRIBUTE4 76 AP_INV_LINE_ATTRIBUTE5 77 AP_INV_LINE_ATTRIBUTE6 78 AP_INV_LINE_ATTRIBUTE7 79 AP_INV_LINE_ATTRIBUTE8 80 AP_INV_LINE_ATTRIBUTE9 -61.0069 ASSESSABLE_VALUE -52.0053 ASSET_BOOK -52.0054 ASSET_CATEGORY -61.007 BANK_CHARGE_BEARER -61.0066 BUSINESS_CATEGORY 41 DISTRIBUTION_ACCOUNT 40 DISTRIBUTION_ACCOUNT_ALIAS 42 DISTRIBUTION_SET 14 EXCHANGE_DATE 15 EXCHANGE_RATE 13 EXCHANGE_RATE_TYPE 24 EXCLUSIVE_PAYMENT_FLAG 47 EXPENDITURE_ITEM_DATE 49 EXPENDITURE_ORGANIZATION 48 EXPENDITURE_TYPE -61.0065 FISCAL_CLASSIFICATION 9 GL_DATE 18 GOODS_RECEIVED_DATE 10 INVOICE_AMOUNT 55 INVOICE_ATTRIBUTE_CATEGORY 12 INVOICE_CURRENCY 8 INVOICE_DATE 6 INVOICE_DESCRIPTION 5 INVOICE_NUMBER 7 INVOICE_PO_NUMBER 19 INVOICE_RECEIVED_DATE -61.0076 INVOICE_REFERENCE_1 -61.0077 INVOICE_REFERENCE_2 4 INVOICE_TYPE 29 LINE_AMOUNT 71 LINE_ATTRIBUTE_CATEGORY 37 LINE_DESCRIPTION 27 LINE_NUMBER 53 LINE_REFERENCE_1 54 LINE_REFERENCE_2 28 LINE_TYPE -47.0048 MANUFACTURER -47.0049 MODEL_NUMBER 23 PAYMENT_CROSS_RATE 22 PAYMENT_CROSS_RATE_DATE 21 PAYMENT_CROSS_RATE_TYPE 20 PAYMENT_CURRENCY -25.0026 PAYMENT_DELIVERY_CHANNEL 26 PAYMENT_GROUP 25 PAYMENT_METHOD -25.0027 PAYMENT_REASON -25.0028 PAYMENT_REASON_COMMENTS 34 PO_DISTRIBUTION_NUM 32 PO_LINE_NUM 30 PO_NUMBER 36 PO_RECEIPT_LINE_NUM 35 PO_RECEIPT_NUM 31 PO_RELEASE_NUM 33 PO_SHIPMENT_NUM -61.0062 PRIMARY_INTENDED_USE -61.0068 PRODUCT_CATEGORY -61.0064 PRODUCT_FISCAL_CLASSIFICATION -61.0067 PRODUCT_TYPE 45 PROJECT 50 PROJECT_QUANTITY 38 QUANTITY -61.0071 REMITTANCE_MESSAGE1 -61.0072 REMITTANCE_MESSAGE2 -61.0073 REMITTANCE_MESSAGE3 43 REQUESTER -47.005 SERIAL_NUMBER -61.0063 SHIP_TO_LOCATION 1 SUPPLIER_NAME 2 SUPPLIER_NUMBER 3 SUPPLIER_SITE 46 TASK -50.0051 TAX_CLASSIFICATION 52 TAX_CODE 16 TERMS 17 TERMS_DATE 44 TRACK_AS_ASSET -61.0074 UNIQUE_REMITTANCE_IDENTIFIER 39 UNIT_PRICE -41.0042 UOM -61.0075 URI_CHECK_DIGIT -47.0051 WARRANTY_NUMBER S Site Default(with attachment) ENGINATICS 11 AMOUNT_APPLICABLE_TO_DISCOUNT 51 AMOUNT_INCLUDES_TAX_FLAG 56 AP_INV_ATTRIBUTE1 65 AP_INV_ATTRIBUTE10 66 AP_INV_ATTRIBUTE11 67 AP_INV_ATTRIBUTE12 68 AP_INV_ATTRIBUTE13 69 AP_INV_ATTRIBUTE14 70 AP_INV_ATTRIBUTE15 57 AP_INV_ATTRIBUTE2 58 AP_INV_ATTRIBUTE3 59 AP_INV_ATTRIBUTE4 60 AP_INV_ATTRIBUTE5 61 AP_INV_ATTRIBUTE6 62 AP_INV_ATTRIBUTE7 63 AP_INV_ATTRIBUTE8 64 AP_INV_ATTRIBUTE9 72 AP_INV_LINE_ATTRIBUTE1 81 AP_INV_LINE_ATTRIBUTE10 82 AP_INV_LINE_ATTRIBUTE11 83 AP_INV_LINE_ATTRIBUTE12 84 AP_INV_LINE_ATTRIBUTE13 85 AP_INV_LINE_ATTRIBUTE14 86 AP_INV_LINE_ATTRIBUTE15 73 AP_INV_LINE_ATTRIBUTE2 74 AP_INV_LINE_ATTRIBUTE3 75 AP_INV_LINE_ATTRIBUTE4 76 AP_INV_LINE_ATTRIBUTE5 77 AP_INV_LINE_ATTRIBUTE6 78 AP_INV_LINE_ATTRIBUTE7 79 AP_INV_LINE_ATTRIBUTE8 80 AP_INV_LINE_ATTRIBUTE9 -61.0069 ASSESSABLE_VALUE -52.0053 ASSET_BOOK -52.0054 ASSET_CATEGORY 87 ATTACHMENT_CATEGORY_ 91 ATTACHMENT_CONTENT_ 89 ATTACHMENT_DESCRIPTION_ 92 ATTACHMENT_FILE_ID_ 88 ATTACHMENT_TITLE_ 90 ATTACHMENT_TYPE_ -61.007 BANK_CHARGE_BEARER -61.0066 BUSINESS_CATEGORY 41 DISTRIBUTION_ACCOUNT 40 DISTRIBUTION_ACCOUNT_ALIAS 42 DISTRIBUTION_SET 14 EXCHANGE_DATE 15 EXCHANGE_RATE 13 EXCHANGE_RATE_TYPE 24 EXCLUSIVE_PAYMENT_FLAG 47 EXPENDITURE_ITEM_DATE 49 EXPENDITURE_ORGANIZATION 48 EXPENDITURE_TYPE -61.0065 FISCAL_CLASSIFICATION 9 GL_DATE 18 GOODS_RECEIVED_DATE 10 INVOICE_AMOUNT 55 INVOICE_ATTRIBUTE_CATEGORY 12 INVOICE_CURRENCY 8 INVOICE_DATE 6 INVOICE_DESCRIPTION 5 INVOICE_NUMBER 7 INVOICE_PO_NUMBER 19 INVOICE_RECEIVED_DATE -61.0076 INVOICE_REFERENCE_1 -61.0077 INVOICE_REFERENCE_2 4 INVOICE_TYPE 29 LINE_AMOUNT 71 LINE_ATTRIBUTE_CATEGORY 37 LINE_DESCRIPTION 27 LINE_NUMBER 53 LINE_REFERENCE_1 54 LINE_REFERENCE_2 28 LINE_TYPE -47.0048 MANUFACTURER -47.0049 MODEL_NUMBER 23 PAYMENT_CROSS_RATE 22 PAYMENT_CROSS_RATE_DATE 21 PAYMENT_CROSS_RATE_TYPE 20 PAYMENT_CURRENCY -25.0026 PAYMENT_DELIVERY_CHANNEL 26 PAYMENT_GROUP 25 PAYMENT_METHOD -25.0027 PAYMENT_REASON -25.0028 PAYMENT_REASON_COMMENTS 34 PO_DISTRIBUTION_NUM 32 PO_LINE_NUM 30 PO_NUMBER 36 PO_RECEIPT_LINE_NUM 35 PO_RECEIPT_NUM 31 PO_RELEASE_NUM 33 PO_SHIPMENT_NUM -61.0062 PRIMARY_INTENDED_USE -61.0068 PRODUCT_CATEGORY -61.0064 PRODUCT_FISCAL_CLASSIFICATION -61.0067 PRODUCT_TYPE 45 PROJECT 50 PROJECT_QUANTITY 38 QUANTITY -61.0071 REMITTANCE_MESSAGE1 -61.0072 REMITTANCE_MESSAGE2 -61.0073 REMITTANCE_MESSAGE3 43 REQUESTER -47.005 SERIAL_NUMBER -61.0063 SHIP_TO_LOCATION 1 SUPPLIER_NAME 2 SUPPLIER_NUMBER 3 SUPPLIER_SITE 46 TASK -50.0051 TAX_CLASSIFICATION 52 TAX_CODE 16 TERMS 17 TERMS_DATE 44 TRACK_AS_ASSET -61.0074 UNIQUE_REMITTANCE_IDENTIFIER 39 UNIT_PRICE -41.0042 UOM -61.0075 URI_CHECK_DIGIT -47.0051 WARRANTY_NUMBER S Site ENGINATICS Default(with attachment) Default 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 Y 6 ROW_ID Char varchar2 Y Y 7 BATCH_NAME Char varchar2 :$flex$.batch_name Y 8 SUBMIT_VALIDATION Char varchar2 :$flex$.submit_invoice_validation Y 9 SOURCE LOV custom varchar2 Y select alc.lookup_code id, alc.displayed_field value, alc.lookup_code description from ap_lookup_codes alc where alc.lookup_type = 'SOURCE' and alc.lookup_code not in ('XpenseXpress' , 'SelfService') and trunc(sysdate) between nvl(alc.start_date_active,trunc(sysdate)) and nvl(alc.inactive_date,trunc(sysdate)) and enabled_flag = 'Y' order by value select flvv.lookup_code id, flvv.meaning value from fnd_lookup_values_vl flvv where flvv.lookup_type = 'SOURCE' and flvv.view_application_id = 200 :$flex$.invoice_source Y Y Y 10 OPERATING_UNIT LOV varchar2 HR Operating Unit for Upload F263DDA3FBF60F8FE0530100007F75CD Y select hou.organization_id id, hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.operating_unit is null or hou.name=:$flex$.operating_unit) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name :$flex$.operating_unit Y Y Y 11 SUPPLIER_NAME LOV custom varchar2 Y select pv.vendor_id id, pv.vendor_name value, null description from po_vendors pv, hr_operating_units hou where hou.name=:$flex$.operating_unit and exists(select 1 from po_vendor_sites_all pvsa where pvsa.org_id=hou.organization_id and pvsa.vendor_id=pv.vendor_id) and pv.segment1 = nvl(:$column$.supplier_number,pv.segment1) and nvl(pv.end_date_active,sysdate+1) > sysdate order by value Y 12 SUPPLIER_NUMBER LOV custom varchar2 Y select pv.vendor_id id, pv.segment1 value, pv.vendor_name description from po_vendors pv, hr_operating_units hou where hou.name=:$flex$.operating_unit and exists(select 1 from po_vendor_sites_all pvsa where pvsa.org_id=hou.organization_id and pvsa.vendor_id=pv.vendor_id) and pv.vendor_name = nvl(:$column$.supplier_name,pv.vendor_name) and nvl(pv.end_date_active,sysdate+1) > sysdate order by value Y 13 SUPPLIER_SITE LOV custom varchar2 Y select pvsa.vendor_site_id id, pvsa.vendor_site_code value, pvsa.address_line1||', '||pvsa.city||', '||nvl(ftv.territory_short_name,pvsa.country) description from po_vendor_sites_all pvsa, po_vendors pv, hr_operating_units hou, fnd_territories_vl ftv where pvsa.vendor_id=pv.vendor_id and pvsa.org_id=hou.organization_id and pvsa.country=ftv.territory_code(+) and hou.name=:$flex$.operating_unit and pv.vendor_name=:$column$.supplier_name and pv.segment1=:$column$.supplier_number and nvl(pvsa.inactive_date,sysdate+1) > sysdate order by value Y 14 INVOICE_TYPE LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type = 'INVOICE TYPE' and flvv.view_application_id = 200 and flvv.enabled_flag = 'Y' and trunc(sysdate) between nvl(flvv.start_date_active,trunc(sysdate)) and nvl(flvv.end_date_active,trunc(sysdate)) order by value select flvv.lookup_code id, flvv.meaning value from fnd_lookup_values_vl flvv where flvv.lookup_type = 'INVOICE TYPE' and flvv.view_application_id = 200 select flvv.meaning value from fnd_lookup_values_vl flvv where flvv.lookup_type = 'INVOICE TYPE' and flvv.view_application_id = 200 and flvv.enabled_flag = 'Y' and trunc(sysdate) between nvl(flvv.start_date_active,trunc(sysdate)) and nvl(flvv.end_date_active,trunc(sysdate)) and flvv.lookup_code = 'STANDARD' Y 15 INVOICE_NUMBER Char varchar2 Y Y 16 INVOICE_DESCRIPTION Char varchar2 17 INVOICE_PO_NUMBER LOV custom varchar2 Y Y select phav.po_header_id id, phav.po_number value, phav.po_type description from po_vendors pv, ( select poh.segment1 po_number, plc.displayed_field po_type, poh.po_header_id po_header_id, poh.vendor_id vendor_id, poh.currency_code currency_code, poh.approved_flag approved_flag, poh.closed_code closed_code, poh.org_id from po_lookup_codes plc, po_headers_all poh, hr_all_organization_units_vl haouv where poh.type_lookup_code in ( 'STANDARD', 'BLANKET', 'PLANNED' ) and plc.lookup_code = poh.type_lookup_code and plc.lookup_type = 'PO TYPE' and poh.org_id = haouv.organization_id and haouv.name = :$column$.operating_unit and poh.pcard_id is null ) phav where phav.vendor_id = pv.vendor_id and pv.segment1 = :$column$.supplier_number and phav.approved_flag = 'Y' and nvl(phav.closed_code, 'X') <> 'FINALLY CLOSED' order by upper(value) 18 INVOICE_DATE Date date Y 19 GL_DATE Date date :$flex$.gl_date 20 INVOICE_AMOUNT Number number Y 21 AMOUNT_APPLICABLE_TO_DISCOUNT Number number 22 INVOICE_CURRENCY LOV varchar2 FND Currency 8E2FF36EDE9079D2E0530100007F1FF2 Y select fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' order by fcv.currency_code Y 23 EXCHANGE_RATE_TYPE LOV varchar2 GL Currency Conversion Type 91D3167A335F1204E053BB6B63585EE3 Y select gdct.user_conversion_type value, gdct.description from gl_daily_conversion_types gdct order by 1 select gdct.conversion_type id, gdct.user_conversion_type value from gl_daily_conversion_types gdct 24 EXCHANGE_DATE Date date 25 EXCHANGE_RATE Number number 26 TERMS LOV custom varchar2 Y select ate.term_id id, ate.name value, ate.description description from ap_terms ate where ate.enabled_flag = 'Y' and trunc(sysdate) between nvl(ate.start_date_active,trunc(sysdate)) and nvl(ate.end_date_active,trunc(sysdate)) order by value 27 TERMS_DATE Date date 28 GOODS_RECEIVED_DATE Date date 29 INVOICE_RECEIVED_DATE Date date 30 EXCLUSIVE_PAYMENT_FLAG LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 31 PAYMENT_CURRENCY LOV varchar2 FND Currency 8E2FF36EDE9079D2E0530100007F1FF2 Y select fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' order by fcv.currency_code 32 PAYMENT_CROSS_RATE_TYPE LOV varchar2 GL Currency Conversion Type 91D3167A335F1204E053BB6B63585EE3 Y select gdct.user_conversion_type value, gdct.description from gl_daily_conversion_types gdct order by 1 select gdct.conversion_type id, gdct.user_conversion_type value from gl_daily_conversion_types gdct 33 PAYMENT_CROSS_RATE_DATE Date date 34 PAYMENT_CROSS_RATE Number number 35 PAYMENT_METHOD LOV custom varchar2 Y select flvv.lookup_code value, flvv.meaning description from fnd_lookup_values_vl flvv where flvv.lookup_type='PAYMENT METHOD' and flvv.view_application_id = 200 select flvv.lookup_code id, flvv.meaning value from fnd_lookup_values_vl flvv where flvv.lookup_type='PAYMENT METHOD' and flvv.view_application_id = 200 36 PAYMENT_GROUP LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='PAY GROUP' and flvv.view_application_id = 201 and flvv.enabled_flag = 'Y' and trunc(sysdate) between nvl(flvv.start_date_active,trunc(sysdate)) and nvl(flvv.end_date_active,trunc(sysdate)) order by value select flvv.lookup_code id, flvv.meaning value from fnd_lookup_values_vl flvv where flvv.lookup_type='PAY GROUP' and flvv.view_application_id = 201 37 INVOICE_AWT_GROUP LOV custom varchar2 Y select aag.group_id id, aag.name value, aag.description from ap_awt_groups aag where trunc(sysdate) <= nvl(aag.inactive_date,trunc(sysdate)) and exists (select null from ap_awt_group_taxes aagt where aagt.group_id= aag.group_id) order by value 38 LINE_NUMBER Number number Y 39 LINE_TYPE LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type = 'INVOICE DISTRIBUTION TYPE' and flvv.view_application_id = 200 and flvv.enabled_flag = 'Y' and trunc(sysdate) between nvl(flvv.start_date_active,trunc(sysdate)) and nvl(flvv.end_date_active,trunc(sysdate)) order by value select flvv.lookup_code id, flvv.meaning value from fnd_lookup_values_vl flvv where flvv.lookup_type = 'INVOICE DISTRIBUTION TYPE' and flvv.view_application_id = 200 select flvv.meaning value from fnd_lookup_values_vl flvv where flvv.lookup_type = 'INVOICE DISTRIBUTION TYPE' and flvv.view_application_id = 200 and flvv.enabled_flag = 'Y' and trunc(sysdate) between nvl(flvv.start_date_active,trunc(sysdate)) and nvl(flvv.end_date_active,trunc(sysdate)) and flvv.lookup_code = 'ITEM' Y 40 LINE_AMOUNT Number number Y 41 LINE_DESCRIPTION Char varchar2 select pla.item_description from hr_all_organization_units_vl haouv, po_vendors pv, po_headers_all pha, po_lines_all pla where pha.vendor_id = pv.vendor_id and pha.org_id = haouv.organization_id and pha.po_header_id = pla.po_header_id and haouv.name = :$column$.operating_unit and pv.segment1 = :$column$.supplier_number and pha.segment1 = :$column$.po_number and to_char(pla.line_num)= :$column$.po_line_num 42 QUANTITY Number number 43 UNIT_PRICE Number number 44 DISTRIBUTION_ACCOUNT_ALIAS LOV custom varchar2 Y select fsfa.alias_name id, fsfa.alias_name value, fsfa.concatenated_segments || ' (' || flvv.description || ')' description from hr_operating_units hou, xxen_gl_ledgers_v gl, fnd_shorthand_flex_aliases fsfa, gl_code_combinations_kfv gcck, fnd_lookup_values_vl flvv where hou.name=:$flex$.operating_unit and gl.set_of_books_id = to_number(hou.set_of_books_id) and fsfa.application_id = 101 and fsfa.id_flex_code = 'GL#' and fsfa.id_flex_num = gl.chart_of_accounts_id and fsfa.enabled_flag = 'Y' and trunc(sysdate) between nvl(fsfa.start_date_active,trunc(sysdate)) and nvl(fsfa.end_date_active,trunc(sysdate)) and gcck.chart_of_accounts_id = gl.chart_of_accounts_id and gcck.concatenated_segments = fsfa.concatenated_segments and gcck.enabled_flag = 'Y' and gcck.summary_flag = 'N' and trunc(sysdate) between nvl(gcck.start_date_active,trunc(sysdate)) and nvl(gcck.end_date_active,trunc(sysdate)) and flvv.lookup_type = 'ACCOUNT TYPE' and flvv.view_application_id = 101 and flvv.lookup_code = gcck.gl_account_type order by value 45 DISTRIBUTION_ACCOUNT LOV custom varchar2 Y Y select gcck.code_combination_id id, gcck.concatenated_segments value, xxen_util.segments_description(gcck.code_combination_id) || ' (' || flvv.description || ')' description from hr_operating_units hou, xxen_gl_ledgers_v gl, gl_code_combinations_kfv gcck, fnd_lookup_values_vl flvv where hou.name=:$flex$.operating_unit and gl.set_of_books_id = to_number(hou.set_of_books_id) and gcck.chart_of_accounts_id = gl.chart_of_accounts_id and gcck.enabled_flag = 'Y' and gcck.summary_flag = 'N' and trunc(sysdate) between nvl(gcck.start_date_active,trunc(sysdate)) and nvl(gcck.end_date_active,trunc(sysdate)) and flvv.lookup_type = 'ACCOUNT TYPE' and flvv.view_application_id = 101 and flvv.lookup_code = gcck.gl_account_type and (:$column$.distribution_account_alias is null or gcck.concatenated_segments = (select fsfa.concatenated_segments from fnd_shorthand_flex_aliases fsfa where fsfa.application_id = 101 and fsfa.id_flex_code = 'GL#' and fsfa.id_flex_num = gl.chart_of_accounts_id and fsfa.enabled_flag = 'Y' and trunc(sysdate) between nvl(fsfa.start_date_active,trunc(sysdate)) and nvl(fsfa.end_date_active,trunc(sysdate)) and fsfa.alias_name = :$column$.distribution_account_alias ) ) order by value select fsfa.concatenated_segments from hr_operating_units hou, xxen_gl_ledgers_v gl, fnd_shorthand_flex_aliases fsfa where hou.name=:$flex$.operating_unit and gl.set_of_books_id = to_number(hou.set_of_books_id) and fsfa.application_id = 101 and fsfa.id_flex_code = 'GL#' and fsfa.id_flex_num = gl.chart_of_accounts_id and fsfa.enabled_flag = 'Y' and trunc(sysdate) between nvl(fsfa.start_date_active,trunc(sysdate)) and nvl(fsfa.end_date_active,trunc(sysdate)) and fsfa.alias_name = :$column$.distribution_account_alias Account is mandatory when line type is Item 46 DISTRIBUTION_SET LOV custom varchar2 Y select ads.distribution_set_id id, ads.distribution_set_name value, ads.description from hr_all_organization_units_vl haouv, ap_distribution_sets_all ads where haouv.organization_id = ads.org_id and haouv.name = :$column$.operating_unit and sysdate < nvl(ads.inactive_date,sysdate+1) and :$column$.distribution_account is null order by upper(value) 47 REQUESTER LOV custom varchar2 Y select hecv.employee_id id, hecv.full_name || ' (' || hecv.employee_num || ')' value, null description from hr_employees_current_v hecv order by upper(value) select hecv.employee_id id, hecv.full_name || ' (' || hecv.employee_num || ')' value from hr_employees_current_v hecv 48 PO_NUMBER LOV custom varchar2 Y select phav.po_header_id id, phav.po_number value, phav.po_type description from po_vendors pv, ( select poh.segment1 po_number, plc.displayed_field po_type, poh.po_header_id po_header_id, poh.vendor_id vendor_id, poh.currency_code currency_code, poh.approved_flag approved_flag, poh.closed_code closed_code, poh.org_id from po_lookup_codes plc, po_headers_all poh, hr_all_organization_units_vl haouv where poh.type_lookup_code in ( 'STANDARD', 'BLANKET', 'PLANNED' ) and plc.lookup_code = poh.type_lookup_code and plc.lookup_type = 'PO TYPE' and poh.org_id = haouv.organization_id and haouv.name = :$column$.operating_unit and poh.segment1 = nvl(:$column$.invoice_po_number,poh.segment1) and poh.pcard_id is null ) phav where phav.vendor_id = pv.vendor_id and pv.segment1 = :$column$.supplier_number and phav.currency_code = :$column$.invoice_currency and phav.approved_flag = 'Y' and nvl(phav.closed_code, 'X') <> 'FINALLY CLOSED' order by upper(value) 49 PO_RELEASE_NUM LOV custom number Y select pra.po_release_id id, pra.release_num value, null description from po_vendors pv, ( select poh.segment1 po_number, plc.displayed_field po_type, poh.po_header_id po_header_id, poh.vendor_id vendor_id, poh.currency_code currency_code, poh.approved_flag approved_flag, poh.closed_code closed_code, poh.org_id from po_lookup_codes plc, po_headers_all poh, hr_all_organization_units_vl haouv where poh.type_lookup_code in ( 'STANDARD', 'BLANKET', 'PLANNED' ) and plc.lookup_code = poh.type_lookup_code and plc.lookup_type = 'PO TYPE' and poh.org_id = haouv.organization_id and haouv.name = :$column$.operating_unit and poh.segment1 = :$column$.po_number and poh.pcard_id is null ) phav, po_releases_all pra where phav.vendor_id = pv.vendor_id and phav.po_header_id = pra.po_header_id and pv.segment1 = :$column$.supplier_number and phav.currency_code = :$column$.invoice_currency and phav.approved_flag = 'Y' and nvl(phav.closed_code, 'X') <> 'FINALLY CLOSED' and pra.approved_flag = 'Y' and nvl(pra.closed_code, 'X') <> 'FINALLY CLOSED' order by upper(value) 50 PO_LINE_NUM LOV custom number Y select pla.po_line_id id, to_char(pla.line_num) value, pla.item_description || nvl2(pla.item_id,' (' || msiv.concatenated_segments || ')',null) || ' - Qty: ' || pla.quantity || ' ' || pla.unit_meas_lookup_code || ' Unit Price: ' || pla.unit_price description from po_vendors pv, ( select poh.segment1 po_number, plc.displayed_field po_type, poh.po_header_id po_header_id, poh.vendor_id vendor_id, poh.currency_code currency_code, poh.approved_flag approved_flag, poh.closed_code closed_code, poh.org_id from po_lookup_codes plc, po_headers_all poh, hr_all_organization_units_vl haouv where poh.type_lookup_code in ( 'STANDARD', 'BLANKET', 'PLANNED' ) and plc.lookup_code = poh.type_lookup_code and plc.lookup_type = 'PO TYPE' and poh.org_id = haouv.organization_id and haouv.name = :$column$.operating_unit and poh.segment1 = nvl(:$column$.po_number,poh.segment1) and poh.pcard_id is null ) phav, po_lines_all pla, po_line_locations pll, financials_system_parameters fsp, mtl_system_items_vl msiv where phav.vendor_id = pv.vendor_id and phav.po_header_id = pla.po_header_id and pla.po_line_id = pll.po_line_id and pla.org_id = fsp.org_id and pla.item_id = msiv.inventory_item_id(+) and nvl(msiv.organization_id,fsp.inventory_organization_id) = fsp.inventory_organization_id and pv.segment1 = :$column$.supplier_number and phav.currency_code = :$column$.invoice_currency and ( (:$column$.po_release_num is null and pll.po_release_id is null) or (:$column$.po_release_num is not null and exists (select null from po_releases pr where pr.release_num = :$column$.po_release_num and pr.po_release_id = pll.po_release_id ) ) ) and nvl(pla.closed_code, 'X') <> 'FINALLY CLOSED' group by pla.po_line_id, to_char(pla.line_num), pla.item_description, nvl2(pla.item_id,' (' || msiv.concatenated_segments || ')',null), pla.quantity, pla.unit_meas_lookup_code, pla.unit_price order by value 51 PO_SHIPMENT_NUM LOV custom number Y select pll.line_location_id id, pll.shipment_num value, pla.item_description || ' - Qty: ' || pll.quantity || ' ' || pll.unit_meas_lookup_code || ' Unit Price: ' || nvl(pll.price_override,pla.unit_price) description from po_vendors pv, ( select poh.segment1 po_number, plc.displayed_field po_type, poh.po_header_id po_header_id, poh.vendor_id vendor_id, poh.currency_code currency_code, poh.approved_flag approved_flag, poh.closed_code closed_code, poh.org_id from po_lookup_codes plc, po_headers_all poh, hr_all_organization_units_vl haouv where poh.type_lookup_code in ( 'STANDARD', 'BLANKET', 'PLANNED' ) and plc.lookup_code = poh.type_lookup_code and plc.lookup_type = 'PO TYPE' and poh.org_id = haouv.organization_id and haouv.name = :$column$.operating_unit and poh.segment1 = nvl(:$column$.po_number,poh.segment1) and poh.pcard_id is null ) phav, po_lines_all pla, po_line_locations pll where phav.vendor_id = pv.vendor_id and phav.po_header_id = pla.po_header_id and pla.po_header_id = pll.po_header_id and pla.po_line_id = pll.po_line_id and pv.segment1 = :$column$.supplier_number and ( (:$column$.po_release_num is null and pll.po_release_id is null) or (:$column$.po_release_num is not null and exists (select null from po_releases pr where pr.release_num = :$column$.po_release_num and pr.po_release_id = pll.po_release_id ) ) ) and to_char(pla.line_num) = :$column$.po_line_num and nvl(pll.closed_code, 'X') <> 'FINALLY CLOSED' order by value 52 PO_DISTRIBUTION_NUM LOV custom number Y select pod.po_distribution_id id, pod.distribution_num value, hl.location_code || ' - Qty: ' || pod.quantity_ordered description from po_vendors pv, ( select poh.segment1 po_number, plc.displayed_field po_type, poh.po_header_id po_header_id, poh.vendor_id vendor_id, poh.currency_code currency_code, poh.approved_flag approved_flag, poh.closed_code closed_code, poh.org_id from po_lookup_codes plc, po_headers_all poh, hr_all_organization_units_vl haouv where poh.type_lookup_code in ( 'STANDARD', 'BLANKET', 'PLANNED' ) and plc.lookup_code = poh.type_lookup_code and plc.lookup_type = 'PO TYPE' and poh.org_id = haouv.organization_id and haouv.name = :$column$.operating_unit and poh.segment1 = nvl(:$column$.po_number,poh.segment1) and poh.pcard_id is null ) phav, po_lines_all pla, po_line_locations_ap_v pllav, po_distributions pod, hr_locations hl where phav.vendor_id = pv.vendor_id and phav.po_header_id = pla.po_header_id and pla.po_header_id = pllav.po_header_id and pla.po_line_id = pllav.po_line_id and pllav.po_header_id = pod.po_header_id and pllav.po_line_id = pod.po_line_id and pllav.line_location_id = pod.line_location_id and pod.deliver_to_location_id = hl.location_id(+) and pv.segment1 = :$column$.supplier_number and phav.currency_code = :$column$.invoice_currency and to_char(pla.line_num) = :$column$.po_line_num and pllav.shipment_num = :$column$.po_shipment_num order by value 53 PO_RECEIPT_NUM LOV custom varchar2 Y select rsh.shipment_header_id id, rsh.receipt_num value, null description from po_vendors pv, ( select poh.segment1 po_number, plc.displayed_field po_type, poh.po_header_id po_header_id, poh.vendor_id vendor_id, poh.currency_code currency_code, poh.approved_flag approved_flag, poh.closed_code closed_code, poh.org_id from po_lookup_codes plc, po_headers_all poh, hr_all_organization_units_vl haouv where poh.type_lookup_code in ( 'STANDARD', 'BLANKET', 'PLANNED' ) and plc.lookup_code = poh.type_lookup_code and plc.lookup_type = 'PO TYPE' and poh.org_id = haouv.organization_id and haouv.name = :$column$.operating_unit and poh.segment1 = nvl(:$column$.po_number,poh.segment1) and poh.pcard_id is null ) phav, po_lines_all pla, po_line_locations pll, rcv_shipment_headers rsh where phav.vendor_id = pv.vendor_id and phav.po_header_id = pla.po_header_id and pla.po_header_id = pll.po_header_id and pla.po_line_id = pll.po_line_id and pll.match_option = 'R' and nvl(pll.consigned_flag, 'N') <> 'Y' and pv.vendor_id = rsh.vendor_id and exists (select null from rcv_shipment_lines rsl1, rcv_transactions rtxn1 where rsl1.shipment_header_id=rsh.shipment_header_id and rsl1.po_header_id=pll.po_header_id and rsl1.po_line_location_id=pll.line_location_id and rtxn1.shipment_line_id=rsl1.shipment_line_id and rtxn1.currency_code=phav.currency_code ) and pv.segment1 = :$column$.supplier_number and phav.currency_code = :$column$.invoice_currency and to_char(pla.line_num) = :$column$.po_line_num and pll.shipment_num = :$column$.po_shipment_num order by value 54 PO_RECEIPT_LINE_NUM LOV custom number Y select parmv.rcv_transaction_id id, parmv.rcv_shipment_line_number value, null description from po_vendors pv, ( select poh.segment1 po_number, plc.displayed_field po_type, poh.po_header_id po_header_id, poh.vendor_id vendor_id, poh.currency_code currency_code, poh.approved_flag approved_flag, poh.closed_code closed_code, poh.org_id from po_lookup_codes plc, po_headers_all poh, hr_all_organization_units_vl haouv where poh.type_lookup_code in ( 'STANDARD', 'BLANKET', 'PLANNED' ) and plc.lookup_code = poh.type_lookup_code and plc.lookup_type = 'PO TYPE' and poh.org_id = haouv.organization_id and haouv.name = :$column$.operating_unit and poh.segment1 = nvl(:$column$.po_number,poh.segment1) and poh.pcard_id is null ) phav, po_lines_all pla, po_line_locations_ap_v pll, po_ap_receipt_match_v parmv where phav.vendor_id = pv.vendor_id and phav.po_header_id = pla.po_header_id and pla.po_header_id = pll.po_header_id and pla.po_line_id = pll.po_line_id and pv.vendor_id = parmv.vendor_id and pll.po_header_id = parmv.po_header_id and pll.line_location_id = parmv.po_line_location_id and parmv.po_match_option = 'R' and pv.segment1 = :$column$.supplier_number and phav.currency_code = :$column$.invoice_currency and to_char(pla.line_num) = :$column$.po_line_num and pll.shipment_num = :$column$.po_shipment_num and parmv.receipt_number = :$column$.po_receipt_num order by value 55 TRACK_AS_ASSET LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 56 PROJECT LOV custom varchar2 Y select pap.project_id id, pap.segment1 value, pap.name description from pa_projects_all pap order by pap.segment1 select project_id id, segment1 value from pa_projects_all pap 57 TASK LOV custom varchar2 Y select pt.task_id id, pt.task_number value, pt.task_name description from pa_projects_all pap, pa_tasks pt where pap.project_id = pt.project_id and pap.segment1 = :$column$.project order by pt.task_id select pt.task_id id, pt.task_number value from pa_projects_all pap, pa_tasks pt where pap.project_id = pt.project_id and pap.segment1 = :$column$.project 58 EXPENDITURE_ITEM_DATE Date date 59 EXPENDITURE_TYPE LOV custom varchar2 Y select pet.expenditure_type value, pet.description from pa_expenditure_types pet where pet.system_linkage_function = decode(xxen_util.lookup_code(:$column$.invoice_type,'INVOICE TYPE',200),'EXPENSE REPORT','ER','VI') and :$column$.expenditure_item_date between pet.start_date_active and nvl(pet.end_date_active,:$column$.expenditure_item_date) order by value 60 EXPENDITURE_ORGANIZATION LOV custom varchar2 Y select hrorg.organization_id id, hrorg.name value, null description from hr_organization_units hrorg, pa_all_organizations paorg, hr_all_organization_units_vl haouv where haouv.name = :$column$.operating_unit and haouv.organization_id=paorg.org_id and paorg.organization_id = hrorg.organization_id and paorg.pa_org_use_type = 'EXPENDITURES' and paorg.inactive_date is null order by value select hrorg.organization_id id, hrorg.name value from hr_organization_units hrorg, pa_all_organizations paorg, hr_all_organization_units_vl haouv where haouv.name = :$column$.operating_unit and haouv.organization_id=paorg.org_id and paorg.organization_id = hrorg.organization_id and paorg.pa_org_use_type = 'EXPENDITURES' and paorg.inactive_date is null 61 PROJECT_QUANTITY Number number 62 INCOME_TAX_TYPE LOV custom varchar2 Y select aitt.income_tax_type value, aitt.description from ap_income_tax_types aitt where sysdate < nvl(aitt.inactive_date, sysdate+1) order by upper(value) 63 INCOME_TAX_REGION LOV custom varchar2 Y select aitr.region_short_name value, aitr.region_long_name description from ap_income_tax_regions aitr where sysdate between nvl(aitr.active_date, sysdate) and nvl(aitr.inactive_date, sysdate) order by upper(value) 64 AMOUNT_INCLUDES_TAX_FLAG LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 65 TAX_CODE LOV custom varchar2 Y select distinct atca.name value, atca.description from hr_all_organization_units_vl haouv, ap_tax_codes_all atca where haouv.name = :$column$.operating_unit and atca.org_id = haouv.organization_id and atca.enabled_flag = 'Y' and nvl(atca.inactive_date,trunc(sysdate + 1)) > trunc(sysdate) 66 LINE_INVOICE_AWT_GROUP LOV custom varchar2 Y select aag.group_id id, aag.name value, aag.description from ap_awt_groups aag where trunc(sysdate) <= nvl(aag.inactive_date,trunc(sysdate)) and exists (select null from ap_awt_group_taxes aagt where aagt.group_id= aag.group_id) order by value 67 LINE_REFERENCE_1 Char varchar2 68 LINE_REFERENCE_2 Char varchar2 69 INVOICE_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id = fdfv.application_id and fdfcv.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfcv.enabled_flag = 'Y' and fdfv.application_id = 200 and fdfv.descriptive_flexfield_name = 'AP_INVOICES' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 70 AP_INV_ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICES', p_context_name => :$column$.invoice_attribute_category, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.ap_inv_attribute1, p_attribute2 => :$column$.ap_inv_attribute2, p_attribute3 => :$column$.ap_inv_attribute3, p_attribute4 => :$column$.ap_inv_attribute4, p_attribute5 => :$column$.ap_inv_attribute5, p_attribute6 => :$column$.ap_inv_attribute6, p_attribute7 => :$column$.ap_inv_attribute7, p_attribute8 => :$column$.ap_inv_attribute8, p_attribute9 => :$column$.ap_inv_attribute9, p_attribute10 => :$column$.ap_inv_attribute10, p_attribute11 => :$column$.ap_inv_attribute11, p_attribute12 => :$column$.ap_inv_attribute12, p_attribute13 => :$column$.ap_inv_attribute13, p_attribute14 => :$column$.ap_inv_attribute14, p_attribute15 => :$column$.ap_inv_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICES' and dffcu.application_column_name = 'ATTRIBUTE1' 71 AP_INV_ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICES', p_context_name => :$column$.invoice_attribute_category, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.ap_inv_attribute1, p_attribute2 => :$column$.ap_inv_attribute2, p_attribute3 => :$column$.ap_inv_attribute3, p_attribute4 => :$column$.ap_inv_attribute4, p_attribute5 => :$column$.ap_inv_attribute5, p_attribute6 => :$column$.ap_inv_attribute6, p_attribute7 => :$column$.ap_inv_attribute7, p_attribute8 => :$column$.ap_inv_attribute8, p_attribute9 => :$column$.ap_inv_attribute9, p_attribute10 => :$column$.ap_inv_attribute10, p_attribute11 => :$column$.ap_inv_attribute11, p_attribute12 => :$column$.ap_inv_attribute12, p_attribute13 => :$column$.ap_inv_attribute13, p_attribute14 => :$column$.ap_inv_attribute14, p_attribute15 => :$column$.ap_inv_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICES' and dffcu.application_column_name = 'ATTRIBUTE2' 72 AP_INV_ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICES', p_context_name => :$column$.invoice_attribute_category, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.ap_inv_attribute1, p_attribute2 => :$column$.ap_inv_attribute2, p_attribute3 => :$column$.ap_inv_attribute3, p_attribute4 => :$column$.ap_inv_attribute4, p_attribute5 => :$column$.ap_inv_attribute5, p_attribute6 => :$column$.ap_inv_attribute6, p_attribute7 => :$column$.ap_inv_attribute7, p_attribute8 => :$column$.ap_inv_attribute8, p_attribute9 => :$column$.ap_inv_attribute9, p_attribute10 => :$column$.ap_inv_attribute10, p_attribute11 => :$column$.ap_inv_attribute11, p_attribute12 => :$column$.ap_inv_attribute12, p_attribute13 => :$column$.ap_inv_attribute13, p_attribute14 => :$column$.ap_inv_attribute14, p_attribute15 => :$column$.ap_inv_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICES' and dffcu.application_column_name = 'ATTRIBUTE3' 73 AP_INV_ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICES', p_context_name => :$column$.invoice_attribute_category, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.ap_inv_attribute1, p_attribute2 => :$column$.ap_inv_attribute2, p_attribute3 => :$column$.ap_inv_attribute3, p_attribute4 => :$column$.ap_inv_attribute4, p_attribute5 => :$column$.ap_inv_attribute5, p_attribute6 => :$column$.ap_inv_attribute6, p_attribute7 => :$column$.ap_inv_attribute7, p_attribute8 => :$column$.ap_inv_attribute8, p_attribute9 => :$column$.ap_inv_attribute9, p_attribute10 => :$column$.ap_inv_attribute10, p_attribute11 => :$column$.ap_inv_attribute11, p_attribute12 => :$column$.ap_inv_attribute12, p_attribute13 => :$column$.ap_inv_attribute13, p_attribute14 => :$column$.ap_inv_attribute14, p_attribute15 => :$column$.ap_inv_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICES' and dffcu.application_column_name = 'ATTRIBUTE4' 74 AP_INV_ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICES', p_context_name => :$column$.invoice_attribute_category, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.ap_inv_attribute1, p_attribute2 => :$column$.ap_inv_attribute2, p_attribute3 => :$column$.ap_inv_attribute3, p_attribute4 => :$column$.ap_inv_attribute4, p_attribute5 => :$column$.ap_inv_attribute5, p_attribute6 => :$column$.ap_inv_attribute6, p_attribute7 => :$column$.ap_inv_attribute7, p_attribute8 => :$column$.ap_inv_attribute8, p_attribute9 => :$column$.ap_inv_attribute9, p_attribute10 => :$column$.ap_inv_attribute10, p_attribute11 => :$column$.ap_inv_attribute11, p_attribute12 => :$column$.ap_inv_attribute12, p_attribute13 => :$column$.ap_inv_attribute13, p_attribute14 => :$column$.ap_inv_attribute14, p_attribute15 => :$column$.ap_inv_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICES' and dffcu.application_column_name = 'ATTRIBUTE5' 75 AP_INV_ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICES', p_context_name => :$column$.invoice_attribute_category, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.ap_inv_attribute1, p_attribute2 => :$column$.ap_inv_attribute2, p_attribute3 => :$column$.ap_inv_attribute3, p_attribute4 => :$column$.ap_inv_attribute4, p_attribute5 => :$column$.ap_inv_attribute5, p_attribute6 => :$column$.ap_inv_attribute6, p_attribute7 => :$column$.ap_inv_attribute7, p_attribute8 => :$column$.ap_inv_attribute8, p_attribute9 => :$column$.ap_inv_attribute9, p_attribute10 => :$column$.ap_inv_attribute10, p_attribute11 => :$column$.ap_inv_attribute11, p_attribute12 => :$column$.ap_inv_attribute12, p_attribute13 => :$column$.ap_inv_attribute13, p_attribute14 => :$column$.ap_inv_attribute14, p_attribute15 => :$column$.ap_inv_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICES' and dffcu.application_column_name = 'ATTRIBUTE6' 76 AP_INV_ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICES', p_context_name => :$column$.invoice_attribute_category, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.ap_inv_attribute1, p_attribute2 => :$column$.ap_inv_attribute2, p_attribute3 => :$column$.ap_inv_attribute3, p_attribute4 => :$column$.ap_inv_attribute4, p_attribute5 => :$column$.ap_inv_attribute5, p_attribute6 => :$column$.ap_inv_attribute6, p_attribute7 => :$column$.ap_inv_attribute7, p_attribute8 => :$column$.ap_inv_attribute8, p_attribute9 => :$column$.ap_inv_attribute9, p_attribute10 => :$column$.ap_inv_attribute10, p_attribute11 => :$column$.ap_inv_attribute11, p_attribute12 => :$column$.ap_inv_attribute12, p_attribute13 => :$column$.ap_inv_attribute13, p_attribute14 => :$column$.ap_inv_attribute14, p_attribute15 => :$column$.ap_inv_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICES' and dffcu.application_column_name = 'ATTRIBUTE7' 77 AP_INV_ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICES', p_context_name => :$column$.invoice_attribute_category, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.ap_inv_attribute1, p_attribute2 => :$column$.ap_inv_attribute2, p_attribute3 => :$column$.ap_inv_attribute3, p_attribute4 => :$column$.ap_inv_attribute4, p_attribute5 => :$column$.ap_inv_attribute5, p_attribute6 => :$column$.ap_inv_attribute6, p_attribute7 => :$column$.ap_inv_attribute7, p_attribute8 => :$column$.ap_inv_attribute8, p_attribute9 => :$column$.ap_inv_attribute9, p_attribute10 => :$column$.ap_inv_attribute10, p_attribute11 => :$column$.ap_inv_attribute11, p_attribute12 => :$column$.ap_inv_attribute12, p_attribute13 => :$column$.ap_inv_attribute13, p_attribute14 => :$column$.ap_inv_attribute14, p_attribute15 => :$column$.ap_inv_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICES' and dffcu.application_column_name = 'ATTRIBUTE8' 78 AP_INV_ATTRIBUTE9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICES', p_context_name => :$column$.invoice_attribute_category, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.ap_inv_attribute1, p_attribute2 => :$column$.ap_inv_attribute2, p_attribute3 => :$column$.ap_inv_attribute3, p_attribute4 => :$column$.ap_inv_attribute4, p_attribute5 => :$column$.ap_inv_attribute5, p_attribute6 => :$column$.ap_inv_attribute6, p_attribute7 => :$column$.ap_inv_attribute7, p_attribute8 => :$column$.ap_inv_attribute8, p_attribute9 => :$column$.ap_inv_attribute9, p_attribute10 => :$column$.ap_inv_attribute10, p_attribute11 => :$column$.ap_inv_attribute11, p_attribute12 => :$column$.ap_inv_attribute12, p_attribute13 => :$column$.ap_inv_attribute13, p_attribute14 => :$column$.ap_inv_attribute14, p_attribute15 => :$column$.ap_inv_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICES' and dffcu.application_column_name = 'ATTRIBUTE9' 79 AP_INV_ATTRIBUTE10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICES', p_context_name => :$column$.invoice_attribute_category, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.ap_inv_attribute1, p_attribute2 => :$column$.ap_inv_attribute2, p_attribute3 => :$column$.ap_inv_attribute3, p_attribute4 => :$column$.ap_inv_attribute4, p_attribute5 => :$column$.ap_inv_attribute5, p_attribute6 => :$column$.ap_inv_attribute6, p_attribute7 => :$column$.ap_inv_attribute7, p_attribute8 => :$column$.ap_inv_attribute8, p_attribute9 => :$column$.ap_inv_attribute9, p_attribute10 => :$column$.ap_inv_attribute10, p_attribute11 => :$column$.ap_inv_attribute11, p_attribute12 => :$column$.ap_inv_attribute12, p_attribute13 => :$column$.ap_inv_attribute13, p_attribute14 => :$column$.ap_inv_attribute14, p_attribute15 => :$column$.ap_inv_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICES' and dffcu.application_column_name = 'ATTRIBUTE10' 80 AP_INV_ATTRIBUTE11 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICES', p_context_name => :$column$.invoice_attribute_category, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.ap_inv_attribute1, p_attribute2 => :$column$.ap_inv_attribute2, p_attribute3 => :$column$.ap_inv_attribute3, p_attribute4 => :$column$.ap_inv_attribute4, p_attribute5 => :$column$.ap_inv_attribute5, p_attribute6 => :$column$.ap_inv_attribute6, p_attribute7 => :$column$.ap_inv_attribute7, p_attribute8 => :$column$.ap_inv_attribute8, p_attribute9 => :$column$.ap_inv_attribute9, p_attribute10 => :$column$.ap_inv_attribute10, p_attribute11 => :$column$.ap_inv_attribute11, p_attribute12 => :$column$.ap_inv_attribute12, p_attribute13 => :$column$.ap_inv_attribute13, p_attribute14 => :$column$.ap_inv_attribute14, p_attribute15 => :$column$.ap_inv_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICES' and dffcu.application_column_name = 'ATTRIBUTE11' 81 AP_INV_ATTRIBUTE12 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICES', p_context_name => :$column$.invoice_attribute_category, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.ap_inv_attribute1, p_attribute2 => :$column$.ap_inv_attribute2, p_attribute3 => :$column$.ap_inv_attribute3, p_attribute4 => :$column$.ap_inv_attribute4, p_attribute5 => :$column$.ap_inv_attribute5, p_attribute6 => :$column$.ap_inv_attribute6, p_attribute7 => :$column$.ap_inv_attribute7, p_attribute8 => :$column$.ap_inv_attribute8, p_attribute9 => :$column$.ap_inv_attribute9, p_attribute10 => :$column$.ap_inv_attribute10, p_attribute11 => :$column$.ap_inv_attribute11, p_attribute12 => :$column$.ap_inv_attribute12, p_attribute13 => :$column$.ap_inv_attribute13, p_attribute14 => :$column$.ap_inv_attribute14, p_attribute15 => :$column$.ap_inv_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICES' and dffcu.application_column_name = 'ATTRIBUTE12' 82 AP_INV_ATTRIBUTE13 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICES', p_context_name => :$column$.invoice_attribute_category, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.ap_inv_attribute1, p_attribute2 => :$column$.ap_inv_attribute2, p_attribute3 => :$column$.ap_inv_attribute3, p_attribute4 => :$column$.ap_inv_attribute4, p_attribute5 => :$column$.ap_inv_attribute5, p_attribute6 => :$column$.ap_inv_attribute6, p_attribute7 => :$column$.ap_inv_attribute7, p_attribute8 => :$column$.ap_inv_attribute8, p_attribute9 => :$column$.ap_inv_attribute9, p_attribute10 => :$column$.ap_inv_attribute10, p_attribute11 => :$column$.ap_inv_attribute11, p_attribute12 => :$column$.ap_inv_attribute12, p_attribute13 => :$column$.ap_inv_attribute13, p_attribute14 => :$column$.ap_inv_attribute14, p_attribute15 => :$column$.ap_inv_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICES' and dffcu.application_column_name = 'ATTRIBUTE13' 83 AP_INV_ATTRIBUTE14 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICES', p_context_name => :$column$.invoice_attribute_category, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.ap_inv_attribute1, p_attribute2 => :$column$.ap_inv_attribute2, p_attribute3 => :$column$.ap_inv_attribute3, p_attribute4 => :$column$.ap_inv_attribute4, p_attribute5 => :$column$.ap_inv_attribute5, p_attribute6 => :$column$.ap_inv_attribute6, p_attribute7 => :$column$.ap_inv_attribute7, p_attribute8 => :$column$.ap_inv_attribute8, p_attribute9 => :$column$.ap_inv_attribute9, p_attribute10 => :$column$.ap_inv_attribute10, p_attribute11 => :$column$.ap_inv_attribute11, p_attribute12 => :$column$.ap_inv_attribute12, p_attribute13 => :$column$.ap_inv_attribute13, p_attribute14 => :$column$.ap_inv_attribute14, p_attribute15 => :$column$.ap_inv_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICES' and dffcu.application_column_name = 'ATTRIBUTE14' 84 AP_INV_ATTRIBUTE15 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICES', p_context_name => :$column$.invoice_attribute_category, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.ap_inv_attribute1, p_attribute2 => :$column$.ap_inv_attribute2, p_attribute3 => :$column$.ap_inv_attribute3, p_attribute4 => :$column$.ap_inv_attribute4, p_attribute5 => :$column$.ap_inv_attribute5, p_attribute6 => :$column$.ap_inv_attribute6, p_attribute7 => :$column$.ap_inv_attribute7, p_attribute8 => :$column$.ap_inv_attribute8, p_attribute9 => :$column$.ap_inv_attribute9, p_attribute10 => :$column$.ap_inv_attribute10, p_attribute11 => :$column$.ap_inv_attribute11, p_attribute12 => :$column$.ap_inv_attribute12, p_attribute13 => :$column$.ap_inv_attribute13, p_attribute14 => :$column$.ap_inv_attribute14, p_attribute15 => :$column$.ap_inv_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICES' and dffcu.application_column_name = 'ATTRIBUTE15' 85 LINE_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id = fdfv.application_id and fdfcv.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfcv.enabled_flag = 'Y' and fdfv.application_id = 200 and fdfv.descriptive_flexfield_name = 'AP_INVOICE_DISTRIBUTIONS' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 86 AP_INV_LINE_ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.ap_inv_line_attribute1, p_attribute2 => :$column$.ap_inv_line_attribute2, p_attribute3 => :$column$.ap_inv_line_attribute3, p_attribute4 => :$column$.ap_inv_line_attribute4, p_attribute5 => :$column$.ap_inv_line_attribute5, p_attribute6 => :$column$.ap_inv_line_attribute6, p_attribute7 => :$column$.ap_inv_line_attribute7, p_attribute8 => :$column$.ap_inv_line_attribute8, p_attribute9 => :$column$.ap_inv_line_attribute9, p_attribute10 => :$column$.ap_inv_line_attribute10, p_attribute11 => :$column$.ap_inv_line_attribute11, p_attribute12 => :$column$.ap_inv_line_attribute12, p_attribute13 => :$column$.ap_inv_line_attribute13, p_attribute14 => :$column$.ap_inv_line_attribute14, p_attribute15 => :$column$.ap_inv_line_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICE_DISTRIBUTIONS' and dffcu.application_column_name = 'ATTRIBUTE1' 87 AP_INV_LINE_ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.ap_inv_line_attribute1, p_attribute2 => :$column$.ap_inv_line_attribute2, p_attribute3 => :$column$.ap_inv_line_attribute3, p_attribute4 => :$column$.ap_inv_line_attribute4, p_attribute5 => :$column$.ap_inv_line_attribute5, p_attribute6 => :$column$.ap_inv_line_attribute6, p_attribute7 => :$column$.ap_inv_line_attribute7, p_attribute8 => :$column$.ap_inv_line_attribute8, p_attribute9 => :$column$.ap_inv_line_attribute9, p_attribute10 => :$column$.ap_inv_line_attribute10, p_attribute11 => :$column$.ap_inv_line_attribute11, p_attribute12 => :$column$.ap_inv_line_attribute12, p_attribute13 => :$column$.ap_inv_line_attribute13, p_attribute14 => :$column$.ap_inv_line_attribute14, p_attribute15 => :$column$.ap_inv_line_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICE_DISTRIBUTIONS' and dffcu.application_column_name = 'ATTRIBUTE2' 88 AP_INV_LINE_ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.ap_inv_line_attribute1, p_attribute2 => :$column$.ap_inv_line_attribute2, p_attribute3 => :$column$.ap_inv_line_attribute3, p_attribute4 => :$column$.ap_inv_line_attribute4, p_attribute5 => :$column$.ap_inv_line_attribute5, p_attribute6 => :$column$.ap_inv_line_attribute6, p_attribute7 => :$column$.ap_inv_line_attribute7, p_attribute8 => :$column$.ap_inv_line_attribute8, p_attribute9 => :$column$.ap_inv_line_attribute9, p_attribute10 => :$column$.ap_inv_line_attribute10, p_attribute11 => :$column$.ap_inv_line_attribute11, p_attribute12 => :$column$.ap_inv_line_attribute12, p_attribute13 => :$column$.ap_inv_line_attribute13, p_attribute14 => :$column$.ap_inv_line_attribute14, p_attribute15 => :$column$.ap_inv_line_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICE_DISTRIBUTIONS' and dffcu.application_column_name = 'ATTRIBUTE3' 89 AP_INV_LINE_ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.ap_inv_line_attribute1, p_attribute2 => :$column$.ap_inv_line_attribute2, p_attribute3 => :$column$.ap_inv_line_attribute3, p_attribute4 => :$column$.ap_inv_line_attribute4, p_attribute5 => :$column$.ap_inv_line_attribute5, p_attribute6 => :$column$.ap_inv_line_attribute6, p_attribute7 => :$column$.ap_inv_line_attribute7, p_attribute8 => :$column$.ap_inv_line_attribute8, p_attribute9 => :$column$.ap_inv_line_attribute9, p_attribute10 => :$column$.ap_inv_line_attribute10, p_attribute11 => :$column$.ap_inv_line_attribute11, p_attribute12 => :$column$.ap_inv_line_attribute12, p_attribute13 => :$column$.ap_inv_line_attribute13, p_attribute14 => :$column$.ap_inv_line_attribute14, p_attribute15 => :$column$.ap_inv_line_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICE_DISTRIBUTIONS' and dffcu.application_column_name = 'ATTRIBUTE4' 90 AP_INV_LINE_ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.ap_inv_line_attribute1, p_attribute2 => :$column$.ap_inv_line_attribute2, p_attribute3 => :$column$.ap_inv_line_attribute3, p_attribute4 => :$column$.ap_inv_line_attribute4, p_attribute5 => :$column$.ap_inv_line_attribute5, p_attribute6 => :$column$.ap_inv_line_attribute6, p_attribute7 => :$column$.ap_inv_line_attribute7, p_attribute8 => :$column$.ap_inv_line_attribute8, p_attribute9 => :$column$.ap_inv_line_attribute9, p_attribute10 => :$column$.ap_inv_line_attribute10, p_attribute11 => :$column$.ap_inv_line_attribute11, p_attribute12 => :$column$.ap_inv_line_attribute12, p_attribute13 => :$column$.ap_inv_line_attribute13, p_attribute14 => :$column$.ap_inv_line_attribute14, p_attribute15 => :$column$.ap_inv_line_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICE_DISTRIBUTIONS' and dffcu.application_column_name = 'ATTRIBUTE5' 91 AP_INV_LINE_ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.ap_inv_line_attribute1, p_attribute2 => :$column$.ap_inv_line_attribute2, p_attribute3 => :$column$.ap_inv_line_attribute3, p_attribute4 => :$column$.ap_inv_line_attribute4, p_attribute5 => :$column$.ap_inv_line_attribute5, p_attribute6 => :$column$.ap_inv_line_attribute6, p_attribute7 => :$column$.ap_inv_line_attribute7, p_attribute8 => :$column$.ap_inv_line_attribute8, p_attribute9 => :$column$.ap_inv_line_attribute9, p_attribute10 => :$column$.ap_inv_line_attribute10, p_attribute11 => :$column$.ap_inv_line_attribute11, p_attribute12 => :$column$.ap_inv_line_attribute12, p_attribute13 => :$column$.ap_inv_line_attribute13, p_attribute14 => :$column$.ap_inv_line_attribute14, p_attribute15 => :$column$.ap_inv_line_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICE_DISTRIBUTIONS' and dffcu.application_column_name = 'ATTRIBUTE6' 92 AP_INV_LINE_ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.ap_inv_line_attribute1, p_attribute2 => :$column$.ap_inv_line_attribute2, p_attribute3 => :$column$.ap_inv_line_attribute3, p_attribute4 => :$column$.ap_inv_line_attribute4, p_attribute5 => :$column$.ap_inv_line_attribute5, p_attribute6 => :$column$.ap_inv_line_attribute6, p_attribute7 => :$column$.ap_inv_line_attribute7, p_attribute8 => :$column$.ap_inv_line_attribute8, p_attribute9 => :$column$.ap_inv_line_attribute9, p_attribute10 => :$column$.ap_inv_line_attribute10, p_attribute11 => :$column$.ap_inv_line_attribute11, p_attribute12 => :$column$.ap_inv_line_attribute12, p_attribute13 => :$column$.ap_inv_line_attribute13, p_attribute14 => :$column$.ap_inv_line_attribute14, p_attribute15 => :$column$.ap_inv_line_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICE_DISTRIBUTIONS' and dffcu.application_column_name = 'ATTRIBUTE7' 93 AP_INV_LINE_ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.ap_inv_line_attribute1, p_attribute2 => :$column$.ap_inv_line_attribute2, p_attribute3 => :$column$.ap_inv_line_attribute3, p_attribute4 => :$column$.ap_inv_line_attribute4, p_attribute5 => :$column$.ap_inv_line_attribute5, p_attribute6 => :$column$.ap_inv_line_attribute6, p_attribute7 => :$column$.ap_inv_line_attribute7, p_attribute8 => :$column$.ap_inv_line_attribute8, p_attribute9 => :$column$.ap_inv_line_attribute9, p_attribute10 => :$column$.ap_inv_line_attribute10, p_attribute11 => :$column$.ap_inv_line_attribute11, p_attribute12 => :$column$.ap_inv_line_attribute12, p_attribute13 => :$column$.ap_inv_line_attribute13, p_attribute14 => :$column$.ap_inv_line_attribute14, p_attribute15 => :$column$.ap_inv_line_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICE_DISTRIBUTIONS' and dffcu.application_column_name = 'ATTRIBUTE8' 94 AP_INV_LINE_ATTRIBUTE9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.ap_inv_line_attribute1, p_attribute2 => :$column$.ap_inv_line_attribute2, p_attribute3 => :$column$.ap_inv_line_attribute3, p_attribute4 => :$column$.ap_inv_line_attribute4, p_attribute5 => :$column$.ap_inv_line_attribute5, p_attribute6 => :$column$.ap_inv_line_attribute6, p_attribute7 => :$column$.ap_inv_line_attribute7, p_attribute8 => :$column$.ap_inv_line_attribute8, p_attribute9 => :$column$.ap_inv_line_attribute9, p_attribute10 => :$column$.ap_inv_line_attribute10, p_attribute11 => :$column$.ap_inv_line_attribute11, p_attribute12 => :$column$.ap_inv_line_attribute12, p_attribute13 => :$column$.ap_inv_line_attribute13, p_attribute14 => :$column$.ap_inv_line_attribute14, p_attribute15 => :$column$.ap_inv_line_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICE_DISTRIBUTIONS' and dffcu.application_column_name = 'ATTRIBUTE9' 95 AP_INV_LINE_ATTRIBUTE10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.ap_inv_line_attribute1, p_attribute2 => :$column$.ap_inv_line_attribute2, p_attribute3 => :$column$.ap_inv_line_attribute3, p_attribute4 => :$column$.ap_inv_line_attribute4, p_attribute5 => :$column$.ap_inv_line_attribute5, p_attribute6 => :$column$.ap_inv_line_attribute6, p_attribute7 => :$column$.ap_inv_line_attribute7, p_attribute8 => :$column$.ap_inv_line_attribute8, p_attribute9 => :$column$.ap_inv_line_attribute9, p_attribute10 => :$column$.ap_inv_line_attribute10, p_attribute11 => :$column$.ap_inv_line_attribute11, p_attribute12 => :$column$.ap_inv_line_attribute12, p_attribute13 => :$column$.ap_inv_line_attribute13, p_attribute14 => :$column$.ap_inv_line_attribute14, p_attribute15 => :$column$.ap_inv_line_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICE_DISTRIBUTIONS' and dffcu.application_column_name = 'ATTRIBUTE10' 96 AP_INV_LINE_ATTRIBUTE11 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.ap_inv_line_attribute1, p_attribute2 => :$column$.ap_inv_line_attribute2, p_attribute3 => :$column$.ap_inv_line_attribute3, p_attribute4 => :$column$.ap_inv_line_attribute4, p_attribute5 => :$column$.ap_inv_line_attribute5, p_attribute6 => :$column$.ap_inv_line_attribute6, p_attribute7 => :$column$.ap_inv_line_attribute7, p_attribute8 => :$column$.ap_inv_line_attribute8, p_attribute9 => :$column$.ap_inv_line_attribute9, p_attribute10 => :$column$.ap_inv_line_attribute10, p_attribute11 => :$column$.ap_inv_line_attribute11, p_attribute12 => :$column$.ap_inv_line_attribute12, p_attribute13 => :$column$.ap_inv_line_attribute13, p_attribute14 => :$column$.ap_inv_line_attribute14, p_attribute15 => :$column$.ap_inv_line_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICE_DISTRIBUTIONS' and dffcu.application_column_name = 'ATTRIBUTE11' 97 AP_INV_LINE_ATTRIBUTE12 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.ap_inv_line_attribute1, p_attribute2 => :$column$.ap_inv_line_attribute2, p_attribute3 => :$column$.ap_inv_line_attribute3, p_attribute4 => :$column$.ap_inv_line_attribute4, p_attribute5 => :$column$.ap_inv_line_attribute5, p_attribute6 => :$column$.ap_inv_line_attribute6, p_attribute7 => :$column$.ap_inv_line_attribute7, p_attribute8 => :$column$.ap_inv_line_attribute8, p_attribute9 => :$column$.ap_inv_line_attribute9, p_attribute10 => :$column$.ap_inv_line_attribute10, p_attribute11 => :$column$.ap_inv_line_attribute11, p_attribute12 => :$column$.ap_inv_line_attribute12, p_attribute13 => :$column$.ap_inv_line_attribute13, p_attribute14 => :$column$.ap_inv_line_attribute14, p_attribute15 => :$column$.ap_inv_line_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICE_DISTRIBUTIONS' and dffcu.application_column_name = 'ATTRIBUTE12' 98 AP_INV_LINE_ATTRIBUTE13 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.ap_inv_line_attribute1, p_attribute2 => :$column$.ap_inv_line_attribute2, p_attribute3 => :$column$.ap_inv_line_attribute3, p_attribute4 => :$column$.ap_inv_line_attribute4, p_attribute5 => :$column$.ap_inv_line_attribute5, p_attribute6 => :$column$.ap_inv_line_attribute6, p_attribute7 => :$column$.ap_inv_line_attribute7, p_attribute8 => :$column$.ap_inv_line_attribute8, p_attribute9 => :$column$.ap_inv_line_attribute9, p_attribute10 => :$column$.ap_inv_line_attribute10, p_attribute11 => :$column$.ap_inv_line_attribute11, p_attribute12 => :$column$.ap_inv_line_attribute12, p_attribute13 => :$column$.ap_inv_line_attribute13, p_attribute14 => :$column$.ap_inv_line_attribute14, p_attribute15 => :$column$.ap_inv_line_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICE_DISTRIBUTIONS' and dffcu.application_column_name = 'ATTRIBUTE13' 99 AP_INV_LINE_ATTRIBUTE14 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.ap_inv_line_attribute1, p_attribute2 => :$column$.ap_inv_line_attribute2, p_attribute3 => :$column$.ap_inv_line_attribute3, p_attribute4 => :$column$.ap_inv_line_attribute4, p_attribute5 => :$column$.ap_inv_line_attribute5, p_attribute6 => :$column$.ap_inv_line_attribute6, p_attribute7 => :$column$.ap_inv_line_attribute7, p_attribute8 => :$column$.ap_inv_line_attribute8, p_attribute9 => :$column$.ap_inv_line_attribute9, p_attribute10 => :$column$.ap_inv_line_attribute10, p_attribute11 => :$column$.ap_inv_line_attribute11, p_attribute12 => :$column$.ap_inv_line_attribute12, p_attribute13 => :$column$.ap_inv_line_attribute13, p_attribute14 => :$column$.ap_inv_line_attribute14, p_attribute15 => :$column$.ap_inv_line_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICE_DISTRIBUTIONS' and dffcu.application_column_name = 'ATTRIBUTE14' 100 AP_INV_LINE_ATTRIBUTE15 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.line_attribute_category, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.ap_inv_line_attribute1, p_attribute2 => :$column$.ap_inv_line_attribute2, p_attribute3 => :$column$.ap_inv_line_attribute3, p_attribute4 => :$column$.ap_inv_line_attribute4, p_attribute5 => :$column$.ap_inv_line_attribute5, p_attribute6 => :$column$.ap_inv_line_attribute6, p_attribute7 => :$column$.ap_inv_line_attribute7, p_attribute8 => :$column$.ap_inv_line_attribute8, p_attribute9 => :$column$.ap_inv_line_attribute9, p_attribute10 => :$column$.ap_inv_line_attribute10, p_attribute11 => :$column$.ap_inv_line_attribute11, p_attribute12 => :$column$.ap_inv_line_attribute12, p_attribute13 => :$column$.ap_inv_line_attribute13, p_attribute14 => :$column$.ap_inv_line_attribute14, p_attribute15 => :$column$.ap_inv_line_attribute15 ) ) lov order by value SELECT distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) FROM fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu WHERE dffcx.application_id = dff.application_id and dffcx.descriptive_flexfield_name = dff.descriptive_flexfield_name and dffcx.enabled_flag = 'Y' and dffcu.application_id = dffcx.application_id and dffcu.descriptive_flexfield_name = dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code = dffcx.descriptive_flex_context_code and dffcu.enabled_flag = 'Y' and dff.application_id = 200 and dff.descriptive_flexfield_name = 'AP_INVOICE_DISTRIBUTIONS' and dffcu.application_column_name = 'ATTRIBUTE15' 101 ATTACHMENT_CATEGORY_ LOV custom varchar2 Y select fdcuv.user_name value, null description from fnd_doc_category_usages_vl fdcuv, fnd_attachment_functions af, fnd_document_categories fdc where fdcuv.attachment_function_id=af.attachment_function_id and af.function_name='APXINWKB' and af.function_type='O' and fdc.category_id=fdcuv.category_id and nvl(fdc.start_date_active,sysdate-1)<=sysdate and nvl(fdc.start_date_active,sysdate+1)>sysdate Required for adding an attachment 102 ATTACHMENT_TITLE_ Char varchar2 103 ATTACHMENT_DESCRIPTION_ Char varchar2 104 ATTACHMENT_TYPE_ LOV custom varchar2 Y select user_name value, null description from fnd_document_datatypes_vl where name in ('SHORT_TEXT','FILE') Required for adding an attachment 105 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 106 ATTACHMENT_FILE_ID_ Char varchar2 Autopopulated after clicking on Upload Attachments U 1 action_ in Char ACTION_CODE_ U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 4 request_id_ out Number REQUEST_ID_ U 5 p_row_id in/out Char ROW_ID U 6 p_source in Char SOURCE U 7 p_operating_unit in Char OPERATING_UNIT U 8 p_invoice_type in Char Y INVOICE_TYPE U 9 p_supplier_name in Char SUPPLIER_NAME U 10 p_supplier_num in Char SUPPLIER_NAME U 11 p_supplier_site in Char SUPPLIER_SITE U 12 p_invoice_po_number in Char Y INVOICE_PO_NUMBER U 13 p_invoice_date in Date INVOICE_DATE U 14 p_gl_date in Date Y GL_DATE U 15 p_invoice_number in Char INVOICE_NUMBER U 16 p_invoice_description in Char INVOICE_DESCRIPTION U 17 p_invoice_amount in Number INVOICE_AMOUNT U 18 p_amount_applicable_to_disc in Number Y AMOUNT_APPLICABLE_TO_DISCOUNT U 19 p_terms in Char Y TERMS U 20 p_terms_date in Date Y TERMS_DATE U 21 p_goods_received_date in Date Y GOODS_RECEIVED_DATE U 22 p_invoice_received_date in Date Y INVOICE_RECEIVED_DATE U 23 p_invoice_currency in Char INVOICE_CURRENCY U 24 p_exchange_rate_type in Char Y EXCHANGE_RATE_TYPE U 25 p_exchange_date in Date Y EXCHANGE_DATE U 26 p_exchange_rate in Number Y EXCHANGE_RATE U 27 p_payment_currency in Char Y PAYMENT_CURRENCY U 28 p_payment_cross_rate_type in Char Y PAYMENT_CROSS_RATE_TYPE U 29 p_payment_cross_rate_date in Date Y PAYMENT_CROSS_RATE_DATE U 30 p_payment_cross_rate in Number Y PAYMENT_CROSS_RATE U 31 p_payment_group in Char Y PAYMENT_GROUP U 32 p_payment_method in Char Y PAYMENT_METHOD U 33 p_exclusive_payment_flag in Char Y EXCLUSIVE_PAYMENT_FLAG U 34 p_awt_group_name in Char Y U 35 p_header_requester_id in Number Y U 36 p_line_num in Number PO_LINE_NUM U 37 p_line_type in Char Y LINE_TYPE U 38 p_line_amount in Number LINE_AMOUNT U 39 p_quantity_invoiced in Number Y U 40 p_unit_price in Number Y UNIT_PRICE U 41 p_line_description in Char Y LINE_DESCRIPTION U 42 p_dist_account_segments in Char Y U 43 p_dist_account_alias in Char Y DISTRIBUTION_ACCOUNT_ALIAS U 44 p_distribution_set_name in Char Y DISTRIBUTION_SET U 45 p_line_po_number in Char Y INVOICE_PO_NUMBER U 46 p_line_po_release_num in Number Y PO_RELEASE_NUM U 47 p_line_po_line_num in Number Y PO_RECEIPT_LINE_NUM U 48 p_line_po_shipment_num in Number Y PO_SHIPMENT_NUM U 49 p_line_po_distribution_num in Number Y PO_DISTRIBUTION_NUM U 50 p_line_receipt_number in Char Y PO_RECEIPT_NUM U 51 p_line_receipt_line_num in Number Y PO_RECEIPT_LINE_NUM U 52 p_project_id in Number Y PROJECT U 53 p_task_id in Number Y U 54 p_expenditure_type in Char Y EXPENDITURE_TYPE U 55 p_expenditure_item_date in Date Y EXPENDITURE_ITEM_DATE U 56 p_expenditure_organization_id in Number Y EXPENDITURE_ORGANIZATION U 57 p_pa_quantity in Number Y PROJECT_QUANTITY U 58 p_assets_tracking_flag in Char Y U 59 p_type_1099 in Char Y U 60 p_income_tax_region in Char Y INCOME_TAX_REGION U 61 p_tax_code in Char Y TAX_CODE U 62 p_inv_line_incl_of_tax in Char Y AP_INV_LINE_ATTRIBUTE1 U 63 p_line_awt_group_name in Char Y INVOICE_AWT_GROUP U 64 p_lin_reference_1 in Char Y LINE_REFERENCE_1 U 65 p_lin_reference_2 in Char Y LINE_REFERENCE_2 U 66 p_inv_attribute_category in Char Y LINE_ATTRIBUTE_CATEGORY U 67 p_inv_attribute1 in Char Y AP_INV_ATTRIBUTE1 U 68 p_inv_attribute2 in Char Y AP_INV_ATTRIBUTE2 U 69 p_inv_attribute3 in Char Y AP_INV_ATTRIBUTE3 U 70 p_inv_attribute4 in Char Y AP_INV_ATTRIBUTE4 U 71 p_inv_attribute5 in Char Y AP_INV_ATTRIBUTE5 U 72 p_inv_attribute6 in Char Y AP_INV_ATTRIBUTE6 U 73 p_inv_attribute7 in Char Y AP_INV_ATTRIBUTE7 U 74 p_inv_attribute8 in Char Y AP_INV_ATTRIBUTE8 U 75 p_inv_attribute9 in Char Y AP_INV_ATTRIBUTE9 U 76 p_inv_attribute10 in Char Y AP_INV_ATTRIBUTE10 U 77 p_inv_attribute11 in Char Y AP_INV_ATTRIBUTE11 U 78 p_inv_attribute12 in Char Y AP_INV_ATTRIBUTE12 U 79 p_inv_attribute13 in Char Y AP_INV_ATTRIBUTE13 U 80 p_inv_attribute14 in Char Y AP_INV_ATTRIBUTE14 U 81 p_inv_attribute15 in Char Y AP_INV_ATTRIBUTE15 U 82 p_lin_attribute_category in Char Y LINE_ATTRIBUTE_CATEGORY U 83 p_lin_attribute1 in Char Y AP_INV_ATTRIBUTE1 U 84 p_lin_attribute2 in Char Y AP_INV_ATTRIBUTE2 U 85 p_lin_attribute3 in Char Y AP_INV_ATTRIBUTE3 U 86 p_lin_attribute4 in Char Y AP_INV_ATTRIBUTE4 U 87 p_lin_attribute5 in Char Y AP_INV_ATTRIBUTE5 U 88 p_lin_attribute6 in Char Y AP_INV_ATTRIBUTE6 U 89 p_lin_attribute7 in Char Y AP_INV_ATTRIBUTE7 U 90 p_lin_attribute8 in Char Y AP_INV_ATTRIBUTE8 U 91 p_lin_attribute9 in Char Y AP_INV_ATTRIBUTE9 U 92 p_lin_attribute10 in Char Y AP_INV_ATTRIBUTE10 U 93 p_lin_attribute11 in Char Y AP_INV_ATTRIBUTE11 U 94 p_lin_attribute12 in Char Y AP_INV_ATTRIBUTE12 U 95 p_lin_attribute13 in Char Y AP_INV_ATTRIBUTE13 U 96 p_lin_attribute14 in Char Y AP_INV_ATTRIBUTE14 U 97 p_lin_attribute15 in Char Y AP_INV_ATTRIBUTE15 P 1 status_ out Char STATUS_CODE_ P 2 message_ out Char MESSAGE_ P 3 request_id_ out Number REQUEST_ID_ P 4 p_source in Char SOURCE P 5 p_batch_name in Char BATCH_NAME P 6 p_gl_date in Date Y GL_DATE P 7 p_submit_validation in Char Y SUBMIT_VALIDATION Lexical &error_with_query ,q_reporting_table as ( select case when aii.status = 'PROCESSED' then xxen_upload.status_success when aili.invoice_id is not null then xxen_upload.status_error else xm.status_code_ end pstatus, case when aii.status = 'PROCESSED' then xxen_upload.status_meaning(xxen_upload.status_success) when aili.invoice_id is not null then xxen_upload.status_meaning(xxen_upload.status_error) else xm.status_ end pstatus_dsp, -- case when aii.status = 'PROCESSED' then xxen_upload.status_meaning(xxen_upload.status_success) when aii.status = 'REJECTED' then (select distinct listagg(coalesce(xxen_util.meaning(air.reject_lookup_code,'REJECT CODE',200), case when air.reject_lookup_code like 'ZX%' then fnd_message.get_string('ZX',air.reject_lookup_code) else null end, air.reject_lookup_code ) ,chr(10)) within group (order by decode(air.parent_table,'AP_INVOICES_INTERFACE',1,2),air.reject_lookup_code) text from ap_interface_rejections air where ( (air.parent_table = 'AP_INVOICES_INTERFACE' and air.parent_id = aili.invoice_id) or (air.parent_table = 'AP_INVOICE_LINES_INTERFACE' and air.parent_id = aili.invoice_line_id) ) ) when xm.status_code_ = xxen_upload.status_error then xm.message_ else null end pmessage, aii.request_id prequestid, xm.action_code_, xm.status_code_, xm.message_, xm.request_id_, xm.modified_columns_, xm.row_id, xm.batch_name, xm.submit_validation, -- nvl(xm.source,:p_source) source, nvl(xm.operating_unit,:p_operating_unit) operating_unit, xm.supplier_name, xm.supplier_number, xm.supplier_site, xm.invoice_type, xm.invoice_number, xm.invoice_description, xm.invoice_po_number, xm.invoice_date invoice_date, nvl(xm.gl_date,aii.gl_date) gl_date, xm.invoice_amount, xm.amount_applicable_to_discount, xm.invoice_currency, xm.exchange_rate_type, xm.exchange_date, xm.exchange_rate, nvl(xm.terms,aii.terms_name) terms, nvl(xm.terms_date,aii.terms_date) terms_date, nvl(xm.goods_received_date,aii.goods_received_date) goods_received_date, nvl(xm.invoice_received_date,aii.invoice_received_date) invoice_received_date, xm.exclusive_payment_flag, nvl(xm.payment_currency,aii.payment_currency_code) payment_currency, xm.payment_cross_rate_type, xm.payment_cross_rate_date, xm.payment_cross_rate, nvl(xm.payment_method,xxen_util.meaning(aii.payment_method_lookup_code,'PAYMENT METHOD',200)) payment_method, xm.payment_group, --xm.payment_priority, xm.invoice_awt_group, --xm.ussgl_transaction_code, -- xm.line_number, xm.line_type, xm.line_amount, xm.line_description, xm.quantity, xm.unit_price, -- xm.distribution_account_alias, xm.distribution_account, xm.distribution_set, -- xm.requester, -- xm.po_number, xm.po_release_num, xm.po_line_num, xm.po_shipment_num, xm.po_distribution_num, xm.po_receipt_num, xm.po_receipt_line_num, -- xm.track_as_asset, -- xm.project, xm.task, xm.expenditure_item_date, xm.expenditure_type, xm.expenditure_organization, xm.project_quantity, -- xm.income_tax_type, xm.income_tax_region, -- xm.amount_includes_tax_flag, xm.tax_code, -- xm.line_invoice_awt_group, -- xm.line_reference_1, xm.line_reference_2, -- xm.invoice_attribute_category, xm.ap_inv_attribute1, xm.ap_inv_attribute2, xm.ap_inv_attribute3, xm.ap_inv_attribute4, xm.ap_inv_attribute5, xm.ap_inv_attribute6, xm.ap_inv_attribute7, xm.ap_inv_attribute8, xm.ap_inv_attribute9, xm.ap_inv_attribute10, xm.ap_inv_attribute11, xm.ap_inv_attribute12, xm.ap_inv_attribute13, xm.ap_inv_attribute14, xm.ap_inv_attribute15, xm.line_attribute_category, xm.ap_inv_line_attribute1, xm.ap_inv_line_attribute2, xm.ap_inv_line_attribute3, xm.ap_inv_line_attribute4, xm.ap_inv_line_attribute5, xm.ap_inv_line_attribute6, xm.ap_inv_line_attribute7, xm.ap_inv_line_attribute8, xm.ap_inv_line_attribute9, xm.ap_inv_line_attribute10, xm.ap_inv_line_attribute11, xm.ap_inv_line_attribute12, xm.ap_inv_line_attribute13, xm.ap_inv_line_attribute14, xm.ap_inv_line_attribute15, xm.attachment_category_, xm.attachment_title_, xm.attachment_description_, xm.attachment_type_, xm.attachment_content_, xm.attachment_file_id_ from &report_table_name xm, ap_invoice_lines_interface aili, ap_invoices_interface aii where xm.row_id = aili.rowid (+) and aili.invoice_id = aii.invoice_id (+) ) Lexical &not_use_first_block and 1=0 Lexical &processed_run and 'Y'='Y' Lexical &processed_run_query union all select /* push_pred(inv) */ xm.action_code_, decode(inv.invoice_id,null,xxen_upload.status_meaning(xxen_upload.status_error),xm.pstatus_dsp) status_, nvl(xm.pmessage,nvl2(inv.invoice_id,xxen_upload.status_meaning(xxen_upload.status_success),'One or more lines in the invoice have errors')) message_, xm.prequestid request_id_, xm.modified_columns_, xm.row_id row_id, xm.batch_name, xm.submit_validation, -- decode(inv.invoice_id,null,xm.source,inv.source) source, decode(inv.invoice_id,null,xm.operating_unit,inv.operating_unit) operating_unit, decode(inv.invoice_id,null,xm.supplier_name,inv.supplier_name) supplier_name, decode(inv.invoice_id,null,xm.supplier_number,inv.supplier_number) supplier_number, decode(inv.invoice_id,null,xm.supplier_site,inv.supplier_site) supplier_site, decode(inv.invoice_id,null,xm.invoice_type,inv.invoice_type) invoice_type, decode(inv.invoice_id,null,xm.invoice_number,inv.invoice_number) invoice_number, decode(inv.invoice_id,null,xm.invoice_description,inv.invoice_description) invoice_description, decode(inv.invoice_id,null,xm.invoice_po_number,inv.invoice_po_number) invoice_po_number, decode(inv.invoice_id,null,xm.invoice_date,inv.invoice_date) invoice_date, decode(inv.invoice_id,null,xm.gl_date,inv.gl_date) gl_date, decode(inv.invoice_id,null,xm.invoice_amount,inv.invoice_amount) invoice_amount, decode(inv.invoice_id,null,xm.amount_applicable_to_discount,inv.amount_applicable_to_discount) amount_applicable_to_discount, decode(inv.invoice_id,null,xm.invoice_currency,inv.invoice_currency) invoice_currency, decode(inv.invoice_id,null,xm.exchange_rate_type,inv.exchange_rate_type) exchange_rate_type, decode(inv.invoice_id,null,xm.exchange_date,inv.exchange_date) exchange_date, decode(inv.invoice_id,null,xm.exchange_rate,inv.exchange_rate) exchange_rate, decode(inv.invoice_id,null,xm.terms,inv.terms) terms, decode(inv.invoice_id,null,xm.terms_date,inv.terms_date) terms_date, decode(inv.invoice_id,null,xm.goods_received_date,inv.goods_received_date) goods_received_date, decode(inv.invoice_id,null,xm.invoice_received_date,inv.invoice_received_date) invoice_received_date, decode(inv.invoice_id,null,xm.exclusive_payment_flag,inv.exclusive_payment_flag) exclusive_payment_flag, decode(inv.invoice_id,null,xm.payment_currency,inv.payment_currency) payment_currency, decode(inv.invoice_id,null,xm.payment_cross_rate_type,inv.payment_cross_rate_type) payment_cross_rate_type, decode(inv.invoice_id,null,xm.payment_cross_rate_date,inv.payment_cross_rate_date) payment_cross_rate_date, decode(inv.invoice_id,null,xm.payment_cross_rate,inv.payment_cross_rate) payment_cross_rate, decode(inv.invoice_id,null,xm.payment_method,inv.payment_method) payment_method, decode(inv.invoice_id,null,xm.payment_group,inv.payment_group) payment_group, --decode(inv.invoice_id,null,xm.payment_priority,inv.payment_priority) payment_priority, decode(inv.invoice_id,null,xm.invoice_awt_group,inv.invoice_awt_group) invoice_awt_group, --decode(inv.invoice_id,null,xm.ussgl_transaction_code,inv.ussgl_transaction_code) ussgl_transaction_code, -- decode(inv.invoice_id,null,xm.line_number,inv.line_number) line_number, decode(inv.invoice_id,null,xm.line_type,inv.line_type) line_type, decode(inv.invoice_id,null,xm.line_amount,inv.line_amount) line_amount, decode(inv.invoice_id,null,xm.line_description,inv.line_description) line_description, decode(inv.invoice_id,null,xm.quantity,inv.quantity) quantity, decode(inv.invoice_id,null,xm.unit_price,inv.unit_price) unit_price, -- decode(inv.invoice_id,null,xm.distribution_account_alias,inv.distribution_account_alias) distribution_account_alias, decode(inv.invoice_id,null,xm.distribution_account,inv.distribution_account) distribution_account, decode(inv.invoice_id,null,xm.distribution_set,xm.distribution_set) distribution_set, -- decode(inv.invoice_id,null,xm.requester,inv.requester) requester, -- decode(inv.invoice_id,null,xm.po_number,inv.po_number) po_number, decode(inv.invoice_id,null,xm.po_release_num,inv.po_release_num) po_release_num, decode(inv.invoice_id,null,xm.po_line_num,inv.po_line_num) po_line_num, decode(inv.invoice_id,null,xm.po_shipment_num,inv.po_shipment_num) po_shipment_num, decode(inv.invoice_id,null,xm.po_distribution_num,inv.po_distribution_num) po_distribution_num, decode(inv.invoice_id,null,xm.po_receipt_num,inv.po_receipt_num) po_receipt_num, decode(inv.invoice_id,null,xm.po_receipt_line_num,inv.po_receipt_line_num) po_receipt_line_num, -- decode(inv.invoice_id,null,xm.track_as_asset,inv.track_as_asset) track_as_asset, -- decode(inv.invoice_id,null,xm.project,inv.project) project, decode(inv.invoice_id,null,xm.task,inv.task) task, decode(inv.invoice_id,null,xm.expenditure_item_date,inv.expenditure_item_date) expenditure_item_date, decode(inv.invoice_id,null,xm.expenditure_type,inv.expenditure_type) expenditure_type, decode(inv.invoice_id,null,xm.expenditure_organization,inv.expenditure_organization) expenditure_organization, decode(inv.invoice_id,null,xm.project_quantity,inv.project_quantity) project_quantity, -- decode(inv.invoice_id,null,xm.income_tax_type,inv.income_tax_type) income_tax_type, decode(inv.invoice_id,null,xm.income_tax_region,inv.income_tax_region) income_tax_region, -- decode(inv.invoice_id,null,xm.amount_includes_tax_flag,inv.amount_includes_tax_flag) amount_includes_tax_flag, decode(inv.invoice_id,null,xm.tax_code,inv.tax_code) tax_code, -- decode(inv.invoice_id,null,xm.line_invoice_awt_group,inv.line_invoice_awt_group) line_invoice_awt_group, -- decode(inv.invoice_id,null,xm.line_reference_1,inv.line_reference_1) line_reference_1, decode(inv.invoice_id,null,xm.line_reference_2,inv.line_reference_2) line_reference_2, -- decode(inv.invoice_id,null,xm.invoice_attribute_category,inv.invoice_attribute_category) invoice_attribute_category, decode(inv.invoice_id,null,xm.ap_inv_attribute1,inv.ap_inv_attribute1) ap_inv_attribute1, decode(inv.invoice_id,null,xm.ap_inv_attribute2,inv.ap_inv_attribute2) ap_inv_attribute2, decode(inv.invoice_id,null,xm.ap_inv_attribute3,inv.ap_inv_attribute3) ap_inv_attribute3, decode(inv.invoice_id,null,xm.ap_inv_attribute4,inv.ap_inv_attribute4) ap_inv_attribute4, decode(inv.invoice_id,null,xm.ap_inv_attribute5,inv.ap_inv_attribute5) ap_inv_attribute5, decode(inv.invoice_id,null,xm.ap_inv_attribute6,inv.ap_inv_attribute6) ap_inv_attribute6, decode(inv.invoice_id,null,xm.ap_inv_attribute7,inv.ap_inv_attribute7) ap_inv_attribute7, decode(inv.invoice_id,null,xm.ap_inv_attribute8,inv.ap_inv_attribute8) ap_inv_attribute8, decode(inv.invoice_id,null,xm.ap_inv_attribute9,inv.ap_inv_attribute9) ap_inv_attribute9, decode(inv.invoice_id,null,xm.ap_inv_attribute10,inv.ap_inv_attribute10) ap_inv_attribute10, decode(inv.invoice_id,null,xm.ap_inv_attribute11,inv.ap_inv_attribute11) ap_inv_attribute11, decode(inv.invoice_id,null,xm.ap_inv_attribute12,inv.ap_inv_attribute12) ap_inv_attribute12, decode(inv.invoice_id,null,xm.ap_inv_attribute13,inv.ap_inv_attribute13) ap_inv_attribute13, decode(inv.invoice_id,null,xm.ap_inv_attribute14,inv.ap_inv_attribute14) ap_inv_attribute14, decode(inv.invoice_id,null,xm.ap_inv_attribute15,inv.ap_inv_attribute15) ap_inv_attribute15, decode(inv.invoice_id,null,xm.line_attribute_category,inv.line_attribute_category) line_attribute_category, decode(inv.invoice_id,null,xm.ap_inv_line_attribute1,inv.ap_inv_line_attribute1) ap_inv_line_attribute1, decode(inv.invoice_id,null,xm.ap_inv_line_attribute2,inv.ap_inv_line_attribute2) ap_inv_line_attribute2, decode(inv.invoice_id,null,xm.ap_inv_line_attribute3,inv.ap_inv_line_attribute3) ap_inv_line_attribute3, decode(inv.invoice_id,null,xm.ap_inv_line_attribute4,inv.ap_inv_line_attribute4) ap_inv_line_attribute4, decode(inv.invoice_id,null,xm.ap_inv_line_attribute5,inv.ap_inv_line_attribute5) ap_inv_line_attribute5, decode(inv.invoice_id,null,xm.ap_inv_line_attribute6,inv.ap_inv_line_attribute6) ap_inv_line_attribute6, decode(inv.invoice_id,null,xm.ap_inv_line_attribute7,inv.ap_inv_line_attribute7) ap_inv_line_attribute7, decode(inv.invoice_id,null,xm.ap_inv_line_attribute8,inv.ap_inv_line_attribute8) ap_inv_line_attribute8, decode(inv.invoice_id,null,xm.ap_inv_line_attribute9,inv.ap_inv_line_attribute9) ap_inv_line_attribute9, decode(inv.invoice_id,null,xm.ap_inv_line_attribute10,inv.ap_inv_line_attribute10) ap_inv_line_attribute10, decode(inv.invoice_id,null,xm.ap_inv_line_attribute11,inv.ap_inv_line_attribute11) ap_inv_line_attribute11, decode(inv.invoice_id,null,xm.ap_inv_line_attribute12,inv.ap_inv_line_attribute12) ap_inv_line_attribute12, decode(inv.invoice_id,null,xm.ap_inv_line_attribute13,inv.ap_inv_line_attribute13) ap_inv_line_attribute13, decode(inv.invoice_id,null,xm.ap_inv_line_attribute14,inv.ap_inv_line_attribute14) ap_inv_line_attribute14, decode(inv.invoice_id,null,xm.ap_inv_line_attribute15,inv.ap_inv_line_attribute15) ap_inv_line_attribute15, xm.attachment_category_, xm.attachment_title_, xm.attachment_description_, xm.attachment_type_, xxen_upload.check_and_add_attachment( p_function_name=>'APXINWKB', p_function_type=>'O', p_category_name=>xm.attachment_category_, p_entity_name=>'AP_INVOICES', p_data_type=>xm.attachment_type_, p_title=>xm.attachment_title_, p_description=>xm.attachment_description_, p_text=>xm.attachment_content_, p_file_id=>xm.attachment_file_id_, p_pk1_value=>inv.invoice_id ) attachment_content_, xm.attachment_file_id_ from q_reporting_table xm, q_success_inv inv where decode(xm.pstatus,xxen_upload.status_success,xm.operating_unit) = inv.operating_unit (+) and decode(xm.pstatus,xxen_upload.status_success,xm.source) = inv.source (+) and decode(xm.pstatus,xxen_upload.status_success,xm.supplier_name) = inv.supplier_name (+) and decode(xm.pstatus,xxen_upload.status_success,xm.supplier_number) = inv.supplier_number (+) and decode(xm.pstatus,xxen_upload.status_success,xm.supplier_site) = inv.supplier_site (+) and decode(xm.pstatus,xxen_upload.status_success,xm.invoice_number) = inv.invoice_number (+) and decode(xm.pstatus,xxen_upload.status_success,xm.invoice_date) = inv.invoice_date (+) and decode(xm.pstatus,xxen_upload.status_success,xm.line_number) = inv.line_number (+) and decode(xm.pstatus,xxen_upload.status_success,xm.line_type) = inv.line_type (+) Lexical &report_table_name xxen_ap_invoice_upload_0255_u Lexical &success_with_query ,q_success_inv as ( select aia.invoice_id, alc.displayed_field source, haouv.name operating_unit, pv.vendor_name supplier_name, pv.segment1 supplier_number, pvsa.vendor_site_code supplier_site, xxen_util.meaning(aia.invoice_type_lookup_code,'INVOICE TYPE',200) invoice_type, aia.invoice_num invoice_number, aia.description invoice_description, (select pha.segment1 from po_headers_all pha where pha.po_header_id = aia.po_header_id) invoice_po_number, aia.invoice_date, aia.gl_date, aia.invoice_amount, aia.amount_applicable_to_discount, aia.invoice_currency_code invoice_currency, (select gdct.user_conversion_type from gl_daily_conversion_types gdct where gdct.conversion_type = aia.exchange_rate_type) exchange_rate_type, aia.exchange_date, aia.exchange_rate, (select ate.name from ap_terms ate where ate.term_id = aia.terms_id) terms, aia.terms_date, aia.goods_received_date, aia.invoice_received_date, xxen_util.meaning(aia.exclusive_payment_flag,'YES_NO',0) exclusive_payment_flag, aia.payment_currency_code payment_currency, (select gdct.user_conversion_type from gl_daily_conversion_types gdct where gdct.conversion_type = aia.payment_cross_rate_type) payment_cross_rate_type, aia.payment_cross_rate_date, aia.payment_cross_rate, nvl(xxen_util.meaning(apsa.payment_method_lookup_code,'PAYMENT METHOD',200),aia.payment_method_lookup_code) payment_method, (select flvv.meaning from fnd_lookup_values_vl flvv where flvv.lookup_type='PAY GROUP' and flvv.view_application_id = 201 and flvv.lookup_code = aia.pay_group_lookup_code) payment_group, --apsa.payment_priority, (select aag.name from ap_awt_groups aag where aag.group_id = aia.awt_group_id) invoice_awt_group, --aia.ussgl_transaction_code, -- Line aida.distribution_line_number line_number, xxen_util.meaning(aida.line_type_lookup_code,'INVOICE DISTRIBUTION TYPE',200) line_type, aida.amount line_amount, aida.description line_description, aida.quantity_invoiced quantity, aida.unit_price, -- (select fsfa.alias_name from fnd_shorthand_flex_aliases fsfa where fsfa.application_id = 101 and fsfa.id_flex_code = 'GL#' and fsfa.id_flex_num = gcck.chart_of_accounts_id and fsfa.concatenated_segments = gcck.concatenated_segments and fsfa.enabled_flag = 'Y' and trunc(sysdate) between nvl(fsfa.start_date_active,trunc(sysdate)) and nvl(fsfa.end_date_active,trunc(sysdate)) and rownum <= 1 ) distribution_account_alias, gcck.concatenated_segments distribution_account, null distribution_set, -- (select hecv.full_name || ' (' || hecv.employee_num || ')' from hr_employees_current_v hecv where hecv.employee_id = aia.requester_id) requester, (select pha.segment1 from po_headers_all pha where pha.po_header_id = pda.po_header_id) po_number, (select pra.release_num from po_releases_all pra,po_line_locations_all plla where pra.po_release_id = plla.po_release_id and plla.line_location_id = pda.line_location_id) po_release_num, (select pla.line_num from po_lines_all pla where pla.po_line_id = pda.po_line_id) po_line_num, (select plla.shipment_num from po_line_locations_all plla where plla.line_location_id = pda.line_location_id) po_shipment_num, pda.distribution_num po_distribution_num, (select rsh.receipt_num from rcv_shipment_headers rsh,rcv_shipment_lines rsl,rcv_transactions rtxns where rsl.shipment_line_id = rtxns.shipment_line_id and aida.rcv_transaction_id = rtxns.transaction_id and rsl.shipment_header_id = rsh.shipment_header_id) po_receipt_num, (select rsl.line_num from rcv_shipment_lines rsl,rcv_transactions rtxns where rsl.shipment_line_id = rtxns.shipment_line_id and aida.rcv_transaction_id = rtxns.transaction_id) po_receipt_line_num, -- xxen_util.meaning(aida.assets_tracking_flag,'YES_NO',0) track_as_asset, -- (select pap.segment1 from pa_projects_all pap where pap.project_id = aida.project_id) project, (select pat.task_number from pa_tasks pat where pat.task_id = aida.task_id) task, aida.expenditure_item_date, aida.expenditure_type, (select hou.name from hr_organization_units hou where hou.organization_id = aida.expenditure_organization_id) expenditure_organization, aida.pa_quantity project_quantity, -- tax aida.type_1099 income_tax_type, aida.income_tax_region, aida.amount_includes_tax_flag, (select atc.name from ap_tax_codes atc where atc.tax_id=aida.tax_code_id ) tax_code, (select aag.name from ap_awt_groups aag where aag.group_id = aida.awt_group_id) line_invoice_awt_group, -- aida.reference_1 line_reference_1, aida.reference_2 line_reference_2, -- xxen_util.display_flexfield_context(200,'AP_INVOICES',aia.attribute_category) invoice_attribute_category, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE1',aia.rowid,aia.attribute1) ap_inv_attribute1, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE2',aia.rowid,aia.attribute2) ap_inv_attribute2, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE3',aia.rowid,aia.attribute3) ap_inv_attribute3, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE4',aia.rowid,aia.attribute4) ap_inv_attribute4, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE5',aia.rowid,aia.attribute5) ap_inv_attribute5, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE6',aia.rowid,aia.attribute6) ap_inv_attribute6, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE7',aia.rowid,aia.attribute7) ap_inv_attribute7, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE8',aia.rowid,aia.attribute8) ap_inv_attribute8, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE9',aia.rowid,aia.attribute9) ap_inv_attribute9, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE10',aia.rowid,aia.attribute10) ap_inv_attribute10, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE11',aia.rowid,aia.attribute11) ap_inv_attribute11, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE12',aia.rowid,aia.attribute12) ap_inv_attribute12, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE13',aia.rowid,aia.attribute13) ap_inv_attribute13, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE14',aia.rowid,aia.attribute14) ap_inv_attribute14, xxen_util.display_flexfield_value(200,'AP_INVOICES',aia.attribute_category,'ATTRIBUTE15',aia.rowid,aia.attribute15) ap_inv_attribute15, aida.attribute_category line_attribute_category, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE1',aida.rowid,aida.attribute1) ap_inv_line_attribute1, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE2',aida.rowid,aida.attribute2) ap_inv_line_attribute2, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE3',aida.rowid,aida.attribute3) ap_inv_line_attribute3, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE4',aida.rowid,aida.attribute4) ap_inv_line_attribute4, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE5',aida.rowid,aida.attribute5) ap_inv_line_attribute5, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE6',aida.rowid,aida.attribute6) ap_inv_line_attribute6, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE7',aida.rowid,aida.attribute7) ap_inv_line_attribute7, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE8',aida.rowid,aida.attribute8) ap_inv_line_attribute8, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE9',aida.rowid,aida.attribute9) ap_inv_line_attribute9, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE10',aida.rowid,aida.attribute10) ap_inv_line_attribute10, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE11',aida.rowid,aida.attribute11) ap_inv_line_attribute11, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE12',aida.rowid,aida.attribute12) ap_inv_line_attribute12, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE13',aida.rowid,aida.attribute13) ap_inv_line_attribute13, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE14',aida.rowid,aida.attribute14) ap_inv_line_attribute14, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE15',aida.rowid,aida.attribute15) ap_inv_line_attribute15 from ap_invoices_all aia, ap_payment_schedules_all apsa, ap_invoice_distributions_all aida, po_distributions_all pda, hr_all_organization_units_vl haouv, po_vendors pv, po_vendor_sites_all pvsa, gl_code_combinations_kfv gcck, ap_lookup_codes alc where aia.invoice_id = apsa.invoice_id (+) and aia.invoice_id = aida.invoice_id and aia.vendor_id = pv.vendor_id and aia.vendor_site_id = pvsa.vendor_site_id and aia.org_id = haouv.organization_id and aida.po_distribution_id=pda.po_distribution_id(+) and aida.dist_code_combination_id = gcck.code_combination_id (+) and alc.lookup_type = 'SOURCE' and alc.lookup_code = aia.source and haouv.name = :p_operating_unit and alc.displayed_field = :p_source and aia.created_by = fnd_global.user_id and aia.creation_date >= sysdate - (1/24) ) LOV query :$column$.ap_inv_attribute1 AP_INV_ATTRIBUTE1 AP_INV_ATTRIBUTE1 LOV query :$column$.ap_inv_attribute10 AP_INV_ATTRIBUTE10 AP_INV_ATTRIBUTE1 LOV query :$column$.ap_inv_attribute11 AP_INV_ATTRIBUTE11 AP_INV_ATTRIBUTE1 LOV query :$column$.ap_inv_attribute12 AP_INV_ATTRIBUTE12 AP_INV_ATTRIBUTE1 LOV query :$column$.ap_inv_attribute13 AP_INV_ATTRIBUTE13 AP_INV_ATTRIBUTE1 LOV query :$column$.ap_inv_attribute14 AP_INV_ATTRIBUTE14 AP_INV_ATTRIBUTE1 LOV query :$column$.ap_inv_attribute15 AP_INV_ATTRIBUTE15 AP_INV_ATTRIBUTE1 LOV query :$column$.ap_inv_attribute2 AP_INV_ATTRIBUTE2 AP_INV_ATTRIBUTE1 LOV query :$column$.ap_inv_attribute3 AP_INV_ATTRIBUTE3 AP_INV_ATTRIBUTE1 LOV query :$column$.ap_inv_attribute4 AP_INV_ATTRIBUTE4 AP_INV_ATTRIBUTE1 LOV query :$column$.ap_inv_attribute5 AP_INV_ATTRIBUTE5 AP_INV_ATTRIBUTE1 LOV query :$column$.ap_inv_attribute6 AP_INV_ATTRIBUTE6 AP_INV_ATTRIBUTE1 LOV query :$column$.ap_inv_attribute7 AP_INV_ATTRIBUTE7 AP_INV_ATTRIBUTE1 LOV query :$column$.ap_inv_attribute8 AP_INV_ATTRIBUTE8 AP_INV_ATTRIBUTE1 LOV query :$column$.ap_inv_attribute9 AP_INV_ATTRIBUTE9 AP_INV_ATTRIBUTE1 LOV query :$column$.invoice_attribute_category INVOICE_ATTRIBUTE_CATEGORY AP_INV_ATTRIBUTE1 LOV query :$column$.ap_inv_attribute1 AP_INV_ATTRIBUTE1 AP_INV_ATTRIBUTE10 LOV query :$column$.ap_inv_attribute10 AP_INV_ATTRIBUTE10 AP_INV_ATTRIBUTE10 LOV query :$column$.ap_inv_attribute11 AP_INV_ATTRIBUTE11 AP_INV_ATTRIBUTE10 LOV query :$column$.ap_inv_attribute12 AP_INV_ATTRIBUTE12 AP_INV_ATTRIBUTE10 LOV query :$column$.ap_inv_attribute13 AP_INV_ATTRIBUTE13 AP_INV_ATTRIBUTE10 LOV query :$column$.ap_inv_attribute14 AP_INV_ATTRIBUTE14 AP_INV_ATTRIBUTE10 LOV query :$column$.ap_inv_attribute15 AP_INV_ATTRIBUTE15 AP_INV_ATTRIBUTE10 LOV query :$column$.ap_inv_attribute2 AP_INV_ATTRIBUTE2 AP_INV_ATTRIBUTE10 LOV query :$column$.ap_inv_attribute3 AP_INV_ATTRIBUTE3 AP_INV_ATTRIBUTE10 LOV query :$column$.ap_inv_attribute4 AP_INV_ATTRIBUTE4 AP_INV_ATTRIBUTE10 LOV query :$column$.ap_inv_attribute5 AP_INV_ATTRIBUTE5 AP_INV_ATTRIBUTE10 LOV query :$column$.ap_inv_attribute6 AP_INV_ATTRIBUTE6 AP_INV_ATTRIBUTE10 LOV query :$column$.ap_inv_attribute7 AP_INV_ATTRIBUTE7 AP_INV_ATTRIBUTE10 LOV query :$column$.ap_inv_attribute8 AP_INV_ATTRIBUTE8 AP_INV_ATTRIBUTE10 LOV query :$column$.ap_inv_attribute9 AP_INV_ATTRIBUTE9 AP_INV_ATTRIBUTE10 LOV query :$column$.invoice_attribute_category INVOICE_ATTRIBUTE_CATEGORY AP_INV_ATTRIBUTE10 LOV query :$column$.ap_inv_attribute1 AP_INV_ATTRIBUTE1 AP_INV_ATTRIBUTE11 LOV query :$column$.ap_inv_attribute10 AP_INV_ATTRIBUTE10 AP_INV_ATTRIBUTE11 LOV query :$column$.ap_inv_attribute11 AP_INV_ATTRIBUTE11 AP_INV_ATTRIBUTE11 LOV query :$column$.ap_inv_attribute12 AP_INV_ATTRIBUTE12 AP_INV_ATTRIBUTE11 LOV query :$column$.ap_inv_attribute13 AP_INV_ATTRIBUTE13 AP_INV_ATTRIBUTE11 LOV query :$column$.ap_inv_attribute14 AP_INV_ATTRIBUTE14 AP_INV_ATTRIBUTE11 LOV query :$column$.ap_inv_attribute15 AP_INV_ATTRIBUTE15 AP_INV_ATTRIBUTE11 LOV query :$column$.ap_inv_attribute2 AP_INV_ATTRIBUTE2 AP_INV_ATTRIBUTE11 LOV query :$column$.ap_inv_attribute3 AP_INV_ATTRIBUTE3 AP_INV_ATTRIBUTE11 LOV query :$column$.ap_inv_attribute4 AP_INV_ATTRIBUTE4 AP_INV_ATTRIBUTE11 LOV query :$column$.ap_inv_attribute5 AP_INV_ATTRIBUTE5 AP_INV_ATTRIBUTE11 LOV query :$column$.ap_inv_attribute6 AP_INV_ATTRIBUTE6 AP_INV_ATTRIBUTE11 LOV query :$column$.ap_inv_attribute7 AP_INV_ATTRIBUTE7 AP_INV_ATTRIBUTE11 LOV query :$column$.ap_inv_attribute8 AP_INV_ATTRIBUTE8 AP_INV_ATTRIBUTE11 LOV query :$column$.ap_inv_attribute9 AP_INV_ATTRIBUTE9 AP_INV_ATTRIBUTE11 LOV query :$column$.invoice_attribute_category INVOICE_ATTRIBUTE_CATEGORY AP_INV_ATTRIBUTE11 LOV query :$column$.ap_inv_attribute1 AP_INV_ATTRIBUTE1 AP_INV_ATTRIBUTE12 LOV query :$column$.ap_inv_attribute10 AP_INV_ATTRIBUTE10 AP_INV_ATTRIBUTE12 LOV query :$column$.ap_inv_attribute11 AP_INV_ATTRIBUTE11 AP_INV_ATTRIBUTE12 LOV query :$column$.ap_inv_attribute12 AP_INV_ATTRIBUTE12 AP_INV_ATTRIBUTE12 LOV query :$column$.ap_inv_attribute13 AP_INV_ATTRIBUTE13 AP_INV_ATTRIBUTE12 LOV query :$column$.ap_inv_attribute14 AP_INV_ATTRIBUTE14 AP_INV_ATTRIBUTE12 LOV query :$column$.ap_inv_attribute15 AP_INV_ATTRIBUTE15 AP_INV_ATTRIBUTE12 LOV query :$column$.ap_inv_attribute2 AP_INV_ATTRIBUTE2 AP_INV_ATTRIBUTE12 LOV query :$column$.ap_inv_attribute3 AP_INV_ATTRIBUTE3 AP_INV_ATTRIBUTE12 LOV query :$column$.ap_inv_attribute4 AP_INV_ATTRIBUTE4 AP_INV_ATTRIBUTE12 LOV query :$column$.ap_inv_attribute5 AP_INV_ATTRIBUTE5 AP_INV_ATTRIBUTE12 LOV query :$column$.ap_inv_attribute6 AP_INV_ATTRIBUTE6 AP_INV_ATTRIBUTE12 LOV query :$column$.ap_inv_attribute7 AP_INV_ATTRIBUTE7 AP_INV_ATTRIBUTE12 LOV query :$column$.ap_inv_attribute8 AP_INV_ATTRIBUTE8 AP_INV_ATTRIBUTE12 LOV query :$column$.ap_inv_attribute9 AP_INV_ATTRIBUTE9 AP_INV_ATTRIBUTE12 LOV query :$column$.invoice_attribute_category INVOICE_ATTRIBUTE_CATEGORY AP_INV_ATTRIBUTE12 LOV query :$column$.ap_inv_attribute1 AP_INV_ATTRIBUTE1 AP_INV_ATTRIBUTE13 LOV query :$column$.ap_inv_attribute10 AP_INV_ATTRIBUTE10 AP_INV_ATTRIBUTE13 LOV query :$column$.ap_inv_attribute11 AP_INV_ATTRIBUTE11 AP_INV_ATTRIBUTE13 LOV query :$column$.ap_inv_attribute12 AP_INV_ATTRIBUTE12 AP_INV_ATTRIBUTE13 LOV query :$column$.ap_inv_attribute13 AP_INV_ATTRIBUTE13 AP_INV_ATTRIBUTE13 LOV query :$column$.ap_inv_attribute14 AP_INV_ATTRIBUTE14 AP_INV_ATTRIBUTE13 LOV query :$column$.ap_inv_attribute15 AP_INV_ATTRIBUTE15 AP_INV_ATTRIBUTE13 LOV query :$column$.ap_inv_attribute2 AP_INV_ATTRIBUTE2 AP_INV_ATTRIBUTE13 LOV query :$column$.ap_inv_attribute3 AP_INV_ATTRIBUTE3 AP_INV_ATTRIBUTE13 LOV query :$column$.ap_inv_attribute4 AP_INV_ATTRIBUTE4 AP_INV_ATTRIBUTE13 LOV query :$column$.ap_inv_attribute5 AP_INV_ATTRIBUTE5 AP_INV_ATTRIBUTE13 LOV query :$column$.ap_inv_attribute6 AP_INV_ATTRIBUTE6 AP_INV_ATTRIBUTE13 LOV query :$column$.ap_inv_attribute7 AP_INV_ATTRIBUTE7 AP_INV_ATTRIBUTE13 LOV query :$column$.ap_inv_attribute8 AP_INV_ATTRIBUTE8 AP_INV_ATTRIBUTE13 LOV query :$column$.ap_inv_attribute9 AP_INV_ATTRIBUTE9 AP_INV_ATTRIBUTE13 LOV query :$column$.invoice_attribute_category INVOICE_ATTRIBUTE_CATEGORY AP_INV_ATTRIBUTE13 LOV query :$column$.ap_inv_attribute1 AP_INV_ATTRIBUTE1 AP_INV_ATTRIBUTE14 LOV query :$column$.ap_inv_attribute10 AP_INV_ATTRIBUTE10 AP_INV_ATTRIBUTE14 LOV query :$column$.ap_inv_attribute11 AP_INV_ATTRIBUTE11 AP_INV_ATTRIBUTE14 LOV query :$column$.ap_inv_attribute12 AP_INV_ATTRIBUTE12 AP_INV_ATTRIBUTE14 LOV query :$column$.ap_inv_attribute13 AP_INV_ATTRIBUTE13 AP_INV_ATTRIBUTE14 LOV query :$column$.ap_inv_attribute14 AP_INV_ATTRIBUTE14 AP_INV_ATTRIBUTE14 LOV query :$column$.ap_inv_attribute15 AP_INV_ATTRIBUTE15 AP_INV_ATTRIBUTE14 LOV query :$column$.ap_inv_attribute2 AP_INV_ATTRIBUTE2 AP_INV_ATTRIBUTE14 LOV query :$column$.ap_inv_attribute3 AP_INV_ATTRIBUTE3 AP_INV_ATTRIBUTE14 LOV query :$column$.ap_inv_attribute4 AP_INV_ATTRIBUTE4 AP_INV_ATTRIBUTE14 LOV query :$column$.ap_inv_attribute5 AP_INV_ATTRIBUTE5 AP_INV_ATTRIBUTE14 LOV query :$column$.ap_inv_attribute6 AP_INV_ATTRIBUTE6 AP_INV_ATTRIBUTE14 LOV query :$column$.ap_inv_attribute7 AP_INV_ATTRIBUTE7 AP_INV_ATTRIBUTE14 LOV query :$column$.ap_inv_attribute8 AP_INV_ATTRIBUTE8 AP_INV_ATTRIBUTE14 LOV query :$column$.ap_inv_attribute9 AP_INV_ATTRIBUTE9 AP_INV_ATTRIBUTE14 LOV query :$column$.invoice_attribute_category INVOICE_ATTRIBUTE_CATEGORY AP_INV_ATTRIBUTE14 LOV query :$column$.ap_inv_attribute1 AP_INV_ATTRIBUTE1 AP_INV_ATTRIBUTE15 LOV query :$column$.ap_inv_attribute10 AP_INV_ATTRIBUTE10 AP_INV_ATTRIBUTE15 LOV query :$column$.ap_inv_attribute11 AP_INV_ATTRIBUTE11 AP_INV_ATTRIBUTE15 LOV query :$column$.ap_inv_attribute12 AP_INV_ATTRIBUTE12 AP_INV_ATTRIBUTE15 LOV query :$column$.ap_inv_attribute13 AP_INV_ATTRIBUTE13 AP_INV_ATTRIBUTE15 LOV query :$column$.ap_inv_attribute14 AP_INV_ATTRIBUTE14 AP_INV_ATTRIBUTE15 LOV query :$column$.ap_inv_attribute15 AP_INV_ATTRIBUTE15 AP_INV_ATTRIBUTE15 LOV query :$column$.ap_inv_attribute2 AP_INV_ATTRIBUTE2 AP_INV_ATTRIBUTE15 LOV query :$column$.ap_inv_attribute3 AP_INV_ATTRIBUTE3 AP_INV_ATTRIBUTE15 LOV query :$column$.ap_inv_attribute4 AP_INV_ATTRIBUTE4 AP_INV_ATTRIBUTE15 LOV query :$column$.ap_inv_attribute5 AP_INV_ATTRIBUTE5 AP_INV_ATTRIBUTE15 LOV query :$column$.ap_inv_attribute6 AP_INV_ATTRIBUTE6 AP_INV_ATTRIBUTE15 LOV query :$column$.ap_inv_attribute7 AP_INV_ATTRIBUTE7 AP_INV_ATTRIBUTE15 LOV query :$column$.ap_inv_attribute8 AP_INV_ATTRIBUTE8 AP_INV_ATTRIBUTE15 LOV query :$column$.ap_inv_attribute9 AP_INV_ATTRIBUTE9 AP_INV_ATTRIBUTE15 LOV query :$column$.invoice_attribute_category INVOICE_ATTRIBUTE_CATEGORY AP_INV_ATTRIBUTE15 LOV query :$column$.ap_inv_attribute1 AP_INV_ATTRIBUTE1 AP_INV_ATTRIBUTE2 LOV query :$column$.ap_inv_attribute10 AP_INV_ATTRIBUTE10 AP_INV_ATTRIBUTE2 LOV query :$column$.ap_inv_attribute11 AP_INV_ATTRIBUTE11 AP_INV_ATTRIBUTE2 LOV query :$column$.ap_inv_attribute12 AP_INV_ATTRIBUTE12 AP_INV_ATTRIBUTE2 LOV query :$column$.ap_inv_attribute13 AP_INV_ATTRIBUTE13 AP_INV_ATTRIBUTE2 LOV query :$column$.ap_inv_attribute14 AP_INV_ATTRIBUTE14 AP_INV_ATTRIBUTE2 LOV query :$column$.ap_inv_attribute15 AP_INV_ATTRIBUTE15 AP_INV_ATTRIBUTE2 LOV query :$column$.ap_inv_attribute2 AP_INV_ATTRIBUTE2 AP_INV_ATTRIBUTE2 LOV query :$column$.ap_inv_attribute3 AP_INV_ATTRIBUTE3 AP_INV_ATTRIBUTE2 LOV query :$column$.ap_inv_attribute4 AP_INV_ATTRIBUTE4 AP_INV_ATTRIBUTE2 LOV query :$column$.ap_inv_attribute5 AP_INV_ATTRIBUTE5 AP_INV_ATTRIBUTE2 LOV query :$column$.ap_inv_attribute6 AP_INV_ATTRIBUTE6 AP_INV_ATTRIBUTE2 LOV query :$column$.ap_inv_attribute7 AP_INV_ATTRIBUTE7 AP_INV_ATTRIBUTE2 LOV query :$column$.ap_inv_attribute8 AP_INV_ATTRIBUTE8 AP_INV_ATTRIBUTE2 LOV query :$column$.ap_inv_attribute9 AP_INV_ATTRIBUTE9 AP_INV_ATTRIBUTE2 LOV query :$column$.invoice_attribute_category INVOICE_ATTRIBUTE_CATEGORY AP_INV_ATTRIBUTE2 LOV query :$column$.ap_inv_attribute1 AP_INV_ATTRIBUTE1 AP_INV_ATTRIBUTE3 LOV query :$column$.ap_inv_attribute10 AP_INV_ATTRIBUTE10 AP_INV_ATTRIBUTE3 LOV query :$column$.ap_inv_attribute11 AP_INV_ATTRIBUTE11 AP_INV_ATTRIBUTE3 LOV query :$column$.ap_inv_attribute12 AP_INV_ATTRIBUTE12 AP_INV_ATTRIBUTE3 LOV query :$column$.ap_inv_attribute13 AP_INV_ATTRIBUTE13 AP_INV_ATTRIBUTE3 LOV query :$column$.ap_inv_attribute14 AP_INV_ATTRIBUTE14 AP_INV_ATTRIBUTE3 LOV query :$column$.ap_inv_attribute15 AP_INV_ATTRIBUTE15 AP_INV_ATTRIBUTE3 LOV query :$column$.ap_inv_attribute2 AP_INV_ATTRIBUTE2 AP_INV_ATTRIBUTE3 LOV query :$column$.ap_inv_attribute3 AP_INV_ATTRIBUTE3 AP_INV_ATTRIBUTE3 LOV query :$column$.ap_inv_attribute4 AP_INV_ATTRIBUTE4 AP_INV_ATTRIBUTE3 LOV query :$column$.ap_inv_attribute5 AP_INV_ATTRIBUTE5 AP_INV_ATTRIBUTE3 LOV query :$column$.ap_inv_attribute6 AP_INV_ATTRIBUTE6 AP_INV_ATTRIBUTE3 LOV query :$column$.ap_inv_attribute7 AP_INV_ATTRIBUTE7 AP_INV_ATTRIBUTE3 LOV query :$column$.ap_inv_attribute8 AP_INV_ATTRIBUTE8 AP_INV_ATTRIBUTE3 LOV query :$column$.ap_inv_attribute9 AP_INV_ATTRIBUTE9 AP_INV_ATTRIBUTE3 LOV query :$column$.invoice_attribute_category INVOICE_ATTRIBUTE_CATEGORY AP_INV_ATTRIBUTE3 LOV query :$column$.ap_inv_attribute1 AP_INV_ATTRIBUTE1 AP_INV_ATTRIBUTE4 LOV query :$column$.ap_inv_attribute10 AP_INV_ATTRIBUTE10 AP_INV_ATTRIBUTE4 LOV query :$column$.ap_inv_attribute11 AP_INV_ATTRIBUTE11 AP_INV_ATTRIBUTE4 LOV query :$column$.ap_inv_attribute12 AP_INV_ATTRIBUTE12 AP_INV_ATTRIBUTE4 LOV query :$column$.ap_inv_attribute13 AP_INV_ATTRIBUTE13 AP_INV_ATTRIBUTE4 LOV query :$column$.ap_inv_attribute14 AP_INV_ATTRIBUTE14 AP_INV_ATTRIBUTE4 LOV query :$column$.ap_inv_attribute15 AP_INV_ATTRIBUTE15 AP_INV_ATTRIBUTE4 LOV query :$column$.ap_inv_attribute2 AP_INV_ATTRIBUTE2 AP_INV_ATTRIBUTE4 LOV query :$column$.ap_inv_attribute3 AP_INV_ATTRIBUTE3 AP_INV_ATTRIBUTE4 LOV query :$column$.ap_inv_attribute4 AP_INV_ATTRIBUTE4 AP_INV_ATTRIBUTE4 LOV query :$column$.ap_inv_attribute5 AP_INV_ATTRIBUTE5 AP_INV_ATTRIBUTE4 LOV query :$column$.ap_inv_attribute6 AP_INV_ATTRIBUTE6 AP_INV_ATTRIBUTE4 LOV query :$column$.ap_inv_attribute7 AP_INV_ATTRIBUTE7 AP_INV_ATTRIBUTE4 LOV query :$column$.ap_inv_attribute8 AP_INV_ATTRIBUTE8 AP_INV_ATTRIBUTE4 LOV query :$column$.ap_inv_attribute9 AP_INV_ATTRIBUTE9 AP_INV_ATTRIBUTE4 LOV query :$column$.invoice_attribute_category INVOICE_ATTRIBUTE_CATEGORY AP_INV_ATTRIBUTE4 LOV query :$column$.ap_inv_attribute1 AP_INV_ATTRIBUTE1 AP_INV_ATTRIBUTE5 LOV query :$column$.ap_inv_attribute10 AP_INV_ATTRIBUTE10 AP_INV_ATTRIBUTE5 LOV query :$column$.ap_inv_attribute11 AP_INV_ATTRIBUTE11 AP_INV_ATTRIBUTE5 LOV query :$column$.ap_inv_attribute12 AP_INV_ATTRIBUTE12 AP_INV_ATTRIBUTE5 LOV query :$column$.ap_inv_attribute13 AP_INV_ATTRIBUTE13 AP_INV_ATTRIBUTE5 LOV query :$column$.ap_inv_attribute14 AP_INV_ATTRIBUTE14 AP_INV_ATTRIBUTE5 LOV query :$column$.ap_inv_attribute15 AP_INV_ATTRIBUTE15 AP_INV_ATTRIBUTE5 LOV query :$column$.ap_inv_attribute2 AP_INV_ATTRIBUTE2 AP_INV_ATTRIBUTE5 LOV query :$column$.ap_inv_attribute3 AP_INV_ATTRIBUTE3 AP_INV_ATTRIBUTE5 LOV query :$column$.ap_inv_attribute4 AP_INV_ATTRIBUTE4 AP_INV_ATTRIBUTE5 LOV query :$column$.ap_inv_attribute5 AP_INV_ATTRIBUTE5 AP_INV_ATTRIBUTE5 LOV query :$column$.ap_inv_attribute6 AP_INV_ATTRIBUTE6 AP_INV_ATTRIBUTE5 LOV query :$column$.ap_inv_attribute7 AP_INV_ATTRIBUTE7 AP_INV_ATTRIBUTE5 LOV query :$column$.ap_inv_attribute8 AP_INV_ATTRIBUTE8 AP_INV_ATTRIBUTE5 LOV query :$column$.ap_inv_attribute9 AP_INV_ATTRIBUTE9 AP_INV_ATTRIBUTE5 LOV query :$column$.invoice_attribute_category INVOICE_ATTRIBUTE_CATEGORY AP_INV_ATTRIBUTE5 LOV query :$column$.ap_inv_attribute1 AP_INV_ATTRIBUTE1 AP_INV_ATTRIBUTE6 LOV query :$column$.ap_inv_attribute10 AP_INV_ATTRIBUTE10 AP_INV_ATTRIBUTE6 LOV query :$column$.ap_inv_attribute11 AP_INV_ATTRIBUTE11 AP_INV_ATTRIBUTE6 LOV query :$column$.ap_inv_attribute12 AP_INV_ATTRIBUTE12 AP_INV_ATTRIBUTE6 LOV query :$column$.ap_inv_attribute13 AP_INV_ATTRIBUTE13 AP_INV_ATTRIBUTE6 LOV query :$column$.ap_inv_attribute14 AP_INV_ATTRIBUTE14 AP_INV_ATTRIBUTE6 LOV query :$column$.ap_inv_attribute15 AP_INV_ATTRIBUTE15 AP_INV_ATTRIBUTE6 LOV query :$column$.ap_inv_attribute2 AP_INV_ATTRIBUTE2 AP_INV_ATTRIBUTE6 LOV query :$column$.ap_inv_attribute3 AP_INV_ATTRIBUTE3 AP_INV_ATTRIBUTE6 LOV query :$column$.ap_inv_attribute4 AP_INV_ATTRIBUTE4 AP_INV_ATTRIBUTE6 LOV query :$column$.ap_inv_attribute5 AP_INV_ATTRIBUTE5 AP_INV_ATTRIBUTE6 LOV query :$column$.ap_inv_attribute6 AP_INV_ATTRIBUTE6 AP_INV_ATTRIBUTE6 LOV query :$column$.ap_inv_attribute7 AP_INV_ATTRIBUTE7 AP_INV_ATTRIBUTE6 LOV query :$column$.ap_inv_attribute8 AP_INV_ATTRIBUTE8 AP_INV_ATTRIBUTE6 LOV query :$column$.ap_inv_attribute9 AP_INV_ATTRIBUTE9 AP_INV_ATTRIBUTE6 LOV query :$column$.invoice_attribute_category INVOICE_ATTRIBUTE_CATEGORY AP_INV_ATTRIBUTE6 LOV query :$column$.ap_inv_attribute1 AP_INV_ATTRIBUTE1 AP_INV_ATTRIBUTE7 LOV query :$column$.ap_inv_attribute10 AP_INV_ATTRIBUTE10 AP_INV_ATTRIBUTE7 LOV query :$column$.ap_inv_attribute11 AP_INV_ATTRIBUTE11 AP_INV_ATTRIBUTE7 LOV query :$column$.ap_inv_attribute12 AP_INV_ATTRIBUTE12 AP_INV_ATTRIBUTE7 LOV query :$column$.ap_inv_attribute13 AP_INV_ATTRIBUTE13 AP_INV_ATTRIBUTE7 LOV query :$column$.ap_inv_attribute14 AP_INV_ATTRIBUTE14 AP_INV_ATTRIBUTE7 LOV query :$column$.ap_inv_attribute15 AP_INV_ATTRIBUTE15 AP_INV_ATTRIBUTE7 LOV query :$column$.ap_inv_attribute2 AP_INV_ATTRIBUTE2 AP_INV_ATTRIBUTE7 LOV query :$column$.ap_inv_attribute3 AP_INV_ATTRIBUTE3 AP_INV_ATTRIBUTE7 LOV query :$column$.ap_inv_attribute4 AP_INV_ATTRIBUTE4 AP_INV_ATTRIBUTE7 LOV query :$column$.ap_inv_attribute5 AP_INV_ATTRIBUTE5 AP_INV_ATTRIBUTE7 LOV query :$column$.ap_inv_attribute6 AP_INV_ATTRIBUTE6 AP_INV_ATTRIBUTE7 LOV query :$column$.ap_inv_attribute7 AP_INV_ATTRIBUTE7 AP_INV_ATTRIBUTE7 LOV query :$column$.ap_inv_attribute8 AP_INV_ATTRIBUTE8 AP_INV_ATTRIBUTE7 LOV query :$column$.ap_inv_attribute9 AP_INV_ATTRIBUTE9 AP_INV_ATTRIBUTE7 LOV query :$column$.invoice_attribute_category INVOICE_ATTRIBUTE_CATEGORY AP_INV_ATTRIBUTE7 LOV query :$column$.ap_inv_attribute1 AP_INV_ATTRIBUTE1 AP_INV_ATTRIBUTE8 LOV query :$column$.ap_inv_attribute10 AP_INV_ATTRIBUTE10 AP_INV_ATTRIBUTE8 LOV query :$column$.ap_inv_attribute11 AP_INV_ATTRIBUTE11 AP_INV_ATTRIBUTE8 LOV query :$column$.ap_inv_attribute12 AP_INV_ATTRIBUTE12 AP_INV_ATTRIBUTE8 LOV query :$column$.ap_inv_attribute13 AP_INV_ATTRIBUTE13 AP_INV_ATTRIBUTE8 LOV query :$column$.ap_inv_attribute14 AP_INV_ATTRIBUTE14 AP_INV_ATTRIBUTE8 LOV query :$column$.ap_inv_attribute15 AP_INV_ATTRIBUTE15 AP_INV_ATTRIBUTE8 LOV query :$column$.ap_inv_attribute2 AP_INV_ATTRIBUTE2 AP_INV_ATTRIBUTE8 LOV query :$column$.ap_inv_attribute3 AP_INV_ATTRIBUTE3 AP_INV_ATTRIBUTE8 LOV query :$column$.ap_inv_attribute4 AP_INV_ATTRIBUTE4 AP_INV_ATTRIBUTE8 LOV query :$column$.ap_inv_attribute5 AP_INV_ATTRIBUTE5 AP_INV_ATTRIBUTE8 LOV query :$column$.ap_inv_attribute6 AP_INV_ATTRIBUTE6 AP_INV_ATTRIBUTE8 LOV query :$column$.ap_inv_attribute7 AP_INV_ATTRIBUTE7 AP_INV_ATTRIBUTE8 LOV query :$column$.ap_inv_attribute8 AP_INV_ATTRIBUTE8 AP_INV_ATTRIBUTE8 LOV query :$column$.ap_inv_attribute9 AP_INV_ATTRIBUTE9 AP_INV_ATTRIBUTE8 LOV query :$column$.invoice_attribute_category INVOICE_ATTRIBUTE_CATEGORY AP_INV_ATTRIBUTE8 LOV query :$column$.ap_inv_attribute1 AP_INV_ATTRIBUTE1 AP_INV_ATTRIBUTE9 LOV query :$column$.ap_inv_attribute10 AP_INV_ATTRIBUTE10 AP_INV_ATTRIBUTE9 LOV query :$column$.ap_inv_attribute11 AP_INV_ATTRIBUTE11 AP_INV_ATTRIBUTE9 LOV query :$column$.ap_inv_attribute12 AP_INV_ATTRIBUTE12 AP_INV_ATTRIBUTE9 LOV query :$column$.ap_inv_attribute13 AP_INV_ATTRIBUTE13 AP_INV_ATTRIBUTE9 LOV query :$column$.ap_inv_attribute14 AP_INV_ATTRIBUTE14 AP_INV_ATTRIBUTE9 LOV query :$column$.ap_inv_attribute15 AP_INV_ATTRIBUTE15 AP_INV_ATTRIBUTE9 LOV query :$column$.ap_inv_attribute2 AP_INV_ATTRIBUTE2 AP_INV_ATTRIBUTE9 LOV query :$column$.ap_inv_attribute3 AP_INV_ATTRIBUTE3 AP_INV_ATTRIBUTE9 LOV query :$column$.ap_inv_attribute4 AP_INV_ATTRIBUTE4 AP_INV_ATTRIBUTE9 LOV query :$column$.ap_inv_attribute5 AP_INV_ATTRIBUTE5 AP_INV_ATTRIBUTE9 LOV query :$column$.ap_inv_attribute6 AP_INV_ATTRIBUTE6 AP_INV_ATTRIBUTE9 LOV query :$column$.ap_inv_attribute7 AP_INV_ATTRIBUTE7 AP_INV_ATTRIBUTE9 LOV query :$column$.ap_inv_attribute8 AP_INV_ATTRIBUTE8 AP_INV_ATTRIBUTE9 LOV query :$column$.ap_inv_attribute9 AP_INV_ATTRIBUTE9 AP_INV_ATTRIBUTE9 LOV query :$column$.invoice_attribute_category INVOICE_ATTRIBUTE_CATEGORY AP_INV_ATTRIBUTE9 LOV query :$column$.ap_inv_line_attribute1 AP_INV_LINE_ATTRIBUTE1 AP_INV_LINE_ATTRIBUTE1 LOV query :$column$.ap_inv_line_attribute10 AP_INV_LINE_ATTRIBUTE10 AP_INV_LINE_ATTRIBUTE1 LOV query :$column$.ap_inv_line_attribute11 AP_INV_LINE_ATTRIBUTE11 AP_INV_LINE_ATTRIBUTE1 LOV query :$column$.ap_inv_line_attribute12 AP_INV_LINE_ATTRIBUTE12 AP_INV_LINE_ATTRIBUTE1 LOV query :$column$.ap_inv_line_attribute13 AP_INV_LINE_ATTRIBUTE13 AP_INV_LINE_ATTRIBUTE1 LOV query :$column$.ap_inv_line_attribute14 AP_INV_LINE_ATTRIBUTE14 AP_INV_LINE_ATTRIBUTE1 LOV query :$column$.ap_inv_line_attribute15 AP_INV_LINE_ATTRIBUTE15 AP_INV_LINE_ATTRIBUTE1 LOV query :$column$.ap_inv_line_attribute2 AP_INV_LINE_ATTRIBUTE2 AP_INV_LINE_ATTRIBUTE1 LOV query :$column$.ap_inv_line_attribute3 AP_INV_LINE_ATTRIBUTE3 AP_INV_LINE_ATTRIBUTE1 LOV query :$column$.ap_inv_line_attribute4 AP_INV_LINE_ATTRIBUTE4 AP_INV_LINE_ATTRIBUTE1 LOV query :$column$.ap_inv_line_attribute5 AP_INV_LINE_ATTRIBUTE5 AP_INV_LINE_ATTRIBUTE1 LOV query :$column$.ap_inv_line_attribute6 AP_INV_LINE_ATTRIBUTE6 AP_INV_LINE_ATTRIBUTE1 LOV query :$column$.ap_inv_line_attribute7 AP_INV_LINE_ATTRIBUTE7 AP_INV_LINE_ATTRIBUTE1 LOV query :$column$.ap_inv_line_attribute8 AP_INV_LINE_ATTRIBUTE8 AP_INV_LINE_ATTRIBUTE1 LOV query :$column$.ap_inv_line_attribute9 AP_INV_LINE_ATTRIBUTE9 AP_INV_LINE_ATTRIBUTE1 LOV query :$column$.line_attribute_category LINE_ATTRIBUTE_CATEGORY AP_INV_LINE_ATTRIBUTE1 LOV query :$column$.ap_inv_line_attribute1 AP_INV_LINE_ATTRIBUTE1 AP_INV_LINE_ATTRIBUTE10 LOV query :$column$.ap_inv_line_attribute10 AP_INV_LINE_ATTRIBUTE10 AP_INV_LINE_ATTRIBUTE10 LOV query :$column$.ap_inv_line_attribute11 AP_INV_LINE_ATTRIBUTE11 AP_INV_LINE_ATTRIBUTE10 LOV query :$column$.ap_inv_line_attribute12 AP_INV_LINE_ATTRIBUTE12 AP_INV_LINE_ATTRIBUTE10 LOV query :$column$.ap_inv_line_attribute13 AP_INV_LINE_ATTRIBUTE13 AP_INV_LINE_ATTRIBUTE10 LOV query :$column$.ap_inv_line_attribute14 AP_INV_LINE_ATTRIBUTE14 AP_INV_LINE_ATTRIBUTE10 LOV query :$column$.ap_inv_line_attribute15 AP_INV_LINE_ATTRIBUTE15 AP_INV_LINE_ATTRIBUTE10 LOV query :$column$.ap_inv_line_attribute2 AP_INV_LINE_ATTRIBUTE2 AP_INV_LINE_ATTRIBUTE10 LOV query :$column$.ap_inv_line_attribute3 AP_INV_LINE_ATTRIBUTE3 AP_INV_LINE_ATTRIBUTE10 LOV query :$column$.ap_inv_line_attribute4 AP_INV_LINE_ATTRIBUTE4 AP_INV_LINE_ATTRIBUTE10 LOV query :$column$.ap_inv_line_attribute5 AP_INV_LINE_ATTRIBUTE5 AP_INV_LINE_ATTRIBUTE10 LOV query :$column$.ap_inv_line_attribute6 AP_INV_LINE_ATTRIBUTE6 AP_INV_LINE_ATTRIBUTE10 LOV query :$column$.ap_inv_line_attribute7 AP_INV_LINE_ATTRIBUTE7 AP_INV_LINE_ATTRIBUTE10 LOV query :$column$.ap_inv_line_attribute8 AP_INV_LINE_ATTRIBUTE8 AP_INV_LINE_ATTRIBUTE10 LOV query :$column$.ap_inv_line_attribute9 AP_INV_LINE_ATTRIBUTE9 AP_INV_LINE_ATTRIBUTE10 LOV query :$column$.line_attribute_category LINE_ATTRIBUTE_CATEGORY AP_INV_LINE_ATTRIBUTE10 LOV query :$column$.ap_inv_line_attribute1 AP_INV_LINE_ATTRIBUTE1 AP_INV_LINE_ATTRIBUTE11 LOV query :$column$.ap_inv_line_attribute10 AP_INV_LINE_ATTRIBUTE10 AP_INV_LINE_ATTRIBUTE11 LOV query :$column$.ap_inv_line_attribute11 AP_INV_LINE_ATTRIBUTE11 AP_INV_LINE_ATTRIBUTE11 LOV query :$column$.ap_inv_line_attribute12 AP_INV_LINE_ATTRIBUTE12 AP_INV_LINE_ATTRIBUTE11 LOV query :$column$.ap_inv_line_attribute13 AP_INV_LINE_ATTRIBUTE13 AP_INV_LINE_ATTRIBUTE11 LOV query :$column$.ap_inv_line_attribute14 AP_INV_LINE_ATTRIBUTE14 AP_INV_LINE_ATTRIBUTE11 LOV query :$column$.ap_inv_line_attribute15 AP_INV_LINE_ATTRIBUTE15 AP_INV_LINE_ATTRIBUTE11 LOV query :$column$.ap_inv_line_attribute2 AP_INV_LINE_ATTRIBUTE2 AP_INV_LINE_ATTRIBUTE11 LOV query :$column$.ap_inv_line_attribute3 AP_INV_LINE_ATTRIBUTE3 AP_INV_LINE_ATTRIBUTE11 LOV query :$column$.ap_inv_line_attribute4 AP_INV_LINE_ATTRIBUTE4 AP_INV_LINE_ATTRIBUTE11 LOV query :$column$.ap_inv_line_attribute5 AP_INV_LINE_ATTRIBUTE5 AP_INV_LINE_ATTRIBUTE11 LOV query :$column$.ap_inv_line_attribute6 AP_INV_LINE_ATTRIBUTE6 AP_INV_LINE_ATTRIBUTE11 LOV query :$column$.ap_inv_line_attribute7 AP_INV_LINE_ATTRIBUTE7 AP_INV_LINE_ATTRIBUTE11 LOV query :$column$.ap_inv_line_attribute8 AP_INV_LINE_ATTRIBUTE8 AP_INV_LINE_ATTRIBUTE11 LOV query :$column$.ap_inv_line_attribute9 AP_INV_LINE_ATTRIBUTE9 AP_INV_LINE_ATTRIBUTE11 LOV query :$column$.line_attribute_category LINE_ATTRIBUTE_CATEGORY AP_INV_LINE_ATTRIBUTE11 LOV query :$column$.ap_inv_line_attribute1 AP_INV_LINE_ATTRIBUTE1 AP_INV_LINE_ATTRIBUTE12 LOV query :$column$.ap_inv_line_attribute10 AP_INV_LINE_ATTRIBUTE10 AP_INV_LINE_ATTRIBUTE12 LOV query :$column$.ap_inv_line_attribute11 AP_INV_LINE_ATTRIBUTE11 AP_INV_LINE_ATTRIBUTE12 LOV query :$column$.ap_inv_line_attribute12 AP_INV_LINE_ATTRIBUTE12 AP_INV_LINE_ATTRIBUTE12 LOV query :$column$.ap_inv_line_attribute13 AP_INV_LINE_ATTRIBUTE13 AP_INV_LINE_ATTRIBUTE12 LOV query :$column$.ap_inv_line_attribute14 AP_INV_LINE_ATTRIBUTE14 AP_INV_LINE_ATTRIBUTE12 LOV query :$column$.ap_inv_line_attribute15 AP_INV_LINE_ATTRIBUTE15 AP_INV_LINE_ATTRIBUTE12 LOV query :$column$.ap_inv_line_attribute2 AP_INV_LINE_ATTRIBUTE2 AP_INV_LINE_ATTRIBUTE12 LOV query :$column$.ap_inv_line_attribute3 AP_INV_LINE_ATTRIBUTE3 AP_INV_LINE_ATTRIBUTE12 LOV query :$column$.ap_inv_line_attribute4 AP_INV_LINE_ATTRIBUTE4 AP_INV_LINE_ATTRIBUTE12 LOV query :$column$.ap_inv_line_attribute5 AP_INV_LINE_ATTRIBUTE5 AP_INV_LINE_ATTRIBUTE12 LOV query :$column$.ap_inv_line_attribute6 AP_INV_LINE_ATTRIBUTE6 AP_INV_LINE_ATTRIBUTE12 LOV query :$column$.ap_inv_line_attribute7 AP_INV_LINE_ATTRIBUTE7 AP_INV_LINE_ATTRIBUTE12 LOV query :$column$.ap_inv_line_attribute8 AP_INV_LINE_ATTRIBUTE8 AP_INV_LINE_ATTRIBUTE12 LOV query :$column$.ap_inv_line_attribute9 AP_INV_LINE_ATTRIBUTE9 AP_INV_LINE_ATTRIBUTE12 LOV query :$column$.line_attribute_category LINE_ATTRIBUTE_CATEGORY AP_INV_LINE_ATTRIBUTE12 LOV query :$column$.ap_inv_line_attribute1 AP_INV_LINE_ATTRIBUTE1 AP_INV_LINE_ATTRIBUTE13 LOV query :$column$.ap_inv_line_attribute10 AP_INV_LINE_ATTRIBUTE10 AP_INV_LINE_ATTRIBUTE13 LOV query :$column$.ap_inv_line_attribute11 AP_INV_LINE_ATTRIBUTE11 AP_INV_LINE_ATTRIBUTE13 LOV query :$column$.ap_inv_line_attribute12 AP_INV_LINE_ATTRIBUTE12 AP_INV_LINE_ATTRIBUTE13 LOV query :$column$.ap_inv_line_attribute13 AP_INV_LINE_ATTRIBUTE13 AP_INV_LINE_ATTRIBUTE13 LOV query :$column$.ap_inv_line_attribute14 AP_INV_LINE_ATTRIBUTE14 AP_INV_LINE_ATTRIBUTE13 LOV query :$column$.ap_inv_line_attribute15 AP_INV_LINE_ATTRIBUTE15 AP_INV_LINE_ATTRIBUTE13 LOV query :$column$.ap_inv_line_attribute2 AP_INV_LINE_ATTRIBUTE2 AP_INV_LINE_ATTRIBUTE13 LOV query :$column$.ap_inv_line_attribute3 AP_INV_LINE_ATTRIBUTE3 AP_INV_LINE_ATTRIBUTE13 LOV query :$column$.ap_inv_line_attribute4 AP_INV_LINE_ATTRIBUTE4 AP_INV_LINE_ATTRIBUTE13 LOV query :$column$.ap_inv_line_attribute5 AP_INV_LINE_ATTRIBUTE5 AP_INV_LINE_ATTRIBUTE13 LOV query :$column$.ap_inv_line_attribute6 AP_INV_LINE_ATTRIBUTE6 AP_INV_LINE_ATTRIBUTE13 LOV query :$column$.ap_inv_line_attribute7 AP_INV_LINE_ATTRIBUTE7 AP_INV_LINE_ATTRIBUTE13 LOV query :$column$.ap_inv_line_attribute8 AP_INV_LINE_ATTRIBUTE8 AP_INV_LINE_ATTRIBUTE13 LOV query :$column$.ap_inv_line_attribute9 AP_INV_LINE_ATTRIBUTE9 AP_INV_LINE_ATTRIBUTE13 LOV query :$column$.line_attribute_category LINE_ATTRIBUTE_CATEGORY AP_INV_LINE_ATTRIBUTE13 LOV query :$column$.ap_inv_line_attribute1 AP_INV_LINE_ATTRIBUTE1 AP_INV_LINE_ATTRIBUTE14 LOV query :$column$.ap_inv_line_attribute10 AP_INV_LINE_ATTRIBUTE10 AP_INV_LINE_ATTRIBUTE14 LOV query :$column$.ap_inv_line_attribute11 AP_INV_LINE_ATTRIBUTE11 AP_INV_LINE_ATTRIBUTE14 LOV query :$column$.ap_inv_line_attribute12 AP_INV_LINE_ATTRIBUTE12 AP_INV_LINE_ATTRIBUTE14 LOV query :$column$.ap_inv_line_attribute13 AP_INV_LINE_ATTRIBUTE13 AP_INV_LINE_ATTRIBUTE14 LOV query :$column$.ap_inv_line_attribute14 AP_INV_LINE_ATTRIBUTE14 AP_INV_LINE_ATTRIBUTE14 LOV query :$column$.ap_inv_line_attribute15 AP_INV_LINE_ATTRIBUTE15 AP_INV_LINE_ATTRIBUTE14 LOV query :$column$.ap_inv_line_attribute2 AP_INV_LINE_ATTRIBUTE2 AP_INV_LINE_ATTRIBUTE14 LOV query :$column$.ap_inv_line_attribute3 AP_INV_LINE_ATTRIBUTE3 AP_INV_LINE_ATTRIBUTE14 LOV query :$column$.ap_inv_line_attribute4 AP_INV_LINE_ATTRIBUTE4 AP_INV_LINE_ATTRIBUTE14 LOV query :$column$.ap_inv_line_attribute5 AP_INV_LINE_ATTRIBUTE5 AP_INV_LINE_ATTRIBUTE14 LOV query :$column$.ap_inv_line_attribute6 AP_INV_LINE_ATTRIBUTE6 AP_INV_LINE_ATTRIBUTE14 LOV query :$column$.ap_inv_line_attribute7 AP_INV_LINE_ATTRIBUTE7 AP_INV_LINE_ATTRIBUTE14 LOV query :$column$.ap_inv_line_attribute8 AP_INV_LINE_ATTRIBUTE8 AP_INV_LINE_ATTRIBUTE14 LOV query :$column$.ap_inv_line_attribute9 AP_INV_LINE_ATTRIBUTE9 AP_INV_LINE_ATTRIBUTE14 LOV query :$column$.line_attribute_category LINE_ATTRIBUTE_CATEGORY AP_INV_LINE_ATTRIBUTE14 LOV query :$column$.ap_inv_line_attribute1 AP_INV_LINE_ATTRIBUTE1 AP_INV_LINE_ATTRIBUTE15 LOV query :$column$.ap_inv_line_attribute10 AP_INV_LINE_ATTRIBUTE10 AP_INV_LINE_ATTRIBUTE15 LOV query :$column$.ap_inv_line_attribute11 AP_INV_LINE_ATTRIBUTE11 AP_INV_LINE_ATTRIBUTE15 LOV query :$column$.ap_inv_line_attribute12 AP_INV_LINE_ATTRIBUTE12 AP_INV_LINE_ATTRIBUTE15 LOV query :$column$.ap_inv_line_attribute13 AP_INV_LINE_ATTRIBUTE13 AP_INV_LINE_ATTRIBUTE15 LOV query :$column$.ap_inv_line_attribute14 AP_INV_LINE_ATTRIBUTE14 AP_INV_LINE_ATTRIBUTE15 LOV query :$column$.ap_inv_line_attribute15 AP_INV_LINE_ATTRIBUTE15 AP_INV_LINE_ATTRIBUTE15 LOV query :$column$.ap_inv_line_attribute2 AP_INV_LINE_ATTRIBUTE2 AP_INV_LINE_ATTRIBUTE15 LOV query :$column$.ap_inv_line_attribute3 AP_INV_LINE_ATTRIBUTE3 AP_INV_LINE_ATTRIBUTE15 LOV query :$column$.ap_inv_line_attribute4 AP_INV_LINE_ATTRIBUTE4 AP_INV_LINE_ATTRIBUTE15 LOV query :$column$.ap_inv_line_attribute5 AP_INV_LINE_ATTRIBUTE5 AP_INV_LINE_ATTRIBUTE15 LOV query :$column$.ap_inv_line_attribute6 AP_INV_LINE_ATTRIBUTE6 AP_INV_LINE_ATTRIBUTE15 LOV query :$column$.ap_inv_line_attribute7 AP_INV_LINE_ATTRIBUTE7 AP_INV_LINE_ATTRIBUTE15 LOV query :$column$.ap_inv_line_attribute8 AP_INV_LINE_ATTRIBUTE8 AP_INV_LINE_ATTRIBUTE15 LOV query :$column$.ap_inv_line_attribute9 AP_INV_LINE_ATTRIBUTE9 AP_INV_LINE_ATTRIBUTE15 LOV query :$column$.line_attribute_category LINE_ATTRIBUTE_CATEGORY AP_INV_LINE_ATTRIBUTE15 LOV query :$column$.ap_inv_line_attribute1 AP_INV_LINE_ATTRIBUTE1 AP_INV_LINE_ATTRIBUTE2 LOV query :$column$.ap_inv_line_attribute10 AP_INV_LINE_ATTRIBUTE10 AP_INV_LINE_ATTRIBUTE2 LOV query :$column$.ap_inv_line_attribute11 AP_INV_LINE_ATTRIBUTE11 AP_INV_LINE_ATTRIBUTE2 LOV query :$column$.ap_inv_line_attribute12 AP_INV_LINE_ATTRIBUTE12 AP_INV_LINE_ATTRIBUTE2 LOV query :$column$.ap_inv_line_attribute13 AP_INV_LINE_ATTRIBUTE13 AP_INV_LINE_ATTRIBUTE2 LOV query :$column$.ap_inv_line_attribute14 AP_INV_LINE_ATTRIBUTE14 AP_INV_LINE_ATTRIBUTE2 LOV query :$column$.ap_inv_line_attribute15 AP_INV_LINE_ATTRIBUTE15 AP_INV_LINE_ATTRIBUTE2 LOV query :$column$.ap_inv_line_attribute2 AP_INV_LINE_ATTRIBUTE2 AP_INV_LINE_ATTRIBUTE2 LOV query :$column$.ap_inv_line_attribute3 AP_INV_LINE_ATTRIBUTE3 AP_INV_LINE_ATTRIBUTE2 LOV query :$column$.ap_inv_line_attribute4 AP_INV_LINE_ATTRIBUTE4 AP_INV_LINE_ATTRIBUTE2 LOV query :$column$.ap_inv_line_attribute5 AP_INV_LINE_ATTRIBUTE5 AP_INV_LINE_ATTRIBUTE2 LOV query :$column$.ap_inv_line_attribute6 AP_INV_LINE_ATTRIBUTE6 AP_INV_LINE_ATTRIBUTE2 LOV query :$column$.ap_inv_line_attribute7 AP_INV_LINE_ATTRIBUTE7 AP_INV_LINE_ATTRIBUTE2 LOV query :$column$.ap_inv_line_attribute8 AP_INV_LINE_ATTRIBUTE8 AP_INV_LINE_ATTRIBUTE2 LOV query :$column$.ap_inv_line_attribute9 AP_INV_LINE_ATTRIBUTE9 AP_INV_LINE_ATTRIBUTE2 LOV query :$column$.line_attribute_category LINE_ATTRIBUTE_CATEGORY AP_INV_LINE_ATTRIBUTE2 LOV query :$column$.ap_inv_line_attribute1 AP_INV_LINE_ATTRIBUTE1 AP_INV_LINE_ATTRIBUTE3 LOV query :$column$.ap_inv_line_attribute10 AP_INV_LINE_ATTRIBUTE10 AP_INV_LINE_ATTRIBUTE3 LOV query :$column$.ap_inv_line_attribute11 AP_INV_LINE_ATTRIBUTE11 AP_INV_LINE_ATTRIBUTE3 LOV query :$column$.ap_inv_line_attribute12 AP_INV_LINE_ATTRIBUTE12 AP_INV_LINE_ATTRIBUTE3 LOV query :$column$.ap_inv_line_attribute13 AP_INV_LINE_ATTRIBUTE13 AP_INV_LINE_ATTRIBUTE3 LOV query :$column$.ap_inv_line_attribute14 AP_INV_LINE_ATTRIBUTE14 AP_INV_LINE_ATTRIBUTE3 LOV query :$column$.ap_inv_line_attribute15 AP_INV_LINE_ATTRIBUTE15 AP_INV_LINE_ATTRIBUTE3 LOV query :$column$.ap_inv_line_attribute2 AP_INV_LINE_ATTRIBUTE2 AP_INV_LINE_ATTRIBUTE3 LOV query :$column$.ap_inv_line_attribute3 AP_INV_LINE_ATTRIBUTE3 AP_INV_LINE_ATTRIBUTE3 LOV query :$column$.ap_inv_line_attribute4 AP_INV_LINE_ATTRIBUTE4 AP_INV_LINE_ATTRIBUTE3 LOV query :$column$.ap_inv_line_attribute5 AP_INV_LINE_ATTRIBUTE5 AP_INV_LINE_ATTRIBUTE3 LOV query :$column$.ap_inv_line_attribute6 AP_INV_LINE_ATTRIBUTE6 AP_INV_LINE_ATTRIBUTE3 LOV query :$column$.ap_inv_line_attribute7 AP_INV_LINE_ATTRIBUTE7 AP_INV_LINE_ATTRIBUTE3 LOV query :$column$.ap_inv_line_attribute8 AP_INV_LINE_ATTRIBUTE8 AP_INV_LINE_ATTRIBUTE3 LOV query :$column$.ap_inv_line_attribute9 AP_INV_LINE_ATTRIBUTE9 AP_INV_LINE_ATTRIBUTE3 LOV query :$column$.line_attribute_category LINE_ATTRIBUTE_CATEGORY AP_INV_LINE_ATTRIBUTE3 LOV query :$column$.ap_inv_line_attribute1 AP_INV_LINE_ATTRIBUTE1 AP_INV_LINE_ATTRIBUTE4 LOV query :$column$.ap_inv_line_attribute10 AP_INV_LINE_ATTRIBUTE10 AP_INV_LINE_ATTRIBUTE4 LOV query :$column$.ap_inv_line_attribute11 AP_INV_LINE_ATTRIBUTE11 AP_INV_LINE_ATTRIBUTE4 LOV query :$column$.ap_inv_line_attribute12 AP_INV_LINE_ATTRIBUTE12 AP_INV_LINE_ATTRIBUTE4 LOV query :$column$.ap_inv_line_attribute13 AP_INV_LINE_ATTRIBUTE13 AP_INV_LINE_ATTRIBUTE4 LOV query :$column$.ap_inv_line_attribute14 AP_INV_LINE_ATTRIBUTE14 AP_INV_LINE_ATTRIBUTE4 LOV query :$column$.ap_inv_line_attribute15 AP_INV_LINE_ATTRIBUTE15 AP_INV_LINE_ATTRIBUTE4 LOV query :$column$.ap_inv_line_attribute2 AP_INV_LINE_ATTRIBUTE2 AP_INV_LINE_ATTRIBUTE4 LOV query :$column$.ap_inv_line_attribute3 AP_INV_LINE_ATTRIBUTE3 AP_INV_LINE_ATTRIBUTE4 LOV query :$column$.ap_inv_line_attribute4 AP_INV_LINE_ATTRIBUTE4 AP_INV_LINE_ATTRIBUTE4 LOV query :$column$.ap_inv_line_attribute5 AP_INV_LINE_ATTRIBUTE5 AP_INV_LINE_ATTRIBUTE4 LOV query :$column$.ap_inv_line_attribute6 AP_INV_LINE_ATTRIBUTE6 AP_INV_LINE_ATTRIBUTE4 LOV query :$column$.ap_inv_line_attribute7 AP_INV_LINE_ATTRIBUTE7 AP_INV_LINE_ATTRIBUTE4 LOV query :$column$.ap_inv_line_attribute8 AP_INV_LINE_ATTRIBUTE8 AP_INV_LINE_ATTRIBUTE4 LOV query :$column$.ap_inv_line_attribute9 AP_INV_LINE_ATTRIBUTE9 AP_INV_LINE_ATTRIBUTE4 LOV query :$column$.line_attribute_category LINE_ATTRIBUTE_CATEGORY AP_INV_LINE_ATTRIBUTE4 LOV query :$column$.ap_inv_line_attribute1 AP_INV_LINE_ATTRIBUTE1 AP_INV_LINE_ATTRIBUTE5 LOV query :$column$.ap_inv_line_attribute10 AP_INV_LINE_ATTRIBUTE10 AP_INV_LINE_ATTRIBUTE5 LOV query :$column$.ap_inv_line_attribute11 AP_INV_LINE_ATTRIBUTE11 AP_INV_LINE_ATTRIBUTE5 LOV query :$column$.ap_inv_line_attribute12 AP_INV_LINE_ATTRIBUTE12 AP_INV_LINE_ATTRIBUTE5 LOV query :$column$.ap_inv_line_attribute13 AP_INV_LINE_ATTRIBUTE13 AP_INV_LINE_ATTRIBUTE5 LOV query :$column$.ap_inv_line_attribute14 AP_INV_LINE_ATTRIBUTE14 AP_INV_LINE_ATTRIBUTE5 LOV query :$column$.ap_inv_line_attribute15 AP_INV_LINE_ATTRIBUTE15 AP_INV_LINE_ATTRIBUTE5 LOV query :$column$.ap_inv_line_attribute2 AP_INV_LINE_ATTRIBUTE2 AP_INV_LINE_ATTRIBUTE5 LOV query :$column$.ap_inv_line_attribute3 AP_INV_LINE_ATTRIBUTE3 AP_INV_LINE_ATTRIBUTE5 LOV query :$column$.ap_inv_line_attribute4 AP_INV_LINE_ATTRIBUTE4 AP_INV_LINE_ATTRIBUTE5 LOV query :$column$.ap_inv_line_attribute5 AP_INV_LINE_ATTRIBUTE5 AP_INV_LINE_ATTRIBUTE5 LOV query :$column$.ap_inv_line_attribute6 AP_INV_LINE_ATTRIBUTE6 AP_INV_LINE_ATTRIBUTE5 LOV query :$column$.ap_inv_line_attribute7 AP_INV_LINE_ATTRIBUTE7 AP_INV_LINE_ATTRIBUTE5 LOV query :$column$.ap_inv_line_attribute8 AP_INV_LINE_ATTRIBUTE8 AP_INV_LINE_ATTRIBUTE5 LOV query :$column$.ap_inv_line_attribute9 AP_INV_LINE_ATTRIBUTE9 AP_INV_LINE_ATTRIBUTE5 LOV query :$column$.line_attribute_category LINE_ATTRIBUTE_CATEGORY AP_INV_LINE_ATTRIBUTE5 LOV query :$column$.ap_inv_line_attribute1 AP_INV_LINE_ATTRIBUTE1 AP_INV_LINE_ATTRIBUTE6 LOV query :$column$.ap_inv_line_attribute10 AP_INV_LINE_ATTRIBUTE10 AP_INV_LINE_ATTRIBUTE6 LOV query :$column$.ap_inv_line_attribute11 AP_INV_LINE_ATTRIBUTE11 AP_INV_LINE_ATTRIBUTE6 LOV query :$column$.ap_inv_line_attribute12 AP_INV_LINE_ATTRIBUTE12 AP_INV_LINE_ATTRIBUTE6 LOV query :$column$.ap_inv_line_attribute13 AP_INV_LINE_ATTRIBUTE13 AP_INV_LINE_ATTRIBUTE6 LOV query :$column$.ap_inv_line_attribute14 AP_INV_LINE_ATTRIBUTE14 AP_INV_LINE_ATTRIBUTE6 LOV query :$column$.ap_inv_line_attribute15 AP_INV_LINE_ATTRIBUTE15 AP_INV_LINE_ATTRIBUTE6 LOV query :$column$.ap_inv_line_attribute2 AP_INV_LINE_ATTRIBUTE2 AP_INV_LINE_ATTRIBUTE6 LOV query :$column$.ap_inv_line_attribute3 AP_INV_LINE_ATTRIBUTE3 AP_INV_LINE_ATTRIBUTE6 LOV query :$column$.ap_inv_line_attribute4 AP_INV_LINE_ATTRIBUTE4 AP_INV_LINE_ATTRIBUTE6 LOV query :$column$.ap_inv_line_attribute5 AP_INV_LINE_ATTRIBUTE5 AP_INV_LINE_ATTRIBUTE6 LOV query :$column$.ap_inv_line_attribute6 AP_INV_LINE_ATTRIBUTE6 AP_INV_LINE_ATTRIBUTE6 LOV query :$column$.ap_inv_line_attribute7 AP_INV_LINE_ATTRIBUTE7 AP_INV_LINE_ATTRIBUTE6 LOV query :$column$.ap_inv_line_attribute8 AP_INV_LINE_ATTRIBUTE8 AP_INV_LINE_ATTRIBUTE6 LOV query :$column$.ap_inv_line_attribute9 AP_INV_LINE_ATTRIBUTE9 AP_INV_LINE_ATTRIBUTE6 LOV query :$column$.line_attribute_category LINE_ATTRIBUTE_CATEGORY AP_INV_LINE_ATTRIBUTE6 LOV query :$column$.ap_inv_line_attribute1 AP_INV_LINE_ATTRIBUTE1 AP_INV_LINE_ATTRIBUTE7 LOV query :$column$.ap_inv_line_attribute10 AP_INV_LINE_ATTRIBUTE10 AP_INV_LINE_ATTRIBUTE7 LOV query :$column$.ap_inv_line_attribute11 AP_INV_LINE_ATTRIBUTE11 AP_INV_LINE_ATTRIBUTE7 LOV query :$column$.ap_inv_line_attribute12 AP_INV_LINE_ATTRIBUTE12 AP_INV_LINE_ATTRIBUTE7 LOV query :$column$.ap_inv_line_attribute13 AP_INV_LINE_ATTRIBUTE13 AP_INV_LINE_ATTRIBUTE7 LOV query :$column$.ap_inv_line_attribute14 AP_INV_LINE_ATTRIBUTE14 AP_INV_LINE_ATTRIBUTE7 LOV query :$column$.ap_inv_line_attribute15 AP_INV_LINE_ATTRIBUTE15 AP_INV_LINE_ATTRIBUTE7 LOV query :$column$.ap_inv_line_attribute2 AP_INV_LINE_ATTRIBUTE2 AP_INV_LINE_ATTRIBUTE7 LOV query :$column$.ap_inv_line_attribute3 AP_INV_LINE_ATTRIBUTE3 AP_INV_LINE_ATTRIBUTE7 LOV query :$column$.ap_inv_line_attribute4 AP_INV_LINE_ATTRIBUTE4 AP_INV_LINE_ATTRIBUTE7 LOV query :$column$.ap_inv_line_attribute5 AP_INV_LINE_ATTRIBUTE5 AP_INV_LINE_ATTRIBUTE7 LOV query :$column$.ap_inv_line_attribute6 AP_INV_LINE_ATTRIBUTE6 AP_INV_LINE_ATTRIBUTE7 LOV query :$column$.ap_inv_line_attribute7 AP_INV_LINE_ATTRIBUTE7 AP_INV_LINE_ATTRIBUTE7 LOV query :$column$.ap_inv_line_attribute8 AP_INV_LINE_ATTRIBUTE8 AP_INV_LINE_ATTRIBUTE7 LOV query :$column$.ap_inv_line_attribute9 AP_INV_LINE_ATTRIBUTE9 AP_INV_LINE_ATTRIBUTE7 LOV query :$column$.line_attribute_category LINE_ATTRIBUTE_CATEGORY AP_INV_LINE_ATTRIBUTE7 LOV query :$column$.ap_inv_line_attribute1 AP_INV_LINE_ATTRIBUTE1 AP_INV_LINE_ATTRIBUTE8 LOV query :$column$.ap_inv_line_attribute10 AP_INV_LINE_ATTRIBUTE10 AP_INV_LINE_ATTRIBUTE8 LOV query :$column$.ap_inv_line_attribute11 AP_INV_LINE_ATTRIBUTE11 AP_INV_LINE_ATTRIBUTE8 LOV query :$column$.ap_inv_line_attribute12 AP_INV_LINE_ATTRIBUTE12 AP_INV_LINE_ATTRIBUTE8 LOV query :$column$.ap_inv_line_attribute13 AP_INV_LINE_ATTRIBUTE13 AP_INV_LINE_ATTRIBUTE8 LOV query :$column$.ap_inv_line_attribute14 AP_INV_LINE_ATTRIBUTE14 AP_INV_LINE_ATTRIBUTE8 LOV query :$column$.ap_inv_line_attribute15 AP_INV_LINE_ATTRIBUTE15 AP_INV_LINE_ATTRIBUTE8 LOV query :$column$.ap_inv_line_attribute2 AP_INV_LINE_ATTRIBUTE2 AP_INV_LINE_ATTRIBUTE8 LOV query :$column$.ap_inv_line_attribute3 AP_INV_LINE_ATTRIBUTE3 AP_INV_LINE_ATTRIBUTE8 LOV query :$column$.ap_inv_line_attribute4 AP_INV_LINE_ATTRIBUTE4 AP_INV_LINE_ATTRIBUTE8 LOV query :$column$.ap_inv_line_attribute5 AP_INV_LINE_ATTRIBUTE5 AP_INV_LINE_ATTRIBUTE8 LOV query :$column$.ap_inv_line_attribute6 AP_INV_LINE_ATTRIBUTE6 AP_INV_LINE_ATTRIBUTE8 LOV query :$column$.ap_inv_line_attribute7 AP_INV_LINE_ATTRIBUTE7 AP_INV_LINE_ATTRIBUTE8 LOV query :$column$.ap_inv_line_attribute8 AP_INV_LINE_ATTRIBUTE8 AP_INV_LINE_ATTRIBUTE8 LOV query :$column$.ap_inv_line_attribute9 AP_INV_LINE_ATTRIBUTE9 AP_INV_LINE_ATTRIBUTE8 LOV query :$column$.line_attribute_category LINE_ATTRIBUTE_CATEGORY AP_INV_LINE_ATTRIBUTE8 LOV query :$column$.ap_inv_line_attribute1 AP_INV_LINE_ATTRIBUTE1 AP_INV_LINE_ATTRIBUTE9 LOV query :$column$.ap_inv_line_attribute10 AP_INV_LINE_ATTRIBUTE10 AP_INV_LINE_ATTRIBUTE9 LOV query :$column$.ap_inv_line_attribute11 AP_INV_LINE_ATTRIBUTE11 AP_INV_LINE_ATTRIBUTE9 LOV query :$column$.ap_inv_line_attribute12 AP_INV_LINE_ATTRIBUTE12 AP_INV_LINE_ATTRIBUTE9 LOV query :$column$.ap_inv_line_attribute13 AP_INV_LINE_ATTRIBUTE13 AP_INV_LINE_ATTRIBUTE9 LOV query :$column$.ap_inv_line_attribute14 AP_INV_LINE_ATTRIBUTE14 AP_INV_LINE_ATTRIBUTE9 LOV query :$column$.ap_inv_line_attribute15 AP_INV_LINE_ATTRIBUTE15 AP_INV_LINE_ATTRIBUTE9 LOV query :$column$.ap_inv_line_attribute2 AP_INV_LINE_ATTRIBUTE2 AP_INV_LINE_ATTRIBUTE9 LOV query :$column$.ap_inv_line_attribute3 AP_INV_LINE_ATTRIBUTE3 AP_INV_LINE_ATTRIBUTE9 LOV query :$column$.ap_inv_line_attribute4 AP_INV_LINE_ATTRIBUTE4 AP_INV_LINE_ATTRIBUTE9 LOV query :$column$.ap_inv_line_attribute5 AP_INV_LINE_ATTRIBUTE5 AP_INV_LINE_ATTRIBUTE9 LOV query :$column$.ap_inv_line_attribute6 AP_INV_LINE_ATTRIBUTE6 AP_INV_LINE_ATTRIBUTE9 LOV query :$column$.ap_inv_line_attribute7 AP_INV_LINE_ATTRIBUTE7 AP_INV_LINE_ATTRIBUTE9 LOV query :$column$.ap_inv_line_attribute8 AP_INV_LINE_ATTRIBUTE8 AP_INV_LINE_ATTRIBUTE9 LOV query :$column$.ap_inv_line_attribute9 AP_INV_LINE_ATTRIBUTE9 AP_INV_LINE_ATTRIBUTE9 LOV query :$column$.line_attribute_category LINE_ATTRIBUTE_CATEGORY AP_INV_LINE_ATTRIBUTE9 Default value :$flex$.batch_name Batch Name|:p_batch_name| BATCH_NAME LOV query :$column$.distribution_account_alias DISTRIBUTION_ACCOUNT_ALIAS DISTRIBUTION_ACCOUNT Default value :$column$.distribution_account_alias DISTRIBUTION_ACCOUNT_ALIAS DISTRIBUTION_ACCOUNT Default value :$flex$.operating_unit Operating Unit|:p_operating_unit| DISTRIBUTION_ACCOUNT LOV query :$flex$.operating_unit Operating Unit|:p_operating_unit| DISTRIBUTION_ACCOUNT LOV query :$flex$.operating_unit Operating Unit|:p_operating_unit| DISTRIBUTION_ACCOUNT_ALIAS LOV query :$column$.distribution_account DISTRIBUTION_ACCOUNT DISTRIBUTION_SET LOV query :$column$.operating_unit OPERATING_UNIT DISTRIBUTION_SET LOV query :$column$.operating_unit OPERATING_UNIT EXPENDITURE_ORGANIZATION LOV query :$column$.expenditure_item_date EXPENDITURE_ITEM_DATE EXPENDITURE_TYPE LOV query :$column$.invoice_type INVOICE_TYPE EXPENDITURE_TYPE Default value :$flex$.gl_date GL Date|:p_gl_date| GL_DATE LOV query :$column$.operating_unit OPERATING_UNIT INVOICE_PO_NUMBER LOV query :$column$.supplier_number SUPPLIER_NUMBER INVOICE_PO_NUMBER Default value :$column$.operating_unit OPERATING_UNIT LINE_DESCRIPTION Default value :$column$.po_line_num PO_LINE_NUM LINE_DESCRIPTION Default value :$column$.po_number PO_NUMBER LINE_DESCRIPTION Default value :$column$.supplier_number SUPPLIER_NUMBER LINE_DESCRIPTION Default value :$flex$.operating_unit Operating Unit|:p_operating_unit| OPERATING_UNIT LOV query :$flex$.operating_unit Operating Unit|:p_operating_unit| OPERATING_UNIT LOV query :$column$.invoice_currency INVOICE_CURRENCY PO_DISTRIBUTION_NUM LOV query :$column$.operating_unit OPERATING_UNIT PO_DISTRIBUTION_NUM LOV query :$column$.po_line_num PO_LINE_NUM PO_DISTRIBUTION_NUM LOV query :$column$.po_number PO_NUMBER PO_DISTRIBUTION_NUM LOV query :$column$.po_shipment_num PO_SHIPMENT_NUM PO_DISTRIBUTION_NUM LOV query :$column$.supplier_number SUPPLIER_NUMBER PO_DISTRIBUTION_NUM LOV query :$column$.invoice_currency INVOICE_CURRENCY PO_LINE_NUM LOV query :$column$.operating_unit OPERATING_UNIT PO_LINE_NUM LOV query :$column$.po_number PO_NUMBER PO_LINE_NUM LOV query :$column$.po_release_num PO_RELEASE_NUM PO_LINE_NUM LOV query :$column$.supplier_number SUPPLIER_NUMBER PO_LINE_NUM LOV query :$column$.invoice_currency INVOICE_CURRENCY PO_NUMBER LOV query :$column$.invoice_po_number INVOICE_PO_NUMBER PO_NUMBER LOV query :$column$.operating_unit OPERATING_UNIT PO_NUMBER LOV query :$column$.supplier_number SUPPLIER_NUMBER PO_NUMBER LOV query :$column$.invoice_currency INVOICE_CURRENCY PO_RECEIPT_LINE_NUM LOV query :$column$.operating_unit OPERATING_UNIT PO_RECEIPT_LINE_NUM LOV query :$column$.po_line_num PO_LINE_NUM PO_RECEIPT_LINE_NUM LOV query :$column$.po_number PO_NUMBER PO_RECEIPT_LINE_NUM LOV query :$column$.po_receipt_num PO_RECEIPT_NUM PO_RECEIPT_LINE_NUM LOV query :$column$.po_shipment_num PO_SHIPMENT_NUM PO_RECEIPT_LINE_NUM LOV query :$column$.supplier_number SUPPLIER_NUMBER PO_RECEIPT_LINE_NUM LOV query :$column$.invoice_currency INVOICE_CURRENCY PO_RECEIPT_NUM LOV query :$column$.operating_unit OPERATING_UNIT PO_RECEIPT_NUM LOV query :$column$.po_line_num PO_LINE_NUM PO_RECEIPT_NUM LOV query :$column$.po_number PO_NUMBER PO_RECEIPT_NUM LOV query :$column$.po_shipment_num PO_SHIPMENT_NUM PO_RECEIPT_NUM LOV query :$column$.supplier_number SUPPLIER_NUMBER PO_RECEIPT_NUM LOV query :$column$.invoice_currency INVOICE_CURRENCY PO_RELEASE_NUM LOV query :$column$.operating_unit OPERATING_UNIT PO_RELEASE_NUM LOV query :$column$.po_number PO_NUMBER PO_RELEASE_NUM LOV query :$column$.supplier_number SUPPLIER_NUMBER PO_RELEASE_NUM LOV query :$column$.operating_unit OPERATING_UNIT PO_SHIPMENT_NUM LOV query :$column$.po_line_num PO_LINE_NUM PO_SHIPMENT_NUM LOV query :$column$.po_number PO_NUMBER PO_SHIPMENT_NUM LOV query :$column$.po_release_num PO_RELEASE_NUM PO_SHIPMENT_NUM LOV query :$column$.supplier_number SUPPLIER_NUMBER PO_SHIPMENT_NUM Default value :$flex$.invoice_source Invoice Source|:p_source| SOURCE Default value :$flex$.submit_invoice_validation Submit Invoice Validation|:p_submit_validation| SUBMIT_VALIDATION LOV query :$column$.supplier_number SUPPLIER_NUMBER SUPPLIER_NAME LOV query :$flex$.operating_unit Operating Unit|:p_operating_unit| SUPPLIER_NAME LOV query :$column$.supplier_name SUPPLIER_NAME SUPPLIER_NUMBER LOV query :$flex$.operating_unit Operating Unit|:p_operating_unit| SUPPLIER_NUMBER LOV query :$column$.supplier_name SUPPLIER_NAME SUPPLIER_SITE LOV query :$column$.supplier_number SUPPLIER_NUMBER SUPPLIER_SITE LOV query :$flex$.operating_unit Operating Unit|:p_operating_unit| SUPPLIER_SITE LOV query :$column$.project PROJECT TASK LOV query :$column$.operating_unit OPERATING_UNIT TAX_CODE Value to id query :$column$.distribution_account DISTRIBUTION_ACCOUNT p_distribution_set_name Value to id query :$column$.invoice_currency INVOICE_CURRENCY p_line_num Value to id query :$column$.invoice_currency INVOICE_CURRENCY p_line_po_distribution_num Value to id query :$column$.invoice_currency INVOICE_CURRENCY p_line_po_line_num Value to id query :$column$.invoice_currency INVOICE_CURRENCY p_line_po_release_num Value to id query :$column$.invoice_currency INVOICE_CURRENCY p_line_receipt_line_num Value to id query :$column$.invoice_currency INVOICE_CURRENCY p_line_receipt_number Value to id query :$column$.operating_unit OPERATING_UNIT p_distribution_set_name Value to id query :$column$.operating_unit OPERATING_UNIT p_expenditure_organization_id Value to id query :$column$.operating_unit OPERATING_UNIT p_invoice_po_number Value to id query :$column$.operating_unit OPERATING_UNIT p_line_num Value to id query :$column$.operating_unit OPERATING_UNIT p_line_po_distribution_num Value to id query :$column$.operating_unit OPERATING_UNIT p_line_po_line_num Value to id query :$column$.operating_unit OPERATING_UNIT p_line_po_number Value to id query :$column$.operating_unit OPERATING_UNIT p_line_po_release_num Value to id query :$column$.operating_unit OPERATING_UNIT p_line_po_shipment_num Value to id query :$column$.operating_unit OPERATING_UNIT p_line_receipt_line_num Value to id query :$column$.operating_unit OPERATING_UNIT p_line_receipt_number Value to id query :$column$.po_line_num PO_LINE_NUM p_line_po_distribution_num Value to id query :$column$.po_line_num PO_LINE_NUM p_line_po_line_num Value to id query :$column$.po_line_num PO_LINE_NUM p_line_po_shipment_num Value to id query :$column$.po_line_num PO_LINE_NUM p_line_receipt_line_num Value to id query :$column$.po_line_num PO_LINE_NUM p_line_receipt_number Value to id query :$column$.po_number PO_NUMBER p_line_num Value to id query :$column$.po_number PO_NUMBER p_line_po_distribution_num Value to id query :$column$.po_number PO_NUMBER p_line_po_line_num Value to id query :$column$.po_number PO_NUMBER p_line_po_release_num Value to id query :$column$.po_number PO_NUMBER p_line_po_shipment_num Value to id query :$column$.po_number PO_NUMBER p_line_receipt_line_num Value to id query :$column$.po_number PO_NUMBER p_line_receipt_number Value to id query :$column$.po_receipt_num PO_RECEIPT_NUM p_line_po_line_num Value to id query :$column$.po_receipt_num PO_RECEIPT_NUM p_line_receipt_line_num Value to id query :$column$.po_release_num PO_RELEASE_NUM p_line_num Value to id query :$column$.po_release_num PO_RELEASE_NUM p_line_po_shipment_num Value to id query :$column$.po_shipment_num PO_SHIPMENT_NUM p_line_po_distribution_num Value to id query :$column$.po_shipment_num PO_SHIPMENT_NUM p_line_po_line_num Value to id query :$column$.po_shipment_num PO_SHIPMENT_NUM p_line_receipt_line_num Value to id query :$column$.po_shipment_num PO_SHIPMENT_NUM p_line_receipt_number Value to id query :$column$.supplier_name SUPPLIER_NAME p_supplier_site Value to id query :$column$.supplier_number SUPPLIER_NUMBER p_invoice_po_number Value to id query :$column$.supplier_number SUPPLIER_NUMBER p_line_num Value to id query :$column$.supplier_number SUPPLIER_NUMBER p_line_po_distribution_num Value to id query :$column$.supplier_number SUPPLIER_NUMBER p_line_po_line_num Value to id query :$column$.supplier_number SUPPLIER_NUMBER p_line_po_number Value to id query :$column$.supplier_number SUPPLIER_NUMBER p_line_po_release_num Value to id query :$column$.supplier_number SUPPLIER_NUMBER p_line_po_shipment_num Value to id query :$column$.supplier_number SUPPLIER_NUMBER p_line_receipt_line_num Value to id query :$column$.supplier_number SUPPLIER_NUMBER p_line_receipt_number Value to id query :$column$.supplier_number SUPPLIER_NUMBER p_supplier_name Value to id query :$column$.supplier_number SUPPLIER_NUMBER p_supplier_num Value to id query :$column$.supplier_number SUPPLIER_NUMBER p_supplier_site Value to id query :$flex$.operating_unit Operating Unit|:p_operating_unit| p_operating_unit Value to id query :$flex$.operating_unit Operating Unit|:p_operating_unit| p_supplier_name Value to id query :$flex$.operating_unit Operating Unit|:p_operating_unit| p_supplier_num Value to id query :$flex$.operating_unit Operating Unit|:p_operating_unit| p_supplier_site