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.PAAPIMP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 885: UPDATE ap_invoice_distributions_all DIST

881: write_log(LOG, '......Paapimp is not running, do cleanup');
882: end if;
883: G_err_stage := 'UPDATING INVOICE DISTRIBUTIONS';
884:
885: UPDATE ap_invoice_distributions_all DIST
886: SET DIST.pa_addition_flag = 'N'
887: , DIST.request_id = G_REQUEST_ID
888: WHERE DIST.pa_addition_flag IN ('O','W')
889: AND DIST.posted_flag= 'Y' -- removed the append || '' for bug 13599091

Line 1792: FROM ap_invoice_distributions_All

1788:
1789: If is_self_assessed_tax = 'N' then
1790: SELECT prepay_amount_remaining
1791: INTO l_prepay_rem_amt
1792: FROM ap_invoice_distributions_All
1793: WHERE invoice_distribution_id = p_prepay_dist_id;
1794: else
1795: SELECT prepay_amount_remaining
1796: INTO l_prepay_rem_amt

Line 2023: UPDATE ap_invoice_distributions_all dist

2019: Pre Rel12 Upgrade should also be brought into Projects */
2020:
2021: write_log(LOG, 'Marking Historical Prepayments for processing...');
2022:
2023: UPDATE ap_invoice_distributions_all dist
2024: SET dist.pa_addition_flag = 'O',
2025: request_id = G_REQUEST_ID,
2026: last_update_date=SYSDATE,
2027: last_updated_by= G_USER_ID,

Line 2064: AP_Invoice_Distributions_all aid

