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_INVOICE_LINES_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 124: l_dist_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;

120: l_dset_line_attribute12 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE12%TYPE;
121: l_dset_line_attribute13 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE13%TYPE;
122: l_dset_line_attribute14 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE14%TYPE;
123: l_dset_line_attribute15 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE15%TYPE;
124: l_dist_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;
125: l_dist_base_amount AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE;
126: l_dist_set_percent_number NUMBER;
127: l_running_total_pa_quantity AP_INVOICE_DISTRIBUTIONS.PA_QUANTITY%TYPE := 0;
128: l_running_total_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;

Line 125: l_dist_base_amount AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE;

121: l_dset_line_attribute13 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE13%TYPE;
122: l_dset_line_attribute14 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE14%TYPE;
123: l_dset_line_attribute15 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE15%TYPE;
124: l_dist_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;
125: l_dist_base_amount AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE;
126: l_dist_set_percent_number NUMBER;
127: l_running_total_pa_quantity AP_INVOICE_DISTRIBUTIONS.PA_QUANTITY%TYPE := 0;
128: l_running_total_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;
129: l_running_total_base_amt AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE := 0;

Line 127: l_running_total_pa_quantity AP_INVOICE_DISTRIBUTIONS.PA_QUANTITY%TYPE := 0;

123: l_dset_line_attribute15 AP_DISTRIBUTION_SET_LINES.ATTRIBUTE15%TYPE;
124: l_dist_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;
125: l_dist_base_amount AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE;
126: l_dist_set_percent_number NUMBER;
127: l_running_total_pa_quantity AP_INVOICE_DISTRIBUTIONS.PA_QUANTITY%TYPE := 0;
128: l_running_total_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;
129: l_running_total_base_amt AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE := 0;
130: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
131: l_status VARCHAR2(10);

Line 128: l_running_total_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;

124: l_dist_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE;
125: l_dist_base_amount AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE;
126: l_dist_set_percent_number NUMBER;
127: l_running_total_pa_quantity AP_INVOICE_DISTRIBUTIONS.PA_QUANTITY%TYPE := 0;
128: l_running_total_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;
129: l_running_total_base_amt AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE := 0;
130: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
131: l_status VARCHAR2(10);
132: l_industry VARCHAR2(10);

Line 129: l_running_total_base_amt AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE := 0;

125: l_dist_base_amount AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE;
126: l_dist_set_percent_number NUMBER;
127: l_running_total_pa_quantity AP_INVOICE_DISTRIBUTIONS.PA_QUANTITY%TYPE := 0;
128: l_running_total_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;
129: l_running_total_base_amt AP_INVOICE_DISTRIBUTIONS.BASE_AMOUNT%TYPE := 0;
130: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
131: l_status VARCHAR2(10);
132: l_industry VARCHAR2(10);
133: l_set_of_books_id AP_INVOICES.SET_OF_BOOKS_ID%TYPE;

Line 136: l_max_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;

132: l_industry VARCHAR2(10);
133: l_set_of_books_id AP_INVOICES.SET_OF_BOOKS_ID%TYPE;
134: l_pa_installed VARCHAR2(1);
135:
136: l_max_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;
137: l_max_pa_quantity AP_INVOICE_DISTRIBUTIONS.PA_QUANTITY%TYPE := 0;
138: l_max_i BINARY_INTEGER := 0;
139: l_max_pa_qty_i BINARY_INTEGER := 0;
140: i BINARY_INTEGER := 0;

Line 137: l_max_pa_quantity AP_INVOICE_DISTRIBUTIONS.PA_QUANTITY%TYPE := 0;

133: l_set_of_books_id AP_INVOICES.SET_OF_BOOKS_ID%TYPE;
134: l_pa_installed VARCHAR2(1);
135:
136: l_max_amount AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;
137: l_max_pa_quantity AP_INVOICE_DISTRIBUTIONS.PA_QUANTITY%TYPE := 0;
138: l_max_i BINARY_INTEGER := 0;
139: l_max_pa_qty_i BINARY_INTEGER := 0;
140: i BINARY_INTEGER := 0;
141: l_msg_application VARCHAR2(25);

Line 159: l_prepay_dist_code_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;

155: l_rounding_exists VARCHAR2(1) := 'N';
156: l_rounding_pa_qty_exists VARCHAR2(1) := 'N';
157: --For bug2938770
158: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;
159: l_prepay_dist_code_ccid ap_invoice_distributions.dist_code_combination_id%TYPE;
160: --bugfix:5725904
161: l_sys_link_function VARCHAR2(2);
162: l_message_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
163: l_api_name VARCHAR2(50);

Line 977: -- by calling ap_invoice_distributions_pkg.insert_from_dist_set.

973:
974: -----------------------------------------------------------------------
975: -- FUNCTION insert_from_dist_set validates the distribution_set info
976: -- and generates distributions
977: -- by calling ap_invoice_distributions_pkg.insert_from_dist_set.
978: --
979: FUNCTION Insert_From_Dist_Set(
980: X_invoice_id IN NUMBER,
981: X_line_number IN NUMBER DEFAULT NULL,

Line 1494: debug_info := 'Calling AP_INVOICE_DISTRIBUTIONS_PKG.Insert_From_Dist_Set';

1490: -- them.
1491: --------------------------------------------------------------
1492: IF (X_Generate_Dists = 'Y' ) then
1493:
1494: debug_info := 'Calling AP_INVOICE_DISTRIBUTIONS_PKG.Insert_From_Dist_Set';
1495: IF ( NOT (AP_INVOICE_DISTRIBUTIONS_PKG.Insert_From_Dist_Set(
1496: l_batch_id,
1497: X_invoice_id,
1498: X_line_number,

Line 1495: IF ( NOT (AP_INVOICE_DISTRIBUTIONS_PKG.Insert_From_Dist_Set(

1491: --------------------------------------------------------------
1492: IF (X_Generate_Dists = 'Y' ) then
1493:
1494: debug_info := 'Calling AP_INVOICE_DISTRIBUTIONS_PKG.Insert_From_Dist_Set';
1495: IF ( NOT (AP_INVOICE_DISTRIBUTIONS_PKG.Insert_From_Dist_Set(
1496: l_batch_id,
1497: X_invoice_id,
1498: X_line_number,
1499: y_dist_tab,

Line 1553: FROM ap_invoice_distributions_all -- Bug 7195488 Moac synonym replaced

1549: BEGIN
1550:
1551: SELECT nvl(max(distribution_line_number),0)
1552: INTO l_max_dist_line_num
1553: FROM ap_invoice_distributions_all -- Bug 7195488 Moac synonym replaced
1554: WHERE invoice_id = X_invoice_id
1555: AND invoice_line_number = X_line_number;
1556:
1557: RETURN(l_max_dist_line_num);

Line 1658: FROM ap_invoice_distributions AID

1654: --Bug 5555622 and recoupment, and the related tax distributions
1655: BEGIN
1656: SELECT SUM(base_amount)
1657: INTO l_sum_base_amt
1658: FROM ap_invoice_distributions AID
1659: WHERE AID.invoice_id = X_INVOICE_ID
1660: AND AID.invoice_line_number = X_LINE_NUMBER
1661: AND AID.line_type_lookup_code NOT IN ('RETAINAGE', 'PREPAY')
1662: AND AID.charge_applicable_to_dist_id NOT IN

Line 1664: FROM ap_invoice_distributions AID1

1660: AND AID.invoice_line_number = X_LINE_NUMBER
1661: AND AID.line_type_lookup_code NOT IN ('RETAINAGE', 'PREPAY')
1662: AND AID.charge_applicable_to_dist_id NOT IN
1663: (SELECT AID1.invoice_distribution_id
1664: FROM ap_invoice_distributions AID1
1665: WHERE AID1.line_type_lookup_code IN ('RETAINAGE', 'PREPAY')
1666: AND AID1.invoice_id = X_INVOICE_ID
1667: AND AID1.invoice_line_number = X_LINE_NUMBER);
1668:

Line 1697: FROM AP_INVOICE_DISTRIBUTIONS aid1

1693: BEGIN
1694: --bugfix:4625349
1695: SELECT invoice_distribution_id
1696: BULK COLLECT INTO l_round_dist_id_list
1697: FROM AP_INVOICE_DISTRIBUTIONS aid1
1698: WHERE aid1.invoice_id = X_INVOICE_ID
1699: AND aid1.invoice_line_number = X_LINE_NUMBER
1700: AND nvl(aid1.posted_flag, 'N') = 'N'
1701: AND NVL(aid1.match_status_flag, 'N') IN ('N', 'S')

Line 1789: ap_invoice_distributions.po_distribution_id%TYPE;

1785: l_debug_info VARCHAR2(4000);
1786: l_curr_calling_sequence VARCHAR2(4000);
1787:
1788: l_po_distribution_id
1789: ap_invoice_distributions.po_distribution_id%TYPE;
1790:
1791: l_distribution_count NUMBER := 0;
1792: l_sum_matched_qty NUMBER := 0;
1793: l_sum_matched_amt NUMBER := 0;

Line 1794: l_dist_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE;

1790:
1791: l_distribution_count NUMBER := 0;
1792: l_sum_matched_qty NUMBER := 0;
1793: l_sum_matched_amt NUMBER := 0;
1794: l_dist_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE;
1795: l_matching_basis po_line_locations_all.matching_basis%TYPE;
1796: i NUMBER := 1;
1797: l_max_line_num
1798: ap_invoice_distributions.distribution_line_number%TYPE;

Line 1798: ap_invoice_distributions.distribution_line_number%TYPE;

1794: l_dist_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE;
1795: l_matching_basis po_line_locations_all.matching_basis%TYPE;
1796: i NUMBER := 1;
1797: l_max_line_num
1798: ap_invoice_distributions.distribution_line_number%TYPE;
1799: l_matched_uom VARCHAR2(30);
1800: l_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;
1801: l_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;
1802: l_key_value_list3 ap_dbi_pkg.r_dbi_key_value_arr;

Line 1803: l_global_attr_category ap_invoice_distributions.global_attribute_category%TYPE;

1799: l_matched_uom VARCHAR2(30);
1800: l_key_value_list ap_dbi_pkg.r_dbi_key_value_arr;
1801: l_key_value_list2 ap_dbi_pkg.r_dbi_key_value_arr;
1802: l_key_value_list3 ap_dbi_pkg.r_dbi_key_value_arr;
1803: l_global_attr_category ap_invoice_distributions.global_attribute_category%TYPE;
1804: l_open_gl_date DATE;
1805: l_result_string VARCHAR2(4000);
1806: l_loop_counter BINARY_INTEGER;
1807: l_awt_success VARCHAR2(2000);

Line 1864: FROM ap_invoice_distributions_all AID ,

1860: aid.line_type_lookup_code,
1861: pll.matching_basis,
1862: aid1.invoice_id prepay_invoice_id,
1863: aid1.invoice_line_number prepay_line_number
1864: FROM ap_invoice_distributions_all AID ,
1865: po_line_locations pll,
1866: ap_invoice_distributions_all AID1
1867: WHERE aid.invoice_id = p_line_rec.invoice_id
1868: AND aid.invoice_line_number = p_line_rec.line_number

Line 1866: ap_invoice_distributions_all AID1

1862: aid1.invoice_id prepay_invoice_id,
1863: aid1.invoice_line_number prepay_line_number
1864: FROM ap_invoice_distributions_all AID ,
1865: po_line_locations pll,
1866: ap_invoice_distributions_all AID1
1867: WHERE aid.invoice_id = p_line_rec.invoice_id
1868: AND aid.invoice_line_number = p_line_rec.line_number
1869: --Contract Payments: Added the 'PREPAY' to the clause
1870: AND aid.line_type_lookup_code in ('ITEM','ACCRUAL', 'IPV','ERV','PREPAY','RETAINAGE')

Line 1891: from ap_invoice_distributions_all aid

1887: AND arl.invoice_id = ail.invoice_id
1888: AND arl.chrg_invoice_line_number = ail.line_number
1889: AND exists
1890: (select aid.invoice_line_number
1891: from ap_invoice_distributions_all aid
1892: where aid.invoice_id = ail.invoice_id
1893: and aid.invoice_line_number = ail.line_number);
1894:
1895: l_chrg_line_rec ap_invoice_lines_all%rowtype;

Line 1909: ,ap_invoice_distributions_all aid

1905: 'ITEM_TO_SERVICE_PO', 0,
1906: 'ITEM_TO_SERVICE_RECEIPT', 0,
1907: NVL(AID.corrected_quantity, 0) + NVL(AID.quantity_invoiced,0))) quantity
1908: from ap_invoice_lines_all ail
1909: ,ap_invoice_distributions_all aid
1910: ,po_distributions_all pod
1911: ,po_line_locations_all pll
1912: where ail.invoice_id = p_line_rec.invoice_id
1913: and ail.line_number = p_line_rec.line_number

Line 1931: FROM ap_invoice_distributions_all aid

1927:
1928: -- bug 5572121
1929: cursor dist_debug_cur is
1930: Select *
1931: FROM ap_invoice_distributions_all aid
1932: WHERE aid.invoice_id = p_line_rec.invoice_id;
1933:
1934: --bugfix:5638822
1935: l_recouped_amount ap_invoices_all.invoice_amount%type;

Line 2572: FROM ap_invoice_distributions_all

2568: --Prepay distributions , but not the TAX related to ITEM dists, since DETERMINE_RECOVERY
2569: --will take care of the TAX on ITEM dists.
2570: SELECT count(*)
2571: INTO l_distribution_count
2572: FROM ap_invoice_distributions_all
2573: WHERE invoice_id = p_line_rec.invoice_id
2574: AND invoice_line_number = p_line_rec.line_number
2575: AND ((line_type_lookup_code NOT IN ('REC_TAX','NONREC_TAX','TRV','TERV','TIPV') and
2576: prepay_distribution_id IS NULL) OR

Line 2597: UPDATE ap_invoice_distributions

2593: | the second time |
2594: +-----------------------------------------------------------------*/
2595: l_debug_info := 'Set encumbered flag to N for unapproved dist.';
2596:
2597: UPDATE ap_invoice_distributions
2598: SET encumbered_flag = 'R'
2599: WHERE invoice_id = p_line_rec.invoice_id
2600: AND invoice_line_number = p_line_rec.line_number
2601: AND match_status_flag <> 'A'

Line 2652: INSERT INTO ap_invoice_distributions_all(

2648: --consideration 'Prepay' and its related Tax distributions.
2649:
2650: -- Removed the below HAVING clause, for the 7376114, to allow zero amount ITEM lines to be reversed.
2651:
2652: INSERT INTO ap_invoice_distributions_all(
2653: invoice_id,
2654: invoice_line_number,
2655: dist_code_combination_id,
2656: invoice_distribution_id,

Line 2794: ap_invoice_distributions_s.NEXTVAL, -- distribution_id

2790: (SELECT
2791: Invoice_Id, -- invoice_id
2792: Invoice_Line_Number, -- invoice_line_number
2793: Dist_Code_Combination_Id, -- dist_code_combination_id
2794: ap_invoice_distributions_s.NEXTVAL, -- distribution_id
2795: sysdate, -- last_update_date
2796: p_Last_Updated_By, -- last_updated_by
2797: /* Bug 5584997, Getting the accounting_date from line rec */
2798: DECODE(P_calling_mode,'UNAPPLY_PREPAY',p_line_rec.accounting_date,

Line 2933: ap_invoice_distributions_s.CURRVAL,

2929: charge_applicable_to_dist_id, -- charge_applicable_to_dist_id
2930: corrected_invoice_dist_id, -- corrected_invoice_dist_id
2931: DECODE( related_id, NULL, NULL,
2932: invoice_distribution_id,
2933: ap_invoice_distributions_s.CURRVAL,
2934: --bugfix:4921399
2935: NULL ), -- related_id
2936: asset_book_type_code, -- asset_book_type_code
2937: asset_category_id, -- asset_category_id

Line 2943: FROM ap_invoice_distributions_all

2939: decode(p_calling_mode, 'CANCEL', 'Y', NULL), -- cancellation_flag
2940: 'PERMANENT',
2941: intended_use, -- intended_use
2942: 'N' -- rcv_charge_addition_flag
2943: FROM ap_invoice_distributions_all
2944: WHERE invoice_id = p_line_rec.invoice_id
2945: AND invoice_line_number = p_line_rec.line_number
2946: AND line_type_lookup_code NOT IN
2947: ('REC_TAX', 'NONREC_TAX', 'TRV', 'TERV', 'TIPV')

Line 2952: FROM ap_invoice_distributions_all

2948: AND (line_type_lookup_code <> 'AWT' OR
2949: (line_type_lookup_code = 'AWT' AND awt_flag <> 'A'))
2950: AND dist_code_combination_id
2951: IN (SELECT dist_code_combination_id
2952: FROM ap_invoice_distributions_all
2953: WHERE invoice_id = p_line_rec.invoice_id
2954: AND invoice_line_number = p_line_rec.line_number
2955: GROUP BY dist_code_combination_id,
2956: po_distribution_id,

Line 2972: FROM ap_invoice_distributions_all

2968: rcv_transaction_id) -- Bug 4159731
2969: AND nvl(po_distribution_id,-99) IN
2970: (SELECT
2971: NVL(po_distribution_id, -99)
2972: FROM ap_invoice_distributions_all
2973: WHERE invoice_id = p_line_rec.invoice_id
2974: AND invoice_line_number = p_line_rec.line_number
2975: GROUP BY dist_code_combination_id,
2976: po_distribution_id,

Line 2994: UPDATE ap_invoice_distributions aid

2990: ) ;
2991:
2992:
2993: --bugfix:4921399
2994: UPDATE ap_invoice_distributions aid
2995: SET aid.related_id =
2996: (SELECT invoice_distribution_id
2997: FROM ap_invoice_distributions aid1
2998: WHERE aid1.invoice_id = aid.invoice_id

Line 2997: FROM ap_invoice_distributions aid1

2993: --bugfix:4921399
2994: UPDATE ap_invoice_distributions aid
2995: SET aid.related_id =
2996: (SELECT invoice_distribution_id
2997: FROM ap_invoice_distributions aid1
2998: WHERE aid1.invoice_id = aid.invoice_id
2999: AND aid1.invoice_line_number = aid.invoice_line_number
3000: AND aid1.parent_reversal_id =
3001: (SELECT related_id

Line 3002: FROM ap_invoice_distributions aid2

2998: WHERE aid1.invoice_id = aid.invoice_id
2999: AND aid1.invoice_line_number = aid.invoice_line_number
3000: AND aid1.parent_reversal_id =
3001: (SELECT related_id
3002: FROM ap_invoice_distributions aid2
3003: WHERE aid2.invoice_id = aid.invoice_id
3004: AND aid2.invoice_line_number = aid.invoice_line_number
3005: AND aid2.invoice_distribution_id = aid.parent_reversal_id)
3006: )

Line 3032: FROM ap_invoice_distributions

3028:
3029: --bugfix:4542556
3030: SELECT invoice_distribution_id,prepay_distribution_id
3031: BULK COLLECT INTO l_key_value_list,l_key_value_list3
3032: FROM ap_invoice_distributions
3033: WHERE invoice_id = p_line_rec.invoice_id
3034: AND invoice_line_number = p_line_rec.line_number
3035: AND line_type_lookup_code = 'PREPAY'
3036: AND nvl(reversal_flag,'N') = 'Y'

Line 3065: UPDATE ap_invoice_distributions

3061: +-----------------------------------------------------------------*/
3062:
3063: l_debug_info := 'Set reversal_flag to Y for existing distributions';
3064:
3065: UPDATE ap_invoice_distributions
3066: SET reversal_flag = 'Y'
3067: WHERE invoice_id = p_line_rec.invoice_id
3068: AND invoice_line_number = p_line_rec.line_number;
3069:

Line 3128: FROM ap_invoice_distributions aid, --tax dists

3124: IF (nvl(p_calling_mode,'DISCARD') = 'UNAPPLY_PREPAY') THEN
3125:
3126: SELECT aid.invoice_line_number,nvl(ail1.invoice_includes_prepay_flag,'N')
3127: INTO l_tax_line_number,l_prepay_included
3128: FROM ap_invoice_distributions aid, --tax dists
3129: ap_invoice_lines ail1, --item line
3130: ap_invoice_distributions aid1 --item distributions
3131: WHERE ail1.invoice_id = aid1.invoice_id
3132: AND ail1.invoice_id = p_line_rec.invoice_id

Line 3130: ap_invoice_distributions aid1 --item distributions

3126: SELECT aid.invoice_line_number,nvl(ail1.invoice_includes_prepay_flag,'N')
3127: INTO l_tax_line_number,l_prepay_included
3128: FROM ap_invoice_distributions aid, --tax dists
3129: ap_invoice_lines ail1, --item line
3130: ap_invoice_distributions aid1 --item distributions
3131: WHERE ail1.invoice_id = aid1.invoice_id
3132: AND ail1.invoice_id = p_line_rec.invoice_id
3133: AND ail1.line_number = p_line_rec.line_number
3134: AND aid.invoice_id = aid1.invoice_id

Line 3169: FROM ap_invoice_distributions_all aid1,

3165: --Bug 7526679
3166: -- The query is modified to select the total amount of latest reversed tax distributions.
3167: SELECT sum(aid1.amount)
3168: INTO l_unapplied_tax_amount
3169: FROM ap_invoice_distributions_all aid1,
3170: ap_invoice_distributions_all aid2
3171: WHERE aid1.invoice_id = p_line_rec.invoice_id
3172: AND aid1.invoice_id = aid2.invoice_id
3173: AND aid1.invoice_line_number = l_tax_line_number

Line 3170: ap_invoice_distributions_all aid2

3166: -- The query is modified to select the total amount of latest reversed tax distributions.
3167: SELECT sum(aid1.amount)
3168: INTO l_unapplied_tax_amount
3169: FROM ap_invoice_distributions_all aid1,
3170: ap_invoice_distributions_all aid2
3171: WHERE aid1.invoice_id = p_line_rec.invoice_id
3172: AND aid1.invoice_id = aid2.invoice_id
3173: AND aid1.invoice_line_number = l_tax_line_number
3174: AND aid2.invoice_line_number = p_line_rec.line_number

Line 3319: l_max_line_num ap_invoice_distributions.distribution_line_number%TYPE;

3315: l_curr_calling_sequence VARCHAR2(2000);
3316: l_debug_info VARCHAR2(240);
3317: l_api_name VARCHAR2(50);
3318:
3319: l_max_line_num ap_invoice_distributions.distribution_line_number%TYPE;
3320:
3321: BEGIN
3322: l_api_name := 'Reverse_Charge_Distributions';
3323: ------------------------------------------------------

Line 3338: INSERT INTO ap_invoice_distributions_all(

3334: l_debug_info := 'Insert reverse charge distributions';
3335: Print (l_api_name,l_debug_info);
3336: ------------------------------------------------------
3337:
3338: INSERT INTO ap_invoice_distributions_all(
3339: invoice_id,
3340: invoice_line_number,
3341: dist_code_combination_id,
3342: invoice_distribution_id,

Line 3480: ap_invoice_distributions_s.NEXTVAL, -- distribution_id

3476: (SELECT
3477: Invoice_Id, -- invoice_id
3478: Invoice_Line_Number, -- invoice_line_number
3479: Dist_Code_Combination_Id, -- dist_code_combination_id
3480: ap_invoice_distributions_s.NEXTVAL, -- distribution_id
3481: sysdate, -- last_update_date
3482: fnd_global.user_id, -- last_updated_by
3483: /* Bug 5584997, Getting the accounting_date from line rec */
3484: DECODE(P_calling_mode,'UNAPPLY_PREPAY',p_inv_line_rec.accounting_date,

Line 3619: ap_invoice_distributions_s.CURRVAL,

3615: charge_applicable_to_dist_id, -- charge_applicable_to_dist_id
3616: corrected_invoice_dist_id, -- corrected_invoice_dist_id
3617: DECODE( related_id, NULL, NULL,
3618: invoice_distribution_id,
3619: ap_invoice_distributions_s.CURRVAL,
3620: --bugfix:4921399
3621: NULL ), -- related_id
3622: asset_book_type_code, -- asset_book_type_code
3623: asset_category_id, -- asset_category_id

Line 3629: FROM ap_invoice_distributions_all

3625: decode(p_calling_mode, 'CANCEL', 'Y', NULL), -- cancellation_flag
3626: 'PERMANENT',
3627: intended_use, -- intended_use
3628: 'N' -- rcv_charge_addition_flag
3629: FROM ap_invoice_distributions_all
3630: WHERE invoice_id = p_inv_line_rec.invoice_id
3631: AND invoice_line_number = p_inv_line_rec.line_number
3632: AND (reversal_flag is null
3633: or reversal_flag = 'N')

Line 3648: UPDATE ap_invoice_distributions

3644: l_debug_info := 'Update reversal_flag on charge distributions';
3645: Print (l_api_name,l_debug_info);
3646: ---------------------------------------------------------------
3647:
3648: UPDATE ap_invoice_distributions
3649: SET reversal_flag = 'Y'
3650: WHERE invoice_id = p_inv_line_rec.invoice_id
3651: AND invoice_line_number = p_inv_line_rec.line_number;
3652: