DBA Data[Home] [Help]

APPS.AP_ETAX_SERVICES_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

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 1548: ap_invoice_distributions_all aid,

1544:
1545: CURSOR Invoice_Dists (c_invoice_id NUMBER) IS
1546: SELECT aid.*
1547: FROM ap_invoice_lines_all ail,
1548: ap_invoice_distributions_all aid,
1549: ap_invoices_all ai , --Bug14779241
1550: ap_system_parameters_all asp --Bug14779241
1551: WHERE ail.invoice_id = aid.invoice_id
1552: AND ail.line_number = aid.invoice_line_number

Line 1582: ap_invoice_distributions_all aid,

1578: AND (NVL(aid.reversal_flag,'N') <> 'Y') -- bug 12419997 --Bug14383132
1579: UNION
1580: SELECT aid.*
1581: FROM ap_invoice_lines_all ail,
1582: ap_invoice_distributions_all aid,
1583: ap_invoices_all ai, --Bug14779241
1584: ap_system_parameters_all asp --Bug14779241
1585: WHERE ail.invoice_id = aid.invoice_id
1586: AND ail.line_number = aid.invoice_line_number

Line 1610: ap_invoice_distributions_all aid,

1606: -- cursor will be used
1607: CURSOR Invoice_Dist (c_invoice_id NUMBER, c_line_number NUMBER) IS
1608: SELECT aid.*
1609: FROM ap_invoice_lines_all ail,
1610: ap_invoice_distributions_all aid,
1611: ap_invoices_all ai, --Bug14779241
1612: ap_system_parameters_all asp --Bug14779241
1613: WHERE ail.invoice_id = aid.invoice_id
1614: AND ail.line_number = aid.invoice_line_number

Line 1642: ap_invoice_distributions_all aid,

1638: AND (NVL(aid.reversal_flag,'N') <> 'Y') -- bug 12419997 --Bug14383132
1639: UNION
1640: SELECT aid.*
1641: FROM ap_invoice_lines_all ail,
1642: ap_invoice_distributions_all aid,
1643: ap_invoices_all ai, --Bug14779241
1644: ap_system_parameters_all asp --Bug14779241
1645: WHERE ail.invoice_id = aid.invoice_id
1646: AND ail.line_number = aid.invoice_line_number

Line 1817: UPDATE ap_invoice_distributions_All aid1

