AP Invoice Upload
Description
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
/* &report_table_name */ select x.* from ( with q_dual as (select * from dual) -- dummy to allow the lexical to follow &processed_with_queries select null action_, null status_, null message_, null request_id_, null row_id, null batch_name, null submit_validation, :p_validate_dff validate_dff, 'Invoice Source' source, 'OU Name' operating_unit, 'Standard' invoice_type, 'VEND_NAME' supplier_name, '99999' supplier_number, 'VEND_SITE_CODE' supplier_site, trunc(sysdate) invoice_date, 'INV#0001' invoice_number, 100 invoice_amount, 'USD' invoice_currency, '30 Days' terms, trunc(sysdate) gl_date, 'USD' payment_currency, 'Check' payment_method, 1 line_number, 'Item' line_type, 100 line_amount, 'Line Description' line_description, 'Distribution Alias' distribution_account_alias, '00-000-0000-0000-000' distribution_account, 'Tax Class code' tax_classification, 'Primary Intended Use' primary_intended_use, 'Ship To Location' ship_to_location, 'Prod Fix Class' product_fiscal_classification, 'Fiscal Class' fiscal_classification, 'Business Category' business_category, 'Product Type' product_type, 'Product Category' product_category, -- null invoice_attribute_category, null ap_inv_attribute1, null ap_inv_attribute2, null ap_inv_attribute3, null ap_inv_attribute4, null ap_inv_attribute5, null ap_inv_attribute6, null ap_inv_attribute7, null ap_inv_attribute8, null ap_inv_attribute9, null ap_inv_attribute10, null ap_inv_attribute11, null ap_inv_attribute12, null ap_inv_attribute13, null ap_inv_attribute14, null ap_inv_attribute15, null line_attribute_category, null ap_inv_line_attribute1, null ap_inv_line_attribute2, null ap_inv_line_attribute3, null ap_inv_line_attribute4, null ap_inv_line_attribute5, null ap_inv_line_attribute6, null ap_inv_line_attribute7, null ap_inv_line_attribute8, null ap_inv_line_attribute9, null ap_inv_line_attribute10, null ap_inv_line_attribute11, null ap_inv_line_attribute12, null ap_inv_line_attribute13, null ap_inv_line_attribute14, null ap_inv_line_attribute15 from q_dual where :p_operating_unit = :p_operating_unit and :p_source = :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 1=0 ¬_use_first_block &processed_run_query &processed_run ) x order by x.operating_unit, x.invoice_date, x.supplier_name, x.invoice_number, x.line_number |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Operating Unit |
|
LOV | |
Invoice Source |
|
LOV | |
Batch Name |
|
Char | |
GL Date |
|
Date | |
Submit Invoice Validation |
|
LOV Oracle |