APPS.JG_ZZ_SUMMARY_ALL_PKG dependencies on AP_INVOICES_ALL

Line 1689: ,AP_INVOICES_ALL AP

1685: ,SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT_STANDARD
1686: FROM
1687: JG_ZZ_VAT_TRX_DETAILS JZVTD
1688: ,JG_ZZ_VAT_REP_STATUS JZVRS
1689: ,AP_INVOICES_ALL AP
1690: WHERE
1691: JZVRS.VAT_REPORTING_ENTITY_ID in
1692: (p_vat_rep_entity_id, p_vat_rep_entity_id2,
1693: p_vat_rep_entity_id3, p_vat_rep_entity_id4,

Line 1738: AP_INVOICES_ALL APINV,

1734: SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR,JZVTD.TAX_AMT)) VAT_AMOUNT_IMPORT,
1735: SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT_IMPORT
1736: FROM JG_ZZ_VAT_TRX_DETAILS JZVTD,
1737: JG_ZZ_VAT_REP_STATUS JZVRS,
1738: AP_INVOICES_ALL APINV,
1739: AP_INVOICE_LINES_ALL APINVL,
1740: ZX_LINES ZXL
1741: WHERE JZVRS.SOURCE = 'AP'
1742: AND JZVRS.VAT_REPORTING_ENTITY_ID in

Line 1790: AP_INVOICES_ALL APINV

1786: SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR,JZVTD.TAX_AMT)) VAT_AMOUNT,
1787: SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT
1788: FROM JG_ZZ_VAT_TRX_DETAILS JZVTD,
1789: JG_ZZ_VAT_REP_STATUS JZVRS,
1790: AP_INVOICES_ALL APINV
1791: WHERE JZVRS.SOURCE = 'AP'
1792: AND JZVRS.VAT_REPORTING_ENTITY_ID in
1793: (p_vat_rep_entity_id, p_vat_rep_entity_id2,
1794: p_vat_rep_entity_id3, p_vat_rep_entity_id4,