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_ALL

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 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 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 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 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 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 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 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')