2060: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))
2061: ))
2062: AND exists(SELECT inv.invoice_id
2063: FROM AP_INVOICES inv,
2064: AP_Invoice_Distributions_all aid
2065: WHERE aid.invoice_id = inv.invoice_id
2066: AND inv.invoice_type_lookup_code = 'PREPAYMENT'
2067: AND aid.historical_flag = 'Y'
2068: AND aid.pa_addition_flag = 'Y'

Line 2420: AP_Invoice_Distributions_all aid

2416: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))
2417: ))
2418: AND exists(SELECT inv.invoice_id
2419: FROM AP_INVOICES_ALL inv,
2420: AP_Invoice_Distributions_all aid
2421: WHERE aid.invoice_id = inv.invoice_id
2422: AND inv.invoice_type_lookup_code = 'PREPAYMENT'
2423: AND aid.historical_flag = 'Y'
2424: AND aid.pa_addition_flag = 'Y'

Line 2622: ap_invoice_distributions_all dist2

2618: EXISTS (
2619: SELECT NULL
2620: FROM ap_invoices_all inv,
2621: po_distributions_all PO,
2622: ap_invoice_distributions_all dist2
2623: WHERE inv.invoice_id = dist2.invoice_id
2624: AND nvl(po.distribution_type,'XXX') <> 'PREPAYMENT'
2625: AND dist2.invoice_id = DIST.invoice_id
2626: AND dist2.invoice_distribution_id = DIST.invoice_distribution_id

Line 2643: ap_invoice_distributions_all dist3

2639: OR
2640: EXISTS (
2641: SELECT NULL
2642: FROM ap_invoices_all inv1,
2643: ap_invoice_distributions_all dist3
2644: WHERE inv1.invoice_id = dist3.invoice_id
2645: AND inv1.invoice_id = dist.invoice_id
2646: AND inv1.invoice_type_lookup_code <> 'EXPENSE REPORT'
2647: AND (dist.reversal_flag = 'Y' or dist.cancellation_flag = 'Y' )

Line 2707: UPDATE ap_invoice_distributions_all dist

2703: Pre Rel12 Upgrade should also be brought into Projects */
2704:
2705: write_log(LOG, 'Marking PREPAYMENT invoices in Cash Based Acctng');
2706:
2707: UPDATE ap_invoice_distributions_all dist
2708: SET dist.pa_addition_flag = 'O',
2709: request_id = G_REQUEST_ID,
2710: last_update_date=SYSDATE,
2711: last_updated_by= G_USER_ID,

Line 2736: AP_Invoice_Distributions_all aid

2732: AND nvl(INV.source, 'xx' ) NOT IN (
2733: 'PA_IC_INVOICES','PA_COST_ADJUSTMENTS') ) /* Removed 'Oracle Project Accounting' */
2734: AND exists(SELECT inv.invoice_id
2735: FROM AP_INVOICES inv,
2736: AP_Invoice_Distributions_all aid
2737: WHERE aid.invoice_id = inv.invoice_id
2738: AND inv.invoice_type_lookup_code = 'PREPAYMENT'
2739: AND aid.historical_flag = 'Y'
2740: AND aid.pa_addition_flag = 'Y'

Line 2894: ap_invoice_distributions_all dist2

2890: AND EXISTS (
2891: SELECT NULL
2892: FROM ap_invoices_all inv,
2893: po_distributions_all PO,
2894: ap_invoice_distributions_all dist2
2895: WHERE inv.invoice_id = dist2.invoice_id
2896: AND nvl(po.distribution_type,'XXX') <> 'PREPAYMENT'
2897: AND dist2.invoice_id = DIST.invoice_id
2898: /*credit card txn enhancement, make sure this update doesn't pick tehm */

Line 3067: ap_invoice_distributions_all dist2

3063: EXISTS (
3064: SELECT NULL
3065: FROM ap_invoices_all inv,
3066: po_distributions_all PO,
3067: ap_invoice_distributions_all dist2
3068: WHERE inv.invoice_id = dist2.invoice_id
3069: AND nvl(po.distribution_type,'XXX') <> 'PREPAYMENT'
3070: AND dist2.invoice_id = DIST.invoice_id
3071: AND dist2.invoice_distribution_id = DIST.invoice_distribution_id

Line 3151: UPDATE ap_invoice_distributions_all dist

3147: Pre Rel12 Upgrade should also be brought into Projects */
3148:
3149: write_log(LOG, 'Marking Historical Prepayments for processing...');
3150:
3151: UPDATE ap_invoice_distributions_all dist
3152: SET dist.pa_addition_flag = 'O',
3153: request_id = G_REQUEST_ID,
3154: last_update_date=SYSDATE,
3155: last_updated_by= G_USER_ID,

Line 3179: AP_Invoice_Distributions_all aid

3175: AND nvl(INV.source, 'xx' ) NOT IN (
3176: 'PA_IC_INVOICES','PA_COST_ADJUSTMENTS') ) /* Removed 'Oracle Project Accounting' */
3177: AND exists(SELECT inv.invoice_id
3178: FROM AP_INVOICES_all inv,
3179: AP_Invoice_Distributions_all aid
3180: WHERE aid.invoice_id = inv.invoice_id
3181: AND inv.invoice_type_lookup_code = 'PREPAYMENT'
3182: AND aid.historical_flag = 'Y'
3183: AND aid.pa_addition_flag = 'Y'

Line 3335: ap_invoice_distributions_all dist2

3331: AND EXISTS (
3332: SELECT NULL
3333: FROM ap_invoices_all inv,
3334: po_distributions_all PO,
3335: ap_invoice_distributions_all dist2
3336: WHERE inv.invoice_id = dist2.invoice_id
3337: AND nvl(po.distribution_type,'XXX') <> 'PREPAYMENT'
3338: AND dist2.invoice_id = DIST.invoice_id
3339: /* credit card txn enhancement, make sure this update doesn't pick tehm */

Line 3669: UPDATE ap_invoice_distributions_all dist

3665: write_log(LOG,'Before bulk update of prepayment invoices');
3666:
3667: FORALL i IN l_invoice_id_tbl.FIRST..l_invoice_id_tbl.LAST
3668:
3669: UPDATE ap_invoice_distributions_all dist
3670: SET dist.pa_addition_flag = decode(l_insert_flag_tbl(i),'F','G','P','N')
3671: WHERE dist.invoice_id = l_invoice_id_tbl(i)
3672: AND dist.invoice_distribution_id = l_invoice_dist_id_tbl(i)
3673: AND dist.pa_addition_flag = 'O'

Line 4449: FROM ap_invoice_distributions_all

4445:
4446: IF l_is_self_assessed_tax_tbl(i) = 'N' then --Bug 13602288: Self Assessed Tax Changes
4447: SELECT nvl(historical_flag,'N')
4448: INTO l_prepay_hist_flag
4449: FROM ap_invoice_distributions_all
4450: WHERE invoice_distribution_id = l_prepay_dist_id_tbl(i);
4451: ELSE
4452: l_prepay_hist_flag := 'N';
4453: END IF;

Line 4460: FROM ap_invoice_distributions_all

4456:
4457: IF l_is_self_assessed_tax_tbl(i) = 'N' then --Bug 13602288: Self Assessed Tax Changes
4458: SELECT nvl(historical_flag,'N')
4459: INTO l_prepay_hist_flag
4460: FROM ap_invoice_distributions_all
4461: WHERE invoice_distribution_id = l_parent_rev_id_tbl(i);
4462: ELSE
4463: l_prepay_hist_flag := 'N';
4464: END IF;

Line 4566: FROM ap_invoice_distributions_all

4562: else
4563:
4564: SELECT nvl(historical_flag,'N')
4565: INTO l_historical_flag
4566: FROM ap_invoice_distributions_all
4567: WHERE invoice_id = l_invoice_id_tbl(i)
4568: AND invoice_distribution_id = l_parent_rev_id_tbl(i); --check the index on this table
4569:
4570: end if;

Line 5285: UPDATE ap_invoice_distributions_all dist

5281: write_log(LOG, G_err_stage);
5282:
5283: FORALL i IN l_sys_ref1_tbl.FIRST..l_sys_ref1_tbl.LAST
5284:
5285: UPDATE ap_invoice_distributions_all dist
5286: SET dist.pa_addition_flag = l_pa_addflag_tbl(i)
5287: ,dist.assets_addition_flag = decode(l_assets_addflag_tbl(i),'P','P',dist.assets_addition_flag)
5288: WHERE dist.invoice_id = l_sys_ref2_tbl(i)
5289: AND dist.invoice_distribution_id = l_sys_ref5_tbl(i)

Line 5315: from ap_invoice_distributions_all dist

5311: WHERE document_header_id = l_sys_ref2_tbl(i)
5312: AND document_distribution_id = l_sys_ref5_tbl(i)
5313: AND document_distribution_type <> 'SELF_ASSESSED_TAX' /*Bug 13602288: Self Assessed Tax Changes*/
5314: AND exists (select 'exist'
5315: from ap_invoice_distributions_all dist
5316: where dist.invoice_id =l_sys_ref2_tbl(i)
5317: and dist.invoice_distribution_id = l_sys_ref5_tbl(i)
5318: and dist.pa_addition_flag = 'Y'
5319: and dist.historical_flag = 'Y');

Line 5345: AP_Invoice_Distributions_all aid,

5341: WHERE hist.payment_history_id = dist.payment_history_id
5342: AND hist.posted_flag = 'Y')
5343: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
5344: FROM AP_INVOICES_ALL inv,
5345: AP_Invoice_Distributions_all aid,
5346: ap_invoice_payments_all aip
5347: WHERE inv.invoice_id = aip.invoice_id
5348: AND aid.invoice_id = inv.invoice_id
5349: AND aip.invoice_payment_id = dist.invoice_payment_id

Line 5612: AP_Invoice_Distributions_all aid,

5608: WHERE hist.payment_history_id = dist.payment_history_id
5609: AND hist.posted_flag = 'Y')
5610: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5611: FROM AP_INVOICES_ALL inv,
5612: AP_Invoice_Distributions_all aid,
5613: ap_invoice_payments_all aip
5614: WHERE inv.invoice_id = aip.invoice_id
5615: AND aid.invoice_id = inv.invoice_id
5616: AND aip.invoice_payment_id = dist.invoice_payment_id

Line 5654: AP_Invoice_Distributions_all aid,

5650: AND hist.posted_flag = 'Y')
5651: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5652: FROM AP_INVOICES_ALL inv,
5653: PO_Distributions_all PO,
5654: AP_Invoice_Distributions_all aid,
5655: ap_invoice_payments_all aip
5656: WHERE inv.invoice_id = aip.invoice_id
5657: AND aid.invoice_id = inv.invoice_id
5658: AND aip.invoice_payment_id = dist.invoice_payment_id

Line 5713: AP_Invoice_Distributions_all aid,

5709: AND hist.posted_flag = 'Y')
5710: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5711: FROM AP_INVOICES_ALL inv,
5712: PO_Distributions_all PO,
5713: AP_Invoice_Distributions_all aid,
5714: ap_invoice_payments_all aip
5715: WHERE inv.invoice_id = aip.invoice_id
5716: AND aid.invoice_id = inv.invoice_id
5717: AND aip.invoice_payment_id = dist.invoice_payment_id

Line 5769: AP_Invoice_Distributions_all aid,

5765: WHERE hist.payment_history_id = dist.payment_history_id
5766: AND hist.posted_flag = 'Y')
5767: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5768: FROM AP_INVOICES_ALL inv,
5769: AP_Invoice_Distributions_all aid,
5770: ap_invoice_payments_all aip
5771: WHERE inv.invoice_id = aip.invoice_id
5772: AND aid.invoice_id = inv.invoice_id
5773: AND aip.invoice_payment_id = dist.invoice_payment_id

Line 5807: AP_Invoice_Distributions_all aid,

5803: AND hist.posted_flag = 'Y')
5804: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5805: FROM AP_INVOICES_ALL inv,
5806: PO_Distributions_all PO,
5807: AP_Invoice_Distributions_all aid,
5808: ap_invoice_payments_all aip
5809: WHERE inv.invoice_id = aip.invoice_id
5810: AND aid.invoice_id = inv.invoice_id
5811: AND aip.invoice_payment_id = dist.invoice_payment_id

Line 5865: AP_Invoice_Distributions_all aid,

5861: AND hist.posted_flag = 'Y')
5862: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5863: FROM AP_INVOICES_ALL inv,
5864: PO_Distributions_all PO,
5865: AP_Invoice_Distributions_all aid,
5866: ap_invoice_payments_all aip
5867: WHERE inv.invoice_id = aip.invoice_id
5868: AND aid.invoice_id = inv.invoice_id
5869: AND aip.invoice_payment_id = dist.invoice_payment_id

Line 8876: UPDATE ap_invoice_distributions_all dist

8872:
8873: G_err_stage := 'Within calling lock_ap_invoice';
8874: write_log(LOG, G_err_stage);
8875:
8876: UPDATE ap_invoice_distributions_all dist
8877: SET dist.pa_addition_flag = 'L'
8878: WHERE dist.po_distribution_id = p_po_distribution_id
8879: AND dist.pa_addition_flag = 'N';
8880:

Line 8905: UPDATE ap_invoice_distributions_all dist

8901:
8902: G_err_stage := 'Within calling tieback_locked_invoice';
8903: write_log(LOG, G_err_stage);
8904:
8905: UPDATE ap_invoice_distributions_all dist
8906: SET dist.pa_addition_flag = 'N'
8907: WHERE dist.pa_addition_flag = 'L';
8908:
8909: l_num_rows := SQL%ROWCOUNT;

