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

Line 24: TYPE Inv_Dists_Tab_Type IS TABLE OF ap_invoice_distributions_all%ROWTYPE;

20: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_ETAX_SERVICES_PKG.';
21:
22: -- Define the structures for lines and distributions
23: TYPE Inv_Lines_Tab_Type IS TABLE OF ap_invoice_lines_all%ROWTYPE;
24: TYPE Inv_Dists_Tab_Type IS TABLE OF ap_invoice_distributions_all%ROWTYPE;
25:
26: l_inv_line_list Inv_Lines_Tab_Type;
27: l_inv_tax_list Inv_Lines_Tab_Type;
28: l_inv_dist_list Inv_Dists_Tab_Type;

Line 1181: ap_invoice_distributions_all aid

1177:
1178: CURSOR Invoice_Dists (c_invoice_id NUMBER) IS
1179: SELECT aid.*
1180: FROM ap_invoice_lines_all ail,
1181: ap_invoice_distributions_all aid
1182: WHERE ail.invoice_id = aid.invoice_id
1183: AND ail.line_number = aid.invoice_line_number
1184: AND ail.invoice_id = c_invoice_id
1185: AND aid.line_type_lookup_code NOT IN

Line 1200: ap_invoice_distributions_all aid

1196: AND p_calling_mode <> 'DISTRIBUTE RECOUP'
1197: UNION
1198: SELECT aid.*
1199: FROM ap_invoice_lines_all ail,
1200: ap_invoice_distributions_all aid
1201: WHERE ail.invoice_id = aid.invoice_id
1202: AND ail.line_number = aid.invoice_line_number
1203: AND ail.invoice_id = c_invoice_id
1204: AND ail.line_type_lookup_code <> 'PREPAY'

Line 1219: ap_invoice_distributions_all aid

1215: -- cursor will be used
1216: CURSOR Invoice_Dist (c_invoice_id NUMBER, c_line_number NUMBER) IS
1217: SELECT aid.*
1218: FROM ap_invoice_lines_all ail,
1219: ap_invoice_distributions_all aid
1220: WHERE ail.invoice_id = aid.invoice_id
1221: AND ail.line_number = aid.invoice_line_number
1222: AND ail.invoice_id = c_invoice_id
1223: AND ail.line_number = c_line_number

Line 1236: ap_invoice_distributions_all aid

1232: AND p_calling_mode <> 'DISTRIBUTE RECOUP'
1233: UNION
1234: SELECT aid.*
1235: FROM ap_invoice_lines_all ail,
1236: ap_invoice_distributions_all aid
1237: WHERE ail.invoice_id = aid.invoice_id
1238: AND ail.line_number = aid.invoice_line_number
1239: AND ail.invoice_id = c_invoice_id
1240: AND ail.line_number = c_line_number

Line 1433: UPDATE ap_invoice_distributions_All aid1

1429: ------------------------------------------------------------------------
1430: l_debug_info := 'Update dist amount for included TAX (ITEM line no and tax amount) '||p_line_number||' '||i.included_tax_amount;
1431: Print(l_api_name,l_debug_info);
1432: ------------------------------------------------------------------------
1433: UPDATE ap_invoice_distributions_All aid1
1434: SET aid1.amount = aid1.amount + nvl((SELECT SUM(nvl(amount,0))
1435: FROM ap_invoice_distributions_All aid2
1436: WHERE aid2.invoice_id = p_invoice_id
1437: AND aid2.invoice_line_number = i.line_number

Line 1435: FROM ap_invoice_distributions_All aid2

1431: Print(l_api_name,l_debug_info);
1432: ------------------------------------------------------------------------
1433: UPDATE ap_invoice_distributions_All aid1
1434: SET aid1.amount = aid1.amount + nvl((SELECT SUM(nvl(amount,0))
1435: FROM ap_invoice_distributions_All aid2
1436: WHERE aid2.invoice_id = p_invoice_id
1437: AND aid2.invoice_line_number = i.line_number
1438: AND aid2.charge_applicable_to_dist_id = aid1.invoice_distribution_id
1439: AND aid2.line_type_lookup_code IN ('REC_TAX','NONREC_TAX','TRV','TIPV')),0),

Line 1441: FROM ap_invoice_distributions_All aid3

1437: AND aid2.invoice_line_number = i.line_number
1438: AND aid2.charge_applicable_to_dist_id = aid1.invoice_distribution_id
1439: AND aid2.line_type_lookup_code IN ('REC_TAX','NONREC_TAX','TRV','TIPV')),0),
1440: aid1.base_amount = aid1.base_amount + nvl((SELECT SUM(nvl(base_amount,0))
1441: FROM ap_invoice_distributions_All aid3
1442: WHERE aid3.invoice_id = p_invoice_id
1443: AND aid3.invoice_line_number = i.line_number
1444: AND aid3.charge_applicable_to_dist_id = aid1.invoice_distribution_id
1445: AND aid3.line_type_lookup_code IN ('REC_TAX','NONREC_TAX','TRV','TIPV')),0)

Line 1469: UPDATE ap_invoice_distributions_All aid1

1465: ------------------------------------------------------------------------
1466: l_debug_info := 'Test: Update dist amount for included TAX (tax amount) '|| i.included_tax_amount;
1467: Print(l_api_name,l_debug_info);
1468: ------------------------------------------------------------------------
1469: UPDATE ap_invoice_distributions_All aid1
1470: SET aid1.amount = aid1.amount + nvl((SELECT SUM(nvl(amount,0))
1471: FROM ap_invoice_distributions_All aid2
1472: WHERE aid2.invoice_id = p_invoice_id
1473: AND aid2.invoice_line_number = i.line_number

Line 1471: FROM ap_invoice_distributions_All aid2

1467: Print(l_api_name,l_debug_info);
1468: ------------------------------------------------------------------------
1469: UPDATE ap_invoice_distributions_All aid1
1470: SET aid1.amount = aid1.amount + nvl((SELECT SUM(nvl(amount,0))
1471: FROM ap_invoice_distributions_All aid2
1472: WHERE aid2.invoice_id = p_invoice_id
1473: AND aid2.invoice_line_number = i.line_number
1474: AND aid2.charge_applicable_to_dist_id = aid1.invoice_distribution_id
1475: AND aid2.line_type_lookup_code IN ('REC_TAX','NONREC_TAX','TRV','TIPV')),0),

Line 1477: FROM ap_invoice_distributions_All aid3

1473: AND aid2.invoice_line_number = i.line_number
1474: AND aid2.charge_applicable_to_dist_id = aid1.invoice_distribution_id
1475: AND aid2.line_type_lookup_code IN ('REC_TAX','NONREC_TAX','TRV','TIPV')),0),
1476: aid1.base_amount =aid1.base_amount + nvl((SELECT SUM(nvl(base_amount,0))
1477: FROM ap_invoice_distributions_All aid3
1478: WHERE aid3.invoice_id = p_invoice_id
1479: AND aid3.invoice_line_number = i.line_number
1480: AND aid3.charge_applicable_to_dist_id = aid1.invoice_distribution_id
1481: AND aid3.line_type_lookup_code IN ('REC_TAX','NONREC_TAX','TRV','TIPV')),0)

Line 1523: UPDATE /+ ROWID (AID) / AP_Invoice_Distributions_All AID

1519: -------------------------------------------------------------------
1520: l_debug_info := 'Upgrade historical invoice distributions';
1521: Print(l_api_name,l_debug_info);
1522: -------------------------------------------------------------------
1523: UPDATE /*+ ROWID (AID) */ AP_Invoice_Distributions_All AID
1524: SET (RECOVERY_RATE_CODE,
1525: RECOVERY_RATE_ID,
1526: RECOVERY_TYPE_CODE) =
1527: (SELECT REC.Tax_Rate_Code,

Line 2286: FROM ap_invoice_distributions_all aid,

2282: 'LINE', -- reversed_trx_level_type
2283: idc.invoice_line_number, -- reversed_trx_line_id
2284: idc.invoice_distribution_id, -- reversed_trx_line_dist_id
2285: NULL -- reversed_tax_line_id
2286: FROM ap_invoice_distributions_all aid,
2287: ap_invoice_distributions_all idc
2288: WHERE aid.invoice_id = l_inv_header_rec.invoice_id
2289: AND aid.line_type_lookup_code NOT IN
2290: ('AWT', 'REC_TAX', 'NONREC_TAX', 'TRV', 'TERV', 'TIPV')

Line 2287: ap_invoice_distributions_all idc

2283: idc.invoice_line_number, -- reversed_trx_line_id
2284: idc.invoice_distribution_id, -- reversed_trx_line_dist_id
2285: NULL -- reversed_tax_line_id
2286: FROM ap_invoice_distributions_all aid,
2287: ap_invoice_distributions_all idc
2288: WHERE aid.invoice_id = l_inv_header_rec.invoice_id
2289: AND aid.line_type_lookup_code NOT IN
2290: ('AWT', 'REC_TAX', 'NONREC_TAX', 'TRV', 'TERV', 'TIPV')
2291: AND (aid.related_id IS NULL

Line 3155: FROM ap_invoice_distributions_all

3151: accounting_event_id,
3152: dist_match_type,
3153: amount,
3154: prepay_amount_remaining
3155: FROM ap_invoice_distributions_all
3156: WHERE invoice_id = p_invoice_header_rec.invoice_id
3157: AND line_type_lookup_code NOT IN ('REC_TAX', 'NONREC_TAX', 'TRV', 'TERV', 'TIPV');
3158:
3159: TYPE l_itm_dist_tab_local IS TABLE OF itm_Dist%ROWTYPE;

Line 3175: l_po_distribution_id ap_invoice_distributions_all.po_distribution_id%TYPE;

3171:
3172: l_return_status BOOLEAN := TRUE;
3173: l_freeze_dist_flag VARCHAR2(1);
3174:
3175: l_po_distribution_id ap_invoice_distributions_all.po_distribution_id%TYPE;
3176: l_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE;
3177:
3178: freeze_dist_list ZX_API_PUB.number_tbl_type;
3179:

Line 3176: l_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE;

3172: l_return_status BOOLEAN := TRUE;
3173: l_freeze_dist_flag VARCHAR2(1);
3174:
3175: l_po_distribution_id ap_invoice_distributions_all.po_distribution_id%TYPE;
3176: l_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE;
3177:
3178: freeze_dist_list ZX_API_PUB.number_tbl_type;
3179:
3180:

Line 3520: FROM ap_invoice_distributions_all

3516: corrected_invoice_dist_id,
3517: invoice_distribution_id,
3518: detail_tax_dist_id,
3519: accounting_event_id
3520: FROM ap_invoice_distributions_all
3521: WHERE invoice_id = p_invoice_header_rec.invoice_id
3522: AND line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX', 'TRV', 'TERV', 'TIPV')
3523: AND (related_id IS NULL
3524: OR (related_id = invoice_distribution_id

Line 3567: l_po_distribution_id ap_invoice_distributions_all.po_distribution_id%TYPE;

3563:
3564: l_return_status BOOLEAN := TRUE;
3565: l_freeze_dist_flag VARCHAR2(1);
3566:
3567: l_po_distribution_id ap_invoice_distributions_all.po_distribution_id%TYPE;
3568: l_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE;
3569:
3570: TYPE freeze_tax_dist_type IS TABLE OF zx_tax_dist_id_gt%ROWTYPE;
3571: freeze_dist_list freeze_tax_dist_type := freeze_tax_dist_type();

Line 3568: l_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE;

3564: l_return_status BOOLEAN := TRUE;
3565: l_freeze_dist_flag VARCHAR2(1);
3566:
3567: l_po_distribution_id ap_invoice_distributions_all.po_distribution_id%TYPE;
3568: l_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE;
3569:
3570: TYPE freeze_tax_dist_type IS TABLE OF zx_tax_dist_id_gt%ROWTYPE;
3571: freeze_dist_list freeze_tax_dist_type := freeze_tax_dist_type();
3572:

Line 3653: FROM ap_invoice_distributions_all

3649: --this validation because it can be null for tax-only lines
3650:
3651: SELECT po_distribution_id, rcv_transaction_id
3652: INTO l_po_distribution_id, l_rcv_transaction_id
3653: FROM ap_invoice_distributions_all
3654: WHERE invoice_distribution_id =
3655: l_tax_dist_list_local(i).charge_applicable_to_dist_id;
3656:
3657:

Line 3769: FROM ap_invoice_distributions_all

3765: IF (l_freeze_dist_flag = 'N' ) THEN
3766: BEGIN
3767: SELECT 'Y'
3768: INTO l_freeze_dist_flag
3769: FROM ap_invoice_distributions_all
3770: WHERE corrected_invoice_dist_id =
3771: l_tax_dist_list_local(i).charge_applicable_to_dist_id
3772: AND ROWNUM = 1;
3773:

Line 6538: FROM ap_invoice_distributions_all aids

6534: trans_lines(i).trx_line_id := -1 * (l_inv_line_list(i).invoice_id || l_inv_line_list(i).line_number || p_line_number);
6535:
6536: SELECT sum(amount)
6537: INTO trans_lines(i).line_amt
6538: FROM ap_invoice_distributions_all aids
6539: WHERE invoice_id = p_invoice_header_rec.invoice_id
6540: AND invoice_line_number = p_line_number
6541: AND line_type_lookup_code = 'PREPAY'
6542: AND EXISTS

Line 6544: from ap_invoice_distributions_all aidp

6540: AND invoice_line_number = p_line_number
6541: AND line_type_lookup_code = 'PREPAY'
6542: AND EXISTS
6543: (select 'Prepayment Invoice'
6544: from ap_invoice_distributions_all aidp
6545: where aidp.invoice_distribution_id = aids.prepay_distribution_id
6546: and aidp.invoice_id = l_inv_line_list(i).invoice_id
6547: and aidp.invoice_line_number = l_inv_line_list(i).line_number);
6548:

Line 8660: l_converted_qty ap_invoice_distributions_all.quantity_invoiced%TYPE;

8656: l_amount zx_itm_distributions_gt.trx_line_dist_amt%TYPE;
8657: l_price_diff zx_itm_distributions_gt.price_diff%TYPE;
8658: l_po_header_curr_conv_rate zx_itm_distributions_gt.ref_doc_curr_conv_rate%TYPE;
8659: l_receipt_curr_conv_rate zx_itm_distributions_gt.applied_to_doc_curr_conv_rate%TYPE;
8660: l_converted_qty ap_invoice_distributions_all.quantity_invoiced%TYPE;
8661: l_converted_price ap_invoice_distributions_all.unit_price%TYPE;
8662:
8663: -- Correction Invoice Info
8664: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;

Line 8661: l_converted_price ap_invoice_distributions_all.unit_price%TYPE;

8657: l_price_diff zx_itm_distributions_gt.price_diff%TYPE;
8658: l_po_header_curr_conv_rate zx_itm_distributions_gt.ref_doc_curr_conv_rate%TYPE;
8659: l_receipt_curr_conv_rate zx_itm_distributions_gt.applied_to_doc_curr_conv_rate%TYPE;
8660: l_converted_qty ap_invoice_distributions_all.quantity_invoiced%TYPE;
8661: l_converted_price ap_invoice_distributions_all.unit_price%TYPE;
8662:
8663: -- Correction Invoice Info
8664: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
8665: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;

Line 8731: FROM ap_invoice_distributions_all

8727: IF (l_inv_dist_list(i).related_id IS NOT NULL
8728: OR l_inv_dist_list(i).related_retainage_dist_id IS NOT NULL) THEN
8729: SELECT SUM(amount)
8730: INTO l_amount
8731: FROM ap_invoice_distributions_all
8732: WHERE invoice_id = l_inv_dist_list(i).invoice_id
8733: AND (related_id = l_inv_dist_list(i).related_id
8734: or related_retainage_dist_id = l_inv_dist_list(i).related_retainage_dist_id);
8735:

Line 8838: From ap_invoice_distributions_all

8834: l_inv_dist_list(i).corrected_invoice_dist_id IS NOT NULL) THEN
8835:
8836: Select invoice_id, invoice_line_number
8837: Into l_adj_doc_trx_id, l_adj_doc_line_id
8838: From ap_invoice_distributions_all
8839: Where invoice_distribution_id = l_inv_dist_list(i).corrected_invoice_dist_id;
8840:
8841: IF NOT (AP_ETAX_UTILITY_PKG.Get_Corrected_Invoice_Info(
8842: P_Corrected_Invoice_Id => l_inv_line_list(i).corrected_inv_id,

Line 8877: FROM ap_invoice_distributions_all

8873: l_inv_dist_list(i).prepay_distribution_id IS NOT NULL) THEN
8874:
8875: SELECT invoice_id, invoice_line_number
8876: INTO l_applied_from_trx_id, l_applied_from_line_id
8877: FROM ap_invoice_distributions_all
8878: WHERE invoice_distribution_id = l_inv_dist_list(i).prepay_distribution_id;
8879:
8880: IF NOT (AP_ETAX_UTILITY_PKG.Get_Prepay_Invoice_Info(
8881: P_Prepay_Invoice_Id => l_applied_from_trx_id,

Line 8925: FROM ap_invoice_distributions_all

8921: IF l_inv_dist_list(i).prepay_distribution_id IS NOT NULL THEN
8922:
8923: SELECT invoice_id, invoice_line_number
8924: INTO l_prepay_inv_id, l_prepay_line_num
8925: FROM ap_invoice_distributions_all
8926: WHERE invoice_distribution_id = l_inv_dist_list(i).prepay_distribution_id;
8927:
8928: trans_dists(i).trx_line_id := -1 * (l_prepay_inv_id || l_prepay_line_num || l_inv_dist_list(i).invoice_line_number);
8929:

Line 9970: from ap_invoice_distributions_all tax_dist,

9966: tax_dist.tax_already_distributed_flag tax_already_distributed_flag,
9967: tax_dist.summary_tax_line_id summary_tax_line_id,
9968: 'N' rcv_charge_addition_flag,
9969: tax_dist.prepay_tax_diff_amount -- BUG 7338249
9970: from ap_invoice_distributions_all tax_dist,
9971: ap_invoice_distributions_all item_dist,
9972: zx_rec_nrec_dist zx_dist
9973: where tax_dist.invoice_id = p_invoice_id
9974: and tax_dist.line_type_lookup_code IN ('NONREC_TAX', 'REC_TAX', 'TIPV', 'TERV', 'TRV')

Line 9971: ap_invoice_distributions_all item_dist,

9967: tax_dist.summary_tax_line_id summary_tax_line_id,
9968: 'N' rcv_charge_addition_flag,
9969: tax_dist.prepay_tax_diff_amount -- BUG 7338249
9970: from ap_invoice_distributions_all tax_dist,
9971: ap_invoice_distributions_all item_dist,
9972: zx_rec_nrec_dist zx_dist
9973: where tax_dist.invoice_id = p_invoice_id
9974: and tax_dist.line_type_lookup_code IN ('NONREC_TAX', 'REC_TAX', 'TIPV', 'TERV', 'TRV')
9975: and tax_dist.detail_tax_dist_id = zx_dist.reversed_tax_dist_id

Line 10176: from ap_invoice_distributions_all tax_dist,

10172: tax_dist.tax_already_distributed_flag tax_already_distributed_flag,
10173: tax_dist.summary_tax_line_id summary_tax_line_id,
10174: 'N' rcv_charge_addition_flag,
10175: tax_dist.prepay_tax_diff_amount -- BUG 7338249
10176: from ap_invoice_distributions_all tax_dist,
10177: ap_invoice_distributions_all item_dist,
10178: zx_rec_nrec_dist zx_dist
10179: where tax_dist.invoice_id = p_invoice_id
10180: and tax_dist.line_type_lookup_code IN ('NONREC_TAX', 'REC_TAX', 'TIPV', 'TERV', 'TRV')

Line 10177: ap_invoice_distributions_all item_dist,

10173: tax_dist.summary_tax_line_id summary_tax_line_id,
10174: 'N' rcv_charge_addition_flag,
10175: tax_dist.prepay_tax_diff_amount -- BUG 7338249
10176: from ap_invoice_distributions_all tax_dist,
10177: ap_invoice_distributions_all item_dist,
10178: zx_rec_nrec_dist zx_dist
10179: where tax_dist.invoice_id = p_invoice_id
10180: and tax_dist.line_type_lookup_code IN ('NONREC_TAX', 'REC_TAX', 'TIPV', 'TERV', 'TRV')
10181: and tax_dist.detail_tax_dist_id = zx_dist.reversed_tax_dist_id

Line 10387: ap_invoice_distributions_all item_dist,

10383: -- bug 6805655
10384: tax_dist.self_assessed_tax_liab_ccid self_assessed_tax_liab_ccid,
10385: tax_dist.prepay_tax_diff_amount -- BUG 7338249
10386: from ap_self_assessed_tax_dist_all tax_dist,
10387: ap_invoice_distributions_all item_dist,
10388: zx_rec_nrec_dist zx_dist
10389: where tax_dist.invoice_id = p_invoice_id
10390: and tax_dist.line_type_lookup_code IN ('NONREC_TAX', 'REC_TAX')
10391: and tax_dist.detail_tax_dist_id = zx_dist.reversed_tax_dist_id

Line 10604: ap_invoice_distributions_all item_dist,

10600: -- bug 6805655
10601: tax_dist.self_assessed_tax_liab_ccid self_assessed_tax_liab_ccid,
10602: tax_dist.prepay_tax_diff_amount -- BUG 7338249
10603: from ap_self_assessed_tax_dist_all tax_dist,
10604: ap_invoice_distributions_all item_dist,
10605: zx_rec_nrec_dist zx_dist
10606: where tax_dist.invoice_id = p_invoice_id
10607: and tax_dist.line_type_lookup_code IN ('NONREC_TAX', 'REC_TAX')
10608: and tax_dist.detail_tax_dist_id = zx_dist.reversed_tax_dist_id

Line 10703: from ap_invoice_distributions_all item_dist,

10699: zx_dist.trx_level_type reversed_trx_level_type,
10700: zx_dist.trx_line_id reversed_trx_line_id,
10701: zx_dist.trx_line_dist_id reversed_trx_line_dist_id,
10702: zx_dist.tax_line_id reversed_tax_line_id
10703: from ap_invoice_distributions_all item_dist,
10704: ap_invoice_distributions_all tax_dist,
10705: ap_invoice_distributions_all reverse_dist,
10706: zx_rec_nrec_dist zx_dist
10707: where tax_dist.invoice_id = p_invoice_id

Line 10704: ap_invoice_distributions_all tax_dist,

10700: zx_dist.trx_line_id reversed_trx_line_id,
10701: zx_dist.trx_line_dist_id reversed_trx_line_dist_id,
10702: zx_dist.tax_line_id reversed_tax_line_id
10703: from ap_invoice_distributions_all item_dist,
10704: ap_invoice_distributions_all tax_dist,
10705: ap_invoice_distributions_all reverse_dist,
10706: zx_rec_nrec_dist zx_dist
10707: where tax_dist.invoice_id = p_invoice_id
10708: and tax_dist.invoice_id = item_dist.invoice_id

Line 10705: ap_invoice_distributions_all reverse_dist,

10701: zx_dist.trx_line_dist_id reversed_trx_line_dist_id,
10702: zx_dist.tax_line_id reversed_tax_line_id
10703: from ap_invoice_distributions_all item_dist,
10704: ap_invoice_distributions_all tax_dist,
10705: ap_invoice_distributions_all reverse_dist,
10706: zx_rec_nrec_dist zx_dist
10707: where tax_dist.invoice_id = p_invoice_id
10708: and tax_dist.invoice_id = item_dist.invoice_id
10709: and tax_dist.charge_applicable_to_dist_id = item_dist.invoice_distribution_id

Line 10777: from ap_invoice_distributions_all item_dist,

10773: zx_dist.trx_level_type reversed_trx_level_type,
10774: zx_dist.trx_line_id reversed_trx_line_id,
10775: zx_dist.trx_line_dist_id reversed_trx_line_dist_id,
10776: zx_dist.tax_line_id reversed_tax_line_id
10777: from ap_invoice_distributions_all item_dist,
10778: ap_self_assessed_tax_dist_all tax_dist,
10779: ap_invoice_distributions_all reverse_dist,
10780: zx_rec_nrec_dist zx_dist
10781: where tax_dist.invoice_id = p_invoice_id

Line 10779: ap_invoice_distributions_all reverse_dist,

10775: zx_dist.trx_line_dist_id reversed_trx_line_dist_id,
10776: zx_dist.tax_line_id reversed_tax_line_id
10777: from ap_invoice_distributions_all item_dist,
10778: ap_self_assessed_tax_dist_all tax_dist,
10779: ap_invoice_distributions_all reverse_dist,
10780: zx_rec_nrec_dist zx_dist
10781: where tax_dist.invoice_id = p_invoice_id
10782: and tax_dist.invoice_id = item_dist.invoice_id
10783: and tax_dist.charge_applicable_to_dist_id = item_dist.invoice_distribution_id

Line 10858: INSERT INTO ap_invoice_distributions_all (

10854: FETCH c_reverse_tax_dist
10855: INTO l_reverse_tax_dist;
10856: EXIT WHEN c_reverse_tax_dist%NOTFOUND;
10857:
10858: INSERT INTO ap_invoice_distributions_all (
10859: accounting_date,
10860: accrual_posted_flag,
10861: assets_addition_flag,
10862: assets_tracking_flag,

Line 11520: INSERT INTO ap_invoice_distributions_all (

11516: FETCH c_reverse_tax_dist_1
11517: INTO l_reverse_tax_dist;
11518: EXIT WHEN c_reverse_tax_dist_1%NOTFOUND;
11519:
11520: INSERT INTO ap_invoice_distributions_all (
11521: accounting_date,
11522: accrual_posted_flag,
11523: assets_addition_flag,
11524: assets_tracking_flag,

Line 12221: UPDATE ap_invoice_distributions_all aid

12217: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
12218: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
12219: END IF;
12220:
12221: UPDATE ap_invoice_distributions_all aid
12222: SET reversal_flag = (select reverse_flag
12223: from zx_rec_nrec_dist zx
12224: where zx.rec_nrec_tax_dist_id = aid.detail_tax_dist_id)
12225: WHERE aid.invoice_id = p_invoice_id

Line 12238: FROM ap_invoice_distributions_all aid1

12234:
12235: UPDATE ap_invoice_distributions aid
12236: SET aid.related_id =
12237: (SELECT invoice_distribution_id
12238: FROM ap_invoice_distributions_all aid1
12239: WHERE aid1.invoice_id = aid.invoice_id
12240: AND aid1.invoice_line_number = aid.invoice_line_number
12241: AND aid1.parent_reversal_id =
12242: (SELECT related_id

Line 12243: FROM ap_invoice_distributions_all aid2

12239: WHERE aid1.invoice_id = aid.invoice_id
12240: AND aid1.invoice_line_number = aid.invoice_line_number
12241: AND aid1.parent_reversal_id =
12242: (SELECT related_id
12243: FROM ap_invoice_distributions_all aid2
12244: WHERE aid2.invoice_id = aid.invoice_id
12245: AND aid2.invoice_line_number = aid.invoice_line_number
12246: AND aid2.invoice_distribution_id = aid.parent_reversal_id)
12247: )

Line 12342: FROM ap_invoice_distributions_all invDist,

12338: WHERE invoice_id = P_Invoice_Id;
12339:
12340: CURSOR prepay_lines IS
12341: SELECT distinct prepLine.*
12342: FROM ap_invoice_distributions_all invDist,
12343: ap_invoice_distributions_all prepDist,
12344: ap_invoice_lines_all prepLine
12345: WHERE invDist.prepay_distribution_id = prepDist.invoice_distribution_id
12346: AND prepLine.invoice_id = prepDist.invoice_id

Line 12343: ap_invoice_distributions_all prepDist,

12339:
12340: CURSOR prepay_lines IS
12341: SELECT distinct prepLine.*
12342: FROM ap_invoice_distributions_all invDist,
12343: ap_invoice_distributions_all prepDist,
12344: ap_invoice_lines_all prepLine
12345: WHERE invDist.prepay_distribution_id = prepDist.invoice_distribution_id
12346: AND prepLine.invoice_id = prepDist.invoice_id
12347: AND prepLine.line_number = prepDist.invoice_line_number

Line 12574: (p_invoice_id IN ap_invoice_distributions_all.invoice_id%Type,

12570:
12571: END Generate_Recouped_Tax;
12572:
12573: Function Delete_Tax_Distributions
12574: (p_invoice_id IN ap_invoice_distributions_all.invoice_id%Type,
12575: p_calling_mode IN VARCHAR2,
12576: p_all_error_messages IN VARCHAR2,
12577: p_error_code OUT NOCOPY VARCHAR2,
12578: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN IS

Line 12582: From ap_invoice_distributions_all

12578: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN IS
12579:
12580: Cursor c_preview_dists (c_invoice_id Number) Is
12581: Select org_id, invoice_id, invoice_line_number
12582: From ap_invoice_distributions_all
12583: --bugfix:5565648 added the 'invoice_id = c_invoice_id' as without that
12584: --it was doing a full table scan
12585: Where invoice_id = c_invoice_id
12586: AND distribution_class = 'CANDIDATE'

Line 12685: UPDATE ap_invoice_distributions_All aid1

12681: l_return_status := FALSE;
12682: END IF;
12683: END IF;
12684: --Bug6678578START
12685: UPDATE ap_invoice_distributions_All aid1
12686: SET aid1.amount = aid1.amount + nvl((SELECT SUM(nvl(aid2.amount,0))
12687: FROM ap_invoice_distributions_All aid2
12688: WHERE aid2.invoice_id = p_invoice_id
12689: AND aid2.invoice_line_number = aid1.invoice_line_number

Line 12687: FROM ap_invoice_distributions_All aid2

12683: END IF;
12684: --Bug6678578START
12685: UPDATE ap_invoice_distributions_All aid1
12686: SET aid1.amount = aid1.amount + nvl((SELECT SUM(nvl(aid2.amount,0))
12687: FROM ap_invoice_distributions_All aid2
12688: WHERE aid2.invoice_id = p_invoice_id
12689: AND aid2.invoice_line_number = aid1.invoice_line_number
12690: AND aid2.charge_applicable_to_dist_id = aid1.invoice_distribution_id
12691: AND aid2.line_type_lookup_code IN ('REC_TAX','NONREC_TAX','TRV','TIPV')

Line 12694: FROM ap_invoice_distributions_All aid3

12690: AND aid2.charge_applicable_to_dist_id = aid1.invoice_distribution_id
12691: AND aid2.line_type_lookup_code IN ('REC_TAX','NONREC_TAX','TRV','TIPV')
12692: AND aid2.distribution_class = 'CANDIDATE'),0),
12693: aid1.base_amount = aid1.base_amount + nvl((SELECT SUM(nvl(aid3.base_amount,0))
12694: FROM ap_invoice_distributions_All aid3
12695: WHERE aid3.invoice_id = p_invoice_id
12696: AND aid3.invoice_line_number = aid1.invoice_line_number
12697: AND aid3.charge_applicable_to_dist_id = aid1.invoice_distribution_id
12698: AND aid3.line_type_lookup_code IN ('REC_TAX','NONREC_TAX','TRV','TIPV')

Line 12775: FROM ap_invoice_distributions_all

12771:
12772: BEGIN
12773: SELECT 'Tax Distributions Exist'
12774: INTO l_dummy
12775: FROM ap_invoice_distributions_all
12776: WHERE invoice_id = p_invoice_id
12777: AND line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX', 'TIPV', 'TRV', 'TERV')
12778: AND rownum = 1;
12779:

Line 12799: FROM ap_invoice_distributions_all

12795: END IF;
12796:
12797: /* SELECT 'Tax Only Line Exist'
12798: INTO l_dummy
12799: FROM ap_invoice_distributions_all
12800: WHERE invoice_id = p_invoice_id
12801: AND line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX', 'TIPV', 'TRV', 'TERV')
12802: AND charge_applicable_to_dist_id IS NULL
12803: AND rownum = 1; */

Line 12874: FROM ap_invoice_distributions_all D,

12870: pll.match_option match_option,
12871: pl.unit_meas_lookup_code po_uom,
12872: D.matched_uom_lookup_code rcv_uom,
12873: rsl.item_id rcv_item_id
12874: FROM ap_invoice_distributions_all D,
12875: po_distributions_all PD,
12876: po_lines_all PL,
12877: po_line_locations_all PLL,
12878: rcv_transactions RTXN,

Line 13619: FROM ap_invoice_distributions_all

13615: ELSE 'CREATED'
13616: END),
13617: 'DISTRIBUTE',
13618: (CASE (SELECT 'Y'
13619: FROM ap_invoice_distributions_all
13620: WHERE invoice_id = ai.invoice_id
13621: AND line_type_lookup_code <> 'AWT'
13622: AND (tax_already_distributed_flag = 'Y'
13623: OR detail_tax_dist_id IS NOT NULL)

Line 13729: FROM ap_invoice_distributions_all aid_reverse,

13725: CURSOR c_reverse_dist (c_invoice_id NUMBER) IS
13726: SELECT aid_reverse.invoice_distribution_id invoice_distribution_id,
13727: aid_parent.invoice_distribution_id parent_reversal_id,
13728: aid_parent.dist_code_combination_id parent_ccid
13729: FROM ap_invoice_distributions_all aid_reverse,
13730: ap_invoice_distributions_all aid_parent,
13731: zx_rec_nrec_dist zx
13732: WHERE aid_reverse.invoice_id = c_invoice_id
13733: AND aid_reverse.detail_tax_dist_id = zx.rec_nrec_tax_dist_id

Line 13730: ap_invoice_distributions_all aid_parent,

13726: SELECT aid_reverse.invoice_distribution_id invoice_distribution_id,
13727: aid_parent.invoice_distribution_id parent_reversal_id,
13728: aid_parent.dist_code_combination_id parent_ccid
13729: FROM ap_invoice_distributions_all aid_reverse,
13730: ap_invoice_distributions_all aid_parent,
13731: zx_rec_nrec_dist zx
13732: WHERE aid_reverse.invoice_id = c_invoice_id
13733: AND aid_reverse.detail_tax_dist_id = zx.rec_nrec_tax_dist_id
13734: AND aid_parent.detail_tax_dist_id = zx.reversed_tax_dist_id

Line 13754: (invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE,

13750: AND line_type_lookup_code IN ('ITEM', 'ACCRUAL', 'FREIGHT', 'MISCELLANEOUS','PREPAY') --/*Bug7338249*/
13751: AND included_tax_amount <> 0 ;
13752:
13753: TYPE reversal_dist_info IS RECORD
13754: (invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE,
13755: parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE,
13756: parent_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE);
13757:
13758: TYPE reversal_dist_type IS TABLE OF reversal_dist_info;

Line 13755: parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE,

13751: AND included_tax_amount <> 0 ;
13752:
13753: TYPE reversal_dist_info IS RECORD
13754: (invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE,
13755: parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE,
13756: parent_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE);
13757:
13758: TYPE reversal_dist_type IS TABLE OF reversal_dist_info;
13759:

Line 13756: parent_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE);

13752:
13753: TYPE reversal_dist_info IS RECORD
13754: (invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE,
13755: parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE,
13756: parent_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE);
13757:
13758: TYPE reversal_dist_type IS TABLE OF reversal_dist_info;
13759:
13760: l_reveral_dist_tab reversal_dist_type;

Line 13765: l_dist_amt ap_invoice_distributions_all.amount%type; -- for bug 6326552

13761:
13762: l_debug_info VARCHAR2(240);
13763: l_curr_calling_sequence VARCHAR2(4000);
13764: l_api_name CONSTANT VARCHAR2(100) := 'Update_Distributions';
13765: l_dist_amt ap_invoice_distributions_all.amount%type; -- for bug 6326552
13766: l_tot_tax_amt ap_invoice_distributions_all.amount%type; -- for bug 6326552
13767: BEGIN
13768:
13769: -------------------------------------------------------------------

Line 13766: l_tot_tax_amt ap_invoice_distributions_all.amount%type; -- for bug 6326552

13762: l_debug_info VARCHAR2(240);
13763: l_curr_calling_sequence VARCHAR2(4000);
13764: l_api_name CONSTANT VARCHAR2(100) := 'Update_Distributions';
13765: l_dist_amt ap_invoice_distributions_all.amount%type; -- for bug 6326552
13766: l_tot_tax_amt ap_invoice_distributions_all.amount%type; -- for bug 6326552
13767: BEGIN
13768:
13769: -------------------------------------------------------------------
13770: l_debug_info := 'Step 1: Update the related_id column';

Line 13776: UPDATE ap_invoice_distributions_all aid

13772: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13773: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
13774: END IF;
13775:
13776: UPDATE ap_invoice_distributions_all aid
13777: SET related_id = (SELECT DECODE(MIN(nrtax.invoice_distribution_id),
13778: NULL, MIN(other.invoice_distribution_id),
13779: MIN(nrtax.invoice_distribution_id))
13780: FROM ap_invoice_distributions_all nrtax,

Line 13780: FROM ap_invoice_distributions_all nrtax,

13776: UPDATE ap_invoice_distributions_all aid
13777: SET related_id = (SELECT DECODE(MIN(nrtax.invoice_distribution_id),
13778: NULL, MIN(other.invoice_distribution_id),
13779: MIN(nrtax.invoice_distribution_id))
13780: FROM ap_invoice_distributions_all nrtax,
13781: ap_invoice_distributions_all other
13782: WHERE nrtax.invoice_id = aid.invoice_id
13783: AND other.invoice_id = aid.invoice_id
13784: AND nrtax.detail_tax_dist_id = aid.detail_tax_dist_id

Line 13781: ap_invoice_distributions_all other

13777: SET related_id = (SELECT DECODE(MIN(nrtax.invoice_distribution_id),
13778: NULL, MIN(other.invoice_distribution_id),
13779: MIN(nrtax.invoice_distribution_id))
13780: FROM ap_invoice_distributions_all nrtax,
13781: ap_invoice_distributions_all other
13782: WHERE nrtax.invoice_id = aid.invoice_id
13783: AND other.invoice_id = aid.invoice_id
13784: AND nrtax.detail_tax_dist_id = aid.detail_tax_dist_id
13785: AND other.detail_tax_dist_id = aid.detail_tax_dist_id

Line 13792: FROM ap_invoice_distributions_all aid1

13788: GROUP BY 1)
13789: WHERE aid.invoice_id = P_Invoice_Header_Rec.invoice_id
13790: AND aid.line_type_lookup_code in ('NONREC_TAX', 'TIPV', 'TRV', 'TERV')
13791: AND EXISTS (SELECT aid1.detail_tax_dist_id
13792: FROM ap_invoice_distributions_all aid1
13793: WHERE aid1.invoice_id = aid.invoice_id
13794: AND aid1.detail_tax_dist_id = aid.detail_tax_dist_id
13795: HAVING count(*) > 1
13796: GROUP BY aid1.detail_tax_dist_id);

Line 13835: UPDATE ap_invoice_distributions_all aid

13831: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13832: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
13833: END IF;
13834:
13835: UPDATE ap_invoice_distributions_all aid
13836: SET rounding_amt =
13837: (SELECT zd.func_curr_rounding_adjustment
13838: FROM zx_rec_nrec_dist zd
13839: WHERE zd.rec_nrec_tax_dist_id = aid.detail_tax_dist_id)

Line 13913: UPDATE ap_invoice_distributions_all aid

13909: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13910: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
13911: END IF;
13912:
13913: UPDATE ap_invoice_distributions_all aid
13914: SET aid.tax_already_distributed_flag = 'Y'
13915: WHERE aid.invoice_id = p_invoice_header_rec.invoice_id
13916: AND NVL(aid.tax_already_distributed_flag, 'N') = 'N'
13917: AND aid.invoice_distribution_id IN

Line 13919: FROM ap_invoice_distributions_all aid1,

13915: WHERE aid.invoice_id = p_invoice_header_rec.invoice_id
13916: AND NVL(aid.tax_already_distributed_flag, 'N') = 'N'
13917: AND aid.invoice_distribution_id IN
13918: ( SELECT aid1.charge_applicable_to_dist_id
13919: FROM ap_invoice_distributions_all aid1,
13920: zx_rec_nrec_dist zd
13921: WHERE zd.REC_NREC_TAX_DIST_ID = aid1.DETAIL_TAX_DIST_ID
13922: AND aid1.invoice_id = p_invoice_header_rec.invoice_id );
13923:

Line 13938: FROM ap_invoice_distributions_all aid

13934: AND ail.generate_dists <> 'D'
13935: AND line_type_lookup_code = 'TAX'
13936: AND EXISTS
13937: (SELECT aid.invoice_distribution_id
13938: FROM ap_invoice_distributions_all aid
13939: WHERE aid.invoice_id = ail.invoice_id
13940: AND aid.invoice_line_number = ail.line_number);
13941:
13942: -----------------------------------------------------------------

Line 13945: UPDATE ap_invoice_distributions_all tax

13941:
13942: -----------------------------------------------------------------
13943: l_debug_info := 'Step 7: Update Invoice Includes Prepay Flag';
13944: -----------------------------------------------------------------
13945: UPDATE ap_invoice_distributions_all tax
13946: SET tax.invoice_includes_prepay_flag = 'Y'
13947: WHERE tax.invoice_id = p_invoice_header_rec.invoice_id
13948: AND nvl(tax.invoice_includes_prepay_flag,'N') <> 'Y'
13949: AND line_type_lookup_code in ('NONREC_TAX','REC_TAX','TIPV','TERV','TRV')

Line 13974: FROM ap_invoice_distributions_All

13970:
13971:
13972: SELECT sum(amount) -- Select added for bug 6326552 to make sure
13973: INTO l_dist_amt -- sure that we update the distributions only once.
13974: FROM ap_invoice_distributions_All
13975: WHERE invoice_id = p_invoice_header_rec.invoice_id
13976: AND invoice_line_number = i.line_number
13977: AND line_type_lookup_code IN ('ITEM', --Bug6653070 Added SUM()
13978: --instead of only amount

Line 14006: FROM ap_invoice_distributions_All

14002: SELECT SUM(amount) -- Select added for bug 6326552 to make sure
14003: INTO l_tot_tax_amt -- sure that we update the distributions if
14004: -- if included tax amount is changed at
14005: -- line level. .
14006: FROM ap_invoice_distributions_All
14007: WHERE invoice_id = p_invoice_header_rec.invoice_id
14008: AND invoice_line_number = i.line_number
14009: AND line_type_lookup_code IN ('REC_TAX','NONREC_TAX','TRV','TERV','TIPV');
14010:

Line 14031: UPDATE ap_invoice_distributions_All aid1 --Bug6653070

14027: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
14028: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
14029: END IF;
14030:
14031: UPDATE ap_invoice_distributions_All aid1 --Bug6653070
14032: SET aid1.amount = aid1.amount - nvl((SELECT SUM(nvl(amount,0))
14033: FROM ap_invoice_distributions_All aid2
14034: WHERE aid2.invoice_id = p_invoice_header_rec.invoice_id
14035: AND aid2.invoice_line_number = i.line_number

Line 14033: FROM ap_invoice_distributions_All aid2

14029: END IF;
14030:
14031: UPDATE ap_invoice_distributions_All aid1 --Bug6653070
14032: SET aid1.amount = aid1.amount - nvl((SELECT SUM(nvl(amount,0))
14033: FROM ap_invoice_distributions_All aid2
14034: WHERE aid2.invoice_id = p_invoice_header_rec.invoice_id
14035: AND aid2.invoice_line_number = i.line_number
14036: AND aid2.charge_applicable_to_dist_id = aid1.invoice_distribution_id
14037: AND aid2.line_type_lookup_code IN ('REC_TAX','NONREC_TAX', 'TIPV', 'TRV')),0),

Line 14039: FROM ap_invoice_distributions_All aid3

14035: AND aid2.invoice_line_number = i.line_number
14036: AND aid2.charge_applicable_to_dist_id = aid1.invoice_distribution_id
14037: AND aid2.line_type_lookup_code IN ('REC_TAX','NONREC_TAX', 'TIPV', 'TRV')),0),
14038: aid1.base_amount =aid1.base_amount- nvl((SELECT SUM(nvl(base_amount,0))
14039: FROM ap_invoice_distributions_All aid3
14040: WHERE aid3.invoice_id = p_invoice_header_rec.invoice_id
14041: AND aid3.invoice_line_number = i.line_number
14042: AND aid3.charge_applicable_to_dist_id = aid1.invoice_distribution_id
14043: AND aid3.line_type_lookup_code IN ('REC_TAX','NONREC_TAX', 'TIPV', 'TRV','TERV')),0)

Line 14068: UPDATE ap_invoice_distributions_all

14064:
14065: IF l_reveral_dist_tab.count > 0 THEN
14066: FOR h in l_reveral_dist_tab.first .. l_reveral_dist_tab.last LOOP
14067:
14068: UPDATE ap_invoice_distributions_all
14069: SET parent_reversal_id = l_reveral_dist_tab(h).parent_reversal_id
14070: ,dist_code_combination_id = l_reveral_dist_tab(h).parent_ccid
14071: WHERE invoice_distribution_id = l_reveral_dist_tab(h).invoice_distribution_id
14072: AND nvl(reversal_flag, 'N') <> 'Y';

Line 14084: UPDATE ap_invoice_distributions_all aid

14080: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
14081: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
14082: END IF;
14083:
14084: UPDATE ap_invoice_distributions_all aid
14085: SET reversal_flag = (select reverse_flag
14086: from zx_rec_nrec_dist zx
14087: where zx.rec_nrec_tax_dist_id = aid.detail_tax_dist_id)
14088: WHERE aid.invoice_id = p_invoice_header_rec.invoice_id