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 518: ,ap_invoices_all apinv

514: ,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
515: ,'S' class
516: FROM jg_zz_vat_trx_details jzvtd
517: ,jg_zz_vat_rep_status jzvrs
518: ,ap_invoices_all apinv
519: WHERE jzvrs.source='AP'
520: AND jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
521: AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD
522: AND JZVRS.REPORTING_STATUS_ID = JZVTD.REPORTING_STATUS_ID

Line 564: ,ap_invoices_all apinv

560: 'VAT-KS',Round(nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt),G_PRECISION),0),0)) vat_other_trx
561: ,'P' class
562: FROM jg_zz_vat_trx_details jzvtd
563: ,jg_zz_vat_rep_status jzvrs
564: ,ap_invoices_all apinv
565: WHERE jzvrs.source='AP'
566: AND jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
567: AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD
568: AND JZVRS.REPORTING_STATUS_ID = JZVTD.REPORTING_STATUS_ID

Line 616: ,ap_invoices_all apinv

612: 'VAT-RS',Round(nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt),G_PRECISION),0),0)) vat_other_trx
613: , 'I' class
614: FROM jg_zz_vat_trx_details jzvtd
615: ,jg_zz_vat_rep_status jzvrs
616: ,ap_invoices_all apinv
617: ,ap_invoice_lines_all apinvl
618: ,zx_lines zxl
619: WHERE jzvrs.source='AP'
620: AND jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID

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

1140:
1141: -- Exclude paid transactions for the
1142: -- Annex Report
1143: l_cleared_select := '(SELECT NVL((SELECT NVL(SUM(pay.payment_base_amount),0)
1144: FROM ap_invoices_all INV, ap_invoice_payments_all PAY, ap_checks_all CHECKS
1145: WHERE inv.invoice_id = pay.invoice_id
1146: AND checks.check_id = pay.check_id
1147: AND jg_info_n5 = inv.invoice_id
1148: AND checks.status_lookup_code IN ( ''CLEARED'' , ''RECONCILED'' , ''CLEARED BUT UNACCOUNTED'', ''RECONCILED UNACCOUNTED'' )';

Line 1152: FROM ap_invoices_all INV1

1148: AND checks.status_lookup_code IN ( ''CLEARED'' , ''RECONCILED'' , ''CLEARED BUT UNACCOUNTED'', ''RECONCILED UNACCOUNTED'' )';
1149:
1150: l_cleared_select1 := '* decode(jg_info_n15, NULL, jg_info_n8, jg_info_n2)
1151: / (SELECT inv1.base_amount
1152: FROM ap_invoices_all INV1
1153: WHERE jg_info_n5 = inv1.invoice_id ),0) from dual )';
1154:
1155: l_unpaid_amt_select := 'AND (SELECT nvl(sum(amount_remaining),99999)
1156: FROM ap_invoices_all INV,

Line 1156: FROM ap_invoices_all INV,

1152: FROM ap_invoices_all INV1
1153: WHERE jg_info_n5 = inv1.invoice_id ),0) from dual )';
1154:
1155: l_unpaid_amt_select := 'AND (SELECT nvl(sum(amount_remaining),99999)
1156: FROM ap_invoices_all INV,
1157: ap_invoice_payments_all PAY,
1158: ap_checks_all CHECKS,
1159: ap_payment_schedules_all APS
1160: WHERE APS.invoice_id = inv.invoice_id