1813: --Bug9436217
1814:
1815: --Bug#11674044 modified the query to improve the performance.
1816: IF p_line_number IS NULL THEN
1817: UPDATE ap_invoice_distributions_All aid1
1818: /*no_unnest hints and consolidation of query for bug 11674044 */
1819: SET (aid1.amount, aid1.base_amount) =
1820: (SELECT aid1.amount + NVL(SUM(Nvl(amount, 0)),0)
1821: , aid1.base_amount + NVL(SUM(Nvl(base_amount, 0)),0)

Line 1822: FROM ap_invoice_distributions_all aid2

1818: /*no_unnest hints and consolidation of query for bug 11674044 */
1819: SET (aid1.amount, aid1.base_amount) =
1820: (SELECT aid1.amount + NVL(SUM(Nvl(amount, 0)),0)
1821: , aid1.base_amount + NVL(SUM(Nvl(base_amount, 0)),0)
1822: FROM ap_invoice_distributions_all aid2
1823: WHERE aid2.invoice_id = aid1.invoice_id
1824: AND aid2.charge_applicable_to_dist_id = aid1.invoice_distribution_id
1825: AND aid2.line_type_lookup_code IN ( 'REC_TAX', 'NONREC_TAX', 'TRV', 'TIPV', 'TERV' )
1826: AND EXISTS (SELECT /*+ NO_UNNEST */ 1

Line 1901: UPDATE ap_invoice_distributions_All aid1

1897: -----------------------------------------------------------------
1898: --ER CHANGES 6772098
1899: IF (p_line_number IS NOT NULL) THEN
1900:
1901: UPDATE ap_invoice_distributions_All aid1
1902: /*no_unnest hints and consolidation of query for bug 11674044 */
1903: SET (aid1.amount, aid1.base_amount) =
1904: (SELECT aid1.amount + NVL(SUM(Nvl(amount, 0)),0)
1905: , aid1.base_amount + NVL(SUM(Nvl(base_amount, 0)),0)

Line 1906: FROM ap_invoice_distributions_all aid2

1902: /*no_unnest hints and consolidation of query for bug 11674044 */
1903: SET (aid1.amount, aid1.base_amount) =
1904: (SELECT aid1.amount + NVL(SUM(Nvl(amount, 0)),0)
1905: , aid1.base_amount + NVL(SUM(Nvl(base_amount, 0)),0)
1906: FROM ap_invoice_distributions_all aid2
1907: WHERE aid2.invoice_id = p_invoice_id
1908: AND aid2.invoice_line_number = p_line_number
1909: AND aid2.charge_applicable_to_dist_id = aid1.invoice_distribution_id
1910: AND aid2.line_type_lookup_code IN ( 'REC_TAX', 'NONREC_TAX', 'TRV', 'TIPV', 'TERV' )

Line 2004: UPDATE /*+ ROWID (AID) */ AP_Invoice_Distributions_All AID

2000: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2001: END IF;
2002: --Print(l_api_name,l_debug_info);
2003: -------------------------------------------------------------------
2004: UPDATE /*+ ROWID (AID) */ AP_Invoice_Distributions_All AID
2005: SET (RECOVERY_RATE_CODE,
2006: RECOVERY_RATE_ID,
2007: RECOVERY_TYPE_CODE) =
2008: (SELECT REC.Tax_Rate_Code,

Line 2970: FROM ap_invoice_distributions_all aid,

2966: 'LINE', -- reversed_trx_level_type
2967: idc.invoice_line_number, -- reversed_trx_line_id
2968: idc.invoice_distribution_id, -- reversed_trx_line_dist_id
2969: NULL -- reversed_tax_line_id
2970: FROM ap_invoice_distributions_all aid,
2971: ap_invoice_distributions_all idc
2972: WHERE aid.invoice_id = l_inv_header_rec.invoice_id
2973: AND aid.line_type_lookup_code NOT IN
2974: ('AWT', 'REC_TAX', 'NONREC_TAX', 'TRV', 'TERV', 'TIPV')

Line 2971: ap_invoice_distributions_all idc

2967: idc.invoice_line_number, -- reversed_trx_line_id
2968: idc.invoice_distribution_id, -- reversed_trx_line_dist_id
2969: NULL -- reversed_tax_line_id
2970: FROM ap_invoice_distributions_all aid,
2971: ap_invoice_distributions_all idc
2972: WHERE aid.invoice_id = l_inv_header_rec.invoice_id
2973: AND aid.line_type_lookup_code NOT IN
2974: ('AWT', 'REC_TAX', 'NONREC_TAX', 'TRV', 'TERV', 'TIPV')
2975: AND (aid.related_id IS NULL

Line 3597: UPDATE ap_invoice_distributions_all

3593: WHERE ai.invoice_id = l_inv_header_rec.invoice_id;
3594:
3595:
3596: --Bug9494315
3597: UPDATE ap_invoice_distributions_all
3598: SET distribution_class = 'PERMANENT'
3599: WHERE invoice_id = l_inv_header_rec.invoice_id
3600: AND distribution_class = 'CANDIDATE'
3601: AND line_type_lookup_code IN ('REC_TAX','NONREC_TAX','TRV','TERV','TIPV');

Line 3943: FROM ap_invoice_distributions_all

3939: accounting_event_id,
3940: dist_match_type,
3941: amount,
3942: prepay_amount_remaining
3943: FROM ap_invoice_distributions_all
3944: WHERE invoice_id = p_invoice_header_rec.invoice_id
3945: AND line_type_lookup_code NOT IN ('REC_TAX', 'NONREC_TAX', 'TRV', 'TERV', 'TIPV');
3946:
3947: TYPE l_itm_dist_tab_local IS TABLE OF itm_Dist%ROWTYPE;

Line 3963: l_po_distribution_id ap_invoice_distributions_all.po_distribution_id%TYPE;

3959:
3960: l_return_status BOOLEAN := TRUE;
3961: l_freeze_dist_flag VARCHAR2(1);
3962:
3963: l_po_distribution_id ap_invoice_distributions_all.po_distribution_id%TYPE;
3964: l_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE;
3965:
3966: freeze_dist_list ZX_API_PUB.number_tbl_type;
3967: freeze_dist_count NUMBER := 0; --bug8302194

Line 3964: l_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE;

3960: l_return_status BOOLEAN := TRUE;
3961: l_freeze_dist_flag VARCHAR2(1);
3962:
3963: l_po_distribution_id ap_invoice_distributions_all.po_distribution_id%TYPE;
3964: l_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE;
3965:
3966: freeze_dist_list ZX_API_PUB.number_tbl_type;
3967: freeze_dist_count NUMBER := 0; --bug8302194
3968:

Line 4096: IF ( ap_invoice_distributions_pkg.Get_Posted_Status(

4092: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
4093: END IF;
4094: -----------------------------------------------------------------
4095: IF (l_freeze_dist_flag = 'N' ) THEN
4096: IF ( ap_invoice_distributions_pkg.Get_Posted_Status(
4097: X_Accrual_Posted_Flag => l_itm_dist_list_local(i).accrual_posted_flag,
4098: X_Cash_Posted_Flag => l_itm_dist_list_local(i).cash_posted_flag,
4099: X_Posted_Flag => l_itm_dist_list_local(i).posted_flag,
4100: X_Org_Id => l_itm_dist_list_local(i).org_id) <> 'N') THEN

Line 4367: FROM ap_invoice_distributions_all

4363: corrected_invoice_dist_id,
4364: invoice_distribution_id,
4365: detail_tax_dist_id,
4366: accounting_event_id
4367: FROM ap_invoice_distributions_all
4368: WHERE invoice_id = p_invoice_header_rec.invoice_id
4369: AND line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX', 'TRV', 'TERV', 'TIPV')
4370: AND (related_id IS NULL
4371: OR (related_id = invoice_distribution_id

Line 4414: l_po_distribution_id ap_invoice_distributions_all.po_distribution_id%TYPE;

4410:
4411: l_return_status BOOLEAN := TRUE;
4412: l_freeze_dist_flag VARCHAR2(1);
4413:
4414: l_po_distribution_id ap_invoice_distributions_all.po_distribution_id%TYPE;
4415: l_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE;
4416:
4417: TYPE freeze_tax_dist_type IS TABLE OF zx_tax_dist_id_gt%ROWTYPE;
4418: freeze_dist_list freeze_tax_dist_type := freeze_tax_dist_type();

Line 4415: l_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE;

4411: l_return_status BOOLEAN := TRUE;
4412: l_freeze_dist_flag VARCHAR2(1);
4413:
4414: l_po_distribution_id ap_invoice_distributions_all.po_distribution_id%TYPE;
4415: l_rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE;
4416:
4417: TYPE freeze_tax_dist_type IS TABLE OF zx_tax_dist_id_gt%ROWTYPE;
4418: freeze_dist_list freeze_tax_dist_type := freeze_tax_dist_type();
4419:

Line 4520: FROM ap_invoice_distributions_all

4516: --this validation because it can be null for tax-only lines
4517:
4518: SELECT po_distribution_id, rcv_transaction_id
4519: INTO l_po_distribution_id, l_rcv_transaction_id
4520: FROM ap_invoice_distributions_all
4521: WHERE invoice_distribution_id =
4522: l_tax_dist_list_local(i).charge_applicable_to_dist_id;
4523:
4524:

Line 4557: IF ( ap_invoice_distributions_pkg.Get_Posted_Status(

4553: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
4554: END IF;
4555: -----------------------------------------------------------------
4556: IF (l_freeze_dist_flag = 'N' ) THEN
4557: IF ( ap_invoice_distributions_pkg.Get_Posted_Status(
4558: X_Accrual_Posted_Flag => l_tax_dist_list_local(i).accrual_posted_flag,
4559: X_Cash_Posted_Flag => l_tax_dist_list_local(i).cash_posted_flag,
4560: X_Posted_Flag => l_tax_dist_list_local(i).posted_flag,
4561: X_Org_Id => l_tax_dist_list_local(i).org_id) <> 'N') THEN

Line 4663: FROM ap_invoice_distributions_all

4659: IF (l_freeze_dist_flag = 'N' ) THEN
4660: BEGIN
4661: SELECT 'Y'
4662: INTO l_freeze_dist_flag
4663: FROM ap_invoice_distributions_all
4664: WHERE corrected_invoice_dist_id =
4665: l_tax_dist_list_local(i).charge_applicable_to_dist_id
4666: AND ROWNUM = 1;
4667:

Line 7699: FROM ap_invoice_distributions_all aid

7695: BEGIN
7696:
7697: SELECT aid.dist_code_combination_id
7698: INTO l_inv_line_list(i).default_dist_ccid
7699: FROM ap_invoice_distributions_all aid
7700: WHERE aid.invoice_id = l_inv_line_list(i).invoice_id
7701: AND aid.invoice_line_number = l_inv_line_list(i).line_number
7702: AND ROWNUM = 1;
7703:

Line 7901: FROM ap_invoice_distributions_all aids

7897: trans_lines(i).trx_line_id := -1 * (l_inv_line_list(i).invoice_id || l_inv_line_list(i).line_number || p_line_number);
7898:
7899: SELECT sum(amount)
7900: INTO trans_lines(i).line_amt
7901: FROM ap_invoice_distributions_all aids
7902: WHERE invoice_id = p_invoice_header_rec.invoice_id
7903: AND invoice_line_number = p_line_number
7904: AND line_type_lookup_code = 'PREPAY'
7905: AND EXISTS

Line 7907: from ap_invoice_distributions_all aidp

7903: AND invoice_line_number = p_line_number
7904: AND line_type_lookup_code = 'PREPAY'
7905: AND EXISTS
7906: (select 'Prepayment Invoice'
7907: from ap_invoice_distributions_all aidp
7908: where aidp.invoice_distribution_id = aids.prepay_distribution_id
7909: and aidp.invoice_id = l_inv_line_list(i).invoice_id
7910: and aidp.invoice_line_number = l_inv_line_list(i).line_number);
7911:

Line 11040: l_converted_qty ap_invoice_distributions_all.quantity_invoiced%TYPE;

11036: l_amount zx_itm_distributions_gt.trx_line_dist_amt%TYPE;
11037: l_price_diff zx_itm_distributions_gt.price_diff%TYPE;
11038: l_po_header_curr_conv_rate zx_itm_distributions_gt.ref_doc_curr_conv_rate%TYPE;
11039: l_receipt_curr_conv_rate zx_itm_distributions_gt.applied_to_doc_curr_conv_rate%TYPE;
11040: l_converted_qty ap_invoice_distributions_all.quantity_invoiced%TYPE;
11041: l_converted_price ap_invoice_distributions_all.unit_price%TYPE;
11042:
11043: -- Correction Invoice Info
11044: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;

Line 11041: l_converted_price ap_invoice_distributions_all.unit_price%TYPE;

11037: l_price_diff zx_itm_distributions_gt.price_diff%TYPE;
11038: l_po_header_curr_conv_rate zx_itm_distributions_gt.ref_doc_curr_conv_rate%TYPE;
11039: l_receipt_curr_conv_rate zx_itm_distributions_gt.applied_to_doc_curr_conv_rate%TYPE;
11040: l_converted_qty ap_invoice_distributions_all.quantity_invoiced%TYPE;
11041: l_converted_price ap_invoice_distributions_all.unit_price%TYPE;
11042:
11043: -- Correction Invoice Info
11044: l_adj_doc_application_id zx_transaction_lines_gt.adjusted_doc_application_id%TYPE;
11045: l_adj_doc_entity_code zx_transaction_lines_gt.adjusted_doc_entity_code%TYPE;

Line 11146: FROM ap_invoice_distributions_all

11142: -----------------------------------------------------------------
11143: IF (l_inv_dist_list(i).related_retainage_dist_id IS NOT NULL) THEN
11144: SELECT SUM(amount)
11145: INTO l_amount
11146: FROM ap_invoice_distributions_all
11147: WHERE invoice_id = l_inv_dist_list(i).invoice_id
11148: AND (related_id = l_inv_dist_list(i).related_id
11149: or related_retainage_dist_id = l_inv_dist_list(i).related_retainage_dist_id);
11150:

Line 11156: FROM ap_invoice_distributions_all

11152: ELSIF (l_inv_dist_list(i).related_id IS NOT NULL) THEN
11153:
11154: SELECT SUM(amount)
11155: INTO l_amount
11156: FROM ap_invoice_distributions_all
11157: WHERE invoice_id = l_inv_dist_list(i).invoice_id
11158: AND related_id = l_inv_dist_list(i).related_id;
11159:
11160: ELSE

Line 11267: From ap_invoice_distributions_all

11263: l_inv_dist_list(i).corrected_invoice_dist_id IS NOT NULL) THEN
11264:
11265: Select invoice_id, invoice_line_number
11266: Into l_adj_doc_trx_id, l_adj_doc_line_id
11267: From ap_invoice_distributions_all
11268: Where invoice_distribution_id = l_inv_dist_list(i).corrected_invoice_dist_id;
11269:
11270: IF NOT (AP_ETAX_UTILITY_PKG.Get_Corrected_Invoice_Info(
11271: P_Corrected_Invoice_Id => l_inv_line_list(i).corrected_inv_id,

Line 11306: FROM ap_invoice_distributions_all

11302: l_inv_dist_list(i).prepay_distribution_id IS NOT NULL) THEN
11303:
11304: SELECT invoice_id, invoice_line_number
11305: INTO l_applied_from_trx_id, l_applied_from_line_id
11306: FROM ap_invoice_distributions_all
11307: WHERE invoice_distribution_id = l_inv_dist_list(i).prepay_distribution_id;
11308:
11309: IF NOT (AP_ETAX_UTILITY_PKG.Get_Prepay_Invoice_Info(
11310: P_Prepay_Invoice_Id => l_applied_from_trx_id,

Line 11354: FROM ap_invoice_distributions_all

11350: IF l_inv_dist_list(i).prepay_distribution_id IS NOT NULL THEN
11351:
11352: SELECT invoice_id, invoice_line_number
11353: INTO l_prepay_inv_id, l_prepay_line_num
11354: FROM ap_invoice_distributions_all
11355: WHERE invoice_distribution_id = l_inv_dist_list(i).prepay_distribution_id;
11356:
11357: trans_dists(j).trx_line_id := -1 * (l_prepay_inv_id || l_prepay_line_num || l_inv_dist_list(i).invoice_line_number);
11358:

Line 11387: select amount into l_retained_amount from ap_invoice_distributions_all aid

11383: -- For standard invoice having retainage we will populate the char4 column as 'S' and will get the retained amount
11384:
11385: trans_dists(j).char4 := 'S';
11386:
11387: select amount into l_retained_amount from ap_invoice_distributions_all aid
11388: where aid.invoice_id = l_inv_dist_list(i).invoice_id
11389: and aid.line_type_lookup_code = 'RETAINAGE'
11390: and aid.related_retainage_dist_id is NOT NULL
11391: and aid.related_retainage_dist_id = l_inv_dist_list(i).invoice_distribution_id;

Line 11402: SELECT amount INTO l_retainage_rrf_amount FROM ap_invoice_distributions_all

11398:
11399: trans_dists(j).char4 := 'R';
11400: l_retained_amount := 0;
11401:
11402: SELECT amount INTO l_retainage_rrf_amount FROM ap_invoice_distributions_all
11403: WHERE line_type_lookup_code = 'RETAINAGE'
11404: AND invoice_distribution_id = l_inv_dist_list(i).RETAINED_INVOICE_DIST_ID;
11405:
11406: SELECT aid1.quantity_invoiced , aid1.unit_price INTO l_quantity_invoiced , l_unit_price

Line 11407: FROM ap_invoice_distributions_all aid1 , ap_invoice_distributions_all aid2

11403: WHERE line_type_lookup_code = 'RETAINAGE'
11404: AND invoice_distribution_id = l_inv_dist_list(i).RETAINED_INVOICE_DIST_ID;
11405:
11406: SELECT aid1.quantity_invoiced , aid1.unit_price INTO l_quantity_invoiced , l_unit_price
11407: FROM ap_invoice_distributions_all aid1 , ap_invoice_distributions_all aid2
11408: WHERE aid1.line_type_lookup_code IN ('ACCRUAL' ,'ITEM')
11409: AND aid1.invoice_distribution_id = aid2.related_retainage_dist_id
11410: AND aid2.invoice_distribution_id = l_inv_dist_list(i).RETAINED_INVOICE_DIST_ID
11411: AND aid2.line_type_lookup_code = 'RETAINAGE';

Line 12624: ap_invoice_distributions_s.NEXTVAL invoice_distribution_id,

12620: tax_dist.award_id) award_id,
12621: NULL credit_card_trx_id,
12622: tax_dist.dist_match_type dist_match_type,
12623: tax_dist.rcv_transaction_id rcv_transaction_id,
12624: ap_invoice_distributions_s.NEXTVAL invoice_distribution_id,
12625: tax_dist.invoice_distribution_id parent_reversal_id,
12626: tax_dist.tax_recoverable_flag tax_recoverable_flag,
12627: NULL merchant_document_number,
12628: NULL merchant_name,

Line 12657: ap_invoice_distributions_s.CURRVAL, NULL) related_id,

12653: -- bug 5572121
12654: -- NULL related_id,
12655: DECODE( tax_dist.related_id, NULL, NULL,
12656: tax_dist.invoice_distribution_id,
12657: ap_invoice_distributions_s.CURRVAL, NULL) related_id,
12658: NULL asset_book_type_code,
12659: NULL asset_category_id,
12660: tax_dist.distribution_class distribution_class,
12661: tax_dist.tax_code_id tax_code_id,

Line 12675: from ap_invoice_distributions_all tax_dist,

12671: tax_dist.summary_tax_line_id summary_tax_line_id,
12672: 'N' rcv_charge_addition_flag,
12673: (-1)*tax_dist.prepay_tax_diff_amount prepay_tax_diff_amount, -- BUG 7338249 bug 9040333 added (-1)* as this is reversal
12674: tax_dist.pay_awt_group_id pay_awt_group_id /*BUG 10261626*/
12675: from ap_invoice_distributions_all tax_dist,
12676: ap_invoice_distributions_all item_dist,
12677: zx_rec_nrec_dist zx_dist
12678: where tax_dist.invoice_id = p_invoice_id
12679: /* -- Bug8575619 start */

Line 12676: ap_invoice_distributions_all item_dist,

12672: 'N' rcv_charge_addition_flag,
12673: (-1)*tax_dist.prepay_tax_diff_amount prepay_tax_diff_amount, -- BUG 7338249 bug 9040333 added (-1)* as this is reversal
12674: tax_dist.pay_awt_group_id pay_awt_group_id /*BUG 10261626*/
12675: from ap_invoice_distributions_all tax_dist,
12676: ap_invoice_distributions_all item_dist,
12677: zx_rec_nrec_dist zx_dist
12678: where tax_dist.invoice_id = p_invoice_id
12679: /* -- Bug8575619 start */
12680: and tax_dist.invoice_id = zx_dist.trx_id

Line 12695: from ap_invoice_distributions aid

12691: --and (p_line_number IS NULL -- bug 6056777
12692: -- or zx_dist.trx_line_id = p_line_number) --bug605677
12693: --bugfix:5582836
12694: and not exists(select detail_tax_dist_id
12695: from ap_invoice_distributions aid
12696: where aid.invoice_id = p_invoice_id
12697: and aid.detail_tax_dist_id = zx_dist.rec_nrec_tax_dist_id);
12698:
12699:

Line 12842: ap_invoice_distributions_s.NEXTVAL invoice_distribution_id,

12838: tax_dist.award_id) award_id,
12839: NULL credit_card_trx_id,
12840: tax_dist.dist_match_type dist_match_type,
12841: tax_dist.rcv_transaction_id rcv_transaction_id,
12842: ap_invoice_distributions_s.NEXTVAL invoice_distribution_id,
12843: tax_dist.invoice_distribution_id parent_reversal_id,
12844: tax_dist.tax_recoverable_flag tax_recoverable_flag,
12845: NULL merchant_document_number,
12846: NULL merchant_name,

Line 12875: ap_invoice_distributions_s.CURRVAL, NULL) related_id,

12871: -- bug 5572121
12872: -- NULL related_id,
12873: DECODE( tax_dist.related_id, NULL, NULL,
12874: tax_dist.invoice_distribution_id,
12875: ap_invoice_distributions_s.CURRVAL, NULL) related_id,
12876:
12877: NULL asset_book_type_code,
12878: NULL asset_category_id,
12879: tax_dist.distribution_class distribution_class,

Line 12894: from ap_invoice_distributions_all tax_dist,

12890: tax_dist.summary_tax_line_id summary_tax_line_id,
12891: 'N' rcv_charge_addition_flag,
12892: (-1)*tax_dist.prepay_tax_diff_amount prepay_tax_diff_amount, -- BUG 7338249 bug 9040333 added (-1)* as this is reversal
12893: tax_dist.pay_awt_group_id pay_awt_group_id /*BUG 10261626*/
12894: from ap_invoice_distributions_all tax_dist,
12895: ap_invoice_distributions_all item_dist,
12896: zx_rec_nrec_dist zx_dist
12897: where tax_dist.invoice_id = p_invoice_id
12898: /* -- Bug8575619 start */

Line 12895: ap_invoice_distributions_all item_dist,

12891: 'N' rcv_charge_addition_flag,
12892: (-1)*tax_dist.prepay_tax_diff_amount prepay_tax_diff_amount, -- BUG 7338249 bug 9040333 added (-1)* as this is reversal
12893: tax_dist.pay_awt_group_id pay_awt_group_id /*BUG 10261626*/
12894: from ap_invoice_distributions_all tax_dist,
12895: ap_invoice_distributions_all item_dist,
12896: zx_rec_nrec_dist zx_dist
12897: where tax_dist.invoice_id = p_invoice_id
12898: /* -- Bug8575619 start */
12899: and tax_dist.invoice_id = zx_dist.trx_id

Line 12913: from ap_invoice_distributions aid

12909: and zx_dist.reverse_flag = 'Y'
12910: and zx_dist.trx_line_id = p_line_number --bug6056777
12911: --bugfix:5582836
12912: and not exists(select detail_tax_dist_id
12913: from ap_invoice_distributions aid
12914: where aid.invoice_id = p_invoice_id
12915: and aid.detail_tax_dist_id = zx_dist.rec_nrec_tax_dist_id);
12916:
12917:

Line 13062: ap_invoice_distributions_s.NEXTVAL invoice_distribution_id,

13058: tax_dist.award_id) award_id,
13059: NULL credit_card_trx_id,
13060: tax_dist.dist_match_type dist_match_type,
13061: tax_dist.rcv_transaction_id rcv_transaction_id,
13062: ap_invoice_distributions_s.NEXTVAL invoice_distribution_id,
13063: tax_dist.invoice_distribution_id parent_reversal_id,
13064: tax_dist.tax_recoverable_flag tax_recoverable_flag,
13065: NULL merchant_document_number,
13066: NULL merchant_name,

Line 13095: ap_invoice_distributions_s.CURRVAL, NULL) related_id,

13091: -- bug 5572121
13092: -- NULL related_id,
13093: DECODE( tax_dist.related_id, NULL, NULL,
13094: tax_dist.invoice_distribution_id,
13095: ap_invoice_distributions_s.CURRVAL, NULL) related_id,
13096:
13097: NULL asset_book_type_code,
13098: NULL asset_category_id,
13099: tax_dist.distribution_class distribution_class,

Line 13117: ap_invoice_distributions_all item_dist,

13113: -- bug 6805655
13114: tax_dist.self_assessed_tax_liab_ccid self_assessed_tax_liab_ccid,
13115: (-1)*tax_dist.prepay_tax_diff_amount prepay_tax_diff_amount -- BUG 7338249 bug 9040333 added (-1)* as this is reversal
13116: from ap_self_assessed_tax_dist_all tax_dist,
13117: ap_invoice_distributions_all item_dist,
13118: zx_rec_nrec_dist zx_dist
13119: where tax_dist.invoice_id = p_invoice_id
13120: /* -- Bug8575619 start */
13121: and tax_dist.invoice_id = zx_dist.trx_id

Line 13137: from ap_invoice_distributions aid

13133: -- or zx_dist.trx_line_id = p_line_number) --bug605677
13134: --bugfix:5582836
13135: /* -- bug 6896627
13136: and not exists(select detail_tax_dist_id
13137: from ap_invoice_distributions aid
13138: where aid.invoice_id = p_invoice_id
13139: and aid.detail_tax_dist_id = zx_dist.rec_nrec_tax_dist_id)
13140: */
13141: AND NOT EXISTS

Line 13291: ap_invoice_distributions_s.NEXTVAL invoice_distribution_id,

13287: tax_dist.award_id) award_id,
13288: NULL credit_card_trx_id,
13289: tax_dist.dist_match_type dist_match_type,
13290: tax_dist.rcv_transaction_id rcv_transaction_id,
13291: ap_invoice_distributions_s.NEXTVAL invoice_distribution_id,
13292: tax_dist.invoice_distribution_id parent_reversal_id,
13293: tax_dist.tax_recoverable_flag tax_recoverable_flag,
13294: NULL merchant_document_number,
13295: NULL merchant_name,

Line 13324: ap_invoice_distributions_s.CURRVAL, NULL) related_id,

13320: -- bug 5572121
13321: -- NULL related_id,
13322: DECODE( tax_dist.related_id, NULL, NULL,
13323: tax_dist.invoice_distribution_id,
13324: ap_invoice_distributions_s.CURRVAL, NULL) related_id,
13325:
13326: NULL asset_book_type_code,
13327: NULL asset_category_id,
13328: tax_dist.distribution_class distribution_class,

Line 13346: ap_invoice_distributions_all item_dist,

13342: -- bug 6805655
13343: tax_dist.self_assessed_tax_liab_ccid self_assessed_tax_liab_ccid,
13344: (-1)*tax_dist.prepay_tax_diff_amount prepay_tax_diff_amount-- BUG 7338249 bug 9040333 added (-1)* as this is reversal
13345: from ap_self_assessed_tax_dist_all tax_dist,
13346: ap_invoice_distributions_all item_dist,
13347: zx_rec_nrec_dist zx_dist
13348: where tax_dist.invoice_id = p_invoice_id
13349: /* -- Bug8575619 start */
13350: and tax_dist.invoice_id = zx_dist.trx_id

Line 13365: from ap_invoice_distributions aid

13361: and zx_dist.trx_line_id = p_line_number --bug6056777
13362: --bugfix:5582836
13363: /* -- bug 6896627
13364: and not exists(select detail_tax_dist_id
13365: from ap_invoice_distributions aid
13366: where aid.invoice_id = p_invoice_id
13367: and aid.detail_tax_dist_id = zx_dist.rec_nrec_tax_dist_id)
13368: */
13369:

Line 13620: UPDATE ap_invoice_distributions_all aid

13616: --bug8733916
13617:
13618: IF(p_calling_mode='DISCARD LINE') THEN --Bug8811102
13619:
13620: UPDATE ap_invoice_distributions_all aid
13621: SET aid.encumbered_flag='R'
13622: WHERE aid.invoice_id=p_invoice_id
13623: AND nvl(aid.encumbered_flag,'N') in ('N','H','P')
13624: AND aid.charge_applicable_to_dist_id in (select invoice_distribution_id from ap_invoice_distributions_all aid1

Line 13624: AND aid.charge_applicable_to_dist_id in (select invoice_distribution_id from ap_invoice_distributions_all aid1

13620: UPDATE ap_invoice_distributions_all aid
13621: SET aid.encumbered_flag='R'
13622: WHERE aid.invoice_id=p_invoice_id
13623: AND nvl(aid.encumbered_flag,'N') in ('N','H','P')
13624: AND aid.charge_applicable_to_dist_id in (select invoice_distribution_id from ap_invoice_distributions_all aid1
13625: where aid1.invoice_id=p_invoice_id
13626: and aid1.invoice_line_number=p_line_number)
13627: AND aid.line_type_lookup_code in ('REC_TAX','NONREC_TAX','TRV','TERV','TIPV')
13628: AND nvl(aid.reversal_flag,'N')<>'Y'

Line 13639: UPDATE ap_invoice_distributions_all aid

13635: END IF;
13636:
13637: IF(p_calling_mode='CANCEL INVOICE') THEN --Bug8811102
13638:
13639: UPDATE ap_invoice_distributions_all aid
13640: SET aid.encumbered_flag='R'
13641: WHERE aid.invoice_id=p_invoice_id
13642: AND nvl(aid.encumbered_flag,'N') in ('N','H','P')
13643: AND aid.line_type_lookup_code in ('REC_TAX','NONREC_TAX','TRV','TERV','TIPV')

Line 13702: from ap_invoice_distributions_all item_dist,

13698: zx_dist.trx_level_type reversed_trx_level_type,
13699: zx_dist.trx_line_id reversed_trx_line_id,
13700: zx_dist.trx_line_dist_id reversed_trx_line_dist_id,
13701: zx_dist.tax_line_id reversed_tax_line_id
13702: from ap_invoice_distributions_all item_dist,
13703: ap_invoice_distributions_all tax_dist,
13704: ap_invoice_distributions_all reverse_dist,
13705: zx_rec_nrec_dist zx_dist
13706: where tax_dist.invoice_id = p_invoice_id

Line 13703: ap_invoice_distributions_all tax_dist,

13699: zx_dist.trx_line_id reversed_trx_line_id,
13700: zx_dist.trx_line_dist_id reversed_trx_line_dist_id,
13701: zx_dist.tax_line_id reversed_tax_line_id
13702: from ap_invoice_distributions_all item_dist,
13703: ap_invoice_distributions_all tax_dist,
13704: ap_invoice_distributions_all reverse_dist,
13705: zx_rec_nrec_dist zx_dist
13706: where tax_dist.invoice_id = p_invoice_id
13707: and tax_dist.invoice_id = item_dist.invoice_id

Line 13704: ap_invoice_distributions_all reverse_dist,

13700: zx_dist.trx_line_dist_id reversed_trx_line_dist_id,
13701: zx_dist.tax_line_id reversed_tax_line_id
13702: from ap_invoice_distributions_all item_dist,
13703: ap_invoice_distributions_all tax_dist,
13704: ap_invoice_distributions_all reverse_dist,
13705: zx_rec_nrec_dist zx_dist
13706: where tax_dist.invoice_id = p_invoice_id
13707: and tax_dist.invoice_id = item_dist.invoice_id
13708: and tax_dist.charge_applicable_to_dist_id = item_dist.invoice_distribution_id

Line 13730: FROM ap_invoice_distributions_all tax_dist

13726: IF l_reverse_dist_count = 0 THEN
13727: IF p_line_number IS NULL THEN
13728: SELECT COUNT(1)
13729: INTO l_unrev_dist_count
13730: FROM ap_invoice_distributions_all tax_dist
13731: WHERE tax_dist.invoice_id = p_invoice_id
13732: AND tax_dist.line_type_lookup_code IN ('NONREC_TAX', 'REC_TAX', 'TIPV', 'TRV', 'TERV')
13733: AND tax_dist.charge_applicable_to_dist_id IS NOT NULL
13734: AND tax_dist.detail_tax_dist_id IS NOT NULL

Line 13737: FROM ap_invoice_distributions_all rev_tax_dist

13733: AND tax_dist.charge_applicable_to_dist_id IS NOT NULL
13734: AND tax_dist.detail_tax_dist_id IS NOT NULL
13735: AND tax_dist.parent_reversal_id IS NULL
13736: AND NOT EXISTS ( SELECT 1
13737: FROM ap_invoice_distributions_all rev_tax_dist
13738: WHERE rev_tax_dist.invoice_id = p_invoice_id
13739: AND rev_tax_dist.parent_reversal_id = tax_dist.invoice_distribution_id
13740: )
13741: AND ROWNUM = 1 ;

Line 13745: FROM ap_invoice_distributions_all tax_dist

13741: AND ROWNUM = 1 ;
13742: ELSE
13743: SELECT COUNT(1)
13744: INTO l_unrev_dist_count
13745: FROM ap_invoice_distributions_all tax_dist
13746: WHERE tax_dist.invoice_id = p_invoice_id
13747: AND tax_dist.line_type_lookup_code IN ('NONREC_TAX', 'REC_TAX', 'TIPV', 'TRV', 'TERV')
13748: AND tax_dist.charge_applicable_to_dist_id IS NOT NULL
13749: AND tax_dist.detail_tax_dist_id IS NOT NULL

Line 13752: FROM ap_invoice_distributions_all rev_tax_dist

13748: AND tax_dist.charge_applicable_to_dist_id IS NOT NULL
13749: AND tax_dist.detail_tax_dist_id IS NOT NULL
13750: AND tax_dist.parent_reversal_id IS NULL
13751: AND NOT EXISTS ( SELECT 1
13752: FROM ap_invoice_distributions_all rev_tax_dist
13753: WHERE rev_tax_dist.invoice_id = p_invoice_id
13754: AND rev_tax_dist.parent_reversal_id = tax_dist.invoice_distribution_id
13755: )
13756: AND tax_dist.charge_applicable_to_dist_id IN

Line 13758: FROM ap_invoice_distributions_all item_dist

13754: AND rev_tax_dist.parent_reversal_id = tax_dist.invoice_distribution_id
13755: )
13756: AND tax_dist.charge_applicable_to_dist_id IN
13757: ( SELECT item_dist.invoice_distribution_id
13758: FROM ap_invoice_distributions_all item_dist
13759: WHERE item_dist.invoice_id = p_invoice_id
13760: AND item_dist.invoice_line_number = p_line_number
13761: )
13762: AND ROWNUM = 1 ;

Line 13830: from ap_invoice_distributions_all item_dist,

13826: zx_dist.trx_level_type reversed_trx_level_type,
13827: zx_dist.trx_line_id reversed_trx_line_id,
13828: zx_dist.trx_line_dist_id reversed_trx_line_dist_id,
13829: zx_dist.tax_line_id reversed_tax_line_id
13830: from ap_invoice_distributions_all item_dist,
13831: ap_self_assessed_tax_dist_all tax_dist,
13832: ap_invoice_distributions_all reverse_dist,
13833: zx_rec_nrec_dist zx_dist
13834: where tax_dist.invoice_id = p_invoice_id

Line 13832: ap_invoice_distributions_all reverse_dist,

13828: zx_dist.trx_line_dist_id reversed_trx_line_dist_id,
13829: zx_dist.tax_line_id reversed_tax_line_id
13830: from ap_invoice_distributions_all item_dist,
13831: ap_self_assessed_tax_dist_all tax_dist,
13832: ap_invoice_distributions_all reverse_dist,
13833: zx_rec_nrec_dist zx_dist
13834: where tax_dist.invoice_id = p_invoice_id
13835: and tax_dist.invoice_id = item_dist.invoice_id
13836: and tax_dist.charge_applicable_to_dist_id = item_dist.invoice_distribution_id

Line 13886: FROM ap_invoice_distributions_all item_dist

13882: AND rev_tax_dist.parent_reversal_id = tax_dist.invoice_distribution_id
13883: )
13884: AND tax_dist.charge_applicable_to_dist_id IN
13885: ( SELECT item_dist.invoice_distribution_id
13886: FROM ap_invoice_distributions_all item_dist
13887: WHERE item_dist.invoice_id = p_invoice_id
13888: AND item_dist.invoice_line_number = p_line_number
13889: )
13890: AND ROWNUM = 1 ;

Line 14188: l_debug_info := 'Step 3: Insert reverse tax distributions into ap_invoice_distributions';

14184:
14185: IF l_tax_distributions_exist THEN -- Marker 5
14186:
14187: -----------------------------------------------------------------
14188: l_debug_info := 'Step 3: Insert reverse tax distributions into ap_invoice_distributions';
14189: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
14190: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
14191: END IF;
14192: ----------------------------------------------------------------

Line 14213: from ap_invoice_distributions_All aid

14209: select accounting_date,
14210: period_name
14211: into l_open_gl_date,
14212: l_open_gl_period
14213: from ap_invoice_distributions_All aid
14214: where rowid =
14215: (select max(rowid)
14216: from ap_invoice_distributions_All aid1
14217: where aid1.invoice_id=l_reverse_tax_dist.invoice_id

Line 14216: from ap_invoice_distributions_All aid1

14212: l_open_gl_period
14213: from ap_invoice_distributions_All aid
14214: where rowid =
14215: (select max(rowid)
14216: from ap_invoice_distributions_All aid1
14217: where aid1.invoice_id=l_reverse_tax_dist.invoice_id
14218: and aid1.cancellation_flag = 'Y'
14219: and aid1.detail_tax_dist_id is null
14220: and aid1.prepay_distribution_id is null);

Line 14243: INSERT INTO ap_invoice_distributions_all (

14239: END;
14240: END IF;
14241: --bug 13101979 ends
14242:
14243: INSERT INTO ap_invoice_distributions_all (
14244: accounting_date,
14245: accrual_posted_flag,
14246: assets_addition_flag,
14247: assets_tracking_flag,

Line 14587: l_debug_info := 'Step 3: Insert reverse self assessed tax distributions into ap_invoice_distributions';

14583:
14584: IF l_self_assess_tax_dist_exist THEN -- Marker 6
14585:
14586: -----------------------------------------------------------------
14587: l_debug_info := 'Step 3: Insert reverse self assessed tax distributions into ap_invoice_distributions';
14588: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
14589: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
14590: END IF;
14591: ----------------------------------------------------------------

Line 14613: from ap_invoice_distributions_All aid

14609: select accounting_date,
14610: period_name
14611: into l_open_gl_date,
14612: l_open_gl_period
14613: from ap_invoice_distributions_All aid
14614: where rowid =
14615: (select max(rowid)
14616: from ap_invoice_distributions_All aid1
14617: where aid1.invoice_id=l_self_assess_rev_tax_dist.invoice_id

Line 14616: from ap_invoice_distributions_All aid1

14612: l_open_gl_period
14613: from ap_invoice_distributions_All aid
14614: where rowid =
14615: (select max(rowid)
14616: from ap_invoice_distributions_All aid1
14617: where aid1.invoice_id=l_self_assess_rev_tax_dist.invoice_id
14618: and aid1.cancellation_flag = 'Y'
14619: and aid1.detail_tax_dist_id is null
14620: and aid1.prepay_distribution_id is null);

Line 15029: l_debug_info := 'Inserting reverse entries into ap_invoice_distributions_all after line discard';

15025: else -- Marker 4
15026:
15027: IF l_tax_distributions_exist THEN -- Marker 7
15028:
15029: l_debug_info := 'Inserting reverse entries into ap_invoice_distributions_all after line discard';
15030: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
15031: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
15032: END IF;
15033:

Line 15040: INSERT INTO ap_invoice_distributions_all (

15036: FETCH c_reverse_tax_dist_1
15037: INTO l_reverse_tax_dist;
15038: EXIT WHEN c_reverse_tax_dist_1%NOTFOUND;
15039:
15040: INSERT INTO ap_invoice_distributions_all (
15041: accounting_date,
15042: accrual_posted_flag,
15043: assets_addition_flag,
15044: assets_tracking_flag,

Line 15776: UPDATE ap_invoice_distributions_all aid

15772: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
15773: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
15774: END IF;
15775:
15776: UPDATE ap_invoice_distributions_all aid
15777: SET reversal_flag = (select reverse_flag
15778: from zx_rec_nrec_dist zx
15779: where zx.rec_nrec_tax_dist_id = aid.detail_tax_dist_id)
15780: WHERE aid.invoice_id = p_invoice_id

Line 15790: UPDATE ap_invoice_distributions aid

15786: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
15787: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
15788: END IF;
15789:
15790: UPDATE ap_invoice_distributions aid
15791: SET aid.related_id =
15792: (SELECT invoice_distribution_id
15793: FROM ap_invoice_distributions_all aid1
15794: WHERE aid1.invoice_id = aid.invoice_id

Line 15793: FROM ap_invoice_distributions_all aid1

15789:
15790: UPDATE ap_invoice_distributions aid
15791: SET aid.related_id =
15792: (SELECT invoice_distribution_id
15793: FROM ap_invoice_distributions_all aid1
15794: WHERE aid1.invoice_id = aid.invoice_id
15795: AND aid1.invoice_line_number = aid.invoice_line_number
15796: AND aid1.parent_reversal_id =
15797: (SELECT related_id

Line 15798: FROM ap_invoice_distributions_all aid2

15794: WHERE aid1.invoice_id = aid.invoice_id
15795: AND aid1.invoice_line_number = aid.invoice_line_number
15796: AND aid1.parent_reversal_id =
15797: (SELECT related_id
15798: FROM ap_invoice_distributions_all aid2
15799: WHERE aid2.invoice_id = aid.invoice_id
15800: AND aid2.invoice_line_number = aid.invoice_line_number
15801: AND aid2.invoice_distribution_id = aid.parent_reversal_id)
15802: )

Line 15898: FROM ap_invoice_distributions_all invDist,

15894: WHERE invoice_id = P_Invoice_Id;
15895:
15896: CURSOR prepay_lines IS
15897: SELECT distinct prepLine.*
15898: FROM ap_invoice_distributions_all invDist,
15899: ap_invoice_distributions_all prepDist,
15900: ap_invoice_lines_all prepLine
15901: WHERE invDist.prepay_distribution_id = prepDist.invoice_distribution_id
15902: AND prepLine.invoice_id = prepDist.invoice_id

Line 15899: ap_invoice_distributions_all prepDist,

15895:
15896: CURSOR prepay_lines IS
15897: SELECT distinct prepLine.*
15898: FROM ap_invoice_distributions_all invDist,
15899: ap_invoice_distributions_all prepDist,
15900: ap_invoice_lines_all prepLine
15901: WHERE invDist.prepay_distribution_id = prepDist.invoice_distribution_id
15902: AND prepLine.invoice_id = prepDist.invoice_id
15903: AND prepLine.line_number = prepDist.invoice_line_number

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

16141:
16142: END Generate_Recouped_Tax;
16143:
16144: Function Delete_Tax_Distributions
16145: (p_invoice_id IN ap_invoice_distributions_all.invoice_id%Type,
16146: p_calling_mode IN VARCHAR2,
16147: p_all_error_messages IN VARCHAR2,
16148: p_error_code OUT NOCOPY VARCHAR2,
16149: p_calling_sequence IN VARCHAR2) RETURN BOOLEAN IS

Line 16263: UPDATE ap_invoice_distributions_All aid1

16259: END IF;
16260: END IF;
16261: --Bug6678578START
16262: --ER CHANGES 6772098
16263: UPDATE ap_invoice_distributions_All aid1
16264: SET aid1.amount = aid1.amount + nvl((SELECT SUM(nvl(amount,0))
16265: FROM ap_invoice_distributions_All aid2
16266: WHERE aid2.invoice_id = p_invoice_id
16267: AND aid2.invoice_line_number = aid1.invoice_line_number

Line 16265: FROM ap_invoice_distributions_All aid2

16261: --Bug6678578START
16262: --ER CHANGES 6772098
16263: UPDATE ap_invoice_distributions_All aid1
16264: SET aid1.amount = aid1.amount + nvl((SELECT SUM(nvl(amount,0))
16265: FROM ap_invoice_distributions_All aid2
16266: WHERE aid2.invoice_id = p_invoice_id
16267: AND aid2.invoice_line_number = aid1.invoice_line_number
16268: AND aid2.charge_applicable_to_dist_id = aid1.invoice_distribution_id
16269: AND aid2.line_type_lookup_code IN ('REC_TAX','NONREC_TAX','TRV','TIPV')

Line 16280: FROM ap_invoice_distributions_All aid3

16276: AND zd.trx_id = aid2.invoice_id
16277: AND zd.rec_nrec_tax_dist_id = aid2.detail_tax_dist_id
16278: AND NVL(zd.inclusive_flag,'N') = 'Y')),0),
16279: aid1.base_amount =aid1.base_amount + nvl((SELECT SUM(nvl(base_amount,0))
16280: FROM ap_invoice_distributions_All aid3
16281: WHERE aid3.invoice_id = p_invoice_id
16282: AND aid3.invoice_line_number = aid1.invoice_line_number
16283: AND aid3.charge_applicable_to_dist_id = aid1.invoice_distribution_id
16284: AND aid3.line_type_lookup_code IN ('REC_TAX','NONREC_TAX','TRV','TIPV')

Line 16303: From ap_invoice_distributions_all

16299:
16300:
16301: INSERT INTO zx_tax_dist_id_gt
16302: (Select distinct detail_tax_dist_id
16303: From ap_invoice_distributions_all
16304: Where invoice_id = p_invoice_id
16305: AND distribution_class = 'CANDIDATE'
16306: And line_type_lookup_code In('NONREC_TAX', 'REC_TAX', 'TRV', 'TERV', 'TIPV')
16307: UNION

Line 16385: FROM ap_invoice_distributions_all

16381:
16382: BEGIN
16383: SELECT 'Tax Distributions Exist'
16384: INTO l_dummy
16385: FROM ap_invoice_distributions_all
16386: WHERE invoice_id = p_invoice_id
16387: AND line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX', 'TIPV', 'TRV', 'TERV')
16388: AND rownum = 1;
16389:

Line 16409: FROM ap_invoice_distributions_all

16405: END IF;
16406:
16407: /* SELECT 'Tax Only Line Exist'
16408: INTO l_dummy
16409: FROM ap_invoice_distributions_all
16410: WHERE invoice_id = p_invoice_id
16411: AND line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX', 'TIPV', 'TRV', 'TERV')
16412: AND charge_applicable_to_dist_id IS NULL
16413: AND rownum = 1; */

Line 16493: FROM ap_invoice_distributions_all D,

16489: pll.match_option match_option,
16490: pl.unit_meas_lookup_code po_uom,
16491: D.matched_uom_lookup_code rcv_uom,
16492: rsl.item_id rcv_item_id
16493: FROM ap_invoice_distributions_all D,
16494: po_distributions_all PD,
16495: po_lines_all PL,
16496: po_line_locations_all PLL,
16497: rcv_transactions RTXN,

Line 17265: FROM ap_invoice_distributions_all

17261: ELSE 'CREATED'
17262: END),
17263: 'DISTRIBUTE',
17264: (CASE (SELECT 'Y'
17265: FROM ap_invoice_distributions_all
17266: WHERE invoice_id = ai.invoice_id
17267: AND line_type_lookup_code <> 'AWT'
17268: AND (tax_already_distributed_flag = 'Y'
17269: OR detail_tax_dist_id IS NOT NULL)

Line 17385: FROM ap_invoice_distributions_all aid_reverse,

17381: CURSOR c_reverse_dist (c_invoice_id NUMBER) IS
17382: SELECT aid_reverse.invoice_distribution_id invoice_distribution_id,
17383: aid_parent.invoice_distribution_id parent_reversal_id,
17384: aid_parent.dist_code_combination_id parent_ccid
17385: FROM ap_invoice_distributions_all aid_reverse,
17386: ap_invoice_distributions_all aid_parent,
17387: zx_rec_nrec_dist zx
17388: WHERE aid_reverse.invoice_id = c_invoice_id
17389: AND aid_reverse.detail_tax_dist_id = zx.rec_nrec_tax_dist_id

Line 17386: ap_invoice_distributions_all aid_parent,

17382: SELECT aid_reverse.invoice_distribution_id invoice_distribution_id,
17383: aid_parent.invoice_distribution_id parent_reversal_id,
17384: aid_parent.dist_code_combination_id parent_ccid
17385: FROM ap_invoice_distributions_all aid_reverse,
17386: ap_invoice_distributions_all aid_parent,
17387: zx_rec_nrec_dist zx
17388: WHERE aid_reverse.invoice_id = c_invoice_id
17389: AND aid_reverse.detail_tax_dist_id = zx.rec_nrec_tax_dist_id
17390: AND aid_parent.detail_tax_dist_id = zx.reversed_tax_dist_id

Line 17425: (invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE,

17421: AND included_tax_amount <> 0 ; --ER CHANGES
17422: --Bug9436217
17423:
17424: TYPE reversal_dist_info IS RECORD
17425: (invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE,
17426: parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE,
17427: parent_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE);
17428:
17429: TYPE reversal_dist_type IS TABLE OF reversal_dist_info;

Line 17426: parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE,

17422: --Bug9436217
17423:
17424: TYPE reversal_dist_info IS RECORD
17425: (invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE,
17426: parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE,
17427: parent_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE);
17428:
17429: TYPE reversal_dist_type IS TABLE OF reversal_dist_info;
17430:

Line 17427: parent_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE);

17423:
17424: TYPE reversal_dist_info IS RECORD
17425: (invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE,
17426: parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE,
17427: parent_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE);
17428:
17429: TYPE reversal_dist_type IS TABLE OF reversal_dist_info;
17430:
17431: l_reveral_dist_tab reversal_dist_type;

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

17432:
17433: l_debug_info VARCHAR2(240);
17434: l_curr_calling_sequence VARCHAR2(4000);
17435: l_api_name CONSTANT VARCHAR2(100) := 'Update_Distributions';
17436: l_dist_amt ap_invoice_distributions_all.amount%type; -- for bug 6326552
17437: l_tot_tax_amt ap_invoice_distributions_all.amount%type; -- for bug 6326552
17438: BEGIN
17439:
17440: -------------------------------------------------------------------

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

17433: l_debug_info VARCHAR2(240);
17434: l_curr_calling_sequence VARCHAR2(4000);
17435: l_api_name CONSTANT VARCHAR2(100) := 'Update_Distributions';
17436: l_dist_amt ap_invoice_distributions_all.amount%type; -- for bug 6326552
17437: l_tot_tax_amt ap_invoice_distributions_all.amount%type; -- for bug 6326552
17438: BEGIN
17439:
17440: -------------------------------------------------------------------
17441: l_debug_info := 'Step 1: Update the related_id column';

Line 17447: /* UPDATE ap_invoice_distributions_all aid

17443: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
17444: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
17445: END IF;
17446:
17447: /* UPDATE ap_invoice_distributions_all aid
17448: SET related_id = (SELECT DECODE(MIN(nrtax.invoice_distribution_id),
17449: NULL, MIN(other.invoice_distribution_id),
17450: MIN(nrtax.invoice_distribution_id))
17451: FROM ap_invoice_distributions_all nrtax,

Line 17451: FROM ap_invoice_distributions_all nrtax,

17447: /* UPDATE ap_invoice_distributions_all aid
17448: SET related_id = (SELECT DECODE(MIN(nrtax.invoice_distribution_id),
17449: NULL, MIN(other.invoice_distribution_id),
17450: MIN(nrtax.invoice_distribution_id))
17451: FROM ap_invoice_distributions_all nrtax,
17452: ap_invoice_distributions_all other
17453: WHERE nrtax.invoice_id = aid.invoice_id
17454: AND other.invoice_id = aid.invoice_id
17455: AND nrtax.detail_tax_dist_id = aid.detail_tax_dist_id

Line 17452: ap_invoice_distributions_all other

17448: SET related_id = (SELECT DECODE(MIN(nrtax.invoice_distribution_id),
17449: NULL, MIN(other.invoice_distribution_id),
17450: MIN(nrtax.invoice_distribution_id))
17451: FROM ap_invoice_distributions_all nrtax,
17452: ap_invoice_distributions_all other
17453: WHERE nrtax.invoice_id = aid.invoice_id
17454: AND other.invoice_id = aid.invoice_id
17455: AND nrtax.detail_tax_dist_id = aid.detail_tax_dist_id
17456: AND other.detail_tax_dist_id = aid.detail_tax_dist_id

Line 17464: FROM ap_invoice_distributions_all aid1

17460: GROUP BY 1)
17461: WHERE aid.invoice_id = P_Invoice_Header_Rec.invoice_id
17462: AND aid.line_type_lookup_code in ('NONREC_TAX', 'TIPV', 'TRV', 'TERV')
17463: AND EXISTS (SELECT aid1.detail_tax_dist_id
17464: FROM ap_invoice_distributions_all aid1
17465: WHERE aid1.invoice_id = aid.invoice_id
17466: AND aid1.detail_tax_dist_id = aid.detail_tax_dist_id
17467: HAVING count(*) > 1
17468: GROUP BY aid1.detail_tax_dist_id);*/

Line 17473: UPDATE ap_invoice_distributions_all aid

17469:
17470:
17471: --Bug11730310 changed the above sql as follows
17472:
17473: UPDATE ap_invoice_distributions_all aid
17474: SET related_id =DECODE((SELECT MIN(nrtax.invoice_distribution_id)
17475: FROM ap_invoice_distributions_all nrtax
17476: WHERE nrtax.invoice_id = aid.invoice_id
17477: AND nrtax.detail_tax_dist_id = aid.detail_tax_dist_id

Line 17475: FROM ap_invoice_distributions_all nrtax

17471: --Bug11730310 changed the above sql as follows
17472:
17473: UPDATE ap_invoice_distributions_all aid
17474: SET related_id =DECODE((SELECT MIN(nrtax.invoice_distribution_id)
17475: FROM ap_invoice_distributions_all nrtax
17476: WHERE nrtax.invoice_id = aid.invoice_id
17477: AND nrtax.detail_tax_dist_id = aid.detail_tax_dist_id
17478: AND nrtax.line_type_lookup_code = 'NONREC_TAX'
17479: GROUP BY 1) ,NULL ,

Line 17481: FROM ap_invoice_distributions_all other

17477: AND nrtax.detail_tax_dist_id = aid.detail_tax_dist_id
17478: AND nrtax.line_type_lookup_code = 'NONREC_TAX'
17479: GROUP BY 1) ,NULL ,
17480: (SELECT MIN(other.invoice_distribution_id)
17481: FROM ap_invoice_distributions_all other
17482: WHERE other.invoice_id = aid.invoice_id
17483: AND other.detail_tax_dist_id = aid.detail_tax_dist_id
17484: AND other.line_type_lookup_code IN ('TIPV', 'TRV')
17485: GROUP BY 1) ,

Line 17487: FROM ap_invoice_distributions_all nrtax

17483: AND other.detail_tax_dist_id = aid.detail_tax_dist_id
17484: AND other.line_type_lookup_code IN ('TIPV', 'TRV')
17485: GROUP BY 1) ,
17486: (SELECT MIN(nrtax.invoice_distribution_id)
17487: FROM ap_invoice_distributions_all nrtax
17488: WHERE nrtax.invoice_id = aid.invoice_id
17489: AND nrtax.detail_tax_dist_id = aid.detail_tax_dist_id
17490: AND nrtax.line_type_lookup_code = 'NONREC_TAX'
17491: GROUP BY 1))

Line 17495: FROM ap_invoice_distributions_all aid1

17491: GROUP BY 1))
17492: WHERE aid.invoice_id = P_Invoice_Header_Rec.invoice_id
17493: AND aid.line_type_lookup_code in ('NONREC_TAX', 'TIPV', 'TRV', 'TERV')
17494: AND EXISTS (SELECT aid1.detail_tax_dist_id
17495: FROM ap_invoice_distributions_all aid1
17496: WHERE aid1.invoice_id = aid.invoice_id
17497: AND aid1.detail_tax_dist_id = aid.detail_tax_dist_id
17498: HAVING count(*) > 1
17499: GROUP BY aid1.detail_tax_dist_id);

Line 17539: UPDATE ap_invoice_distributions_all aid

17535: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
17536: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
17537: END IF;
17538:
17539: UPDATE ap_invoice_distributions_all aid
17540: SET rounding_amt =
17541: (SELECT zd.func_curr_rounding_adjustment
17542: FROM zx_rec_nrec_dist zd
17543: WHERE zd.rec_nrec_tax_dist_id = aid.detail_tax_dist_id)

Line 17618: UPDATE ap_invoice_distributions_all aid

17614: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
17615: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
17616: END IF;
17617:
17618: UPDATE ap_invoice_distributions_all aid
17619: SET aid.tax_already_distributed_flag = 'Y'
17620: WHERE aid.invoice_id = p_invoice_header_rec.invoice_id
17621: AND NVL(aid.tax_already_distributed_flag, 'N') = 'N'
17622: AND aid.invoice_distribution_id IN

Line 17624: FROM ap_invoice_distributions_all aid1,

17620: WHERE aid.invoice_id = p_invoice_header_rec.invoice_id
17621: AND NVL(aid.tax_already_distributed_flag, 'N') = 'N'
17622: AND aid.invoice_distribution_id IN
17623: ( SELECT aid1.charge_applicable_to_dist_id
17624: FROM ap_invoice_distributions_all aid1,
17625: zx_rec_nrec_dist zd
17626: WHERE zd.REC_NREC_TAX_DIST_ID = aid1.DETAIL_TAX_DIST_ID
17627: AND aid1.invoice_id = p_invoice_header_rec.invoice_id );
17628:

Line 17643: FROM ap_invoice_distributions_all aid

17639: AND ail.generate_dists <> 'D'
17640: AND line_type_lookup_code = 'TAX'
17641: AND EXISTS
17642: (SELECT aid.invoice_distribution_id
17643: FROM ap_invoice_distributions_all aid
17644: WHERE aid.invoice_id = ail.invoice_id
17645: AND aid.invoice_line_number = ail.line_number);
17646:
17647: -----------------------------------------------------------------

Line 17653: UPDATE ap_invoice_distributions_all tax

17649: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
17650: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
17651: END IF;
17652: -----------------------------------------------------------------
17653: UPDATE ap_invoice_distributions_all tax
17654: SET tax.invoice_includes_prepay_flag = 'Y'
17655: WHERE tax.invoice_id = p_invoice_header_rec.invoice_id
17656: AND nvl(tax.invoice_includes_prepay_flag,'N') <> 'Y'
17657: AND line_type_lookup_code in ('NONREC_TAX','REC_TAX','TIPV','TERV','TRV')

Line 17690: FROM ap_invoice_distributions_All

17686:
17687:
17688: SELECT sum(amount) -- Select added for bug 6326552 to make sure
17689: INTO l_dist_amt -- sure that we update the distributions only once.
17690: FROM ap_invoice_distributions_All
17691: WHERE invoice_id = p_invoice_header_rec.invoice_id
17692: AND invoice_line_number = i.line_number
17693: AND line_type_lookup_code IN ('ITEM', --Bug6653070 Added SUM()
17694: --instead of only amount

Line 17722: FROM ap_invoice_distributions_All

17718: SELECT SUM(amount) -- Select added for bug 6326552 to make sure
17719: INTO l_tot_tax_amt -- sure that we update the distributions if
17720: -- if included tax amount is changed at
17721: -- line level. .
17722: FROM ap_invoice_distributions_All
17723: WHERE invoice_id = p_invoice_header_rec.invoice_id
17724: AND invoice_line_number = i.line_number
17725: AND line_type_lookup_code IN ('REC_TAX','NONREC_TAX','TRV','TERV','TIPV');
17726:

Line 17762: UPDATE ap_invoice_distributions_All aid1 --Bug6653070

17758: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
17759: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
17760: END IF;
17761:
17762: UPDATE ap_invoice_distributions_All aid1 --Bug6653070
17763: SET aid1.amount = aid1.amount - nvl((SELECT SUM(nvl(amount,0))
17764: FROM ap_invoice_distributions_All aid2
17765: WHERE aid2.invoice_id = p_invoice_header_rec.invoice_id
17766: AND aid2.invoice_line_number = i.line_number

Line 17764: FROM ap_invoice_distributions_All aid2

17760: END IF;
17761:
17762: UPDATE ap_invoice_distributions_All aid1 --Bug6653070
17763: SET aid1.amount = aid1.amount - nvl((SELECT SUM(nvl(amount,0))
17764: FROM ap_invoice_distributions_All aid2
17765: WHERE aid2.invoice_id = p_invoice_header_rec.invoice_id
17766: AND aid2.invoice_line_number = i.line_number
17767: AND aid2.charge_applicable_to_dist_id = aid1.invoice_distribution_id
17768: AND aid2.line_type_lookup_code IN ('REC_TAX','NONREC_TAX', 'TIPV', 'TRV')

Line 17778: FROM ap_invoice_distributions_All aid3

17774: AND zd1.trx_id = aid2.invoice_id
17775: AND zd1.rec_nrec_tax_dist_id = aid2.detail_tax_dist_id
17776: AND NVL(zd1.inclusive_flag,'N') = 'Y')),0),
17777: aid1.base_amount =aid1.base_amount- nvl((SELECT SUM(nvl(base_amount,0))
17778: FROM ap_invoice_distributions_All aid3
17779: WHERE aid3.invoice_id = p_invoice_header_rec.invoice_id
17780: AND aid3.invoice_line_number = i.line_number
17781: AND aid3.charge_applicable_to_dist_id = aid1.invoice_distribution_id
17782: AND aid3.line_type_lookup_code IN ('REC_TAX','NONREC_TAX', 'TIPV', 'TRV','TERV')

Line 17823: UPDATE ap_invoice_distributions_all

17819:
17820: IF l_reveral_dist_tab.count > 0 THEN
17821: FOR h in l_reveral_dist_tab.first .. l_reveral_dist_tab.last LOOP
17822:
17823: UPDATE ap_invoice_distributions_all
17824: SET parent_reversal_id = l_reveral_dist_tab(h).parent_reversal_id
17825: ,dist_code_combination_id = l_reveral_dist_tab(h).parent_ccid
17826: WHERE invoice_distribution_id = l_reveral_dist_tab(h).invoice_distribution_id
17827: AND nvl(reversal_flag, 'N') <> 'Y';

Line 17868: UPDATE ap_invoice_distributions_all aid

17864: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
17865: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
17866: END IF;
17867:
17868: UPDATE ap_invoice_distributions_all aid
17869: SET reversal_flag = (select reverse_flag
17870: from zx_rec_nrec_dist zx
17871: where zx.rec_nrec_tax_dist_id = aid.detail_tax_dist_id)
17872: WHERE aid.invoice_id = p_invoice_header_rec.invoice_id

Line 19037: l_detail_tax_dist_id AP_INVOICE_DISTRIBUTIONS_ALL.DETAIL_TAX_DIST_ID%TYPE;

19033: l_message_data VARCHAR2(2000) ;
19034: l_Error_Code VARCHAR2(2000) ;
19035: l_return_status VARCHAR2(2000) ;
19036:
19037: l_detail_tax_dist_id AP_INVOICE_DISTRIBUTIONS_ALL.DETAIL_TAX_DIST_ID%TYPE;
19038: l_line_type_lookup_code AP_INVOICE_DISTRIBUTIONS_ALL.LINE_TYPE_LOOKUP_CODE%TYPE;
19039: l_inv_dist_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE;
19040: l_related_id AP_INVOICE_DISTRIBUTIONS_ALL.RELATED_ID%TYPE;
19041:

Line 19038: l_line_type_lookup_code AP_INVOICE_DISTRIBUTIONS_ALL.LINE_TYPE_LOOKUP_CODE%TYPE;

19034: l_Error_Code VARCHAR2(2000) ;
19035: l_return_status VARCHAR2(2000) ;
19036:
19037: l_detail_tax_dist_id AP_INVOICE_DISTRIBUTIONS_ALL.DETAIL_TAX_DIST_ID%TYPE;
19038: l_line_type_lookup_code AP_INVOICE_DISTRIBUTIONS_ALL.LINE_TYPE_LOOKUP_CODE%TYPE;
19039: l_inv_dist_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE;
19040: l_related_id AP_INVOICE_DISTRIBUTIONS_ALL.RELATED_ID%TYPE;
19041:
19042:

Line 19039: l_inv_dist_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE;

19035: l_return_status VARCHAR2(2000) ;
19036:
19037: l_detail_tax_dist_id AP_INVOICE_DISTRIBUTIONS_ALL.DETAIL_TAX_DIST_ID%TYPE;
19038: l_line_type_lookup_code AP_INVOICE_DISTRIBUTIONS_ALL.LINE_TYPE_LOOKUP_CODE%TYPE;
19039: l_inv_dist_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE;
19040: l_related_id AP_INVOICE_DISTRIBUTIONS_ALL.RELATED_ID%TYPE;
19041:
19042:
19043: l_sync_trx_dist_dff_t ZX_NEW_SERVICES_PKG.tax_dist_dff_type%TYPE;

Line 19040: l_related_id AP_INVOICE_DISTRIBUTIONS_ALL.RELATED_ID%TYPE;

19036:
19037: l_detail_tax_dist_id AP_INVOICE_DISTRIBUTIONS_ALL.DETAIL_TAX_DIST_ID%TYPE;
19038: l_line_type_lookup_code AP_INVOICE_DISTRIBUTIONS_ALL.LINE_TYPE_LOOKUP_CODE%TYPE;
19039: l_inv_dist_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE;
19040: l_related_id AP_INVOICE_DISTRIBUTIONS_ALL.RELATED_ID%TYPE;
19041:
19042:
19043: l_sync_trx_dist_dff_t ZX_NEW_SERVICES_PKG.tax_dist_dff_type%TYPE;
19044:

Line 19081: FROM ap_invoice_distributions_all

19077: SELECT line_type_lookup_code,detail_tax_dist_id,
19078: invoice_distribution_id,related_id
19079: INTO l_line_type_lookup_code,l_detail_tax_dist_id,
19080: l_inv_dist_id,l_related_id
19081: FROM ap_invoice_distributions_all
19082: WHERE invoice_id = p_invoice_id
19083: AND distribution_line_number = p_distribution_line_number
19084: AND invoice_line_number = p_invoice_line_number;
19085: