ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN F263DDA3FBF40F8FE0530100007F75CDY with q_dual as (select * from dual) -- dummy to allow the lexical to follow &error_with_query &success_with_query -- -- Main Query Starts Here -- select null action_, null status_, null message_, null request_id_, null modified_columns_, to_number(null) inv_int_id, to_number(null) line_int_id, null batch_name, null submit_validation, null invoice_calculate_tax, null invoice_inclusive_of_tax, -- alc.displayed_field source, haouv.name operating_unit, asu.vendor_name supplier_name, asu.segment1 supplier_number, assa.vendor_site_code supplier_site, xxen_util.meaning(aia.invoice_type_lookup_code,'INVOICE TYPE',200) invoice_type, (select fdsc.name from fnd_doc_sequence_categories fdsc where fdsc.application_id = 200 and fdsc.table_name in ('AP_INVOICES','AP_INVOICES_ALL') and fdsc.code = aia.doc_category_code) document_category, aia.invoice_num invoice_number, null add_to_existing_invoice, aia.description invoice_description, (select pha.segment1 from po_headers_all pha where pha.po_header_id = nvl(aia.po_header_id,aia.quick_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, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = aia.accts_pay_code_combination_id) liability_account, 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, (select ipmv.payment_method_name from iby_payment_methods_vl ipmv where ipmv.payment_method_code = aia.payment_method_code) payment_method, (select idcv.meaning from iby_delivery_channels_vl idcv where idcv.delivery_channel_code = aia.delivery_channel_code) payment_delivery_channel, (select iprv.meaning from iby_payment_reasons_vl iprv where iprv.payment_reason_code = aia.payment_reason_code) payment_reason, aia.payment_reason_comments, (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, (select aag.name from ap_awt_groups aag where aag.group_id = aia.awt_group_id) payment_awt_group, --aia.ussgl_transaction_code, -- not imported by the Payables Import process aia.tax_invoice_recording_date internal_recording_date, aia.supplier_tax_invoice_number, aia.supplier_tax_invoice_date, aia.supplier_tax_exchange_rate, -- aila.line_number, xxen_util.meaning(aila.line_type_lookup_code,'INVOICE LINE TYPE',200) line_type, aila.amount line_amount, aila.description line_description, aila.quantity_invoiced quantity, aila.unit_meas_lookup_code uom, aila.unit_price, -- aila.line_group_number line_prorate_group, xxen_util.meaning(aila.prorate_across_all_items,'YES_NO',0) prorate_flag, aida.distribution_line_number, -- (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, to_number(null) distribution_percent, aida.amount distribution_amount, (select adsa.distribution_set_name from ap_distribution_sets_all adsa where adsa.distribution_set_id = aila.distribution_set_id and adsa.org_id = aila.org_id) distribution_set, -- (select hecv.full_name || ' (' || hecv.employee_num || ')' from hr_employees_current_v hecv where hecv.employee_id = aila.requester_id) requester, -- (select pha.segment1 from po_headers_all pha where pha.po_header_id = aila.po_header_id) po_number, (select pra.release_num from po_releases_all pra where pra.po_release_id = aila.po_release_id) po_release_num, (select pla.line_num from po_lines_all pla where pla.po_line_id = aila.po_line_id) po_line_num, (select plla.shipment_num from po_line_locations_all plla where plla.line_location_id = aila.po_line_location_id) po_shipment_num, (select pda.distribution_num from po_distributions_all pda where pda.po_distribution_id = aila.po_distribution_id) po_distribution_num, (select rsh.receipt_num from rcv_shipment_headers rsh, rcv_shipment_lines rsl where rsh.shipment_header_id = rsl.shipment_header_id and rsl.shipment_line_id = aila.rcv_shipment_line_id) po_receipt_num, (select rsl.line_num from rcv_shipment_lines rsl where rsl.shipment_line_id = aila.rcv_shipment_line_id) po_receipt_line_num, -- (select msiv.concatenated_segments from mtl_system_items_vl msiv where msiv.inventory_item_id = aila.inventory_item_id and msiv.organization_id = fsp.inventory_organization_id) inventory_item, aila.item_description, aila.manufacturer, aila.model_number, aila.serial_number, aila.warranty_number, xxen_util.meaning(aila.assets_tracking_flag,'YES_NO',0) track_as_asset, (select fbc.book_type_name from fa_book_controls fbc where fbc.book_type_code = aila.asset_book_type_code) asset_book, (select fck.concatenated_segments from fa_categories_b_kfv fck where fck.category_id = aila.asset_category_id) asset_category, -- (select ppa.segment1 from pa_projects_all ppa where aila.project_id=ppa.project_id) project, (select pt.task_number from pa_tasks pt where aila.task_id=pt.task_id) task, aila.expenditure_item_date, aila.expenditure_type, (select haouv_exp.name from hr_all_organization_units_vl haouv_exp where aila.expenditure_organization_id=haouv_exp.organization_id) expenditure_organization, aila.pa_quantity project_quantity, -- tax aila.type_1099 income_tax_type, aila.income_tax_region, --xm.taxation_country (select ft.territory_short_name from fnd_territories_vl ft where ft.territory_code = aia.taxation_country ) taxation_country, -- xm.tax_classification, (select zicv.meaning from zx_input_classifications_v zicv where zicv.lookup_type = 'ZX_INPUT_CLASSIFICATIONS' and zicv.lookup_code = aila.tax_classification_code and (zicv.org_id = aila.org_id or zicv.org_id = -99) and zicv.enabled_flag = 'Y' and trunc(sysdate) between nvl(zicv.start_date_active, trunc(sysdate)) and nvl(zicv.end_date_active, trunc(sysdate)) and rownum <= 1 ) tax_classification, -- xm.primary_intended_use, (select zfiuv.classification_name from zx_fc_intended_use_v zfiuv where (zfiuv.country_code = aia.taxation_country or zfiuv.country_code is null) and trunc(sysdate) between nvl(zfiuv.effective_from,trunc(sysdate)) and nvl(zfiuv.effective_to,trunc(sysdate)) and trunc(sysdate) <= nvl(zfiuv.disable_date,trunc(sysdate)) and zfiuv.classification_code = aila.primary_intended_use and rownum <= 1 ) primary_intended_use, -- xm.ship_to_location, (select hlat.location_code from hr_locations_all_tl hlat where hlat.location_id = aila.ship_to_location_id and hlat.language = userenv('LANG') and rownum <= 1 ) ship_to_location, -- xm.product_fiscal_classification, (select zfpcv.classification_name from zx_fc_product_fiscal_v zfpcv where (zfpcv.country_code = aia.taxation_country or zfpcv.country_code is null) and (zfpcv.effective_to >= trunc(sysdate) or zfpcv.effective_to is null) and zfpcv.classification_code = aila.product_fisc_classification and rownum <= 1 ) product_fiscal_classification, -- xm.fiscal_classification, (select zfudv.classification_name from zx_fc_user_defined_v zfudv where (zfudv.country_code = aia.taxation_country or zfudv.country_code is null) and trunc(sysdate) between nvl(zfudv.effective_from,trunc(sysdate)) and nvl(zfudv.effective_to,trunc(sysdate)) and zfudv.classification_code = aila.user_defined_fisc_class and rownum <= 1 ) fiscal_classification, -- xm.business_category, (select zfbcv.classification_name from zx_fc_business_categories_v zfbcv where (zfbcv.country_code = aia.taxation_country or zfbcv.country_code is null) and trunc(sysdate) between nvl(zfbcv.effective_from,trunc(sysdate)) and nvl(zfbcv.effective_to,trunc(sysdate)) and zfbcv.application_id = 200 and zfbcv.entity_code = 'AP_INVOICES' and zfbcv.event_class_code IN ('STANDARD INVOICES','PREPAYMENT INVOICES','EXPENSE REPORTS') and zfbcv.classification_code = aila.trx_business_category and rownum <= 1 ) business_category, -- xm.product_type, (select zptv.classification_name from zx_product_types_v zptv where zptv.classification_code = aila.product_type and rownum <= 1 ) product_type, -- xm.product_category (select zfpcv.classification_name from zx_fc_product_categories_v zfpcv where (zfpcv.country_code = aia.taxation_country or zfpcv.country_code is null) and trunc(sysdate) between nvl(zfpcv.effective_from,trunc(sysdate)) and nvl(zfpcv.effective_to,trunc(sysdate)) and zfpcv.classification_code = aila.product_category and rownum <= 1 ) product_category, -- tax line only columns aila.tax_regime_code tax_regime, aila.tax, aila.tax_status_code tax_status, aila.tax_jurisdiction_code tax_jurisdiction, aila.tax_rate_code tax_rate_name, aila.tax_rate, -- aila.assessable_value, (select aag.name from ap_awt_groups aag where aag.group_id = aila.awt_group_id) line_invoice_awt_group, (select aag.name from ap_awt_groups aag where aag.group_id = aila.awt_group_id) line_payment_awt_group, -- (select flvv.meaning from fnd_lookup_values_vl flvv where flvv.lookup_type='IBY_BANK_CHARGE_BEARER' and flvv.view_application_id = 0 and flvv.lookup_code = aia.bank_charge_bearer) bank_charge_bearer, aia.remittance_message1, aia.remittance_message2, aia.remittance_message3, aia.unique_remittance_identifier, aia.uri_check_digit, -- aia.reference_1 invoice_reference_1, aia.reference_2 invoice_reference_2, aia.reference_key1 invoice_reference_key1, aia.reference_key2 invoice_reference_key2, aia.reference_key3 invoice_reference_key3, aia.reference_key4 invoice_reference_key4, aia.reference_key5 invoice_reference_key5, aila.reference_1 line_reference_1, aila.reference_2 line_reference_2, aila.reference_key1 line_reference_key1, aila.reference_key2 line_reference_key2, aila.reference_key3 line_reference_key3, aila.reference_key4 line_reference_key4, aila.reference_key5 line_reference_key5, -- 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, xxen_util.display_flexfield_context(200,'AP_INVOICE_LINES',aila.attribute_category) line_attribute_category, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE1',aila.rowid,aila.attribute1) ap_inv_line_attribute1, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE2',aila.rowid,aila.attribute2) ap_inv_line_attribute2, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE3',aila.rowid,aila.attribute3) ap_inv_line_attribute3, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE4',aila.rowid,aila.attribute4) ap_inv_line_attribute4, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE5',aila.rowid,aila.attribute5) ap_inv_line_attribute5, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE6',aila.rowid,aila.attribute6) ap_inv_line_attribute6, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE7',aila.rowid,aila.attribute7) ap_inv_line_attribute7, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE8',aila.rowid,aila.attribute8) ap_inv_line_attribute8, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE9',aila.rowid,aila.attribute9) ap_inv_line_attribute9, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE10',aila.rowid,aila.attribute10) ap_inv_line_attribute10, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE11',aila.rowid,aila.attribute11) ap_inv_line_attribute11, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE12',aila.rowid,aila.attribute12) ap_inv_line_attribute12, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE13',aila.rowid,aila.attribute13) ap_inv_line_attribute13, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE14',aila.rowid,aila.attribute14) ap_inv_line_attribute14, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE15',aila.rowid,aila.attribute15) ap_inv_line_attribute15, xxen_util.display_flexfield_context(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category) dist_attribute_category, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE1',aida.rowid,aida.attribute1) ap_inv_dist_attribute1, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE2',aida.rowid,aida.attribute2) ap_inv_dist_attribute2, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE3',aida.rowid,aida.attribute3) ap_inv_dist_attribute3, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE4',aida.rowid,aida.attribute4) ap_inv_dist_attribute4, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE5',aida.rowid,aida.attribute5) ap_inv_dist_attribute5, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE6',aida.rowid,aida.attribute6) ap_inv_dist_attribute6, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE7',aida.rowid,aida.attribute7) ap_inv_dist_attribute7, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE8',aida.rowid,aida.attribute8) ap_inv_dist_attribute8, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE9',aida.rowid,aida.attribute9) ap_inv_dist_attribute9, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE10',aida.rowid,aida.attribute10) ap_inv_dist_attribute10, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE11',aida.rowid,aida.attribute11) ap_inv_dist_attribute11, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE12',aida.rowid,aida.attribute12) ap_inv_dist_attribute12, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE13',aida.rowid,aida.attribute13) ap_inv_dist_attribute13, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE14',aida.rowid,aida.attribute14) ap_inv_dist_attribute14, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE15',aida.rowid,aida.attribute15) ap_inv_dist_attribute15, null attachment_category_, null attachment_title_, null attachment_description_, null attachment_type_, null attachment_content_, null attachment_file_id_, to_number(null) upload_row &il_columns from ap_invoices_all aia, ap_payment_schedules_all apsa, ap_invoice_lines_all aila, ap_invoice_distributions_all aida, financials_system_parameters fsp, hr_all_organization_units_vl haouv, ap_suppliers asu, ap_supplier_sites_all assa, gl_code_combinations_kfv gcck, ap_lookup_codes alc where aia.invoice_id = apsa.invoice_id (+) and aia.invoice_id = aila.invoice_id and aila.invoice_id = aida.invoice_id (+) and aila.line_number = aida.invoice_line_number (+) and aia.vendor_id = asu.vendor_id and aia.vendor_site_id = assa.vendor_site_id and aia.org_id = haouv.organization_id and aia.org_id = fsp.org_id and aila.default_dist_ccid = 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_tax_inclusive_flag,'?') = nvl(:p_tax_inclusive_flag,'?') and nvl(:p_calulate_tax_flag,'?') = nvl(:p_calulate_tax_flag,'?') and nvl(:p_gl_date,sysdate) = nvl(:p_gl_date,sysdate) and nvl(:p_submit_validation,'N') = nvl(:p_submit_validation,'N') and nvl(:p_dflt_line_amount,'N') = nvl(:p_dflt_line_amount,'N') and 1=0 Added the hidden Upload Row column, removed an unused bind and redundant column aliases. U A xxen_ap_upload.insert_ap_inv_interface xxen_ap_upload.submit_ap_inv_import US AP Invoice Upload Creates Payables invoices through Payables Open Interface Import. Rows with the same Operating Unit, Supplier, Supplier Site and Invoice Number form one invoice, and an error on any of its rows keeps the whole invoice out of the import. To split a line across several distributions, enter it on several rows with the same Line Number and line details, each with its own Distribution Line Number, and either a Distribution Percent on every row, adding up to 100, or a Distribution Amount on every row, adding up to the Line Amount. A rounding difference goes to the largest distribution, as with distribution sets. The distributions are created after the import and before invoice validation, as the Invoices window enters them. Each row of a split line carries its own Distribution Account or its own project details. For a row with project details the Projects account generator derives the account, unless the row has a Distribution Account and profile PA: Allow Override of PA Distributions in AP/PO is Yes, as for a line that is not split. Project Quantity is the quantity of that distribution. The line keeps the project details only when all its rows share them. A line matched to a purchase order or receipt, using a Distribution Set or prorated cannot be split. The result shows one row per distribution, including the distributions Payables creates for a line from a Distribution Set or a purchase order. To add lines to an existing invoice, use the template Add Lines to Existing Invoice, which sets Add to Existing Invoice to Yes on each row; Yes is accepted only when the invoice exists. The lines are added as in the Invoices window, and Invoice Amount on these rows is the amount added to the invoice, including the tax of the added lines, the same on every row of the invoice; the result shows the invoice's new Invoice Amount. The other invoice columns identify the invoice and are not changed. The invoice must be unpaid, and its Invoice Amount changeable in the Invoices window. Item, Freight and Miscellaneous lines can be added, without a purchase order or receipt match, proration or India Localization taxes, and a Line Number already on the invoice is rejected. Enginatics Upload &error_with_query &il_columns &il_columns_reporting &il_columns_success &success_with_query :p_batch_name :p_calulate_tax_flag :p_dflt_line_amount :p_gl_date :p_operating_unit :p_source :p_submit_validation :p_tax_inclusive_flag 1 -100 &il_columns ,cast(null as varchar2(150)) section_code,cast(null as varchar2(240)) tax_category Char Y xxen_util.jai_installed US India Localization 2 &il_columns_reporting ,xm.section_code,xm.tax_category Y US India Localization 3 &il_columns_success ,xm.section_code,xm.tax_category Y US India Localization 4 -80 :p_calulate_tax_flag LOV Oracle Yes_No select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description US Calculate Tax on Import 5 -70 :p_tax_inclusive_flag LOV Oracle Yes_No select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description US Amounts Inclusive of Tax 6 10 :p_operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) US Operating Unit 7 20 :p_source LOV AP Invoice Interface Source F263DDA3FBF50F8FE0530100007F75CD select alc.lookup_code id, 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 value Y US Invoice Source 8 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 9 40 :p_gl_date Date US GL Date 10 50 :p_submit_validation LOV Oracle Yes_No select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y US Submit Invoice Validation 11 60 :p_dflt_line_amount LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Default Line Amount? Defaults Line Amount to the Invoice Amount when Line Amount is blank, for invoices with a single line. 9B7D5016BDD648B8B27D7A4612943668 Add Lines to Existing Invoice SYSADMIN 7 ADD_TO_EXISTING_INVOICE Yes 49 ASSESSABLE_VALUE 33 ASSET_BOOK 34 ASSET_CATEGORY 46 BUSINESS_CATEGORY 21 DISTRIBUTION_ACCOUNT 20 DISTRIBUTION_ACCOUNT_ALIAS 23 DISTRIBUTION_AMOUNT 19 DISTRIBUTION_LINE_NUMBER 22 DISTRIBUTION_PERCENT 24 DISTRIBUTION_SET 37 EXPENDITURE_ITEM_DATE 39 EXPENDITURE_ORGANIZATION 38 EXPENDITURE_TYPE 45 FISCAL_CLASSIFICATION 9 GL_DATE 30 INVENTORY_ITEM 10 INVOICE_AMOUNT 11 INVOICE_CURRENCY 8 INVOICE_DATE Y 6 INVOICE_NUMBER 5 INVOICE_TYPE 31 ITEM_DESCRIPTION 14 LINE_AMOUNT 15 LINE_DESCRIPTION 50 LINE_INVOICE_AWT_GROUP 12 LINE_NUMBER 51 LINE_PAYMENT_AWT_GROUP 52 LINE_REFERENCE_1 53 LINE_REFERENCE_2 13 LINE_TYPE 26 MANUFACTURER 27 MODEL_NUMBER 1 OPERATING_UNIT 42 PRIMARY_INTENDED_USE 48 PRODUCT_CATEGORY 44 PRODUCT_FISCAL_CLASSIFICATION 47 PRODUCT_TYPE 35 PROJECT 40 PROJECT_QUANTITY 16 QUANTITY 25 REQUESTER 28 SERIAL_NUMBER 43 SHIP_TO_LOCATION 2 SUPPLIER_NAME 3 SUPPLIER_NUMBER 4 SUPPLIER_SITE 36 TASK 41 TAX_CLASSIFICATION 32 TRACK_AS_ASSET 18 UNIT_PRICE 17 UOM 29 WARRANTY_NUMBER S Site D703E39AB74BAFC404CB729F5A9A6795 Default SYSADMIN 12 AMOUNT_APPLICABLE_TO_DISCOUNT 79 ASSESSABLE_VALUE 63 ASSET_BOOK 64 ASSET_CATEGORY 82 BANK_CHARGE_BEARER 76 BUSINESS_CATEGORY 51 DISTRIBUTION_ACCOUNT 50 DISTRIBUTION_ACCOUNT_ALIAS 53 DISTRIBUTION_AMOUNT 49 DISTRIBUTION_LINE_NUMBER 52 DISTRIBUTION_PERCENT 54 DISTRIBUTION_SET 15 EXCHANGE_DATE 16 EXCHANGE_RATE 14 EXCHANGE_RATE_TYPE 25 EXCLUSIVE_PAYMENT_FLAG 67 EXPENDITURE_ITEM_DATE 69 EXPENDITURE_ORGANIZATION 68 EXPENDITURE_TYPE 75 FISCAL_CLASSIFICATION 10 GL_DATE 19 GOODS_RECEIVED_DATE 31 INTERNAL_RECORDING_DATE 60 INVENTORY_ITEM 11 INVOICE_AMOUNT 13 INVOICE_CURRENCY 9 INVOICE_DATE 7 INVOICE_DESCRIPTION Y 6 INVOICE_NUMBER 8 INVOICE_PO_NUMBER 20 INVOICE_RECEIVED_DATE 88 INVOICE_REFERENCE_1 89 INVOICE_REFERENCE_2 5 INVOICE_TYPE 61 ITEM_DESCRIPTION 37 LINE_AMOUNT 45 LINE_DESCRIPTION 80 LINE_INVOICE_AWT_GROUP 35 LINE_NUMBER 81 LINE_PAYMENT_AWT_GROUP 90 LINE_REFERENCE_1 91 LINE_REFERENCE_2 36 LINE_TYPE 56 MANUFACTURER 57 MODEL_NUMBER 1 OPERATING_UNIT 24 PAYMENT_CROSS_RATE 23 PAYMENT_CROSS_RATE_DATE 22 PAYMENT_CROSS_RATE_TYPE 21 PAYMENT_CURRENCY 27 PAYMENT_DELIVERY_CHANNEL 30 PAYMENT_GROUP 26 PAYMENT_METHOD 28 PAYMENT_REASON 29 PAYMENT_REASON_COMMENTS 42 PO_DISTRIBUTION_NUM 40 PO_LINE_NUM 38 PO_NUMBER 44 PO_RECEIPT_LINE_NUM 43 PO_RECEIPT_NUM 39 PO_RELEASE_NUM 41 PO_SHIPMENT_NUM 72 PRIMARY_INTENDED_USE 78 PRODUCT_CATEGORY 74 PRODUCT_FISCAL_CLASSIFICATION 77 PRODUCT_TYPE 65 PROJECT 70 PROJECT_QUANTITY 46 QUANTITY 83 REMITTANCE_MESSAGE1 84 REMITTANCE_MESSAGE2 85 REMITTANCE_MESSAGE3 55 REQUESTER 58 SERIAL_NUMBER 73 SHIP_TO_LOCATION 2 SUPPLIER_NAME 3 SUPPLIER_NUMBER 4 SUPPLIER_SITE 34 SUPPLIER_TAX_EXCHANGE_RATE 33 SUPPLIER_TAX_INVOICE_DATE 32 SUPPLIER_TAX_INVOICE_NUMBER 66 TASK 71 TAX_CLASSIFICATION 17 TERMS 18 TERMS_DATE 62 TRACK_AS_ASSET 86 UNIQUE_REMITTANCE_IDENTIFIER 48 UNIT_PRICE 47 UOM 87 URI_CHECK_DIGIT 59 WARRANTY_NUMBER S Site AAAEE90BB54C6BE631B2B3E423980769 Default (with attachment) ENGINATICS 12 AMOUNT_APPLICABLE_TO_DISCOUNT 93 AP_INV_ATTRIBUTE1 102 AP_INV_ATTRIBUTE10 103 AP_INV_ATTRIBUTE11 104 AP_INV_ATTRIBUTE12 105 AP_INV_ATTRIBUTE13 106 AP_INV_ATTRIBUTE14 107 AP_INV_ATTRIBUTE15 94 AP_INV_ATTRIBUTE2 95 AP_INV_ATTRIBUTE3 96 AP_INV_ATTRIBUTE4 97 AP_INV_ATTRIBUTE5 98 AP_INV_ATTRIBUTE6 99 AP_INV_ATTRIBUTE7 100 AP_INV_ATTRIBUTE8 101 AP_INV_ATTRIBUTE9 125 AP_INV_DIST_ATTRIBUTE1 134 AP_INV_DIST_ATTRIBUTE10 135 AP_INV_DIST_ATTRIBUTE11 136 AP_INV_DIST_ATTRIBUTE12 137 AP_INV_DIST_ATTRIBUTE13 138 AP_INV_DIST_ATTRIBUTE14 139 AP_INV_DIST_ATTRIBUTE15 126 AP_INV_DIST_ATTRIBUTE2 127 AP_INV_DIST_ATTRIBUTE3 128 AP_INV_DIST_ATTRIBUTE4 129 AP_INV_DIST_ATTRIBUTE5 130 AP_INV_DIST_ATTRIBUTE6 131 AP_INV_DIST_ATTRIBUTE7 132 AP_INV_DIST_ATTRIBUTE8 133 AP_INV_DIST_ATTRIBUTE9 109 AP_INV_LINE_ATTRIBUTE1 118 AP_INV_LINE_ATTRIBUTE10 119 AP_INV_LINE_ATTRIBUTE11 120 AP_INV_LINE_ATTRIBUTE12 121 AP_INV_LINE_ATTRIBUTE13 122 AP_INV_LINE_ATTRIBUTE14 123 AP_INV_LINE_ATTRIBUTE15 110 AP_INV_LINE_ATTRIBUTE2 111 AP_INV_LINE_ATTRIBUTE3 112 AP_INV_LINE_ATTRIBUTE4 113 AP_INV_LINE_ATTRIBUTE5 114 AP_INV_LINE_ATTRIBUTE6 115 AP_INV_LINE_ATTRIBUTE7 116 AP_INV_LINE_ATTRIBUTE8 117 AP_INV_LINE_ATTRIBUTE9 79 ASSESSABLE_VALUE 63 ASSET_BOOK 64 ASSET_CATEGORY 140 ATTACHMENT_CATEGORY_ 144 ATTACHMENT_CONTENT_ 142 ATTACHMENT_DESCRIPTION_ 145 ATTACHMENT_FILE_ID_ 141 ATTACHMENT_TITLE_ 143 ATTACHMENT_TYPE_ 82 BANK_CHARGE_BEARER 76 BUSINESS_CATEGORY 51 DISTRIBUTION_ACCOUNT 50 DISTRIBUTION_ACCOUNT_ALIAS 53 DISTRIBUTION_AMOUNT 49 DISTRIBUTION_LINE_NUMBER 52 DISTRIBUTION_PERCENT 54 DISTRIBUTION_SET 124 DIST_ATTRIBUTE_CATEGORY 15 EXCHANGE_DATE 16 EXCHANGE_RATE 14 EXCHANGE_RATE_TYPE 25 EXCLUSIVE_PAYMENT_FLAG 67 EXPENDITURE_ITEM_DATE 69 EXPENDITURE_ORGANIZATION 68 EXPENDITURE_TYPE 75 FISCAL_CLASSIFICATION 10 GL_DATE 19 GOODS_RECEIVED_DATE 31 INTERNAL_RECORDING_DATE 60 INVENTORY_ITEM 11 INVOICE_AMOUNT 92 INVOICE_ATTRIBUTE_CATEGORY 13 INVOICE_CURRENCY 9 INVOICE_DATE 7 INVOICE_DESCRIPTION Y 6 INVOICE_NUMBER 8 INVOICE_PO_NUMBER 20 INVOICE_RECEIVED_DATE 88 INVOICE_REFERENCE_1 89 INVOICE_REFERENCE_2 5 INVOICE_TYPE 61 ITEM_DESCRIPTION 37 LINE_AMOUNT 108 LINE_ATTRIBUTE_CATEGORY 45 LINE_DESCRIPTION 80 LINE_INVOICE_AWT_GROUP 35 LINE_NUMBER 81 LINE_PAYMENT_AWT_GROUP 90 LINE_REFERENCE_1 91 LINE_REFERENCE_2 36 LINE_TYPE 56 MANUFACTURER 57 MODEL_NUMBER 1 OPERATING_UNIT 24 PAYMENT_CROSS_RATE 23 PAYMENT_CROSS_RATE_DATE 22 PAYMENT_CROSS_RATE_TYPE 21 PAYMENT_CURRENCY 27 PAYMENT_DELIVERY_CHANNEL 30 PAYMENT_GROUP 26 PAYMENT_METHOD 28 PAYMENT_REASON 29 PAYMENT_REASON_COMMENTS 42 PO_DISTRIBUTION_NUM 40 PO_LINE_NUM 38 PO_NUMBER 44 PO_RECEIPT_LINE_NUM 43 PO_RECEIPT_NUM 39 PO_RELEASE_NUM 41 PO_SHIPMENT_NUM 72 PRIMARY_INTENDED_USE 78 PRODUCT_CATEGORY 74 PRODUCT_FISCAL_CLASSIFICATION 77 PRODUCT_TYPE 65 PROJECT 70 PROJECT_QUANTITY 46 QUANTITY 83 REMITTANCE_MESSAGE1 84 REMITTANCE_MESSAGE2 85 REMITTANCE_MESSAGE3 55 REQUESTER 58 SERIAL_NUMBER 73 SHIP_TO_LOCATION 2 SUPPLIER_NAME 3 SUPPLIER_NUMBER 4 SUPPLIER_SITE 34 SUPPLIER_TAX_EXCHANGE_RATE 33 SUPPLIER_TAX_INVOICE_DATE 32 SUPPLIER_TAX_INVOICE_NUMBER 66 TASK 71 TAX_CLASSIFICATION 17 TERMS 18 TERMS_DATE 62 TRACK_AS_ASSET 86 UNIQUE_REMITTANCE_IDENTIFIER 48 UNIT_PRICE 47 UOM 87 URI_CHECK_DIGIT 59 WARRANTY_NUMBER S Site 4E2887BFD38111F4370B1D11304E87A5 Manual Tax Lines Template This template contains the Taxation Country, Tax Regime, Tax, Tax Status, Tax Jurisdication, and Tax Rate columns required for entering Manual Tax Lines SYSADMIN 12 AMOUNT_APPLICABLE_TO_DISCOUNT 98 AP_INV_ATTRIBUTE1 107 AP_INV_ATTRIBUTE10 108 AP_INV_ATTRIBUTE11 109 AP_INV_ATTRIBUTE12 110 AP_INV_ATTRIBUTE13 111 AP_INV_ATTRIBUTE14 112 AP_INV_ATTRIBUTE15 99 AP_INV_ATTRIBUTE2 100 AP_INV_ATTRIBUTE3 101 AP_INV_ATTRIBUTE4 102 AP_INV_ATTRIBUTE5 103 AP_INV_ATTRIBUTE6 104 AP_INV_ATTRIBUTE7 105 AP_INV_ATTRIBUTE8 106 AP_INV_ATTRIBUTE9 130 AP_INV_DIST_ATTRIBUTE1 139 AP_INV_DIST_ATTRIBUTE10 140 AP_INV_DIST_ATTRIBUTE11 141 AP_INV_DIST_ATTRIBUTE12 142 AP_INV_DIST_ATTRIBUTE13 143 AP_INV_DIST_ATTRIBUTE14 144 AP_INV_DIST_ATTRIBUTE15 131 AP_INV_DIST_ATTRIBUTE2 132 AP_INV_DIST_ATTRIBUTE3 133 AP_INV_DIST_ATTRIBUTE4 134 AP_INV_DIST_ATTRIBUTE5 135 AP_INV_DIST_ATTRIBUTE6 136 AP_INV_DIST_ATTRIBUTE7 137 AP_INV_DIST_ATTRIBUTE8 138 AP_INV_DIST_ATTRIBUTE9 114 AP_INV_LINE_ATTRIBUTE1 123 AP_INV_LINE_ATTRIBUTE10 124 AP_INV_LINE_ATTRIBUTE11 125 AP_INV_LINE_ATTRIBUTE12 126 AP_INV_LINE_ATTRIBUTE13 127 AP_INV_LINE_ATTRIBUTE14 128 AP_INV_LINE_ATTRIBUTE15 115 AP_INV_LINE_ATTRIBUTE2 116 AP_INV_LINE_ATTRIBUTE3 117 AP_INV_LINE_ATTRIBUTE4 118 AP_INV_LINE_ATTRIBUTE5 119 AP_INV_LINE_ATTRIBUTE6 120 AP_INV_LINE_ATTRIBUTE7 121 AP_INV_LINE_ATTRIBUTE8 122 AP_INV_LINE_ATTRIBUTE9 84 ASSESSABLE_VALUE 61 ASSET_BOOK 62 ASSET_CATEGORY 87 BANK_CHARGE_BEARER 75 BUSINESS_CATEGORY 52 DISTRIBUTION_ACCOUNT 51 DISTRIBUTION_ACCOUNT_ALIAS 53 DISTRIBUTION_SET 129 DIST_ATTRIBUTE_CATEGORY 15 EXCHANGE_DATE 16 EXCHANGE_RATE 14 EXCHANGE_RATE_TYPE 25 EXCLUSIVE_PAYMENT_FLAG 65 EXPENDITURE_ITEM_DATE 67 EXPENDITURE_ORGANIZATION 66 EXPENDITURE_TYPE 74 FISCAL_CLASSIFICATION 10 GL_DATE 19 GOODS_RECEIVED_DATE 31 INTERNAL_RECORDING_DATE 11 INVOICE_AMOUNT 97 INVOICE_ATTRIBUTE_CATEGORY 13 INVOICE_CURRENCY 9 INVOICE_DATE 7 INVOICE_DESCRIPTION Y 6 INVOICE_NUMBER 8 INVOICE_PO_NUMBER 20 INVOICE_RECEIVED_DATE 93 INVOICE_REFERENCE_1 94 INVOICE_REFERENCE_2 5 INVOICE_TYPE 59 ITEM_DESCRIPTION 37 LINE_AMOUNT 113 LINE_ATTRIBUTE_CATEGORY 47 LINE_DESCRIPTION 85 LINE_INVOICE_AWT_GROUP 35 LINE_NUMBER 86 LINE_PAYMENT_AWT_GROUP 38 LINE_PRORATE_GROUP 95 LINE_REFERENCE_1 96 LINE_REFERENCE_2 36 LINE_TYPE 55 MANUFACTURER 56 MODEL_NUMBER 1 OPERATING_UNIT 24 PAYMENT_CROSS_RATE 23 PAYMENT_CROSS_RATE_DATE 22 PAYMENT_CROSS_RATE_TYPE 21 PAYMENT_CURRENCY 27 PAYMENT_DELIVERY_CHANNEL 30 PAYMENT_GROUP 26 PAYMENT_METHOD 28 PAYMENT_REASON 29 PAYMENT_REASON_COMMENTS 44 PO_DISTRIBUTION_NUM 42 PO_LINE_NUM 40 PO_NUMBER 46 PO_RECEIPT_LINE_NUM 45 PO_RECEIPT_NUM 41 PO_RELEASE_NUM 43 PO_SHIPMENT_NUM 71 PRIMARY_INTENDED_USE 77 PRODUCT_CATEGORY 73 PRODUCT_FISCAL_CLASSIFICATION 76 PRODUCT_TYPE 63 PROJECT 68 PROJECT_QUANTITY 39 PRORATE_FLAG 48 QUANTITY 88 REMITTANCE_MESSAGE1 89 REMITTANCE_MESSAGE2 90 REMITTANCE_MESSAGE3 54 REQUESTER 57 SERIAL_NUMBER 72 SHIP_TO_LOCATION 2 SUPPLIER_NAME 3 SUPPLIER_NUMBER 4 SUPPLIER_SITE 34 SUPPLIER_TAX_EXCHANGE_RATE 33 SUPPLIER_TAX_INVOICE_DATE 32 SUPPLIER_TAX_INVOICE_NUMBER 64 TASK 79 TAX 69 TAXATION_COUNTRY 70 TAX_CLASSIFICATION 81 TAX_JURISDICTION 83 TAX_RATE 82 TAX_RATE_NAME 78 TAX_REGIME 80 TAX_STATUS 17 TERMS 18 TERMS_DATE 60 TRACK_AS_ASSET 91 UNIQUE_REMITTANCE_IDENTIFIER 50 UNIT_PRICE 49 UOM 92 URI_CHECK_DIGIT 58 WARRANTY_NUMBER S Site SYSADMIN AAAEE90BB54C6BE631B2B3E423980769 ERIC.CLEGG 9B7D5016BDD648B8B27D7A4612943668 MRUGESH.POOJARY AAAEE90BB54C6BE631B2B3E423980769 CLAUDE 9B7D5016BDD648B8B27D7A4612943668 D703E39AB74BAFC404CB729F5A9A6795 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 REQUEST_ID_ Char varchar2 Y Y 5 MODIFIED_COLUMNS_ Char varchar2 Y 6 INV_INT_ID Number number Y Y 7 LINE_INT_ID Number number Y Y 8 BATCH_NAME Char varchar2 :$flex$.batch_name Y 9 SUBMIT_VALIDATION Char varchar2 :$flex$.submit_invoice_validation Y 10 INVOICE_CALCULATE_TAX LOV Oracle varchar2 Yes_No select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description xxen_util.meaning(:$flex$.Calculate_Tax_on_Import,'YES_NO',0) Y 11 INVOICE_INCLUSIVE_OF_TAX LOV Oracle varchar2 Yes_No select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description xxen_util.meaning(:$flex$.Amounts_Inclusive_of_Tax,'YES_NO',0) Y 12 SOURCE LOV varchar2 80 AP Invoice Interface Source F263DDA3FBF50F8FE0530100007F75CD select alc.lookup_code id, 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 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.value Y Y Y 13 OPERATING_UNIT LOV varchar2 240 HR Operating Unit for Upload F263DDA3FBF60F8FE0530100007F75CD 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 xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') order by hou.name :$flex$.operating_unit Y 14 SUPPLIER_NAME LOV custom varchar2 240 select aps.vendor_id id, aps.vendor_name value, aps.segment1 description from ap_suppliers aps, hr_operating_units hou where hou.name=:$column$.operating_unit and exists(select 1 from ap_supplier_sites_all assa where assa.org_id=hou.organization_id and assa.vendor_id=aps.vendor_id) and aps.segment1 = nvl(:$column$.supplier_number,aps.segment1) and nvl(aps.end_date_active,sysdate+1) > sysdate order by value Y 15 SUPPLIER_NUMBER LOV custom varchar2 30 select aps.vendor_id id, aps.segment1 value, aps.vendor_name description from ap_suppliers aps, hr_operating_units hou where hou.name=:$column$.operating_unit and exists(select 1 from ap_supplier_sites_all assa where assa.org_id=hou.organization_id and assa.vendor_id=aps.vendor_id) and aps.vendor_name = nvl(:$column$.supplier_name,aps.vendor_name) and nvl(aps.end_date_active,sysdate+1) > sysdate order by value Y 16 SUPPLIER_SITE LOV custom varchar2 15 select assa.vendor_site_id id, assa.vendor_site_code value, assa.address_line1||', '||assa.city||', '||nvl(ftv.territory_short_name,assa.country) description from ap_supplier_sites_all assa, ap_suppliers asa, hr_operating_units hou, fnd_territories_vl ftv where assa.vendor_id=asa.vendor_id and assa.org_id=hou.organization_id and assa.country=ftv.territory_code(+) and hou.name=:$column$.operating_unit and asa.vendor_name=:$column$.supplier_name and asa.segment1=:$column$.supplier_number and nvl(assa.inactive_date,sysdate+1) > sysdate and assa.pay_site_flag = 'Y' order by value select x.vendor_site_code from ( select assa.vendor_site_code, assa.primary_pay_site_flag, count(distinct assa.vendor_site_code) over () cnt from ap_supplier_sites_all assa, ap_suppliers asa, hr_operating_units hou where assa.vendor_id=asa.vendor_id and assa.org_id=hou.organization_id and hou.name=:$column$.operating_unit and asa.vendor_name=:$column$.supplier_name and asa.segment1=:$column$.supplier_number and nvl(assa.inactive_date,sysdate+1)>sysdate and assa.pay_site_flag='Y' ) x where x.primary_pay_site_flag='Y' or x.cnt=1 Y 17 INVOICE_TYPE LOV custom varchar2 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 xxen_util.meaning('STANDARD','INVOICE TYPE',200) Y 18 DOCUMENT_CATEGORY LOV custom varchar2 80 select distinct fdsc.code id, fdsc.name value, fdsc.description from fnd_doc_sequence_categories fdsc where fdsc.application_id = 200 and fdsc.table_name in ('AP_INVOICES','AP_INVOICES_ALL') and nvl(fnd_profile.value('UNIQUE:SEQ_NUMBERS'),'M') != 'N' and (select aspa.inv_doc_category_override from hr_operating_units hou,ap_system_parameters_all aspa where hou.organization_id = aspa.org_id and hou.name = :$column$.operating_unit) = 'Y' and exists (select null from fnd_doc_sequence_assignments fdsa, hr_operating_units hou where fdsa.category_code = fdsc.code and fdsa.application_id = 200 and trunc(sysdate) between nvl(fdsa.start_date,trunc(sysdate)) and nvl(fdsa.end_date,trunc(sysdate)) and (fdsa.set_of_books_id is null or fdsa.set_of_books_id = (select to_number(hou.set_of_books_id) from hr_operating_units hou where hou.name = :$column$.operating_unit) ) ) order by value select distinct fdsc.code id, fdsc.name value from fnd_doc_sequence_categories fdsc where fdsc.application_id = 200 and fdsc.table_name in ('AP_INVOICES','AP_INVOICES_ALL') and exists (select null from fnd_doc_sequence_assignments fdsa, hr_operating_units hou where fdsa.category_code = fdsc.code and fdsa.application_id = 200 and trunc(sysdate) between nvl(fdsa.start_date,trunc(sysdate)) and nvl(fdsa.end_date,trunc(sysdate)) and (fdsa.set_of_books_id is null or fdsa.set_of_books_id = (select to_number(hou.set_of_books_id) from hr_operating_units hou where hou.name = :$column$.operating_unit) ) ) 19 INVOICE_NUMBER Char varchar2 50 Y Y 20 ADD_TO_EXISTING_INVOICE LOV custom varchar2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where exists ( select null from hr_operating_units hou, ap_invoices_all aia, ap_suppliers asu, ap_supplier_sites_all assa where hou.name=:$column$.operating_unit and hou.organization_id=aia.org_id and aia.invoice_num=:$column$.invoice_number and aia.vendor_id=asu.vendor_id and asu.segment1=:$column$.supplier_number and aia.vendor_site_id=assa.vendor_site_id and assa.vendor_site_code=:$column$.supplier_site ) Yes adds the row to the existing invoice with this Operating Unit, Supplier, Supplier Site and Invoice Number as a new line, and is offered only when that invoice exists. On these rows Invoice Amount is the amount added to the invoice, including the tax of the added lines. 21 INVOICE_DESCRIPTION Char varchar2 240 22 INVOICE_PO_NUMBER LOV custom varchar2 20 Y select phav.po_header_id id, phav.po_number value, phav.po_type description from hr_all_organization_units_vl haouv, ap_suppliers aps, po_headers_ap_v phav where phav.vendor_id = aps.vendor_id and phav.org_id = haouv.organization_id and haouv.name = :$column$.operating_unit and aps.segment1 = :$column$.supplier_number and phav.approved_flag = 'Y' and nvl(phav.closed_code, 'X') <> 'FINALLY CLOSED' order by upper(value) 23 INVOICE_DATE Date date Y 24 GL_DATE Date date :$flex$.gl_date 25 INVOICE_AMOUNT Number number The invoice total, including tax. On rows with Add to Existing Invoice Yes, the amount added to the invoice, including the tax of the added lines. Y 26 AMOUNT_APPLICABLE_TO_DISCOUNT Number number 27 INVOICE_CURRENCY LOV varchar2 15 FND Currency 8E2FF36EDE9079D2E0530100007F1FF2 select fcv.currency_code id, fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' order by fcv.currency_code Y 28 EXCHANGE_RATE_TYPE LOV varchar2 30 GL Currency Conversion Type 91D3167A335F1204E053BB6B63585EE3 select gdct.conversion_type id, gdct.user_conversion_type value, gdct.description from gl_daily_conversion_types gdct order by gdct.user_conversion_type select gdct.conversion_type id, gdct.user_conversion_type value from gl_daily_conversion_types gdct 29 EXCHANGE_DATE Date date 30 EXCHANGE_RATE Number number 31 TERMS LOV varchar2 50 AP Payment Terms 0185D467AD6954E0E0630100007F5847 select atv.term_id id, atv.name value, atv.description from ap_terms_vl atv where atv.enabled_flag = 'Y' and trunc(sysdate) between nvl(atv.start_date_active,trunc(sysdate)) and nvl(atv.end_date_active,trunc(sysdate)) order by value 32 TERMS_DATE Date date 33 GOODS_RECEIVED_DATE Date date 34 INVOICE_RECEIVED_DATE Date date 35 LIABILITY_ACCOUNT LOV custom varchar2 311 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, gl_ledgers gl, gl_code_combinations_kfv gcck, fnd_lookup_values_vl flvv where hou.name=:$column$.operating_unit and gl.ledger_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 gcck.detail_posting_allowed = 'Y' and gcck.gl_account_type = 'L' 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 36 EXCLUSIVE_PAYMENT_FLAG LOV Oracle varchar2 Yes_No select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 37 PAYMENT_CURRENCY LOV varchar2 15 FND Currency 8E2FF36EDE9079D2E0530100007F1FF2 select fcv.currency_code id, fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' order by fcv.currency_code 38 PAYMENT_CROSS_RATE_TYPE LOV varchar2 30 GL Currency Conversion Type 91D3167A335F1204E053BB6B63585EE3 select gdct.conversion_type id, gdct.user_conversion_type value, gdct.description from gl_daily_conversion_types gdct order by gdct.user_conversion_type select gdct.conversion_type id, gdct.user_conversion_type value from gl_daily_conversion_types gdct 39 PAYMENT_CROSS_RATE_DATE Date date 40 PAYMENT_CROSS_RATE Number number 41 PAYMENT_METHOD LOV custom varchar2 100 select x.value, x.description from ( select ipmv.payment_method_name value, ipmv.description from iby_applicable_pmt_mthds iapm, iby_payment_methods_vl ipmv where iapm.payment_flow = 'DISBURSEMENTS' and iapm.applicable_type_code = 'PAYEE' and iapm.applicable_value_to is null and (iapm.application_id is null or iapm.application_id = 200 ) and (ipmv.inactive_date is null or ipmv.inactive_date >= trunc(sysdate)) and (iapm.inactive_date is null or iapm.inactive_date >= trunc(sysdate)) and iapm.payment_method_code = ipmv.payment_method_code and not exists (select 1 from hr_all_organization_units_vl haouv, ap_suppliers asu, ap_supplier_sites_all assa, iby_ext_party_pmt_mthds ieppm, iby_external_payees_all iepa where haouv.name = :$column$.operating_unit and asu.segment1 = :$column$.supplier_number and assa.vendor_id = asu.vendor_id and assa.org_id = haouv.organization_id and assa.vendor_site_code = :$column$.supplier_site and ieppm.payment_flow = 'DISBURSEMENTS' and ieppm.payment_method_code = iapm.payment_method_code and ieppm.payment_function = 'PAYABLES_DISB' and ieppm.inactive_date < trunc(sysdate) and ieppm.ext_pmt_party_id = iepa.ext_payee_id and iepa.payee_party_id = asu.party_id and (iepa.party_site_id is null or iepa.party_site_id = assa.party_site_id ) and (iepa.supplier_site_id is null or iepa.supplier_site_id = assa.vendor_site_id ) and (iepa.org_id is null or (iepa.org_id = haouv.organization_id and iepa.org_type = 'OPERATING_UNIT' ))) union select ipmv.payment_method_name value, ipmv.description from hr_all_organization_units_vl haouv, ap_suppliers asu, ap_supplier_sites_all assa, iby_ext_party_pmt_mthds ieppm, iby_external_payees_all iepa, iby_payment_methods_vl ipmv where haouv.name = :$column$.operating_unit and asu.segment1 = :$column$.supplier_number and assa.vendor_id = asu.vendor_id and assa.org_id = haouv.organization_id and assa.vendor_site_code = :$column$.supplier_site and ieppm.payment_flow = 'DISBURSEMENTS' and ieppm.payment_function = 'PAYABLES_DISB' and (ipmv.inactive_date is null or ipmv.inactive_date >= trunc(sysdate)) and (ieppm.inactive_date is null or ieppm.inactive_date >= trunc(sysdate)) and ieppm.payment_method_code = ipmv.payment_method_code and ieppm.ext_pmt_party_id = iepa.ext_payee_id and iepa.payee_party_id = asu.party_id and (iepa.party_site_id is null or iepa.party_site_id = assa.party_site_id ) and (iepa.supplier_site_id is null or iepa.supplier_site_id = assa.vendor_site_id ) and (iepa.org_id is null or (iepa.org_id = haouv.organization_id and iepa.org_type = 'OPERATING_UNIT' )) ) x order by value select ipmv.payment_method_code id, ipmv.payment_method_name value from iby_payment_methods_vl ipmv 42 PAYMENT_DELIVERY_CHANNEL LOV custom varchar2 80 select idcv.delivery_channel_code id, idcv.meaning value, nvl2(idcv.territory_code ,'(' || ftv.territory_short_name || ') ',null) || idcv.description description from iby_delivery_channels_vl idcv, fnd_territories_vl ftv where idcv.territory_code = ftv.territory_code (+) and trunc(sysdate) <= nvl(idcv.inactive_date,trunc(sysdate)) order by value select idcv.delivery_channel_code id, idcv.meaning value from iby_delivery_channels_vl idcv 43 PAYMENT_REASON LOV custom varchar2 80 select iprv.payment_reason_code id, iprv.meaning value, nvl2(iprv.territory_code ,'(' || ftv.territory_short_name || ') ',null) || iprv.description description from iby_payment_reasons_vl iprv, fnd_territories_vl ftv where iprv.territory_code = ftv.territory_code (+) and trunc(sysdate) <= nvl(iprv.inactive_date,trunc(sysdate)) select iprv.payment_reason_code id, iprv.meaning value from iby_payment_reasons_vl iprv 44 PAYMENT_REASON_COMMENTS Char varchar2 240 45 PAYMENT_GROUP LOV varchar2 80 AP Pay Group 018601843944DE4DE0630100007FF0CF 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.security_group_id=0 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 flvv.lookup_code 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 46 INVOICE_AWT_GROUP LOV custom varchar2 25 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 47 PAYMENT_AWT_GROUP LOV custom varchar2 25 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 48 INTERNAL_RECORDING_DATE Date date 49 SUPPLIER_TAX_INVOICE_NUMBER Char varchar2 150 50 SUPPLIER_TAX_INVOICE_DATE Date date 51 SUPPLIER_TAX_EXCHANGE_RATE Number number 52 LINE_NUMBER Number number Y 53 LINE_TYPE LOV varchar2 AP Invoice Line Type 4437263B252D4587ADC3844EB7E04D72 select flvv.lookup_code id, flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type = 'INVOICE LINE 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 LINE TYPE' and flvv.view_application_id = 200 xxen_util.meaning('ITEM','INVOICE LINE TYPE',200) Y 54 LINE_AMOUNT Number number decode(:$flex$.Default_Line_Amount,'Y',:$column$.invoice_amount) Y 55 LINE_DESCRIPTION Char varchar2 240 select pltv.item_description from hr_all_organization_units_vl haouv, ap_suppliers aps, po_headers_ap_v phav, po_lines_trx_v pltv where phav.vendor_id = aps.vendor_id and phav.org_id = haouv.organization_id and phav.po_header_id = pltv.po_header_id and haouv.name = :$column$.operating_unit and aps.segment1 = :$column$.supplier_number and phav.po_number = :$column$.po_number and nvl(pltv.line_num_display,to_char(pltv.line_num)) = :$column$.po_line_num 56 QUANTITY Number number 57 UOM LOV custom varchar2 25 select uom_code id, unit_of_measure value, unit_of_measure_tl description from mtl_units_of_measure_vl muomv where nvl(muomv.disable_date, sysdate+1) > sysdate order by value select distinct pltv.unit_meas_lookup_code from hr_all_organization_units_vl haouv, ap_suppliers aps, po_headers_ap_v phav, po_lines_trx_v pltv, po_line_locations pll, financials_system_parameters fsp, mtl_system_items_b_kfv msibk where phav.vendor_id=aps.vendor_id and phav.org_id=haouv.organization_id and phav.po_header_id=pltv.po_header_id and pltv.po_line_id=pll.po_line_id and pltv.org_id=fsp.org_id and pltv.item_id=msibk.inventory_item_id(+) and fsp.inventory_organization_id=msibk.organization_id(+) and haouv.name=:$column$.operating_unit and aps.segment1=:$column$.supplier_number and phav.po_number=:$column$.po_number and nvl(pltv.line_num_display,to_char(pltv.line_num))=:$column$.po_line_num 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(pltv.closed_code,'X')<>'FINALLY CLOSED' and ( xxen_util.lookup_code(:$column$.invoice_type,'INVOICE TYPE',200)<>'PREPAYMENT' and exists (select null from po_line_locations pll1 where pll1.po_line_id=pltv.po_line_id and pll1.shipment_type<>'PREPAYMENT') or xxen_util.lookup_code(:$column$.invoice_type,'INVOICE TYPE',200)='PREPAYMENT' and ( exists (select null from po_line_locations pll2 where pll2.po_line_id=pltv.po_line_id and pll2.payment_type is not null and pll2.shipment_type='PREPAYMENT') or exists (select null from po_line_locations pll3 where pll3.po_line_id=pltv.po_line_id and pll3.payment_type is null) ) ) 58 UNIT_PRICE Number number 59 LINE_PRORATE_GROUP Number number 60 PRORATE_FLAG LOV custom varchar2 select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' and :$column$.line_type != xxen_util.meaning('ITEM','INVOICE LINE TYPE',200) order by value,description select lookup_code id, meaning value from fnd_lookups where fnd_lookups.lookup_type='YES_NO' select xxen_util.meaning('Y','YES_NO',0) from dual where :$column$.line_prorate_group is not null and :$column$.line_type != xxen_util.meaning('ITEM','INVOICE LINE TYPE',200) 61 DISTRIBUTION_LINE_NUMBER Number number 1 Number of this distribution within its invoice line. Rows with the same invoice and Line Number are the distributions of one line, each with its own Distribution Line Number. A line with a single distribution keeps 1. 62 DISTRIBUTION_ACCOUNT_ALIAS LOV custom varchar2 30 select fsfa.alias_name id, fsfa.alias_name value, fsfa.concatenated_segments || ' (' || flvv.description || ')' description from hr_operating_units hou, gl_ledgers gl, fnd_shorthand_flex_aliases fsfa, gl_code_combinations_kfv gcck, fnd_lookup_values_vl flvv where hou.name=:$column$.operating_unit and gl.ledger_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 63 DISTRIBUTION_ACCOUNT LOV custom varchar2 311 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, gl_ledgers gl, gl_code_combinations_kfv gcck, fnd_lookup_values_vl flvv where hou.name=:$column$.operating_unit and gl.ledger_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 gcck.detail_posting_allowed = 'Y' 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, gl_ledgers gl, fnd_shorthand_flex_aliases fsfa where hou.name=:$column$.operating_unit and gl.ledger_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 64 DISTRIBUTION_PERCENT Number number Percentage of the Line Amount charged to this distribution. The percentages of a line add up to 100, and a rounding difference goes to the largest distribution. Takes precedence over the Distribution Amount. 65 DISTRIBUTION_AMOUNT Number number Part of the Line Amount charged to this distribution, when no Distribution Percent is entered. The amounts of a line add up to the Line Amount. 66 DISTRIBUTION_SET LOV custom varchar2 50 select ads.distribution_set_id id, ads.distribution_set_name value, ads.description from hr_all_organization_units_vl haouv, ap_distribution_sets 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) 67 REQUESTER LOV custom varchar2 273 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 68 PO_NUMBER LOV custom varchar2 20 select phav.po_header_id id, phav.po_number value, phav.po_type description from hr_all_organization_units_vl haouv, ap_suppliers aps, po_headers_ap_v phav where phav.po_number = nvl(:$column$.invoice_po_number,phav.po_number) and phav.vendor_id = aps.vendor_id and phav.org_id = haouv.organization_id and haouv.name = :$column$.operating_unit and aps.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) 69 PO_RELEASE_NUM LOV custom number select pra.po_release_id id, pra.release_num value, null description from hr_all_organization_units_vl haouv, ap_suppliers aps, po_headers_ap_v phav, po_releases_all pra where phav.vendor_id = aps.vendor_id and phav.org_id = haouv.organization_id and phav.po_header_id = pra.po_header_id and haouv.name = :$column$.operating_unit and aps.segment1 = :$column$.supplier_number and phav.po_number = :$column$.po_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) 70 PO_LINE_NUM LOV custom number select pltv.po_line_id id, nvl(pltv.line_num_display,to_char(pltv.line_num)) value, pltv.item_description||nvl2(pltv.item_id,' ('||msibk.concatenated_segments||')',null)||' - Qty: '||pltv.quantity||' '||pltv.unit_meas_lookup_code||' Unit Price: '||pltv.unit_price || ' Unbilled Qty: '|| sum(decode(pll.shipment_type, 'STANDARD', decode(pll.matching_basis,'QUANTITY', decode(sign(pll.quantity-nvl(pll.quantity_billed,0)-nvl(pll.quantity_cancelled,0)), 1, (pll.quantity-nvl(pll.quantity_billed,0)-nvl(pll.quantity_cancelled,0)), 0)), 'PREPAYMENT', decode(pll.matching_basis,'QUANTITY', decode(sign(pll.quantity-nvl(pll.quantity_financed,0)-nvl(pll.quantity_cancelled,0)), 1, (pll.quantity-nvl(pll.quantity_financed,0)-nvl(pll.quantity_cancelled,0)), 0)) ))|| ' Unbilled Amount: '|| sum(decode(pll.shipment_type, 'STANDARD', decode(pll.matching_basis,'AMOUNT', decode(sign(pll.amount-nvl(pll.amount_billed,0)-nvl(pll.amount_cancelled,0)), 1, (pll.amount-nvl(pll.amount_billed,0)-nvl(pll.amount_cancelled,0)), 0)), 'PREPAYMENT', decode(pll.matching_basis,'AMOUNT', decode(sign(pll.amount-nvl(pll.amount_financed,0)-nvl(pll.amount_cancelled,0)), 1, (pll.amount-nvl(pll.amount_financed,0)-nvl(pll.amount_cancelled,0)), 0)) )) description from hr_all_organization_units_vl haouv, ap_suppliers aps, po_headers_ap_v phav, po_lines_trx_v pltv, po_line_locations pll, financials_system_parameters fsp, mtl_system_items_b_kfv msibk where phav.vendor_id=aps.vendor_id and phav.org_id=haouv.organization_id and phav.po_header_id=pltv.po_header_id and pltv.po_line_id=pll.po_line_id and pltv.org_id=fsp.org_id and pltv.item_id=msibk.inventory_item_id(+) and fsp.inventory_organization_id=msibk.organization_id(+) and haouv.name=:$column$.operating_unit and aps.segment1=:$column$.supplier_number and phav.po_number=:$column$.po_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(pltv.closed_code,'X')<>'FINALLY CLOSED' and ( xxen_util.lookup_code(:$column$.invoice_type,'INVOICE TYPE',200)<>'PREPAYMENT' and exists (select null from po_line_locations pll1 where pll1.po_line_id=pltv.po_line_id and pll1.shipment_type<>'PREPAYMENT') or xxen_util.lookup_code(:$column$.invoice_type,'INVOICE TYPE',200)='PREPAYMENT' and ( exists (select null from po_line_locations pll2 where pll2.po_line_id=pltv.po_line_id and pll2.payment_type is not null and pll2.shipment_type='PREPAYMENT') or exists (select null from po_line_locations pll3 where pll3.po_line_id=pltv.po_line_id and pll3.payment_type is null) ) ) group by pltv.po_line_id, nvl(pltv.line_num_display,to_char(pltv.line_num)), pltv.item_description, nvl2(pltv.item_id,' ('||msibk.concatenated_segments||')',null), pltv.quantity, pltv.unit_meas_lookup_code, pltv.unit_price order by value 71 PO_SHIPMENT_NUM LOV custom number select pll.line_location_id id, pll.shipment_num value, pll.description || ' - Qty: ' || pll.quantity || ' ' || pll.unit_meas_lookup_code || ' Unit Price: ' || nvl(pll.price_override,pltv.unit_price) || ' Unbilled Qty: ' || decode(pll.shipment_type, 'STANDARD', decode(pll.matching_basis, 'QUANTITY', (pll.quantity - nvl(pll.quantity_billed, 0) - nvl(pll.quantity_cancelled, 0)), NULL), 'PREPAYMENT', decode(pll.matching_basis, 'QUANTITY', (pll.quantity - nvl(pll.quantity_financed, 0) - nvl(pll.quantity_cancelled, 0)), NULL) ) || ' Unbilled Amount: ' || decode(pll.shipment_type, 'STANDARD', decode(pll.matching_basis, 'AMOUNT', (pll.amount - nvl(pll.amount_billed, 0) - nvl(pll.amount_cancelled, 0)), NULL), 'PREPAYMENT', decode(pll.matching_basis, 'AMOUNT', (pll.amount - nvl(pll.amount_financed, 0) - nvl(pll.amount_cancelled, 0)), NULL) ) description from hr_all_organization_units_vl haouv, ap_suppliers aps, po_headers_ap_v phav, po_lines_trx_v pltv, po_line_locations pll where phav.vendor_id = aps.vendor_id and phav.org_id = haouv.organization_id and phav.po_header_id = pltv.po_header_id and pltv.po_header_id = pll.po_header_id and pltv.po_line_id = pll.po_line_id and haouv.name = :$column$.operating_unit and aps.segment1 = :$column$.supplier_number and phav.po_number = :$column$.po_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 nvl(pltv.line_num_display,to_char(pltv.line_num)) = :$column$.po_line_num and nvl(pll.closed_code, 'X') <> 'FINALLY CLOSED' and ( (xxen_util.lookup_code(:$column$.invoice_type,'INVOICE TYPE',200) <> 'PREPAYMENT' and pll.shipment_type <> 'PREPAYMENT') or (xxen_util.lookup_code(:$column$.invoice_type,'INVOICE TYPE',200) = 'PREPAYMENT' and ((pll.payment_type is not null and pll.shipment_type = 'PREPAYMENT') or (pll.payment_type is null))) ) order by value 72 PO_DISTRIBUTION_NUM LOV custom number select pod.po_distribution_id id, pod.distribution_num value, hl.location_code || ' - Qty: ' || pod.quantity_ordered || ' Unbilled Qty: ' || decode(pod.distribution_type,'PREPAYMENT', decode(pllav.matching_basis, 'QUANTITY', decode(sign(pod.quantity_ordered - nvl(pod.quantity_cancelled,0) - nvl(pod.quantity_financed,0)) ,1,(pod.quantity_ordered-nvl(pod.quantity_cancelled,0)- nvl(pod.quantity_financed,0)),0)) , decode(pllav.matching_basis, 'QUANTITY', decode(sign(pod.quantity_ordered - nvl(pod.quantity_cancelled,0) - nvl(pod.quantity_billed,0)) ,1,(pod.quantity_ordered - nvl(pod.quantity_cancelled,0) - nvl(pod.quantity_billed,0)),0)) ) || ' Unbilled Amount: ' || decode(pod.distribution_type,'PREPAYMENT', decode(pllav.matching_basis, 'AMOUNT', decode(sign(pod.amount_ordered - nvl(pod.amount_cancelled,0) - nvl(pod.amount_financed,0)) ,1, (pod.amount_ordered - nvl(pod.amount_cancelled,0) - nvl(pod.amount_financed,0)),0)) , decode(pllav.matching_basis, 'AMOUNT', decode(sign(pod.amount_ordered - nvl(pod.amount_cancelled,0) - nvl(pod.amount_billed,0)) ,1, (pod.amount_ordered - nvl(pod.amount_cancelled,0) - nvl(pod.amount_billed,0)),0)) ) description from hr_all_organization_units_vl haouv, ap_suppliers aps, po_headers_ap_v phav, po_lines_trx_v pltv, po_line_locations_ap_v pllav, po_distributions pod, hr_locations hl where phav.vendor_id = aps.vendor_id and phav.org_id = haouv.organization_id and phav.po_header_id = pltv.po_header_id and pltv.po_header_id = pllav.po_header_id and pltv.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 phav.vendor_id = aps.vendor_id and phav.org_id = haouv.organization_id and phav.po_header_id = pltv.po_header_id and pltv.po_header_id = pllav.po_header_id and pltv.po_line_id = pllav.po_line_id and haouv.name = :$column$.operating_unit and aps.segment1 = :$column$.supplier_number and phav.po_number = :$column$.po_number and phav.currency_code = :$column$.invoice_currency and nvl(pltv.line_num_display,to_char(pltv.line_num)) = :$column$.po_line_num and pllav.shipment_num = :$column$.po_shipment_num order by value 73 PO_RECEIPT_NUM LOV custom varchar2 30 select rsh.shipment_header_id id, rsh.receipt_num value, null description from hr_all_organization_units_vl haouv, ap_suppliers aps, po_headers_ap_v phav, po_lines_trx_v pltv, po_line_locations pll, rcv_shipment_headers rsh where phav.vendor_id = aps.vendor_id and phav.org_id = haouv.organization_id and phav.po_header_id = pltv.po_header_id and pltv.po_header_id = pll.po_header_id and pltv.po_line_id = pll.po_line_id and pll.match_option = 'R' and nvl(pll.consigned_flag, 'N') <> 'Y' and aps.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 haouv.name = :$column$.operating_unit and aps.segment1 = :$column$.supplier_number and phav.po_number = :$column$.po_number and phav.currency_code = :$column$.invoice_currency and nvl(pltv.line_num_display,to_char(pltv.line_num)) = :$column$.po_line_num and pll.shipment_num = :$column$.po_shipment_num order by value 74 PO_RECEIPT_LINE_NUM LOV custom number select parmv.rcv_transaction_id id, parmv.rcv_shipment_line_number value, 'Unbilled Qty: ' || decode(parmv.matching_basis_lookup_code, 'QUANTITY', decode(sign(parmv.rcv_transaction_quantity - nvl(parmv.quantity_billed,0)),1,(parmv.rcv_transaction_quantity - nvl(parmv.quantity_billed,0)),0) ) || ' Unbilled Amount: ' || decode(parmv.matching_basis_lookup_code, 'AMOUNT', decode(sign(parmv.rcv_transaction_amount - nvl(parmv.amount_billed,0)),1, (parmv.rcv_transaction_amount - nvl(parmv.amount_billed,0)),0) ) description from hr_all_organization_units_vl haouv, ap_suppliers aps, po_headers_ap_v phav, po_lines_trx_v pltv, po_line_locations_ap_v pll, po_ap_receipt_match_v parmv where phav.vendor_id = aps.vendor_id and phav.org_id = haouv.organization_id and phav.po_header_id = pltv.po_header_id and pltv.po_header_id = pll.po_header_id and pltv.po_line_id = pll.po_line_id and aps.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 haouv.name = :$column$.operating_unit and aps.segment1 = :$column$.supplier_number and phav.po_number = :$column$.po_number and phav.currency_code = :$column$.invoice_currency and nvl(pltv.line_num_display,to_char(pltv.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 75 INVENTORY_ITEM LOV custom varchar2 40 select msiv.inventory_item_id id, msiv.concatenated_segments value, msiv.description from hr_all_organization_units_vl haouv, financials_system_parameters fsp, mtl_system_items_vl msiv where haouv.name=:$column$.operating_unit and fsp.org_id=haouv.organization_id and msiv.organization_id=fsp.inventory_organization_id order by value select distinct msibk.concatenated_segments from hr_all_organization_units_vl haouv, ap_suppliers aps, po_headers_ap_v phav, po_lines_trx_v pltv, po_line_locations pll, financials_system_parameters fsp, mtl_system_items_b_kfv msibk where phav.vendor_id=aps.vendor_id and phav.org_id=haouv.organization_id and phav.po_header_id=pltv.po_header_id and pltv.po_line_id=pll.po_line_id and pltv.org_id=fsp.org_id and pltv.item_id=msibk.inventory_item_id(+) and fsp.inventory_organization_id=msibk.organization_id(+) and haouv.name=:$column$.operating_unit and aps.segment1=:$column$.supplier_number and phav.po_number=:$column$.po_number and nvl(pltv.line_num_display,to_char(pltv.line_num))=:$column$.po_line_num 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(pltv.closed_code,'X')<>'FINALLY CLOSED' and ( xxen_util.lookup_code(:$column$.invoice_type,'INVOICE TYPE',200)<>'PREPAYMENT' and exists (select null from po_line_locations pll1 where pll1.po_line_id=pltv.po_line_id and pll1.shipment_type<>'PREPAYMENT') or xxen_util.lookup_code(:$column$.invoice_type,'INVOICE TYPE',200)='PREPAYMENT' and ( exists (select null from po_line_locations pll2 where pll2.po_line_id=pltv.po_line_id and pll2.payment_type is not null and pll2.shipment_type='PREPAYMENT') or exists (select null from po_line_locations pll3 where pll3.po_line_id=pltv.po_line_id and pll3.payment_type is null) ) ) 76 ITEM_DESCRIPTION LOV custom varchar2 240 Y select msiv.description value, msiv.concatenated_segments description from hr_all_organization_units_vl haouv, financials_system_parameters fsp, mtl_system_items_vl msiv where haouv.name=:$column$.operating_unit and fsp.org_id=haouv.organization_id and msiv.organization_id=fsp.inventory_organization_id and msiv.concatenated_segments=:$column$.inventory_item order by value select msiv.description from hr_all_organization_units_vl haouv, financials_system_parameters fsp, mtl_system_items_vl msiv where haouv.name=:$column$.operating_unit and fsp.org_id=haouv.organization_id and msiv.organization_id=fsp.inventory_organization_id and msiv.concatenated_segments=:$column$.inventory_item 77 MANUFACTURER Char varchar2 30 78 MODEL_NUMBER Char varchar2 40 79 SERIAL_NUMBER Char varchar2 35 80 WARRANTY_NUMBER Char varchar2 15 81 TRACK_AS_ASSET LOV Oracle varchar2 Yes_No select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 82 ASSET_BOOK LOV custom varchar2 30 select fbc.book_type_code id, fbc.book_type_name value, null description from hr_operating_units hou, fa_book_controls fbc where xxen_util.lookup_code(:$column$.track_as_asset,'YES_NO',0) = 'Y' and hou.name = :$column$.operating_unit and to_number(hou.set_of_books_id) = fbc.set_of_books_id and fbc.book_class = 'CORPORATE' and fbc.date_ineffective is null order by value select fbc.book_type_code id, fbc.book_type_name value from hr_operating_units hou, fa_book_controls fbc where xxen_util.lookup_code(:$column$.track_as_asset,'YES_NO',0) = 'Y' and hou.name = :$column$.operating_unit and to_number(hou.set_of_books_id) = fbc.set_of_books_id and fbc.book_class = 'CORPORATE' and fbc.date_ineffective is null 83 ASSET_CATEGORY LOV custom varchar2 61 select fck.category_id id, fck.concatenated_segments value, null description from fa_categories_b_kfv fck where xxen_util.lookup_code(:$column$.track_as_asset,'YES_NO',0) = 'Y' and fck.enabled_flag = 'Y' and trunc(sysdate) between nvl(fck.start_date_active,trunc(sysdate)) and nvl(fck.end_date_active,trunc(sysdate)) and fck.date_ineffective is null order by value select fck.category_id id, fck.concatenated_segments value from fa_categories_b_kfv fck where xxen_util.lookup_code(:$column$.track_as_asset,'YES_NO',0) = 'Y' and fck.enabled_flag = 'Y' and trunc(sysdate) between nvl(fck.start_date_active,trunc(sysdate)) and nvl(fck.end_date_active,trunc(sysdate)) and fck.date_ineffective is null 84 PROJECT LOV varchar2 25 PO Project DEC9ED99A17F5BE8E0530100007FC601 select ppev.project_id id, ppev.project_number value, ppev.project_name description from pa_projects_expend_v ppev select project_id id, project_number value from pa_projects_expend_v ppev 85 TASK LOV custom varchar2 25 select ptev.task_id id, ptev.task_number value, ptev.task_name description from pa_projects_expend_v ppev, pa_tasks_expend_v ptev where ppev.project_id = ptev.project_id and ppev.project_number = :$column$.project order by ptev.wbs_sort_order select ptev.task_id id, task_number value from pa_projects_expend_v ppev, pa_tasks_expend_v ptev where ppev.project_id = ptev.project_id and ppev.project_number = :$column$.project 86 EXPENDITURE_ITEM_DATE Date date 87 EXPENDITURE_TYPE LOV custom varchar2 30 select petev.expenditure_type value, petev.description from pa_expenditure_types_expend_v petev where petev.system_linkage_function = decode(xxen_util.lookup_code(:$column$.invoice_type,'INVOICE TYPE',200),'EXPENSE REPORT','ER','VI') and :$column$.expenditure_item_date between petev.expnd_typ_start_date_active and nvl(petev.expnd_typ_end_date_active,:$column$.expenditure_item_date) and (sysdate between petev.sys_link_start_date_active and nvl(petev.sys_link_end_date_active,sysdate)) order by value 88 EXPENDITURE_ORGANIZATION LOV custom varchar2 240 select distinct poev.organization_id id, poev.name value, null description from pa_organizations_expend_v poev where poev.active_flag = 'Y' and :$column$.expenditure_item_date between trunc(poev.date_from) and nvl(trunc(poev.date_to),:$column$.expenditure_item_date) order by value select poev.organization_id id, poev.name value from pa_organizations_expend_v poev where poev.active_flag = 'Y' 89 PROJECT_QUANTITY Number number 90 INCOME_TAX_TYPE LOV varchar2 10 AP Income Tax Type 01A59711F8BC909DE0630100007FABDA select att.income_tax_type value, att.description from ap_income_tax_types att where (att.inactive_date is null or att.inactive_date > sysdate) order by value 91 INCOME_TAX_REGION LOV custom varchar2 10 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) 92 TAXATION_COUNTRY LOV custom varchar2 80 select ftt.territory_code id, ftt.territory_short_name value, ftt.description from fnd_territories_tl ftt where ftt.language = userenv('LANG') order by value select ftt.territory_code id, ftt.territory_short_name value from fnd_territories_tl ftt where ftt.language = userenv('LANG') select distinct ftt.territory_short_name from hr_operating_units hou, xle_entity_profiles xep, xle_registrations xr, hr_locations_all hla, fnd_territories_tl ftt where hou.name = :$column$.operating_unit and xep.legal_entity_id = to_number(hou.default_legal_context_id) and xep.legal_entity_id = xr.source_id and xr.source_table = 'XLE_ENTITY_PROFILES' and xr.identifying_flag = 'Y' and trunc(sysdate) between nvl(xr.effective_from,trunc(sysdate)) and nvl(xr.effective_to,trunc(sysdate)) and xr.location_id = hla.location_id and hla.country = ftt.territory_code and ftt.language = userenv('LANG') 93 TAX_CLASSIFICATION LOV custom varchar2 240 select distinct zicv.lookup_code value, zicv.description from hr_all_organization_units_vl haouv, zx_input_classifications_v zicv where haouv.name = :$column$.operating_unit and zicv.lookup_type = 'ZX_INPUT_CLASSIFICATIONS' AND (zicv.org_id = haouv.organization_id or zicv.org_id = -99) and zicv.enabled_flag = 'Y' AND trunc(sysdate) between nvl(zicv.start_date_active,trunc(sysdate)) and nvl(zicv.end_date_active, trunc(sysdate)) order by value 94 PRIMARY_INTENDED_USE LOV custom varchar2 240 select zfiuv.classification_name value, zfiuv.country_code description from fnd_territories_tl ftt, zx_fc_intended_use_v zfiuv where ftt.territory_short_name = :$column$.taxation_country and ftt.language = userenv('LANG') and (zfiuv.country_code = ftt.territory_code or zfiuv.country_code is null) and trunc(sysdate) between nvl(zfiuv.effective_from,trunc(sysdate)) and nvl(zfiuv.effective_to,trunc(sysdate)) and trunc(sysdate) <= nvl(zfiuv.disable_date,trunc(sysdate)) order by value select zfiuv.classification_code id, zfiuv.classification_name value from hr_operating_units hou, xle_entity_profiles xep, xle_registrations xr, hr_locations_all hla, zx_fc_intended_use_v zfiuv where hou.name = :$column$.operating_unit and xep.legal_entity_id = to_number(hou.default_legal_context_id) and xep.legal_entity_id = xr.source_id and xr.source_table = 'XLE_ENTITY_PROFILES' and xr.identifying_flag = 'Y' and trunc(sysdate) between nvl(xr.effective_from,trunc(sysdate)) and nvl(xr.effective_to, trunc(sysdate)) and xr.location_id = hla.location_id and (zfiuv.country_code = hla.country or zfiuv.country_code is null) and trunc(sysdate) between nvl(zfiuv.effective_from,trunc(sysdate)) and nvl(zfiuv.effective_to,trunc(sysdate)) and trunc(sysdate) <= nvl(zfiuv.disable_date,trunc(sysdate)) 95 SHIP_TO_LOCATION LOV custom varchar2 60 select hlat.location_code value, hlat.description from hr_operating_units hou, hr_locations_all hla, hr_locations_all_tl hlat where hou.name = :$column$.operating_unit and sysdate < nvl(hla.inactive_date, sysdate+1) and hla.location_id = hlat.location_id and hlat.language = userenv('LANG') and (nvl(hla.business_group_id, nvl(hr_general.get_business_group_id,-99)) = nvl(hr_general.get_business_group_id, -99)) and hla.ship_to_site_flag = 'Y' and (hla.inventory_organization_id in (select ood.organization_id from org_organization_definitions ood, financials_system_params_all fspa where ood.set_of_books_id = fspa.set_of_books_id and fspa.org_id = hou.organization_id ) or hla.inventory_organization_id is null ) order by value select hlat.location_id id, hlat.location_code value from hr_locations_all hla, hr_locations_all_tl hlat where sysdate < nvl(hla.inactive_date, sysdate+1) and hla.location_id = hlat.location_id and hlat.language = userenv('LANG') and (nvl(hla.business_group_id, nvl(hr_general.get_business_group_id,-99)) = nvl(hr_general.get_business_group_id, -99)) and hla.ship_to_site_flag = 'Y' and (hla.inventory_organization_id in (select mp.organization_id from hr_operating_units hou, mtl_parameters mp, hr_organization_information hoi where mp.organization_id = hoi.organization_id and hoi.org_information_context='Accounting Information' and hoi.org_information1 = hou.set_of_books_id and hou.name = :$column$.operating_unit ) or hla.inventory_organization_id is null ) 96 PRODUCT_FISCAL_CLASSIFICATION LOV custom varchar2 240 select zfpcv.classification_name value, zfpcv.country_code description from fnd_territories_tl ftt, zx_fc_product_fiscal_v zfpcv where ftt.territory_short_name = :$column$.taxation_country and ftt.language = userenv('LANG') and (zfpcv.country_code = ftt.territory_code or zfpcv.country_code is null) and trunc(sysdate) <= nvl(zfpcv.effective_to,trunc(sysdate)) order by value select zfpcv.classification_code id, zfpcv.classification_name value from hr_operating_units hou, xle_entity_profiles xep, xle_registrations xr, hr_locations_all hla, zx_fc_product_fiscal_v zfpcv where hou.name = :$column$.operating_unit and xep.legal_entity_id = to_number(hou.default_legal_context_id) and xep.legal_entity_id = xr.source_id and xr.source_table = 'XLE_ENTITY_PROFILES' and xr.identifying_flag = 'Y' and trunc(sysdate) between nvl(xr.effective_from,trunc(sysdate)) and nvl(xr.effective_to,trunc(sysdate)) and xr.location_id = hla.location_id and (zfpcv.country_code = hla.country or zfpcv.country_code is null) and trunc(sysdate) <= nvl(zfpcv.effective_to,trunc(sysdate)) 97 FISCAL_CLASSIFICATION LOV custom varchar2 240 select zfudv.classification_name value, zfudv.country_code description from fnd_territories_tl ftt, zx_fc_user_defined_v zfudv where ftt.territory_short_name = :$column$.taxation_country and ftt.language = userenv('LANG') and (zfudv.country_code = ftt.territory_code or zfudv.country_code is null) and trunc(sysdate) between nvl(zfudv.effective_from,trunc(sysdate)) and nvl(zfudv.effective_to,trunc(sysdate)) order by value select zfudv.classification_code id, zfudv.classification_name value from hr_operating_units hou, xle_entity_profiles xep, xle_registrations xr, hr_locations_all hla, zx_fc_user_defined_v zfudv where hou.name = :$column$.operating_unit and xep.legal_entity_id = to_number(hou.default_legal_context_id) and xep.legal_entity_id = xr.source_id and xr.source_table = 'XLE_ENTITY_PROFILES' and xr.identifying_flag = 'Y' and trunc(sysdate) between nvl(xr.effective_from,trunc(sysdate)) and nvl(xr.effective_to, trunc(sysdate)) and xr.location_id = hla.location_id and (zfudv.country_code = hla.country or zfudv.country_code is null) and trunc(sysdate) between nvl(zfudv.effective_from,trunc(sysdate)) and nvl(zfudv.effective_to,trunc(sysdate)) 98 BUSINESS_CATEGORY LOV custom varchar2 1996 select zfbcv.classification_name value, zfbcv.country_code description from fnd_territories_tl ftt, zx_fc_business_categories_v zfbcv where ftt.territory_short_name = :$column$.taxation_country and ftt.language = userenv('LANG') and (zfbcv.country_code = ftt.territory_code or zfbcv.country_code is null) and trunc(sysdate) between nvl(zfbcv.effective_from,trunc(sysdate)) and nvl(zfbcv.effective_to,trunc(sysdate)) and zfbcv.application_id = 200 and zfbcv.entity_code = 'AP_INVOICES' and zfbcv.event_class_code IN ('STANDARD INVOICES','PREPAYMENT INVOICES','EXPENSE REPORTS') order by value select zfbcv.classification_code id, zfbcv.classification_name value from hr_operating_units hou, xle_entity_profiles xep, xle_registrations xr, hr_locations_all hla, zx_fc_business_categories_v zfbcv where hou.name = :$column$.operating_unit and xep.legal_entity_id = to_number(hou.default_legal_context_id) and xep.legal_entity_id = xr.source_id and xr.source_table = 'XLE_ENTITY_PROFILES' and xr.identifying_flag = 'Y' and trunc(sysdate) between nvl(xr.effective_from,trunc(sysdate)) and nvl(xr.effective_to, trunc(sysdate)) and xr.location_id = hla.location_id and (zfbcv.country_code = hla.country or zfbcv.country_code is null) and trunc(sysdate) between nvl(zfbcv.effective_from,trunc(sysdate)) and nvl(zfbcv.effective_to,trunc(sysdate)) and zfbcv.application_id = 200 and zfbcv.entity_code = 'AP_INVOICES' and zfbcv.event_class_code IN ('STANDARD INVOICES','PREPAYMENT INVOICES','EXPENSE REPORTS') 99 PRODUCT_TYPE LOV custom varchar2 80 select zptv.classification_name value, null description from zx_product_types_v zptv order by value select zptv.classification_code id, zptv.classification_name value from zx_product_types_v zptv 100 PRODUCT_CATEGORY LOV custom varchar2 1996 select zfpcv.classification_name value, zfpcv.country_code description from fnd_territories_tl ftt, zx_fc_product_categories_v zfpcv where ftt.territory_short_name = :$column$.taxation_country and ftt.language = userenv('LANG') and (zfpcv.country_code = ftt.territory_code or zfpcv.country_code is null) and trunc(sysdate) between nvl(zfpcv.effective_from,trunc(sysdate)) and nvl(zfpcv.effective_to,trunc(sysdate)) order by value select zfpcv.classification_code id, zfpcv.classification_name value from hr_operating_units hou, xle_entity_profiles xep, xle_registrations xr, hr_locations_all hla, zx_fc_product_categories_v zfpcv where hou.name = :$column$.operating_unit and xep.legal_entity_id = to_number(hou.default_legal_context_id) and xep.legal_entity_id = xr.source_id and xr.source_table = 'XLE_ENTITY_PROFILES' and xr.identifying_flag = 'Y' and trunc(sysdate) between nvl(xr.effective_from,trunc(sysdate)) and nvl(xr.effective_to, trunc(sysdate)) and xr.location_id = hla.location_id and (zfpcv.country_code = hla.country or zfpcv.country_code is null) and trunc(sysdate) between nvl(zfpcv.effective_from,trunc(sysdate)) and nvl(zfpcv.effective_to,trunc(sysdate)) 101 TAX_REGIME LOV custom varchar2 30 select distinct xrv.tax_regime_code value, xrv.tax_regime_name description from fnd_territories_tl ftt, zx_regimes_vl xrv where :$column$.line_type = xxen_util.meaning('TAX','INVOICE LINE TYPE',200) and ftt.territory_short_name = :$column$.taxation_country and ftt.language = userenv('LANG') and xrv.country_code = ftt.territory_code and xrv.has_sub_regime_flag = 'N' and xrv.effective_from <= :$column$.invoice_date and (xrv.effective_to >= :$column$.invoice_date or xrv.effective_to is null) and xrv.tax_regime_code in (select zsd.tax_regime_code from zx_subscription_details zsd where zsd.first_pty_org_id = nvl( (select decode(zptp.use_le_as_subscriber_flag,'Y',null,zptp.party_tax_profile_id) from hr_operating_units hou, zx_party_tax_profile zptp where hou.name = :$column$.operating_unit and hou.organization_id = zptp.party_id and zptp.party_type_code = 'OU' ), (select zptp.party_tax_profile_id from hr_operating_units hou, xle_entity_profiles xep, zx_party_tax_profile zptp where hou.name = :$column$.operating_unit and to_number(hou.default_legal_context_id) = xep.legal_entity_id and xep.party_id = zptp.party_id and zptp.party_type_code = 'FIRST_PARTY' ) ) ) order by value 102 TAX LOV custom varchar2 30 select distinct zstv.tax value, zstv.tax_full_name description from zx_sco_taxes_v zstv where zstv.tax_regime_code = :$column$.tax_regime and zstv.effective_from <= :$column$.invoice_date and (zstv.effective_to >= :$column$.invoice_date or zstv.effective_to is NULL) and zstv.sdeff_from <= :$column$.invoice_date and (zstv.sdeff_to >= :$column$.invoice_date or zstv.sdeff_to is null) and zstv.sdco_id = nvl( (select decode(zptp.use_le_as_subscriber_flag,'Y',null,zptp.party_tax_profile_id) from hr_operating_units hou, zx_party_tax_profile zptp where hou.name = :$column$.operating_unit and hou.organization_id = zptp.party_id and zptp.party_type_code = 'OU' ), (select zptp.party_tax_profile_id from hr_operating_units hou, xle_entity_profiles xep, zx_party_tax_profile zptp where hou.name = :$column$.operating_unit and to_number(hou.default_legal_context_id) = xep.legal_entity_id and xep.party_id = zptp.party_id and zptp.party_type_code = 'FIRST_PARTY' ) ) order by value select distinct zstv.tax value from zx_sco_taxes_v zstv where zstv.tax_regime_code = :$column$.tax_regime and zstv.effective_from <= :$column$.invoice_date and (zstv.effective_to >= :$column$.invoice_date or zstv.effective_to is NULL) and zstv.sdeff_from <= :$column$.invoice_date and (zstv.sdeff_to >= :$column$.invoice_date or zstv.sdeff_to is null) and zstv.sdco_id = nvl( (select decode(zptp.use_le_as_subscriber_flag,'Y',null,zptp.party_tax_profile_id) from hr_operating_units hou, zx_party_tax_profile zptp where hou.name = :$column$.operating_unit and hou.organization_id = zptp.party_id and zptp.party_type_code = 'OU' ), (select zptp.party_tax_profile_id from hr_operating_units hou, xle_entity_profiles xep, zx_party_tax_profile zptp where hou.name = :$column$.operating_unit and to_number(hou.default_legal_context_id) = xep.legal_entity_id and xep.party_id = zptp.party_id and zptp.party_type_code = 'FIRST_PARTY' ) ) 103 TAX_STATUS LOV custom varchar2 30 select distinct zssv.tax_status_code value, zssv.tax_status_name description from zx_sco_status_v zssv where zssv.tax_regime_code = :$column$.tax_regime and zssv.tax = :$column$.tax and zssv.effective_from <= :$column$.invoice_date and (zssv.effective_to >= :$column$.invoice_date or zssv.effective_to is null) and zssv.sdeff_from <= :$column$.invoice_date and (zssv.sdeff_to >= :$column$.invoice_date or zssv.sdeff_to is null) and zssv.sdco_id = nvl( (select decode(zptp.use_le_as_subscriber_flag,'Y',null,zptp.party_tax_profile_id) from hr_operating_units hou, zx_party_tax_profile zptp where hou.name = :$column$.operating_unit and hou.organization_id = zptp.party_id and zptp.party_type_code = 'OU' ), (select zptp.party_tax_profile_id from hr_operating_units hou, xle_entity_profiles xep, zx_party_tax_profile zptp where hou.name = :$column$.operating_unit and to_number(hou.default_legal_context_id) = xep.legal_entity_id and xep.party_id = zptp.party_id and zptp.party_type_code = 'FIRST_PARTY' ) ) order by value select distinct zssv.tax_status_code from zx_sco_status_v zssv where zssv.tax_regime_code = :$column$.tax_regime and zssv.tax = :$column$.tax and zssv.effective_from <= :$column$.invoice_date and (zssv.effective_to >= :$column$.invoice_date or zssv.effective_to is null) and zssv.sdeff_from <= :$column$.invoice_date and (zssv.sdeff_to >= :$column$.invoice_date or zssv.sdeff_to is null) and zssv.sdco_id = nvl( (select decode(zptp.use_le_as_subscriber_flag,'Y',null,zptp.party_tax_profile_id) from hr_operating_units hou, zx_party_tax_profile zptp where hou.name = :$column$.operating_unit and hou.organization_id = zptp.party_id and zptp.party_type_code = 'OU' ), (select zptp.party_tax_profile_id from hr_operating_units hou, xle_entity_profiles xep, zx_party_tax_profile zptp where hou.name = :$column$.operating_unit and to_number(hou.default_legal_context_id) = xep.legal_entity_id and xep.party_id = zptp.party_id and zptp.party_type_code = 'FIRST_PARTY' ) ) 104 TAX_JURISDICTION LOV custom varchar2 30 select distinct zjv.tax_jurisdiction_code value, zjv.tax_jurisdiction_name description from zx_jurisdictions_vl zjv where zjv.tax_regime_code = :$column$.tax_regime and zjv.tax = :$column$.tax and zjv.effective_from <= :$column$.invoice_date and (zjv.effective_to >= :$column$.invoice_date or zjv.effective_to is null) order by value select zjv.tax_jurisdiction_code value from zx_jurisdictions_vl zjv where zjv.tax_regime_code = :$column$.tax_regime and zjv.tax = :$column$.tax and zjv.effective_from <= :$column$.invoice_date and (zjv.effective_to >= :$column$.invoice_date or zjv.effective_to is null) 105 TAX_RATE_NAME LOV custom varchar2 150 select distinct zsrv.tax_rate_code value, zsrv.tax_rate_name || ' (' || zsrv.percentage_rate || ')' description from zx_sco_rates_v zsrv where zsrv.tax_regime_code = :$column$.tax_regime and zsrv.tax = :$column$.tax and zsrv.tax_status_code = :$column$.tax_status and (zsrv.tax_jurisdiction_code is null or zsrv.tax_jurisdiction_code = nvl(:$column$.tax_jurisdiction,zsrv.tax_jurisdiction_code) )and zsrv.active_flag = 'Y' and (zsrv.tax_class is null or zsrv.tax_class = 'INPUT') and zsrv.effective_from <= :$column$.invoice_date and (zsrv.effective_to >= :$column$.invoice_date or zsrv.effective_to is null) and zsrv.sdeff_from <= :$column$.invoice_date and (zsrv.sdeff_to >= :$column$.invoice_date or zsrv.sdeff_to is null) and zsrv.sdco_id = nvl( (select decode(zptp.use_le_as_subscriber_flag,'Y',null,zptp.party_tax_profile_id) from hr_operating_units hou, zx_party_tax_profile zptp where hou.name = :$column$.operating_unit and hou.organization_id = zptp.party_id and zptp.party_type_code = 'OU' ), (select zptp.party_tax_profile_id from hr_operating_units hou, xle_entity_profiles xep, zx_party_tax_profile zptp where hou.name = :$column$.operating_unit and to_number(hou.default_legal_context_id) = xep.legal_entity_id and xep.party_id = zptp.party_id and zptp.party_type_code = 'FIRST_PARTY' ) ) order by value select distinct zsrv.tax_rate_code from zx_sco_rates_v zsrv where zsrv.tax_regime_code = :$column$.tax_regime and zsrv.tax = :$column$.tax and zsrv.tax_status_code = :$column$.tax_status and (zsrv.tax_jurisdiction_code is null or zsrv.tax_jurisdiction_code = nvl(:$column$.tax_jurisdiction,zsrv.tax_jurisdiction_code) )and zsrv.active_flag = 'Y' and (zsrv.tax_class is null or zsrv.tax_class = 'INPUT') and zsrv.effective_from <= :$column$.invoice_date and (zsrv.effective_to >= :$column$.invoice_date or zsrv.effective_to is null) and zsrv.sdeff_from <= :$column$.invoice_date and (zsrv.sdeff_to >= :$column$.invoice_date or zsrv.sdeff_to is null) and zsrv.sdco_id = nvl( (select decode(zptp.use_le_as_subscriber_flag,'Y',null,zptp.party_tax_profile_id) from hr_operating_units hou, zx_party_tax_profile zptp where hou.name = :$column$.operating_unit and hou.organization_id = zptp.party_id and zptp.party_type_code = 'OU' ), (select zptp.party_tax_profile_id from hr_operating_units hou, xle_entity_profiles xep, zx_party_tax_profile zptp where hou.name = :$column$.operating_unit and to_number(hou.default_legal_context_id) = xep.legal_entity_id and xep.party_id = zptp.party_id and zptp.party_type_code = 'FIRST_PARTY' ) ) 106 TAX_RATE LOV custom number select distinct zsrv.percentage_rate value, null description from zx_sco_rates_v zsrv where zsrv.tax_regime_code = :$column$.tax_regime and zsrv.tax = :$column$.tax and zsrv.tax_status_code = :$column$.tax_status and (zsrv.tax_jurisdiction_code is null or zsrv.tax_jurisdiction_code = nvl(:$column$.tax_jurisdiction,zsrv.tax_jurisdiction_code) ) and zsrv.tax_rate_code = :$column$.tax_rate_name and zsrv.active_flag = 'Y' and (zsrv.tax_class is null or zsrv.tax_class = 'INPUT') and zsrv.effective_from <= :$column$.invoice_date and (zsrv.effective_to >= :$column$.invoice_date or zsrv.effective_to is null) and zsrv.sdeff_from <= :$column$.invoice_date and (zsrv.sdeff_to >= :$column$.invoice_date or zsrv.sdeff_to is null) and zsrv.sdco_id = nvl( (select decode(zptp.use_le_as_subscriber_flag,'Y',null,zptp.party_tax_profile_id) from hr_operating_units hou, zx_party_tax_profile zptp where hou.name = :$column$.operating_unit and hou.organization_id = zptp.party_id and zptp.party_type_code = 'OU' ), (select zptp.party_tax_profile_id from hr_operating_units hou, xle_entity_profiles xep, zx_party_tax_profile zptp where hou.name = :$column$.operating_unit and to_number(hou.default_legal_context_id) = xep.legal_entity_id and xep.party_id = zptp.party_id and zptp.party_type_code = 'FIRST_PARTY' ) ) order by value select distinct zsrv.percentage_rate from zx_sco_rates_v zsrv where zsrv.tax_regime_code = :$column$.tax_regime and zsrv.tax = :$column$.tax and zsrv.tax_status_code = :$column$.tax_status and (zsrv.tax_jurisdiction_code is null or zsrv.tax_jurisdiction_code = nvl(:$column$.tax_jurisdiction,zsrv.tax_jurisdiction_code) ) and zsrv.tax_rate_code = :$column$.tax_rate_name and zsrv.active_flag = 'Y' and (zsrv.tax_class is null or zsrv.tax_class = 'INPUT') and zsrv.effective_from <= :$column$.invoice_date and (zsrv.effective_to >= :$column$.invoice_date or zsrv.effective_to is null) and zsrv.sdeff_from <= :$column$.invoice_date and (zsrv.sdeff_to >= :$column$.invoice_date or zsrv.sdeff_to is null) and zsrv.sdco_id = nvl( (select decode(zptp.use_le_as_subscriber_flag,'Y',null,zptp.party_tax_profile_id) from hr_operating_units hou, zx_party_tax_profile zptp where hou.name = :$column$.operating_unit and hou.organization_id = zptp.party_id and zptp.party_type_code = 'OU' ), (select zptp.party_tax_profile_id from hr_operating_units hou, xle_entity_profiles xep, zx_party_tax_profile zptp where hou.name = :$column$.operating_unit and to_number(hou.default_legal_context_id) = xep.legal_entity_id and xep.party_id = zptp.party_id and zptp.party_type_code = 'FIRST_PARTY' ) ) 107 ASSESSABLE_VALUE Number number 108 LINE_INVOICE_AWT_GROUP LOV custom varchar2 25 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 109 LINE_PAYMENT_AWT_GROUP LOV custom varchar2 25 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 110 BANK_CHARGE_BEARER LOV varchar2 80 IBY Bank Charge Bearer F7A2A73BF0A130DEE0530100007F22E9 select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='IBY_BANK_CHARGE_BEARER' and flvv.view_application_id=0 and flvv.security_group_id=0 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 = 'IBY_BANK_CHARGE_BEARER' and flvv.view_application_id = 0 111 REMITTANCE_MESSAGE1 Char varchar2 150 112 REMITTANCE_MESSAGE2 Char varchar2 150 113 REMITTANCE_MESSAGE3 Char varchar2 150 114 UNIQUE_REMITTANCE_IDENTIFIER Char varchar2 30 115 URI_CHECK_DIGIT Char varchar2 2 116 INVOICE_REFERENCE_1 Char varchar2 30 117 INVOICE_REFERENCE_2 Char varchar2 30 118 INVOICE_REFERENCE_KEY1 Char varchar2 150 119 INVOICE_REFERENCE_KEY2 Char varchar2 150 120 INVOICE_REFERENCE_KEY3 Char varchar2 150 121 INVOICE_REFERENCE_KEY4 Char varchar2 150 122 INVOICE_REFERENCE_KEY5 Char varchar2 150 123 LINE_REFERENCE_1 Char varchar2 30 124 LINE_REFERENCE_2 Char varchar2 30 125 LINE_REFERENCE_KEY1 Char varchar2 150 126 LINE_REFERENCE_KEY2 Char varchar2 150 127 LINE_REFERENCE_KEY3 Char varchar2 150 128 LINE_REFERENCE_KEY4 Char varchar2 150 129 LINE_REFERENCE_KEY5 Char varchar2 150 130 INVOICE_ATTRIBUTE_CATEGORY LOV custom varchar2 select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id = fdfv.application_id and fdfcv.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfcv.enabled_flag = 'Y' and fdfv.application_id = 200 and fdfv.descriptive_flexfield_name = 'AP_INVOICES' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 131 AP_INV_ATTRIBUTE1 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 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' 132 AP_INV_ATTRIBUTE2 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 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' 133 AP_INV_ATTRIBUTE3 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 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' 134 AP_INV_ATTRIBUTE4 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 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' 135 AP_INV_ATTRIBUTE5 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 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' 136 AP_INV_ATTRIBUTE6 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 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' 137 AP_INV_ATTRIBUTE7 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 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' 138 AP_INV_ATTRIBUTE8 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 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' 139 AP_INV_ATTRIBUTE9 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 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' 140 AP_INV_ATTRIBUTE10 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 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' 141 AP_INV_ATTRIBUTE11 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 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' 142 AP_INV_ATTRIBUTE12 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 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' 143 AP_INV_ATTRIBUTE13 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 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' 144 AP_INV_ATTRIBUTE14 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 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' 145 AP_INV_ATTRIBUTE15 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 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' 146 LINE_ATTRIBUTE_CATEGORY LOV custom varchar2 select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id = fdfv.application_id and fdfcv.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfcv.enabled_flag = 'Y' and fdfv.application_id = 200 and fdfv.descriptive_flexfield_name = 'AP_INVOICE_LINES' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 147 AP_INV_LINE_ATTRIBUTE1 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_LINES', 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_LINES' and dffcu.application_column_name = 'ATTRIBUTE1' 148 AP_INV_LINE_ATTRIBUTE2 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_LINES', 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_LINES' and dffcu.application_column_name = 'ATTRIBUTE2' 149 AP_INV_LINE_ATTRIBUTE3 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_LINES', 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_LINES' and dffcu.application_column_name = 'ATTRIBUTE3' 150 AP_INV_LINE_ATTRIBUTE4 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_LINES', 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_LINES' and dffcu.application_column_name = 'ATTRIBUTE4' 151 AP_INV_LINE_ATTRIBUTE5 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_LINES', 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_LINES' and dffcu.application_column_name = 'ATTRIBUTE5' 152 AP_INV_LINE_ATTRIBUTE6 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_LINES', 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_LINES' and dffcu.application_column_name = 'ATTRIBUTE6' 153 AP_INV_LINE_ATTRIBUTE7 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_LINES', 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_LINES' and dffcu.application_column_name = 'ATTRIBUTE7' 154 AP_INV_LINE_ATTRIBUTE8 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_LINES', 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_LINES' and dffcu.application_column_name = 'ATTRIBUTE8' 155 AP_INV_LINE_ATTRIBUTE9 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_LINES', 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_LINES' and dffcu.application_column_name = 'ATTRIBUTE9' 156 AP_INV_LINE_ATTRIBUTE10 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_LINES', 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_LINES' and dffcu.application_column_name = 'ATTRIBUTE10' 157 AP_INV_LINE_ATTRIBUTE11 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_LINES', 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_LINES' and dffcu.application_column_name = 'ATTRIBUTE11' 158 AP_INV_LINE_ATTRIBUTE12 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_LINES', 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_LINES' and dffcu.application_column_name = 'ATTRIBUTE12' 159 AP_INV_LINE_ATTRIBUTE13 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_LINES', 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_LINES' and dffcu.application_column_name = 'ATTRIBUTE13' 160 AP_INV_LINE_ATTRIBUTE14 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_LINES', 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_LINES' and dffcu.application_column_name = 'ATTRIBUTE14' 161 AP_INV_LINE_ATTRIBUTE15 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_LINES', 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_LINES' and dffcu.application_column_name = 'ATTRIBUTE15' 162 DIST_ATTRIBUTE_CATEGORY LOV custom varchar2 select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id = fdfv.application_id and fdfcv.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfcv.enabled_flag = 'Y' and fdfv.application_id = 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 163 AP_INV_DIST_ATTRIBUTE1 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.ap_inv_dist_attribute1, p_attribute2 => :$column$.ap_inv_dist_attribute2, p_attribute3 => :$column$.ap_inv_dist_attribute3, p_attribute4 => :$column$.ap_inv_dist_attribute4, p_attribute5 => :$column$.ap_inv_dist_attribute5, p_attribute6 => :$column$.ap_inv_dist_attribute6, p_attribute7 => :$column$.ap_inv_dist_attribute7, p_attribute8 => :$column$.ap_inv_dist_attribute8, p_attribute9 => :$column$.ap_inv_dist_attribute9, p_attribute10 => :$column$.ap_inv_dist_attribute10, p_attribute11 => :$column$.ap_inv_dist_attribute11, p_attribute12 => :$column$.ap_inv_dist_attribute12, p_attribute13 => :$column$.ap_inv_dist_attribute13, p_attribute14 => :$column$.ap_inv_dist_attribute14, p_attribute15 => :$column$.ap_inv_dist_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' 164 AP_INV_DIST_ATTRIBUTE2 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.ap_inv_dist_attribute1, p_attribute2 => :$column$.ap_inv_dist_attribute2, p_attribute3 => :$column$.ap_inv_dist_attribute3, p_attribute4 => :$column$.ap_inv_dist_attribute4, p_attribute5 => :$column$.ap_inv_dist_attribute5, p_attribute6 => :$column$.ap_inv_dist_attribute6, p_attribute7 => :$column$.ap_inv_dist_attribute7, p_attribute8 => :$column$.ap_inv_dist_attribute8, p_attribute9 => :$column$.ap_inv_dist_attribute9, p_attribute10 => :$column$.ap_inv_dist_attribute10, p_attribute11 => :$column$.ap_inv_dist_attribute11, p_attribute12 => :$column$.ap_inv_dist_attribute12, p_attribute13 => :$column$.ap_inv_dist_attribute13, p_attribute14 => :$column$.ap_inv_dist_attribute14, p_attribute15 => :$column$.ap_inv_dist_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' 165 AP_INV_DIST_ATTRIBUTE3 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.ap_inv_dist_attribute1, p_attribute2 => :$column$.ap_inv_dist_attribute2, p_attribute3 => :$column$.ap_inv_dist_attribute3, p_attribute4 => :$column$.ap_inv_dist_attribute4, p_attribute5 => :$column$.ap_inv_dist_attribute5, p_attribute6 => :$column$.ap_inv_dist_attribute6, p_attribute7 => :$column$.ap_inv_dist_attribute7, p_attribute8 => :$column$.ap_inv_dist_attribute8, p_attribute9 => :$column$.ap_inv_dist_attribute9, p_attribute10 => :$column$.ap_inv_dist_attribute10, p_attribute11 => :$column$.ap_inv_dist_attribute11, p_attribute12 => :$column$.ap_inv_dist_attribute12, p_attribute13 => :$column$.ap_inv_dist_attribute13, p_attribute14 => :$column$.ap_inv_dist_attribute14, p_attribute15 => :$column$.ap_inv_dist_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' 166 AP_INV_DIST_ATTRIBUTE4 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.ap_inv_dist_attribute1, p_attribute2 => :$column$.ap_inv_dist_attribute2, p_attribute3 => :$column$.ap_inv_dist_attribute3, p_attribute4 => :$column$.ap_inv_dist_attribute4, p_attribute5 => :$column$.ap_inv_dist_attribute5, p_attribute6 => :$column$.ap_inv_dist_attribute6, p_attribute7 => :$column$.ap_inv_dist_attribute7, p_attribute8 => :$column$.ap_inv_dist_attribute8, p_attribute9 => :$column$.ap_inv_dist_attribute9, p_attribute10 => :$column$.ap_inv_dist_attribute10, p_attribute11 => :$column$.ap_inv_dist_attribute11, p_attribute12 => :$column$.ap_inv_dist_attribute12, p_attribute13 => :$column$.ap_inv_dist_attribute13, p_attribute14 => :$column$.ap_inv_dist_attribute14, p_attribute15 => :$column$.ap_inv_dist_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' 167 AP_INV_DIST_ATTRIBUTE5 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.ap_inv_dist_attribute1, p_attribute2 => :$column$.ap_inv_dist_attribute2, p_attribute3 => :$column$.ap_inv_dist_attribute3, p_attribute4 => :$column$.ap_inv_dist_attribute4, p_attribute5 => :$column$.ap_inv_dist_attribute5, p_attribute6 => :$column$.ap_inv_dist_attribute6, p_attribute7 => :$column$.ap_inv_dist_attribute7, p_attribute8 => :$column$.ap_inv_dist_attribute8, p_attribute9 => :$column$.ap_inv_dist_attribute9, p_attribute10 => :$column$.ap_inv_dist_attribute10, p_attribute11 => :$column$.ap_inv_dist_attribute11, p_attribute12 => :$column$.ap_inv_dist_attribute12, p_attribute13 => :$column$.ap_inv_dist_attribute13, p_attribute14 => :$column$.ap_inv_dist_attribute14, p_attribute15 => :$column$.ap_inv_dist_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' 168 AP_INV_DIST_ATTRIBUTE6 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.ap_inv_dist_attribute1, p_attribute2 => :$column$.ap_inv_dist_attribute2, p_attribute3 => :$column$.ap_inv_dist_attribute3, p_attribute4 => :$column$.ap_inv_dist_attribute4, p_attribute5 => :$column$.ap_inv_dist_attribute5, p_attribute6 => :$column$.ap_inv_dist_attribute6, p_attribute7 => :$column$.ap_inv_dist_attribute7, p_attribute8 => :$column$.ap_inv_dist_attribute8, p_attribute9 => :$column$.ap_inv_dist_attribute9, p_attribute10 => :$column$.ap_inv_dist_attribute10, p_attribute11 => :$column$.ap_inv_dist_attribute11, p_attribute12 => :$column$.ap_inv_dist_attribute12, p_attribute13 => :$column$.ap_inv_dist_attribute13, p_attribute14 => :$column$.ap_inv_dist_attribute14, p_attribute15 => :$column$.ap_inv_dist_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' 169 AP_INV_DIST_ATTRIBUTE7 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.ap_inv_dist_attribute1, p_attribute2 => :$column$.ap_inv_dist_attribute2, p_attribute3 => :$column$.ap_inv_dist_attribute3, p_attribute4 => :$column$.ap_inv_dist_attribute4, p_attribute5 => :$column$.ap_inv_dist_attribute5, p_attribute6 => :$column$.ap_inv_dist_attribute6, p_attribute7 => :$column$.ap_inv_dist_attribute7, p_attribute8 => :$column$.ap_inv_dist_attribute8, p_attribute9 => :$column$.ap_inv_dist_attribute9, p_attribute10 => :$column$.ap_inv_dist_attribute10, p_attribute11 => :$column$.ap_inv_dist_attribute11, p_attribute12 => :$column$.ap_inv_dist_attribute12, p_attribute13 => :$column$.ap_inv_dist_attribute13, p_attribute14 => :$column$.ap_inv_dist_attribute14, p_attribute15 => :$column$.ap_inv_dist_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' 170 AP_INV_DIST_ATTRIBUTE8 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.ap_inv_dist_attribute1, p_attribute2 => :$column$.ap_inv_dist_attribute2, p_attribute3 => :$column$.ap_inv_dist_attribute3, p_attribute4 => :$column$.ap_inv_dist_attribute4, p_attribute5 => :$column$.ap_inv_dist_attribute5, p_attribute6 => :$column$.ap_inv_dist_attribute6, p_attribute7 => :$column$.ap_inv_dist_attribute7, p_attribute8 => :$column$.ap_inv_dist_attribute8, p_attribute9 => :$column$.ap_inv_dist_attribute9, p_attribute10 => :$column$.ap_inv_dist_attribute10, p_attribute11 => :$column$.ap_inv_dist_attribute11, p_attribute12 => :$column$.ap_inv_dist_attribute12, p_attribute13 => :$column$.ap_inv_dist_attribute13, p_attribute14 => :$column$.ap_inv_dist_attribute14, p_attribute15 => :$column$.ap_inv_dist_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' 171 AP_INV_DIST_ATTRIBUTE9 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.ap_inv_dist_attribute1, p_attribute2 => :$column$.ap_inv_dist_attribute2, p_attribute3 => :$column$.ap_inv_dist_attribute3, p_attribute4 => :$column$.ap_inv_dist_attribute4, p_attribute5 => :$column$.ap_inv_dist_attribute5, p_attribute6 => :$column$.ap_inv_dist_attribute6, p_attribute7 => :$column$.ap_inv_dist_attribute7, p_attribute8 => :$column$.ap_inv_dist_attribute8, p_attribute9 => :$column$.ap_inv_dist_attribute9, p_attribute10 => :$column$.ap_inv_dist_attribute10, p_attribute11 => :$column$.ap_inv_dist_attribute11, p_attribute12 => :$column$.ap_inv_dist_attribute12, p_attribute13 => :$column$.ap_inv_dist_attribute13, p_attribute14 => :$column$.ap_inv_dist_attribute14, p_attribute15 => :$column$.ap_inv_dist_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' 172 AP_INV_DIST_ATTRIBUTE10 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.ap_inv_dist_attribute1, p_attribute2 => :$column$.ap_inv_dist_attribute2, p_attribute3 => :$column$.ap_inv_dist_attribute3, p_attribute4 => :$column$.ap_inv_dist_attribute4, p_attribute5 => :$column$.ap_inv_dist_attribute5, p_attribute6 => :$column$.ap_inv_dist_attribute6, p_attribute7 => :$column$.ap_inv_dist_attribute7, p_attribute8 => :$column$.ap_inv_dist_attribute8, p_attribute9 => :$column$.ap_inv_dist_attribute9, p_attribute10 => :$column$.ap_inv_dist_attribute10, p_attribute11 => :$column$.ap_inv_dist_attribute11, p_attribute12 => :$column$.ap_inv_dist_attribute12, p_attribute13 => :$column$.ap_inv_dist_attribute13, p_attribute14 => :$column$.ap_inv_dist_attribute14, p_attribute15 => :$column$.ap_inv_dist_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' 173 AP_INV_DIST_ATTRIBUTE11 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.ap_inv_dist_attribute1, p_attribute2 => :$column$.ap_inv_dist_attribute2, p_attribute3 => :$column$.ap_inv_dist_attribute3, p_attribute4 => :$column$.ap_inv_dist_attribute4, p_attribute5 => :$column$.ap_inv_dist_attribute5, p_attribute6 => :$column$.ap_inv_dist_attribute6, p_attribute7 => :$column$.ap_inv_dist_attribute7, p_attribute8 => :$column$.ap_inv_dist_attribute8, p_attribute9 => :$column$.ap_inv_dist_attribute9, p_attribute10 => :$column$.ap_inv_dist_attribute10, p_attribute11 => :$column$.ap_inv_dist_attribute11, p_attribute12 => :$column$.ap_inv_dist_attribute12, p_attribute13 => :$column$.ap_inv_dist_attribute13, p_attribute14 => :$column$.ap_inv_dist_attribute14, p_attribute15 => :$column$.ap_inv_dist_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' 174 AP_INV_DIST_ATTRIBUTE12 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.ap_inv_dist_attribute1, p_attribute2 => :$column$.ap_inv_dist_attribute2, p_attribute3 => :$column$.ap_inv_dist_attribute3, p_attribute4 => :$column$.ap_inv_dist_attribute4, p_attribute5 => :$column$.ap_inv_dist_attribute5, p_attribute6 => :$column$.ap_inv_dist_attribute6, p_attribute7 => :$column$.ap_inv_dist_attribute7, p_attribute8 => :$column$.ap_inv_dist_attribute8, p_attribute9 => :$column$.ap_inv_dist_attribute9, p_attribute10 => :$column$.ap_inv_dist_attribute10, p_attribute11 => :$column$.ap_inv_dist_attribute11, p_attribute12 => :$column$.ap_inv_dist_attribute12, p_attribute13 => :$column$.ap_inv_dist_attribute13, p_attribute14 => :$column$.ap_inv_dist_attribute14, p_attribute15 => :$column$.ap_inv_dist_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' 175 AP_INV_DIST_ATTRIBUTE13 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.ap_inv_dist_attribute1, p_attribute2 => :$column$.ap_inv_dist_attribute2, p_attribute3 => :$column$.ap_inv_dist_attribute3, p_attribute4 => :$column$.ap_inv_dist_attribute4, p_attribute5 => :$column$.ap_inv_dist_attribute5, p_attribute6 => :$column$.ap_inv_dist_attribute6, p_attribute7 => :$column$.ap_inv_dist_attribute7, p_attribute8 => :$column$.ap_inv_dist_attribute8, p_attribute9 => :$column$.ap_inv_dist_attribute9, p_attribute10 => :$column$.ap_inv_dist_attribute10, p_attribute11 => :$column$.ap_inv_dist_attribute11, p_attribute12 => :$column$.ap_inv_dist_attribute12, p_attribute13 => :$column$.ap_inv_dist_attribute13, p_attribute14 => :$column$.ap_inv_dist_attribute14, p_attribute15 => :$column$.ap_inv_dist_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' 176 AP_INV_DIST_ATTRIBUTE14 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.ap_inv_dist_attribute1, p_attribute2 => :$column$.ap_inv_dist_attribute2, p_attribute3 => :$column$.ap_inv_dist_attribute3, p_attribute4 => :$column$.ap_inv_dist_attribute4, p_attribute5 => :$column$.ap_inv_dist_attribute5, p_attribute6 => :$column$.ap_inv_dist_attribute6, p_attribute7 => :$column$.ap_inv_dist_attribute7, p_attribute8 => :$column$.ap_inv_dist_attribute8, p_attribute9 => :$column$.ap_inv_dist_attribute9, p_attribute10 => :$column$.ap_inv_dist_attribute10, p_attribute11 => :$column$.ap_inv_dist_attribute11, p_attribute12 => :$column$.ap_inv_dist_attribute12, p_attribute13 => :$column$.ap_inv_dist_attribute13, p_attribute14 => :$column$.ap_inv_dist_attribute14, p_attribute15 => :$column$.ap_inv_dist_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' 177 AP_INV_DIST_ATTRIBUTE15 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id => 200, p_descriptive_flexfield_name => 'AP_INVOICE_DISTRIBUTIONS', p_context_name => :$column$.dist_attribute_category, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.ap_inv_dist_attribute1, p_attribute2 => :$column$.ap_inv_dist_attribute2, p_attribute3 => :$column$.ap_inv_dist_attribute3, p_attribute4 => :$column$.ap_inv_dist_attribute4, p_attribute5 => :$column$.ap_inv_dist_attribute5, p_attribute6 => :$column$.ap_inv_dist_attribute6, p_attribute7 => :$column$.ap_inv_dist_attribute7, p_attribute8 => :$column$.ap_inv_dist_attribute8, p_attribute9 => :$column$.ap_inv_dist_attribute9, p_attribute10 => :$column$.ap_inv_dist_attribute10, p_attribute11 => :$column$.ap_inv_dist_attribute11, p_attribute12 => :$column$.ap_inv_dist_attribute12, p_attribute13 => :$column$.ap_inv_dist_attribute13, p_attribute14 => :$column$.ap_inv_dist_attribute14, p_attribute15 => :$column$.ap_inv_dist_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' 178 ATTACHMENT_CATEGORY_ LOV custom varchar2 select fdcuv.user_name value, null description from fnd_doc_category_usages_vl fdcuv, fnd_attachment_functions af, fnd_document_categories fdc where fdcuv.attachment_function_id=af.attachment_function_id and af.function_name='APXINWKB' and fdc.category_id=fdcuv.category_id and nvl(fdc.start_date_active,sysdate-1)<=sysdate and nvl(fdc.end_date_active,sysdate+1)>sysdate order by value Required for adding an attachment 179 ATTACHMENT_TITLE_ Char varchar2 180 ATTACHMENT_DESCRIPTION_ Char varchar2 181 ATTACHMENT_TYPE_ LOV varchar2 FND Attachment Type B9AF5DAEAF9247899FE9F668B4D79A46 select user_name value, null description from fnd_document_datatypes_vl where name in ('SHORT_TEXT','FILE','WEB_PAGE') order by value Required for adding an attachment 182 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 183 ATTACHMENT_FILE_ID_ Char varchar2 Autopopulated after clicking on Upload Attachments 184 UPLOAD_ROW Number number Y 185 SECTION_CODE LOV custom varchar2 Y select flvv.lookup_code value, flvv.meaning description from fnd_lookup_values_vl flvv where flvv.lookup_type='JAI_TDS_SECTION' and flvv.security_group_id=0 and flvv.enabled_flag='Y' and nvl(flvv.end_date_active,sysdate)>=trunc(sysdate) and exists (select null from jai_rgm_parties jrp, hr_all_organization_units_vl haouv where jrp.organization_type='OU' and jrp.organization_id=haouv.organization_id and haouv.name=:$column$.operating_unit) order by value India Localization TDS section (e.g. 194C) applied to the distribution. Only shown when India Localization is installed and the operating unit is registered for India Localization. 186 TAX_CATEGORY LOV custom varchar2 Y select jtc.tax_category_name value, jtc.tax_category_desc description from jai_tax_categories jtc where trunc(jtc.effective_from)<=trunc(sysdate) and (jtc.effective_to is null or trunc(jtc.effective_to)>=trunc(sysdate)) and exists (select null from jai_rgm_parties jrp, hr_all_organization_units_vl haouv where jrp.organization_type='OU' and jrp.organization_id=haouv.organization_id and haouv.name=:$column$.operating_unit) order by value India Localization GST tax category applied to the distribution. Only shown when India Localization is installed. 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_inv_int_id in/out Number INV_INT_ID U 6 p_line_int_id in/out Number LINE_INT_ID U 7 p_source in Char SOURCE U 8 p_operating_unit in Char OPERATING_UNIT value U 9 p_invoice_type in Char Y INVOICE_TYPE U 10 p_doc_category_code in Char Y DOCUMENT_CATEGORY U 11 p_supplier_name in Char SUPPLIER_NAME value U 12 p_supplier_num in Char SUPPLIER_NUMBER value U 13 p_supplier_site in Char SUPPLIER_SITE value U 14 p_invoice_po_number in Char Y INVOICE_PO_NUMBER value U 15 p_invoice_date in Date INVOICE_DATE U 16 p_gl_date in Date Y GL_DATE U 17 p_invoice_number in Char INVOICE_NUMBER U 18 p_invoice_description in Char INVOICE_DESCRIPTION U 19 p_liability_account_segments in Char Y LIABILITY_ACCOUNT value U 20 p_invoice_amount in Number INVOICE_AMOUNT U 21 p_amount_applicable_to_disc in Number Y AMOUNT_APPLICABLE_TO_DISCOUNT U 22 p_invoice_inclusive_of_tax in Char Y INVOICE_INCLUSIVE_OF_TAX U 23 p_invoice_calculate_tax in Char Y INVOICE_CALCULATE_TAX U 24 p_terms in Char Y TERMS value U 25 p_terms_date in Date Y TERMS_DATE U 26 p_goods_received_date in Date Y GOODS_RECEIVED_DATE U 27 p_invoice_received_date in Date Y INVOICE_RECEIVED_DATE U 28 p_invoice_currency in Char INVOICE_CURRENCY U 29 p_exchange_rate_type in Char Y EXCHANGE_RATE_TYPE U 30 p_exchange_date in Date Y EXCHANGE_DATE U 31 p_exchange_rate in Number Y EXCHANGE_RATE U 32 p_payment_currency in Char Y PAYMENT_CURRENCY U 33 p_payment_cross_rate_type in Char Y PAYMENT_CROSS_RATE_TYPE U 34 p_payment_cross_rate_date in Date Y PAYMENT_CROSS_RATE_DATE U 35 p_payment_cross_rate in Number Y PAYMENT_CROSS_RATE U 36 p_payment_group in Char Y PAYMENT_GROUP U 37 p_payment_method in Char Y PAYMENT_METHOD U 38 p_payment_delivery_channel in Char Y PAYMENT_DELIVERY_CHANNEL U 39 p_payment_reason in Char Y PAYMENT_REASON U 40 p_payment_reason_comments in Char Y PAYMENT_REASON_COMMENTS U 41 p_payment_priority in Number Y U 42 p_exclusive_payment_flag in Char Y EXCLUSIVE_PAYMENT_FLAG U 43 p_ussgl_transaction_code in Char Y U 44 p_awt_group_name in Char Y INVOICE_AWT_GROUP value U 45 p_pay_awt_group_name in Char Y PAYMENT_AWT_GROUP value U 46 p_bank_charge_bearer in Char Y BANK_CHARGE_BEARER U 47 p_remittance_message1 in Char Y REMITTANCE_MESSAGE1 U 48 p_remittance_message2 in Char Y REMITTANCE_MESSAGE2 U 49 p_remittance_message3 in Char Y REMITTANCE_MESSAGE3 U 50 p_unique_remittance_identifier in Char Y UNIQUE_REMITTANCE_IDENTIFIER U 51 p_uri_check_digit in Char Y URI_CHECK_DIGIT U 52 p_tax_invoice_recording_date in Date Y INTERNAL_RECORDING_DATE U 53 p_supplier_tax_invoice_number in Char Y SUPPLIER_TAX_INVOICE_NUMBER U 54 p_supplier_tax_invoice_date in Date Y SUPPLIER_TAX_INVOICE_DATE U 55 p_supplier_tax_exchange_rate in Number Y SUPPLIER_TAX_EXCHANGE_RATE U 56 p_line_num in Number LINE_NUMBER U 57 p_line_type in Char Y LINE_TYPE U 58 p_line_group_number in Number Y LINE_PRORATE_GROUP U 59 p_prorate_across_flag in Char Y PRORATE_FLAG U 60 p_line_amount in Number LINE_AMOUNT U 61 p_quantity_invoiced in Number Y QUANTITY U 62 p_unit_of_measure_lookup_code in Char Y UOM value U 63 p_unit_price in Number Y UNIT_PRICE U 64 p_line_description in Char Y LINE_DESCRIPTION U 65 p_dist_account_segments in Char Y DISTRIBUTION_ACCOUNT value U 66 p_distribution_set_name in Char Y DISTRIBUTION_SET value U 67 p_line_po_number in Char Y PO_NUMBER value U 68 p_line_po_release_num in Number Y PO_RELEASE_NUM value U 69 p_line_po_line_num in Number Y PO_LINE_NUM value U 70 p_line_po_shipment_num in Number Y PO_SHIPMENT_NUM value U 71 p_line_po_distribution_num in Number Y PO_DISTRIBUTION_NUM value U 72 p_line_receipt_number in Char Y PO_RECEIPT_NUM value U 73 p_line_receipt_line_num in Number Y PO_RECEIPT_LINE_NUM value U 74 p_line_requester_id in Number Y REQUESTER U 75 p_project_id in Number Y PROJECT U 76 p_task_id in Number Y TASK U 77 p_expenditure_type in Char Y EXPENDITURE_TYPE U 78 p_expenditure_item_date in Date Y EXPENDITURE_ITEM_DATE U 79 p_expenditure_organization_id in Number Y EXPENDITURE_ORGANIZATION U 80 p_pa_quantity in Number Y PROJECT_QUANTITY U 81 p_pa_addition_flag in Char Y U 82 p_assets_tracking_flag in Char Y TRACK_AS_ASSET U 83 p_asset_book_type_code in Char Y ASSET_BOOK U 84 p_asset_category_id in Number Y ASSET_CATEGORY U 85 p_inventory_item_id in Number Y INVENTORY_ITEM U 86 p_item_description in Char Y ITEM_DESCRIPTION U 87 p_manufacturer in Char Y MANUFACTURER U 88 p_model_number in Char Y MODEL_NUMBER U 89 p_serial_number in Char Y SERIAL_NUMBER U 90 p_warranty_number in Char Y WARRANTY_NUMBER U 91 p_type_1099 in Char Y INCOME_TAX_TYPE U 92 p_income_tax_region in Char Y INCOME_TAX_REGION U 93 p_taxation_country in Char Y TAXATION_COUNTRY U 94 p_tax_classification in Char Y TAX_CLASSIFICATION U 95 p_primary_intended_use in Char Y PRIMARY_INTENDED_USE U 96 p_ship_to_location_id in Number Y SHIP_TO_LOCATION U 97 p_prod_fiscal_classification in Char Y PRODUCT_FISCAL_CLASSIFICATION U 98 p_fiscal_classification in Char Y FISCAL_CLASSIFICATION U 99 p_business_category in Char Y BUSINESS_CATEGORY U 100 p_product_type in Char Y PRODUCT_TYPE U 101 p_product_category in Char Y PRODUCT_CATEGORY U 102 p_tax_regime_code in Char Y TAX_REGIME U 103 p_tax in Char Y TAX U 104 p_tax_status_code in Char Y TAX_STATUS U 105 p_tax_jurisdiction_code in Char Y TAX_JURISDICTION U 106 p_tax_rate_code in Char Y TAX_RATE_NAME U 107 p_tax_rate in Number Y TAX_RATE U 108 p_assessable_value in Number Y ASSESSABLE_VALUE U 109 p_line_awt_group_name in Char Y LINE_INVOICE_AWT_GROUP value U 110 p_line_pay_awt_group_name in Char Y LINE_PAYMENT_AWT_GROUP value U 111 p_inv_reference_1 in Char Y INVOICE_REFERENCE_1 U 112 p_inv_reference_2 in Char Y INVOICE_REFERENCE_2 U 113 p_inv_reference_key1 in Char Y INVOICE_REFERENCE_KEY1 U 114 p_inv_reference_key2 in Char Y INVOICE_REFERENCE_KEY2 U 115 p_inv_reference_key3 in Char Y INVOICE_REFERENCE_KEY3 U 116 p_inv_reference_key4 in Char Y INVOICE_REFERENCE_KEY4 U 117 p_inv_reference_key5 in Char Y INVOICE_REFERENCE_KEY5 U 118 p_lin_reference_1 in Char Y LINE_REFERENCE_1 U 119 p_lin_reference_2 in Char Y LINE_REFERENCE_2 U 120 p_lin_reference_key1 in Char Y LINE_REFERENCE_KEY1 U 121 p_lin_reference_key2 in Char Y LINE_REFERENCE_KEY2 U 122 p_lin_reference_key3 in Char Y LINE_REFERENCE_KEY3 U 123 p_lin_reference_key4 in Char Y LINE_REFERENCE_KEY4 U 124 p_lin_reference_key5 in Char Y LINE_REFERENCE_KEY5 U 125 p_inv_attribute_category in Char Y INVOICE_ATTRIBUTE_CATEGORY U 126 p_inv_attribute1 in Char Y AP_INV_ATTRIBUTE1 U 127 p_inv_attribute2 in Char Y AP_INV_ATTRIBUTE2 U 128 p_inv_attribute3 in Char Y AP_INV_ATTRIBUTE3 U 129 p_inv_attribute4 in Char Y AP_INV_ATTRIBUTE4 U 130 p_inv_attribute5 in Char Y AP_INV_ATTRIBUTE5 U 131 p_inv_attribute6 in Char Y AP_INV_ATTRIBUTE6 U 132 p_inv_attribute7 in Char Y AP_INV_ATTRIBUTE7 U 133 p_inv_attribute8 in Char Y AP_INV_ATTRIBUTE8 U 134 p_inv_attribute9 in Char Y AP_INV_ATTRIBUTE9 U 135 p_inv_attribute10 in Char Y AP_INV_ATTRIBUTE10 U 136 p_inv_attribute11 in Char Y AP_INV_ATTRIBUTE11 U 137 p_inv_attribute12 in Char Y AP_INV_ATTRIBUTE12 U 138 p_inv_attribute13 in Char Y AP_INV_ATTRIBUTE13 U 139 p_inv_attribute14 in Char Y AP_INV_ATTRIBUTE14 U 140 p_inv_attribute15 in Char Y AP_INV_ATTRIBUTE15 U 141 p_lin_attribute_category in Char Y LINE_ATTRIBUTE_CATEGORY U 142 p_lin_attribute1 in Char Y AP_INV_LINE_ATTRIBUTE1 U 143 p_lin_attribute2 in Char Y AP_INV_LINE_ATTRIBUTE2 U 144 p_lin_attribute3 in Char Y AP_INV_LINE_ATTRIBUTE3 U 145 p_lin_attribute4 in Char Y AP_INV_LINE_ATTRIBUTE4 U 146 p_lin_attribute5 in Char Y AP_INV_LINE_ATTRIBUTE5 U 147 p_lin_attribute6 in Char Y AP_INV_LINE_ATTRIBUTE6 U 148 p_lin_attribute7 in Char Y AP_INV_LINE_ATTRIBUTE7 U 149 p_lin_attribute8 in Char Y AP_INV_LINE_ATTRIBUTE8 U 150 p_lin_attribute9 in Char Y AP_INV_LINE_ATTRIBUTE9 U 151 p_lin_attribute10 in Char Y AP_INV_LINE_ATTRIBUTE10 U 152 p_lin_attribute11 in Char Y AP_INV_LINE_ATTRIBUTE11 U 153 p_lin_attribute12 in Char Y AP_INV_LINE_ATTRIBUTE12 U 154 p_lin_attribute13 in Char Y AP_INV_LINE_ATTRIBUTE13 U 155 p_lin_attribute14 in Char Y AP_INV_LINE_ATTRIBUTE14 U 156 p_lin_attribute15 in Char Y AP_INV_LINE_ATTRIBUTE15 U 157 p_dis_attribute_category in Char Y DIST_ATTRIBUTE_CATEGORY U 158 p_dis_attribute1 in Char Y AP_INV_DIST_ATTRIBUTE1 U 159 p_dis_attribute2 in Char Y AP_INV_DIST_ATTRIBUTE2 U 160 p_dis_attribute3 in Char Y AP_INV_DIST_ATTRIBUTE3 U 161 p_dis_attribute4 in Char Y AP_INV_DIST_ATTRIBUTE4 U 162 p_dis_attribute5 in Char Y AP_INV_DIST_ATTRIBUTE5 U 163 p_dis_attribute6 in Char Y AP_INV_DIST_ATTRIBUTE6 U 164 p_dis_attribute7 in Char Y AP_INV_DIST_ATTRIBUTE7 U 165 p_dis_attribute8 in Char Y AP_INV_DIST_ATTRIBUTE8 U 166 p_dis_attribute9 in Char Y AP_INV_DIST_ATTRIBUTE9 U 167 p_dis_attribute10 in Char Y AP_INV_DIST_ATTRIBUTE10 U 168 p_dis_attribute11 in Char Y AP_INV_DIST_ATTRIBUTE11 U 169 p_dis_attribute12 in Char Y AP_INV_DIST_ATTRIBUTE12 U 170 p_dis_attribute13 in Char Y AP_INV_DIST_ATTRIBUTE13 U 171 p_dis_attribute14 in Char Y AP_INV_DIST_ATTRIBUTE14 U 172 p_dis_attribute15 in Char Y AP_INV_DIST_ATTRIBUTE15 U 173 p_section_code in Char Y SECTION_CODE U 174 p_tax_category in Char Y TAX_CATEGORY U 175 p_dist_line_num in Number Y DISTRIBUTION_LINE_NUMBER U 176 p_dist_percent in Number Y DISTRIBUTION_PERCENT U 177 p_dist_amount in Number Y DISTRIBUTION_AMOUNT U 178 p_add_to_existing_invoice in Char Y ADD_TO_EXISTING_INVOICE 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 P 7 p_submit_validation in Char Y SUBMIT_VALIDATION Lexical &error_with_query ,q_reporting_table as ( select xm.action_, case when xxen_ap_upload.distribution_message(xm.line_int_id,xm.distribution_line_number) is not null then xxen_upload.status_error when xm.add_to_existing_invoice is not null and xm.line_int_id is not null then xxen_upload.status_success when aili.invoice_id is not null and nvl(aii.status,'NEW') != 'PROCESSED' or exists (select null from ap_interface_rejections air where air.parent_table in ('AP_INVOICE_INTERFACE','AP_INVOICES_INTERFACE') and air.parent_id = xm.inv_int_id) or exists (select null from ap_interface_rejections air where air.parent_table = 'AP_INVOICE_LINES_INTERFACE' and air.parent_id = xm.line_int_id) then xxen_upload.status_error when aili.invoice_id is not null and aii.status = 'PROCESSED' then xxen_upload.status_success else xm.status_code_ end pstatus, -- case when xm.add_to_existing_invoice is not null and xm.line_int_id is not null then xxen_ap_upload.distribution_message(xm.line_int_id,xm.distribution_line_number) when xm.status_code_ = xxen_upload.status_error and xm.message_ is not null then xm.message_ when xxen_ap_upload.distribution_message(xm.line_int_id,xm.distribution_line_number) is not null then xxen_ap_upload.distribution_message(xm.line_int_id,xm.distribution_line_number) when exists (select null from ap_interface_rejections air where air.parent_table in ('AP_INVOICE_INTERFACE','AP_INVOICES_INTERFACE') and air.parent_id = xm.inv_int_id) or exists (select null from ap_interface_rejections air where air.parent_table = 'AP_INVOICE_LINES_INTERFACE' and air.parent_id = xm.line_int_id) 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_INVOICE_INTERFACE',1,'AP_INVOICES_INTERFACE',1,2),air.reject_lookup_code) text from ap_interface_rejections air where ( (air.parent_table in ('AP_INVOICE_INTERFACE','AP_INVOICES_INTERFACE') and air.parent_id = xm.inv_int_id) or (air.parent_table = 'AP_INVOICE_LINES_INTERFACE' and air.parent_id = xm.line_int_id) ) ) when aili.invoice_id is not null and nvl(aii.status,'NEW') != 'PROCESSED' then 'Payables Open Interface Import did not import this line. Please check the Payables Open Interface Import request' when aii.invoice_id is not null and aii.status = 'PROCESSED' then xxen_upload.status_meaning(xxen_upload.status_success) else null end pmessage, -- aii.request_id prequestid, xm.action_code_, xm.status_code_, xm.message_, xm.request_id_, xm.modified_columns_, xm.inv_int_id, xm.line_int_id, xm.batch_name, xm.submit_validation, xm.invoice_calculate_tax, xm.invoice_inclusive_of_tax, -- nvl(xm.source,:p_source) source, xm.operating_unit, xm.supplier_name, xm.supplier_number, xm.supplier_site, xm.invoice_type, xm.document_category, xm.invoice_number, xm.add_to_existing_invoice, xm.invoice_description, xm.invoice_po_number, xm.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, nvl(xm.liability_account,(select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = aii.accts_pay_code_combination_id)) liability_account, 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,(select ipmv.payment_method_name from iby_payment_methods_vl ipmv where ipmv.payment_method_code = aii.payment_method_code)) payment_method, nvl(xm.payment_delivery_channel,(select idcv.meaning from iby_delivery_channels_vl idcv where idcv.delivery_channel_code = aii.delivery_channel_code)) payment_delivery_channel, nvl(xm.payment_reason,(select iprv.meaning from iby_payment_reasons_vl iprv where iprv.payment_reason_code = aii.payment_reason_code)) payment_reason, xm.payment_reason_comments, xm.payment_group, --xm.payment_priority, xm.invoice_awt_group, xm.payment_awt_group, --xm.ussgl_transaction_code, xm.internal_recording_date, xm.supplier_tax_invoice_number, xm.supplier_tax_invoice_date, xm.supplier_tax_exchange_rate, -- xm.line_number, xm.line_type, xm.line_amount, xm.line_description, xm.quantity, xm.uom, xm.unit_price, -- xm.line_prorate_group, xm.prorate_flag, xm.distribution_line_number, -- xm.distribution_account_alias, xm.distribution_account, xm.distribution_percent, xm.distribution_amount, 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.inventory_item, xm.item_description, xm.manufacturer, xm.model_number, xm.serial_number, xm.warranty_number, xm.track_as_asset, xm.asset_book, xm.asset_category, -- 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.taxation_country, xm.tax_classification, xm.primary_intended_use, xm.ship_to_location, xm.product_fiscal_classification, xm.fiscal_classification, xm.business_category, xm.product_type, xm.product_category, -- tax line only columns xm.tax_regime, xm.tax, xm.tax_status, xm.tax_jurisdiction, xm.tax_rate_name, xm.tax_rate, -- xm.assessable_value, xm.line_invoice_awt_group, xm.line_payment_awt_group, -- xm.bank_charge_bearer, xm.remittance_message1, xm.remittance_message2, xm.remittance_message3, xm.unique_remittance_identifier, xm.uri_check_digit, -- xm.invoice_reference_1, xm.invoice_reference_2, xm.invoice_reference_key1, xm.invoice_reference_key2, xm.invoice_reference_key3, xm.invoice_reference_key4, xm.invoice_reference_key5, xm.line_reference_1, xm.line_reference_2, xm.line_reference_key1, xm.line_reference_key2, xm.line_reference_key3, xm.line_reference_key4, xm.line_reference_key5, -- 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.dist_attribute_category, xm.ap_inv_dist_attribute1, xm.ap_inv_dist_attribute2, xm.ap_inv_dist_attribute3, xm.ap_inv_dist_attribute4, xm.ap_inv_dist_attribute5, xm.ap_inv_dist_attribute6, xm.ap_inv_dist_attribute7, xm.ap_inv_dist_attribute8, xm.ap_inv_dist_attribute9, xm.ap_inv_dist_attribute10, xm.ap_inv_dist_attribute11, xm.ap_inv_dist_attribute12, xm.ap_inv_dist_attribute13, xm.ap_inv_dist_attribute14, xm.ap_inv_dist_attribute15, xm.attachment_category_, xm.attachment_title_, xm.attachment_description_, xm.attachment_type_, xm.attachment_content_, xm.attachment_file_id_, xm.upload_row &il_columns_reporting from xxen_ap_invoice_upload_0715_u xm, ap_invoice_lines_interface aili, ap_invoices_interface aii where xm.inv_int_id = aili.invoice_id (+) and xm.line_int_id = aili.invoice_line_id (+) and aili.invoice_id = aii.invoice_id (+) ) Lexical &success_with_query ,q_success_inv as ( select /*+ inline */ aia.invoice_id, alc.displayed_field source, haouv.name operating_unit, asu.vendor_name supplier_name, asu.segment1 supplier_number, assa.vendor_site_code supplier_site, xxen_util.meaning(aia.invoice_type_lookup_code,'INVOICE TYPE',200) invoice_type, (select fdsc.name from fnd_doc_sequence_categories fdsc where fdsc.application_id = 200 and fdsc.table_name in ('AP_INVOICES','AP_INVOICES_ALL') and fdsc.code = aia.doc_category_code) document_category, aia.invoice_num invoice_number, aia.description invoice_description, (select pha.segment1 from po_headers_all pha where pha.po_header_id = nvl(aia.po_header_id,aia.quick_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, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = aia.accts_pay_code_combination_id) liability_account, 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, (select ipmv.payment_method_name from iby_payment_methods_vl ipmv where ipmv.payment_method_code = aia.payment_method_code) payment_method, (select idcv.meaning from iby_delivery_channels_vl idcv where idcv.delivery_channel_code = aia.delivery_channel_code) payment_delivery_channel, (select iprv.meaning from iby_payment_reasons_vl iprv where iprv.payment_reason_code = aia.payment_reason_code) payment_reason, aia.payment_reason_comments, (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, (select aag.name from ap_awt_groups aag where aag.group_id = aia.awt_group_id) payment_awt_group, --aia.ussgl_transaction_code, aia.tax_invoice_recording_date internal_recording_date, aia.supplier_tax_invoice_number, aia.supplier_tax_invoice_date, aia.supplier_tax_exchange_rate, -- Line aila.line_number, xxen_util.meaning(aila.line_type_lookup_code,'INVOICE LINE TYPE',200) line_type, aila.amount line_amount, aila.description line_description, aila.quantity_invoiced quantity, aila.unit_meas_lookup_code uom, aila.unit_price, -- aila.line_group_number line_prorate_group, xxen_util.meaning(aila.prorate_across_all_items,'YES_NO',0) prorate_flag, nvl(aida.distribution_line_number,1) distribution_line_number, -- (select fsfa.alias_name from fnd_shorthand_flex_aliases fsfa, gl_code_combinations_kfv gcck where nvl(aida.dist_code_combination_id,aila.default_dist_ccid) = gcck.code_combination_id and 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, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where nvl(aida.dist_code_combination_id,aila.default_dist_ccid) = gcck.code_combination_id) distribution_account, aida.amount distribution_amount, (select adsa.distribution_set_name from ap_distribution_sets_all adsa where adsa.distribution_set_id = aila.distribution_set_id and adsa.org_id = aila.org_id) distribution_set, -- (select hecv.full_name || ' (' || hecv.employee_num || ')' from hr_employees_current_v hecv where hecv.employee_id = aila.requester_id) requester, (select pha.segment1 from po_headers_all pha where pha.po_header_id = aila.po_header_id) po_number, (select pra.release_num from po_releases_all pra where pra.po_release_id = aila.po_release_id) po_release_num, (select pla.line_num from po_lines_all pla where pla.po_line_id = aila.po_line_id) po_line_num, (select plla.shipment_num from po_line_locations_all plla where plla.line_location_id = aila.po_line_location_id) po_shipment_num, (select pda.distribution_num from po_distributions_all pda where pda.po_distribution_id = aila.po_distribution_id) po_distribution_num, (select rsh.receipt_num from rcv_shipment_headers rsh, rcv_shipment_lines rsl where rsh.shipment_header_id = rsl.shipment_header_id and rsl.shipment_line_id = aila.rcv_shipment_line_id) po_receipt_num, (select rsl.line_num from rcv_shipment_lines rsl where rsl.shipment_line_id = aila.rcv_shipment_line_id) po_receipt_line_num, -- (select msiv.concatenated_segments from mtl_system_items_vl msiv where msiv.inventory_item_id = aila.inventory_item_id and msiv.organization_id = fsp.inventory_organization_id) inventory_item, aila.item_description, aila.manufacturer, aila.model_number, aila.serial_number, aila.warranty_number, xxen_util.meaning(aila.assets_tracking_flag,'YES_NO',0) track_as_asset, (select fbc.book_type_name from fa_book_controls fbc where fbc.book_type_code = aila.asset_book_type_code) asset_book, (select fck.concatenated_segments from fa_categories_b_kfv fck where fck.category_id = aila.asset_category_id) asset_category, -- (select ppa.segment1 from pa_projects_all ppa where nvl2(aida.invoice_distribution_id,aida.project_id,aila.project_id)=ppa.project_id) project, (select pt.task_number from pa_tasks pt where nvl2(aida.invoice_distribution_id,aida.task_id,aila.task_id)=pt.task_id) task, nvl2(aida.invoice_distribution_id,aida.expenditure_item_date,aila.expenditure_item_date) expenditure_item_date, nvl2(aida.invoice_distribution_id,aida.expenditure_type,aila.expenditure_type) expenditure_type, (select haouv_exp.name from hr_all_organization_units_vl haouv_exp where nvl2(aida.invoice_distribution_id,aida.expenditure_organization_id,aila.expenditure_organization_id)=haouv_exp.organization_id) expenditure_organization, nvl2(aida.invoice_distribution_id,aida.pa_quantity,aila.pa_quantity) project_quantity, -- tax aila.type_1099 income_tax_type, aila.income_tax_region, -- xm.taxation_country (select ft.territory_short_name from fnd_territories_vl ft where ft.territory_code = aia.taxation_country ) taxation_country, -- xm.tax_classification (select zicv.meaning from zx_input_classifications_v zicv where zicv.lookup_type = 'ZX_INPUT_CLASSIFICATIONS' and zicv.lookup_code = aila.tax_classification_code and (zicv.org_id = aila.org_id or zicv.org_id = -99) and zicv.enabled_flag = 'Y' and trunc(sysdate) between nvl(zicv.start_date_active, trunc(sysdate)) and nvl(zicv.end_date_active, trunc(sysdate)) and rownum <= 1 ) tax_classification, -- xm.primary_intended_use, (select zfiuv.classification_name from zx_fc_intended_use_v zfiuv where (zfiuv.country_code = aia.taxation_country or zfiuv.country_code is null) and trunc(sysdate) between nvl(zfiuv.effective_from,trunc(sysdate)) and nvl(zfiuv.effective_to,trunc(sysdate)) and trunc(sysdate) <= nvl(zfiuv.disable_date,trunc(sysdate)) and zfiuv.classification_code = aila.primary_intended_use and rownum <= 1 ) primary_intended_use, -- xm.ship_to_location, (select hlat.location_code from hr_locations_all_tl hlat where hlat.location_id = aila.ship_to_location_id and hlat.language = userenv('LANG') and rownum <= 1 ) ship_to_location, -- xm.product_fiscal_classification, (select zfpcv.classification_name from zx_fc_product_fiscal_v zfpcv where (zfpcv.country_code = aia.taxation_country or zfpcv.country_code is null) and (zfpcv.effective_to >= trunc(sysdate) or zfpcv.effective_to is null) and zfpcv.classification_code = aila.product_fisc_classification and rownum <= 1 ) product_fiscal_classification, -- xm.fiscal_classification, (select zfudv.classification_name from zx_fc_user_defined_v zfudv where (zfudv.country_code =aia.taxation_country or zfudv.country_code is null) and trunc(sysdate) between nvl(zfudv.effective_from,trunc(sysdate)) and nvl(zfudv.effective_to,trunc(sysdate)) and zfudv.classification_code = aila.user_defined_fisc_class and rownum <= 1 ) fiscal_classification, -- xm.business_category, (select zfbcv.classification_name from zx_fc_business_categories_v zfbcv where (zfbcv.country_code = aia.taxation_country or zfbcv.country_code is null) and trunc(sysdate) between nvl(zfbcv.effective_from,trunc(sysdate)) and nvl(zfbcv.effective_to,trunc(sysdate)) and zfbcv.application_id = 200 and zfbcv.entity_code = 'AP_INVOICES' and zfbcv.event_class_code IN ('STANDARD INVOICES','PREPAYMENT INVOICES','EXPENSE REPORTS') and zfbcv.classification_code = aila.trx_business_category and rownum <= 1 ) business_category, -- xm.product_type, (select zptv.classification_name from zx_product_types_v zptv where zptv.classification_code = aila.product_type and rownum <= 1 ) product_type, -- xm.product_category (select zfpcv.classification_name from zx_fc_product_categories_v zfpcv where (zfpcv.country_code = aia.taxation_country or zfpcv.country_code is null) and trunc(sysdate) between nvl(zfpcv.effective_from,trunc(sysdate)) and nvl(zfpcv.effective_to,trunc(sysdate)) and zfpcv.classification_code = aila.product_category and rownum <= 1 ) product_category, -- tax line only columns aila.tax_regime_code tax_regime, aila.tax, aila.tax_status_code tax_status, aila.tax_jurisdiction_code tax_jurisdiction, aila.tax_rate_code tax_rate_name, aila.tax_rate, -- aila.assessable_value, (select aag.name from ap_awt_groups aag where aag.group_id = aila.awt_group_id) line_invoice_awt_group, (select aag.name from ap_awt_groups aag where aag.group_id = aila.awt_group_id) line_payment_awt_group, -- (select flvv.meaning from fnd_lookup_values_vl flvv where flvv.lookup_type='IBY_BANK_CHARGE_BEARER' and flvv.view_application_id = 0 and flvv.lookup_code = aia.bank_charge_bearer) bank_charge_bearer, aia.remittance_message1, aia.remittance_message2, aia.remittance_message3, aia.unique_remittance_identifier, aia.uri_check_digit, -- aia.reference_1 invoice_reference_1, aia.reference_2 invoice_reference_2, aia.reference_key1 invoice_reference_key1, aia.reference_key2 invoice_reference_key2, aia.reference_key3 invoice_reference_key3, aia.reference_key4 invoice_reference_key4, aia.reference_key5 invoice_reference_key5, aila.reference_1 line_reference_1, aila.reference_2 line_reference_2, aila.reference_key1 line_reference_key1, aila.reference_key2 line_reference_key2, aila.reference_key3 line_reference_key3, aila.reference_key4 line_reference_key4, aila.reference_key5 line_reference_key5, -- 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, xxen_util.display_flexfield_context(200,'AP_INVOICE_LINES',aila.attribute_category) line_attribute_category, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE1',aila.rowid,aila.attribute1) ap_inv_line_attribute1, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE2',aila.rowid,aila.attribute2) ap_inv_line_attribute2, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE3',aila.rowid,aila.attribute3) ap_inv_line_attribute3, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE4',aila.rowid,aila.attribute4) ap_inv_line_attribute4, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE5',aila.rowid,aila.attribute5) ap_inv_line_attribute5, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE6',aila.rowid,aila.attribute6) ap_inv_line_attribute6, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE7',aila.rowid,aila.attribute7) ap_inv_line_attribute7, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE8',aila.rowid,aila.attribute8) ap_inv_line_attribute8, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE9',aila.rowid,aila.attribute9) ap_inv_line_attribute9, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE10',aila.rowid,aila.attribute10) ap_inv_line_attribute10, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE11',aila.rowid,aila.attribute11) ap_inv_line_attribute11, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE12',aila.rowid,aila.attribute12) ap_inv_line_attribute12, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE13',aila.rowid,aila.attribute13) ap_inv_line_attribute13, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE14',aila.rowid,aila.attribute14) ap_inv_line_attribute14, xxen_util.display_flexfield_value(200,'AP_INVOICE_LINES',aila.attribute_category,'ATTRIBUTE15',aila.rowid,aila.attribute15) ap_inv_line_attribute15, xxen_util.display_flexfield_context(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category) dist_attribute_category, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE1',aida.rowid,aida.attribute1) ap_inv_dist_attribute1, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE2',aida.rowid,aida.attribute2) ap_inv_dist_attribute2, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE3',aida.rowid,aida.attribute3) ap_inv_dist_attribute3, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE4',aida.rowid,aida.attribute4) ap_inv_dist_attribute4, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE5',aida.rowid,aida.attribute5) ap_inv_dist_attribute5, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE6',aida.rowid,aida.attribute6) ap_inv_dist_attribute6, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE7',aida.rowid,aida.attribute7) ap_inv_dist_attribute7, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE8',aida.rowid,aida.attribute8) ap_inv_dist_attribute8, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE9',aida.rowid,aida.attribute9) ap_inv_dist_attribute9, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE10',aida.rowid,aida.attribute10) ap_inv_dist_attribute10, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE11',aida.rowid,aida.attribute11) ap_inv_dist_attribute11, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE12',aida.rowid,aida.attribute12) ap_inv_dist_attribute12, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE13',aida.rowid,aida.attribute13) ap_inv_dist_attribute13, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE14',aida.rowid,aida.attribute14) ap_inv_dist_attribute14, xxen_util.display_flexfield_value(200,'AP_INVOICE_DISTRIBUTIONS',aida.attribute_category,'ATTRIBUTE15',aida.rowid,aida.attribute15) ap_inv_dist_attribute15 from ap_invoices_all aia, ap_payment_schedules_all apsa, ap_invoice_lines_all aila, ap_invoice_distributions_all aida, financials_system_parameters fsp, hr_all_organization_units_vl haouv, ap_suppliers asu, ap_supplier_sites_all assa, ap_lookup_codes alc where aia.invoice_id = apsa.invoice_id (+) and aia.invoice_id = aila.invoice_id and aila.invoice_id = aida.invoice_id (+) and aila.line_number = aida.invoice_line_number (+) and aia.vendor_id = asu.vendor_id and aia.vendor_site_id = assa.vendor_site_id and aia.org_id = haouv.organization_id and aia.org_id = fsp.org_id and alc.lookup_type = 'SOURCE' and alc.lookup_code = aia.source and haouv.name = nvl(:p_operating_unit,haouv.name) and aia.invoice_id in ( select aia2.invoice_id from ap_invoices_all aia2 where aia2.creation_date >= sysdate - (3/24) and aia2.created_by = fnd_global.user_id union all select aia2.invoice_id from xxen_ap_invoice_upload_0715_u xm2, hr_operating_units hou2, ap_suppliers asu2, ap_invoices_all aia2 where xm2.add_to_existing_invoice is not null and xm2.operating_unit = hou2.name and xm2.supplier_number = asu2.segment1 and hou2.organization_id = aia2.org_id and asu2.vendor_id = aia2.vendor_id and xm2.invoice_number = aia2.invoice_num ) ) Order By x.operating_unit, x.invoice_date, x.supplier_name, x.invoice_number, x.line_number, x.distribution_line_number Success SQL select /* push_pred(inv) */ xm.action_, decode(inv.invoice_id,null,xxen_upload.status_meaning(xxen_upload.status_error),xxen_upload.status_meaning(xm.pstatus)) 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.inv_int_id, xm.line_int_id, xm.batch_name, xm.submit_validation, xm.invoice_calculate_tax, xm.invoice_inclusive_of_tax, -- 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.document_category,inv.document_category) document_category, decode(inv.invoice_id,null,xm.invoice_number,inv.invoice_number) invoice_number, xm.add_to_existing_invoice, 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.liability_account,inv.liability_account) liability_account, 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_delivery_channel,inv.payment_delivery_channel) payment_delivery_channel, decode(inv.invoice_id,null,xm.payment_reason,inv.payment_reason) payment_reason, decode(inv.invoice_id,null,xm.payment_reason_comments,inv.payment_reason_comments) payment_reason_comments, 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.payment_awt_group,inv.payment_awt_group) payment_awt_group, --decode(inv.invoice_id,null,xm.ussgl_transaction_code,inv.ussgl_transaction_code) ussgl_transaction_code, decode(inv.invoice_id,null,xm.internal_recording_date,inv.internal_recording_date) internal_recording_date, decode(inv.invoice_id,null,xm.supplier_tax_invoice_number,inv.supplier_tax_invoice_number) supplier_tax_invoice_number, decode(inv.invoice_id,null,xm.supplier_tax_invoice_date,inv.supplier_tax_invoice_date) supplier_tax_invoice_date, decode(inv.invoice_id,null,xm.supplier_tax_exchange_rate,inv.supplier_tax_exchange_rate) supplier_tax_exchange_rate, -- 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.uom,inv.uom) uom, decode(inv.invoice_id,null,xm.unit_price,inv.unit_price) unit_price, -- decode(inv.invoice_id,null,xm.line_prorate_group,inv.line_prorate_group) line_prorate_group, decode(inv.invoice_id,null,xm.prorate_flag,inv.prorate_flag) prorate_flag, decode(inv.invoice_id,null,xm.distribution_line_number,inv.distribution_line_number) distribution_line_number, -- 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, xm.distribution_percent, decode(inv.invoice_id,null,xm.distribution_amount,inv.distribution_amount) distribution_amount, decode(inv.invoice_id,null,xm.distribution_set,inv.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.inventory_item,inv.inventory_item) inventory_item, decode(inv.invoice_id,null,xm.item_description,inv.item_description) item_description, decode(inv.invoice_id,null,xm.manufacturer,inv.manufacturer) manufacturer, decode(inv.invoice_id,null,xm.model_number,inv.model_number) model_number, decode(inv.invoice_id,null,xm.serial_number,inv.serial_number) serial_number, decode(inv.invoice_id,null,xm.warranty_number,inv.warranty_number) warranty_number, decode(inv.invoice_id,null,xm.track_as_asset,inv.track_as_asset) track_as_asset, decode(inv.invoice_id,null,xm.asset_book,inv.asset_book) asset_book, decode(inv.invoice_id,null,xm.asset_category,inv.asset_category) asset_category, -- 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.taxation_country,inv.taxation_country) taxation_country, decode(inv.invoice_id,null,xm.tax_classification,inv.tax_classification) tax_classification, decode(inv.invoice_id,null,xm.primary_intended_use,inv.primary_intended_use) primary_intended_use, decode(inv.invoice_id,null,xm.ship_to_location,inv.ship_to_location) ship_to_location, decode(inv.invoice_id,null,xm.product_fiscal_classification,inv.product_fiscal_classification) product_fiscal_classification, decode(inv.invoice_id,null,xm.fiscal_classification,inv.fiscal_classification) fiscal_classification, decode(inv.invoice_id,null,xm.business_category,inv.business_category) business_category, decode(inv.invoice_id,null,xm.product_type,inv.product_type) product_type, decode(inv.invoice_id,null,xm.product_category,inv.product_category) product_category, -- tax line only columns decode(inv.invoice_id,null,xm.tax_regime,inv.tax_regime) tax_regime, decode(inv.invoice_id,null,xm.tax,inv.tax) tax, decode(inv.invoice_id,null,xm.tax_status,inv.tax_status) tax_status, decode(inv.invoice_id,null,xm.tax_jurisdiction,inv.tax_jurisdiction) tax_jurisdiction, decode(inv.invoice_id,null,xm.tax_rate_name,inv.tax_rate_name) tax_rate_name, decode(inv.invoice_id,null,xm.tax_rate,inv.tax_rate) tax_rate, -- decode(inv.invoice_id,null,xm.assessable_value,inv.assessable_value) assessable_value, 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_payment_awt_group,inv.line_payment_awt_group) line_payment_awt_group, -- decode(inv.invoice_id,null,xm.bank_charge_bearer,inv.bank_charge_bearer) bank_charge_bearer, decode(inv.invoice_id,null,xm.remittance_message1,inv.remittance_message1) remittance_message1, decode(inv.invoice_id,null,xm.remittance_message2,inv.remittance_message2) remittance_message2, decode(inv.invoice_id,null,xm.remittance_message3,inv.remittance_message3) remittance_message3, decode(inv.invoice_id,null,xm.unique_remittance_identifier,inv.unique_remittance_identifier) unique_remittance_identifier, decode(inv.invoice_id,null,xm.uri_check_digit,inv.uri_check_digit) uri_check_digit, -- decode(inv.invoice_id,null,xm.invoice_reference_1,inv.invoice_reference_1) invoice_reference_1, decode(inv.invoice_id,null,xm.invoice_reference_2,inv.invoice_reference_2) invoice_reference_2, decode(inv.invoice_id,null,xm.invoice_reference_key1,inv.invoice_reference_key1) invoice_reference_key1, decode(inv.invoice_id,null,xm.invoice_reference_key2,inv.invoice_reference_key2) invoice_reference_key2, decode(inv.invoice_id,null,xm.invoice_reference_key3,inv.invoice_reference_key3) invoice_reference_key3, decode(inv.invoice_id,null,xm.invoice_reference_key4,inv.invoice_reference_key4) invoice_reference_key4, decode(inv.invoice_id,null,xm.invoice_reference_key5,inv.invoice_reference_key5) invoice_reference_key5, 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.line_reference_key1,inv.line_reference_key1) line_reference_key1, decode(inv.invoice_id,null,xm.line_reference_key2,inv.line_reference_key2) line_reference_key2, decode(inv.invoice_id,null,xm.line_reference_key3,inv.line_reference_key3) line_reference_key3, decode(inv.invoice_id,null,xm.line_reference_key4,inv.line_reference_key4) line_reference_key4, decode(inv.invoice_id,null,xm.line_reference_key5,inv.line_reference_key5) line_reference_key5, -- 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, decode(inv.invoice_id,null,xm.dist_attribute_category,inv.dist_attribute_category) dist_attribute_category, decode(inv.invoice_id,null,xm.ap_inv_dist_attribute1,inv.ap_inv_dist_attribute1) ap_inv_dist_attribute1, decode(inv.invoice_id,null,xm.ap_inv_dist_attribute2,inv.ap_inv_dist_attribute2) ap_inv_dist_attribute2, decode(inv.invoice_id,null,xm.ap_inv_dist_attribute3,inv.ap_inv_dist_attribute3) ap_inv_dist_attribute3, decode(inv.invoice_id,null,xm.ap_inv_dist_attribute4,inv.ap_inv_dist_attribute4) ap_inv_dist_attribute4, decode(inv.invoice_id,null,xm.ap_inv_dist_attribute5,inv.ap_inv_dist_attribute5) ap_inv_dist_attribute5, decode(inv.invoice_id,null,xm.ap_inv_dist_attribute6,inv.ap_inv_dist_attribute6) ap_inv_dist_attribute6, decode(inv.invoice_id,null,xm.ap_inv_dist_attribute7,inv.ap_inv_dist_attribute7) ap_inv_dist_attribute7, decode(inv.invoice_id,null,xm.ap_inv_dist_attribute8,inv.ap_inv_dist_attribute8) ap_inv_dist_attribute8, decode(inv.invoice_id,null,xm.ap_inv_dist_attribute9,inv.ap_inv_dist_attribute9) ap_inv_dist_attribute9, decode(inv.invoice_id,null,xm.ap_inv_dist_attribute10,inv.ap_inv_dist_attribute10) ap_inv_dist_attribute10, decode(inv.invoice_id,null,xm.ap_inv_dist_attribute11,inv.ap_inv_dist_attribute11) ap_inv_dist_attribute11, decode(inv.invoice_id,null,xm.ap_inv_dist_attribute12,inv.ap_inv_dist_attribute12) ap_inv_dist_attribute12, decode(inv.invoice_id,null,xm.ap_inv_dist_attribute13,inv.ap_inv_dist_attribute13) ap_inv_dist_attribute13, decode(inv.invoice_id,null,xm.ap_inv_dist_attribute14,inv.ap_inv_dist_attribute14) ap_inv_dist_attribute14, decode(inv.invoice_id,null,xm.ap_inv_dist_attribute15,inv.ap_inv_dist_attribute15) ap_inv_dist_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_, xm.upload_row &il_columns_success 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.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.line_number) = inv.line_number (+) and decode(xm.pstatus,xxen_upload.status_success,xm.line_type) = inv.line_type (+) and --a row of a split line shows its own distribution, a line uploaded on one row all of its distributions nvl(case when coalesce(xm.distribution_percent,xm.distribution_amount) is not null then nvl(xm.distribution_line_number,1) end,inv.distribution_line_number (+)) = inv.distribution_line_number (+)