Line 8966: UPDATE ap_invoice_distributions_all apdist

8962: If g_body_debug_mode = 'Y' Then
8963: write_log(LOG, 'Updating empty invoice variance lines pa addtion flag to G for a project');
8964: End if;
8965:
8966: UPDATE ap_invoice_distributions_all apdist
8967: SET apdist.pa_addition_flag = DECODE(NVL(apdist.amount_variance,0),0,'G',increment_W_count('W')),
8968: request_id = G_REQUEST_ID,
8969: last_update_date=SYSDATE,
8970: last_updated_by=G_USER_ID,

Line 8977: FROM ap_invoices inv, ap_invoice_distributions_all dist

8973: program_application_id= G_PROG_APPL_ID,
8974: program_update_date=SYSDATE
8975: WHERE rowid IN (
8976: SELECT dist.rowid
8977: FROM ap_invoices inv, ap_invoice_distributions_all dist
8978: WHERE inv.invoice_id = dist.invoice_id
8979: AND (dist.line_type_lookup_code in ('ITEM','ACCRUAL','RETROACCRUAL','NONREC_TAX')
8980: OR ( pa_nl_installed.is_nl_installed = 'Y' --EIB trackable items
8981: AND EXISTS (SELECT 'X'

Line 8999: FROM ap_invoice_distributions_all apdist2

8995: ))
8996: )
8997: ) --Bug#5399352. Added this here to take care of IPV/TIPV records matched to EIB item PO.
8998: AND NOT EXISTS (SELECT NULL
8999: FROM ap_invoice_distributions_all apdist2
9000: WHERE apdist2.pa_addition_flag = 'Y'
9001: AND apdist2.po_distribution_id = dist.po_distribution_id
9002: AND (apdist2.line_type_lookup_code = dist.line_type_lookup_code
9003: or (apdist2.historical_flag = 'Y' and

Line 9008: FROM ap_invoice_distributions_all apdist1,

9004: dist.line_type_lookup_code = 'ACCRUAL')) /* Modified for bug 14003230 */
9005: AND apdist2.line_type_lookup_code in ('ITEM','ACCRUAL','RETROACCRUAL','NONREC_TAX')
9006: )
9007: AND ( EXISTS (SELECT NULL
9008: FROM ap_invoice_distributions_all apdist1,
9009: ap_invoices_all ap1 /*Changes for bug 7650946 -- Start */
9010: WHERE apdist1.pa_addition_flag IN ('F', 'G')
9011: AND ap1.invoice_id = apdist1.invoice_id /*Added for bug 7650946 */
9012: AND apdist1.po_distribution_id = dist.po_distribution_id

Line 9128: UPDATE ap_invoice_distributions_all apdist

9124: pulled from Payables. The pa_addition_flag for such invoice ITEM distribution lines is updated to G to prevent
9125: further processing into Projects.
9126: However, if there is an amount variance on such invoice, it needs to be processed as W to releive variance commitment */
9127:
9128: UPDATE ap_invoice_distributions_all apdist
9129: SET apdist.pa_addition_flag = DECODE(NVL(apdist.amount_variance,0),0,'G',increment_W_count('W')),
9130: request_id = G_REQUEST_ID,
9131: last_update_date=SYSDATE,
9132: last_updated_by=G_USER_ID,

Line 9141: ap_invoice_distributions_all dist

9137: WHERE rowid in (
9138: SELECT dist.rowid
9139: FROM ap_invoices inv,
9140: po_distributions po,
9141: ap_invoice_distributions_all dist
9142: WHERE inv.invoice_id = dist.invoice_id
9143: AND po.po_distribution_id = dist.po_distribution_id
9144: AND dist.po_distribution_id >0 /*Added the condition for bug#12922795 */
9145: AND nvl(po.distribution_type,'XXX') <> 'PREPAYMENT' -- bug 7192304, added nvl

Line 9187: UPDATE ap_invoice_distributions_all apdist

9183: If g_body_debug_mode = 'Y' Then
9184: write_log(LOG, 'Updating empty invoice variance lines pa addtion flag to G for all');
9185: End if;
9186:
9187: UPDATE ap_invoice_distributions_all apdist
9188: SET apdist.pa_addition_flag = DECODE(NVL(apdist.amount_variance,0),0,'G',increment_W_count('W')),
9189: request_id = G_REQUEST_ID,
9190: last_update_date=SYSDATE,
9191: last_updated_by=G_USER_ID,

Line 9198: FROM ap_invoices inv, ap_invoice_distributions_all dist

9194: program_application_id= G_PROG_APPL_ID,
9195: program_update_date=SYSDATE
9196: WHERE rowid IN (
9197: SELECT dist.rowid
9198: FROM ap_invoices inv, ap_invoice_distributions_all dist
9199: WHERE inv.invoice_id = dist.invoice_id
9200: AND ( dist.line_type_lookup_code in ('ITEM','ACCRUAL','RETROACCRUAL','NONREC_TAX')
9201: OR ( pa_nl_installed.is_nl_installed = 'Y' --EIB trackable items
9202: AND EXISTS (SELECT 'X'

Line 9220: FROM ap_invoice_distributions_all apdist2

9216: ))
9217: )
9218: ) --Bug#5399352. Added this here to take care of IPV/TIPV records matched to EIB item PO.
9219: AND NOT EXISTS (SELECT NULL
9220: FROM ap_invoice_distributions_all apdist2
9221: WHERE apdist2.pa_addition_flag = 'Y'
9222: AND apdist2.po_distribution_id = dist.po_distribution_id
9223: AND (apdist2.line_type_lookup_code = dist.line_type_lookup_code
9224: or (apdist2.historical_flag = 'Y' and

Line 9229: FROM ap_invoice_distributions_all apdist1,

9225: dist.line_type_lookup_code = 'ACCRUAL')) /* Modified for bug 14003230 */
9226: AND apdist2.line_type_lookup_code in ('ITEM','ACCRUAL','RETROACCRUAL','NONREC_TAX')
9227: )
9228: AND ( EXISTS (SELECT NULL
9229: FROM ap_invoice_distributions_all apdist1,
9230: ap_invoices_all ap1 /*Changes for bug 7650946 -- Start */
9231: WHERE apdist1.pa_addition_flag IN ('F', 'G')
9232: AND ap1.invoice_id = apdist1.invoice_id
9233: AND apdist1.po_distribution_id = dist.po_distribution_id

Line 9349: UPDATE ap_invoice_distributions_all apdist

9345: pulled from Payables. The pa_addition_flag for such invoice ITEM distribution lines is updated to G to prevent
9346: further processing into Projects.
9347: However, if there is an amount variance on such invoice, it needs to be processed as W to releive variance commitment */
9348:
9349: UPDATE ap_invoice_distributions_all apdist
9350: SET apdist.pa_addition_flag = DECODE(NVL(apdist.amount_variance,0),0,'G',increment_W_count('W')),
9351: request_id = G_REQUEST_ID,
9352: last_update_date=SYSDATE,
9353: last_updated_by=G_USER_ID,

Line 9362: ap_invoice_distributions_all dist

9358: WHERE rowid in (
9359: SELECT dist.rowid
9360: FROM ap_invoices inv,
9361: po_distributions po,
9362: ap_invoice_distributions_all dist
9363: WHERE inv.invoice_id = dist.invoice_id
9364: AND po.po_distribution_id = dist.po_distribution_id
9365: AND dist.po_distribution_id >0 /*Added the condition for bug#12922795 */
9366: AND NVL(po.destination_type_code, 'EXPENSE') = 'EXPENSE'

Line 9975: FROM ap_invoice_distributions_all

9971: BEGIN
9972:
9973: SELECT nvl(historical_flag,'N') --check if this flag can be used
9974: INTO l_historical_flag
9975: FROM ap_invoice_distributions_all
9976: WHERE invoice_id = l_invoice_id_tbl(i)
9977: AND invoice_distribution_id = l_parent_rev_id_tbl(i); --check the index on this table
9978:
9979: EXCEPTION

Line 10333: UPDATE ap_invoice_distributions_all dist

10329: write_log(LOG, G_err_stage);
10330:
10331: FORALL i IN l_sys_ref1_tbl.FIRST..l_sys_ref1_tbl.LAST
10332:
10333: UPDATE ap_invoice_distributions_all dist
10334: SET dist.pa_addition_flag = l_pa_addflag_tbl(i)
10335: ,dist.assets_addition_flag = decode(l_assets_addflag_tbl(i),'P','P',dist.assets_addition_flag)
10336: WHERE dist.invoice_id = l_sys_ref2_tbl(i)
10337: AND dist.invoice_distribution_id = l_sys_ref5_tbl(i)

Line 10633: AP_Invoice_Distributions_all aid,

10629: AND hist.posted_flag = 'Y')
10630: AND exists (SELECT inv.invoice_id
10631: FROM AP_INVOICES inv,
10632: PO_VENDORS vend,
10633: AP_Invoice_Distributions_all aid,
10634: ap_invoice_payments_all aip
10635: WHERE inv.invoice_id = aid.invoice_id
10636: AND inv.vendor_id = vend.vendor_id
10637: AND aip.invoice_payment_id = dist.invoice_payment_id

Line 10674: AP_Invoice_Distributions_all aid, --STD INV DIST LINE

10670: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10671: FROM AP_INVOICES_ALL inv,
10672: PO_VENDORS vend,
10673: PO_Distributions_all PO,
10674: AP_Invoice_Distributions_all aid, --STD INV DIST LINE
10675: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE
10676: WHERE aid.invoice_id = inv.invoice_id
10677: AND inv.vendor_id = vend.vendor_id
10678: AND inv.org_id = G_ORG_ID

Line 10675: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE

10671: FROM AP_INVOICES_ALL inv,
10672: PO_VENDORS vend,
10673: PO_Distributions_all PO,
10674: AP_Invoice_Distributions_all aid, --STD INV DIST LINE
10675: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE
10676: WHERE aid.invoice_id = inv.invoice_id
10677: AND inv.vendor_id = vend.vendor_id
10678: AND inv.org_id = G_ORG_ID
10679: AND aid.invoice_distribution_id = dist.invoice_distribution_id -- Std inv line

Line 10723: AP_Invoice_Distributions_all aid,

10719: AND hist.posted_flag = 'Y')
10720: AND exists (SELECT inv.invoice_id
10721: FROM AP_INVOICES_ALL inv,
10722: PO_VENDORS vend,
10723: AP_Invoice_Distributions_all aid,
10724: ap_invoice_payments_all aip
10725: WHERE inv.vendor_id = vend.vendor_id
10726: AND aid.invoice_id = inv.invoice_id
10727: AND inv.org_id = G_ORG_ID

Line 10765: AP_Invoice_Distributions_all aid, --STD INV DIST LINE

10761: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10762: FROM AP_INVOICES_ALL inv,
10763: PO_VENDORS vend,
10764: PO_Distributions_all PO,
10765: AP_Invoice_Distributions_all aid, --STD INV DIST LINE
10766: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE
10767: WHERE aid.invoice_id = inv.invoice_id
10768: AND inv.vendor_id = vend.vendor_id
10769: AND inv.org_id = G_ORG_ID

Line 10766: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE

10762: FROM AP_INVOICES_ALL inv,
10763: PO_VENDORS vend,
10764: PO_Distributions_all PO,
10765: AP_Invoice_Distributions_all aid, --STD INV DIST LINE
10766: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE
10767: WHERE aid.invoice_id = inv.invoice_id
10768: AND inv.vendor_id = vend.vendor_id
10769: AND inv.org_id = G_ORG_ID
10770: AND aid.invoice_distribution_id = dist.invoice_distribution_id -- Std inv line

Line 10828: AP_Invoice_Distributions_all aid,

10824: AND hist.posted_flag = 'Y')
10825: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10826: FROM AP_INVOICES_ALL inv,
10827: PO_Distributions_all PO,
10828: AP_Invoice_Distributions_all aid,
10829: ap_invoice_payments_all aip
10830: WHERE inv.invoice_id = aip.invoice_id
10831: AND aid.invoice_id = inv.invoice_id
10832: AND inv.org_id = G_ORG_ID

Line 10875: AP_Invoice_Distributions_all aid, --STD INV DIST LINE

10871: AND dist.amount <> 0
10872: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10873: FROM AP_INVOICES_ALL inv,
10874: PO_Distributions_all PO,
10875: AP_Invoice_Distributions_all aid, --STD INV DIST LINE
10876: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE
10877: WHERE aid.invoice_id = inv.invoice_id
10878: AND aid.invoice_distribution_id = dist.invoice_distribution_id -- Std inv line
10879: AND inv.org_id = G_ORG_ID

Line 10876: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE

10872: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10873: FROM AP_INVOICES_ALL inv,
10874: PO_Distributions_all PO,
10875: AP_Invoice_Distributions_all aid, --STD INV DIST LINE
10876: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE
10877: WHERE aid.invoice_id = inv.invoice_id
10878: AND aid.invoice_distribution_id = dist.invoice_distribution_id -- Std inv line
10879: AND inv.org_id = G_ORG_ID
10880: AND aid2.invoice_id = aid.invoice_id

Line 10930: AP_Invoice_Distributions_all aid,

10926: AND hist.posted_flag = 'Y')
10927: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10928: FROM AP_INVOICES_ALL inv,
10929: PO_Distributions_all PO,
10930: AP_Invoice_Distributions_all aid,
10931: ap_invoice_payments_all aip
10932: WHERE inv.invoice_id = aip.invoice_id
10933: AND aid.invoice_id = inv.invoice_id
10934: AND inv.org_id = G_ORG_ID

Line 10977: AP_Invoice_Distributions_all aid, --STD INV DIST LINE

10973: AND dist.amount <> 0
10974: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10975: FROM AP_INVOICES_ALL inv,
10976: PO_Distributions_all PO,
10977: AP_Invoice_Distributions_all aid, --STD INV DIST LINE
10978: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE
10979: WHERE aid.invoice_id = inv.invoice_id
10980: AND inv.org_id = G_ORG_ID
10981: AND aid.invoice_distribution_id = dist.invoice_distribution_id -- Std inv line

Line 10978: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE

10974: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10975: FROM AP_INVOICES_ALL inv,
10976: PO_Distributions_all PO,
10977: AP_Invoice_Distributions_all aid, --STD INV DIST LINE
10978: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE
10979: WHERE aid.invoice_id = inv.invoice_id
10980: AND inv.org_id = G_ORG_ID
10981: AND aid.invoice_distribution_id = dist.invoice_distribution_id -- Std inv line
10982: AND aid2.invoice_id = aid.invoice_id

Line 12693: UPDATE ap_invoice_distributions_all dist

12689:
12690: IF l_batch <> 'APDISC' THEN --Payment Discount batch
12691:
12692: FORALL i IN l_sys_ref1_tbl.FIRST..l_sys_ref1_tbl.LAST
12693: UPDATE ap_invoice_distributions_all dist
12694: SET dist.assets_addition_flag = decode(l_assets_addflag_tbl(i),'P','P',dist.assets_addition_flag)
12695: WHERE dist.invoice_distribution_id = l_sys_ref5_tbl(i) ;
12696: END IF;
12697: