eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JG_ZZ_SUMMARY_AP_PKG dependencies on AP_INVOICES_ALL

Line 38: FROM ap_invoices_all INV

34: l_cleared_amount NUMBER;
35: CURSOR c_amount_remaining
36: IS
37: SELECT nvl(SUM(amount_remaining), -9999) amount_remaining
38: FROM ap_invoices_all INV
39: ,ap_invoice_payments_all PAY
40: ,ap_checks_all CHECKS
41: ,ap_payment_schedules_all APS
42: WHERE APS.invoice_id = inv.invoice_id

Line 60: FROM ap_invoices_all

56: CURSOR c_inv_amount
57: IS
58: SELECT nvl(base_amount, invoice_amount) invoice_amount
59: ,nvl(exchange_rate, 1) exchange_rate
60: FROM ap_invoices_all
61: WHERE invoice_id = pn_inv_id;
62:
63: CURSOR c_cleared_amount
64: IS

Line 66: FROM ap_invoices_all INV

62:
63: CURSOR c_cleared_amount
64: IS
65: SELECT NVL(SUM(checks.amount),0)
66: FROM ap_invoices_all INV
67: ,ap_invoice_payments_all PAY
68: ,ap_checks_all CHECKS
69: WHERE pn_inv_id = inv.invoice_id
70: AND checks.check_id = pay.check_id

Line 77: FROM po_vendors pv, ap_invoices_all inv

73: AND trunc(checks.cleared_date) <= pd_end_date;
74: CURSOR c_sbe_flag
75: IS
76: SELECT nvl(pv.small_business_flag,'N') small_business_flag
77: FROM po_vendors pv, ap_invoices_all inv
78: WHERE inv.invoice_id = pn_inv_id
79: AND inv.vendor_id = pv.vendor_id;
80: BEGIN
81:

Line 731: ,ap_invoices_all apinv

727: END) class
728: ,0 mark_trx_flag
729: FROM jg_zz_vat_trx_details jzvtd
730: ,jg_zz_vat_rep_status jzvrs
731: ,ap_invoices_all apinv
732: WHERE jzvrs.source='AP'
733: AND jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
734: AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD
735: AND JZVRS.REPORTING_STATUS_ID = JZVTD.REPORTING_STATUS_ID

Line 780: ,ap_invoices_all apinv

776: , 'R' class
777: ,0 mark_trx_flag
778: FROM jg_zz_vat_trx_details jzvtd
779: ,jg_zz_vat_rep_status jzvrs
780: ,ap_invoices_all apinv
781: ,ap_invoice_lines_all apinvl
782: ,zx_lines zxl
783: WHERE jzvrs.source='AP'
784: AND jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID

Line 831: ,ap_invoices_all apinv

827: ,'K' class
828: ,0 mark_trx_flag
829: FROM jg_zz_vat_trx_details jzvtd
830: ,jg_zz_vat_rep_status jzvrs
831: ,ap_invoices_all apinv
832: WHERE jzvrs.source='AP'
833: AND jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
834: AND JZVTD.IL_VAT_REP_STATUS_ID = l_rep_status_id
835: -- AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD -- No period check

Line 873: ,ap_invoices_all apinv

869: ,'K' class
870: ,1 mark_trx_flag
871: FROM jg_zz_vat_trx_details jzvtd
872: ,jg_zz_vat_rep_status jzvrs
873: ,ap_invoices_all apinv
874: WHERE jzvrs.source='AP'
875: AND jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
876: --AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD ( Other periods also possible)
877: AND JZVTD.IL_VAT_REP_STATUS_ID = -999

Line 924: ,ap_invoices_all apinv

920: ,sum(DECODE(tax_recoverable_flag,'Y',decode(jzvtd.reporting_code,'VAT-S',Round(nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt),G_PRECISION),0),0)) vat_other_trx
921: ,'S' class
922: FROM jg_zz_vat_trx_details jzvtd
923: ,jg_zz_vat_rep_status jzvrs
924: ,ap_invoices_all apinv
925: WHERE jzvrs.source='AP'
926: AND jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
927: AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD
928: AND JZVRS.REPORTING_STATUS_ID = JZVTD.REPORTING_STATUS_ID

Line 970: ,ap_invoices_all apinv

966: 'VAT-KS',Round(nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt),G_PRECISION),0),0)) vat_other_trx
967: ,'P' class
968: FROM jg_zz_vat_trx_details jzvtd
969: ,jg_zz_vat_rep_status jzvrs
970: ,ap_invoices_all apinv
971: WHERE jzvrs.source='AP'
972: AND jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
973: AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD
974: AND JZVRS.REPORTING_STATUS_ID = JZVTD.REPORTING_STATUS_ID

Line 1021: ,ap_invoices_all apinv

1017: 'VAT-RS',Round(nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt),G_PRECISION),0),0)) vat_other_trx
1018: , 'I' class
1019: FROM jg_zz_vat_trx_details jzvtd
1020: ,jg_zz_vat_rep_status jzvrs
1021: ,ap_invoices_all apinv
1022: ,ap_invoice_lines_all apinvl
1023: ,zx_lines zxl
1024: WHERE jzvrs.source='AP'
1025: AND jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID

Line 1743: FROM ap_invoices_all INV, ap_invoice_payments_all PAY, ap_checks_all CHECKS

1739:
1740: -- Exclude paid transactions for the
1741: -- Annex Report
1742: l_cleared_select := '(SELECT NVL((SELECT NVL(SUM(pay.payment_base_amount),0)
1743: FROM ap_invoices_all INV, ap_invoice_payments_all PAY, ap_checks_all CHECKS
1744: WHERE inv.invoice_id = pay.invoice_id
1745: AND checks.check_id = pay.check_id
1746: AND jg_info_n5 = inv.invoice_id
1747: AND checks.status_lookup_code IN ( ''CLEARED'' , ''RECONCILED'' , ''CLEARED BUT UNACCOUNTED'', ''RECONCILED UNACCOUNTED'' )';

Line 1751: FROM ap_invoices_all INV1

1747: AND checks.status_lookup_code IN ( ''CLEARED'' , ''RECONCILED'' , ''CLEARED BUT UNACCOUNTED'', ''RECONCILED UNACCOUNTED'' )';
1748:
1749: l_cleared_select1 := '* decode(jg_info_n15, NULL, jg_info_n8, jg_info_n2)
1750: / (SELECT inv1.base_amount
1751: FROM ap_invoices_all INV1
1752: WHERE jg_info_n5 = inv1.invoice_id ),0) from dual )';
1753:
1754: l_unpaid_amt_select := 'AND (SELECT nvl(sum(amount_remaining),99999)
1755: FROM ap_invoices_all INV,

Line 1755: FROM ap_invoices_all INV,

1751: FROM ap_invoices_all INV1
1752: WHERE jg_info_n5 = inv1.invoice_id ),0) from dual )';
1753:
1754: l_unpaid_amt_select := 'AND (SELECT nvl(sum(amount_remaining),99999)
1755: FROM ap_invoices_all INV,
1756: ap_invoice_payments_all PAY,
1757: ap_checks_all CHECKS,
1758: ap_payment_schedules_all APS
1759: WHERE APS.invoice_id = inv.invoice_id