Thisismarkantony.com

Query for AP withholding Tax details AP_AWT_TAX_RATES SELECT DISTINCT awt.* FROM ap_tax_codes_all atc, ap_awt_tax_rates_all awt WHERE awt.tax_name = atc.name AND atc.tax_id IN ( SELECT DISTINCT aid.tax_code_id tax_code_id FROM ap_invoice_distributions_all aid, ap_tax_codes_all atc WHERE aid.tax_code_id = atc.tax_id AND aid.tax_code_id IS NOT NULL AND atc.tax_type = 'AWT' AND aid.invoice_id = :P_INVOICE_ID ) UNION SELECT DISTINCT awt.* FROM ap_awt_tax_rates_all awt WHERE awt.tax_rate_id IN ( SELECT DISTINCT aid.awt_tax_rate_id FROM ap_invoice_distributions_all aid WHERE aid.awt_tax_rate_id IS NOT NULL AND aid.invoice_id = :P_INVOICE_ID ); AP_AWT_GROUPS SELECT DISTINCT awt.* FROM ap_awt_groups awt WHERE awt.group_id IN ( SELECT DISTINCT aid.awt_group_id FROM ap_invoice_distributions_all aid WHERE aid.awt_group_id IS NO...

AP Invoice payments details query AP_DOCUMENTS_PAYABLE SELECT * FROM AP_DOCUMENTS_PAYABLE WHERE calling_app_id = 200 AND calling_app_doc_unique_ref2 = :P_INVOICE_ID; AP_INVOICE_PAYMENTS_ALL SELECT DISTINCT aip.*, fnd_flex_ext.get_segs('SQLGL','GL#', '101' , aip.accts_pay_code_combination_id) "Accts Pay Account" FROM AP_INVOICE_PAYMENTS_ALL aip, AP_INVOICE_PAYMENTS_ALL aip2 WHERE aip2.check_id = aip.check_id AND aip2.invoice_id = :P_INVOICE_ID ORDER BY aip.check_id ASC, aip.invoice_payment_id ASC; AP_CHECKS_ALL SELECT * FROM AP_CHECKS_ALL WHERE check_id IN ( SELECT check_id FROM AP_INVOICE_PAYMENTS_ALL WHERE invoice_id = :P_INVOICE_ID ); AP_PAYMENT_DISTRIBUTIONS_ALL SELECT tab.* FROM AP_INVOICE_PAYMENTS_ALL aip, AP_PAYMENT_DISTRIBUTIONS_ALL tab WHERE aip.invoice_payment_id = tab.invoice_payment_id AND aip.invoice_id = :P_INVOICE_ID; AP_PAY...

SELECT GJH.name Journal_Name, GJB.name Batch_name, GJL.ACCOUNTED_CR, GJL.ACCOUNTED_DR, gcc.CONCATENATED_SEGMENTS, GJH.CREATED_BY, gjc.JE_CATEGORY_NAME, gl.NAME, GJH.CURRENCY_CODE, GJL.DESCRIPTION, GJB.STATUS FROM apps.GL_JE_HEADERS GJH, apps.GL_JE_LINES GJL, apps.GL_JE_BATCHES GJB, apps.GL_JE_CATEGORIES gjc, apps.gl_ledgers gl, apps.gl_code_combinations_kfv gcc WHERE GJH.JE_HEADER_ID=GJL.JE_HEADER_ID AND GJB.JE_BATCH_ID=GJH.JE_BATCH_ID and gcc.CODE_COMBINATION_ID=GJL.CODE_COMBINATION_ID and gjc.JE_CATEGORY_NAME=GJH.JE_CATEGORY and gl.LEDGER_ID=GJH.LEDGER_ID AND GJB.NAME LIKE 'GLbatchName%' and gjh.name like 'JournalHeaderName';