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_RETRO_PRICING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 928: FROM ap_invoice_distributions_all

924: pay_awt_group_id, --bug6817107
925: --Bug#10416960
926: summary_tax_line_id,
927: detail_tax_dist_id
928: FROM ap_invoice_distributions_all
929: WHERE invoice_id = p_existing_ppa_lines_rec.invoice_id
930: AND invoice_line_number = p_existing_ppa_lines_rec.line_number
931: AND NVL(cancellation_flag, 'N' ) <> 'Y'
932: AND NVL(reversal_flag, 'N' ) <> 'Y';

Line 2040: FROM ap_invoice_distributions_all aid1,

2036: aid1.pay_awt_group_id, --bug6817107
2037: /* Bug#10416960 */
2038: summary_tax_line_id,
2039: detail_tax_dist_id
2040: FROM ap_invoice_distributions_all aid1,
2041: (SELECT rownum r FROM ap_invoice_distributions_all WHERE ROWNUM <= c_rows) aid2
2042: WHERE aid1.invoice_id = p_lines_rec.invoice_id
2043: AND aid1.invoice_line_number = p_lines_rec.line_number
2044: AND aid2.r <= c_rows

Line 2041: (SELECT rownum r FROM ap_invoice_distributions_all WHERE ROWNUM <= c_rows) aid2

2037: /* Bug#10416960 */
2038: summary_tax_line_id,
2039: detail_tax_dist_id
2040: FROM ap_invoice_distributions_all aid1,
2041: (SELECT rownum r FROM ap_invoice_distributions_all WHERE ROWNUM <= c_rows) aid2
2042: WHERE aid1.invoice_id = p_lines_rec.invoice_id
2043: AND aid1.invoice_line_number = p_lines_rec.line_number
2044: AND aid2.r <= c_rows
2045: --Bug#10416960

Line 2050: FROM ap_invoice_distributions_all aid3

2046: AND aid1.line_type_lookup_code in ('IPV','ERV')
2047: AND NVL(aid1.cancellation_flag, 'N' ) <> 'Y'
2048: AND NVL( aid1.reversal_flag, 'N' ) <> 'Y'
2049: AND NOT EXISTS (SELECT 1
2050: FROM ap_invoice_distributions_all aid3
2051: WHERE aid3.corrected_invoice_dist_id = aid1.invoice_distribution_id
2052: AND aid3.line_type_lookup_code IN ('RETROACCRUAL', 'RETROEXPENSE')
2053: );
2054: -- Distribution should not have been Adjusted by prior PPA's. Adjustment

Line 2596: FROM ap_invoice_distributions_all aid1,

2592: aid1.pay_awt_group_id, --bugu6817107
2593: /* Bug#10416960 */
2594: summary_tax_line_id,
2595: detail_tax_dist_id
2596: FROM ap_invoice_distributions_all aid1,
2597: (SELECT rownum r FROM ap_invoice_distributions_all WHERE ROWNUM <= c_rows) aid2
2598: WHERE aid1.invoice_id = p_tax_lines_rec.invoice_id
2599: AND aid1.invoice_line_number = p_tax_lines_rec.line_number
2600: AND aid2.r <= c_rows

Line 2597: (SELECT rownum r FROM ap_invoice_distributions_all WHERE ROWNUM <= c_rows) aid2

2593: /* Bug#10416960 */
2594: summary_tax_line_id,
2595: detail_tax_dist_id
2596: FROM ap_invoice_distributions_all aid1,
2597: (SELECT rownum r FROM ap_invoice_distributions_all WHERE ROWNUM <= c_rows) aid2
2598: WHERE aid1.invoice_id = p_tax_lines_rec.invoice_id
2599: AND aid1.invoice_line_number = p_tax_lines_rec.line_number
2600: AND aid2.r <= c_rows
2601: --Bug#10416960

Line 2606: FROM ap_invoice_distributions_all aid3

2602: AND aid1.line_type_lookup_code in ('TIPV','TRV','REC_TAX','TERV')
2603: AND NVL(aid1.cancellation_flag, 'N' ) <> 'Y'
2604: AND NVL( aid1.reversal_flag, 'N' ) <> 'Y'
2605: AND NOT EXISTS (SELECT 1
2606: FROM ap_invoice_distributions_all aid3
2607: WHERE aid3.corrected_invoice_dist_id = aid1.invoice_distribution_id
2608: --Bug#10416960
2609: --AND aid3.line_type_lookup_code IN ('RETROTAX')
2610: AND aid3.dist_match_type='ADJUSTMENT_CORRECTION')

Line 2613: FROM ap_invoice_distributions_all

2609: --AND aid3.line_type_lookup_code IN ('RETROTAX')
2610: AND aid3.dist_match_type='ADJUSTMENT_CORRECTION')
2611: AND aid1.charge_applicable_to_dist_id IN
2612: (SELECT invoice_distribution_id
2613: FROM ap_invoice_distributions_all
2614: WHERE invoice_id = p_lines_rec.invoice_id
2615: --Bug5485084 replaced p_tax_lines_rec with p_lines_rec
2616: AND invoice_line_number = p_lines_rec.line_number);
2617: -- Distribution should not have been Adjusted by prior PPA's. Adjustment

Line 2622: l_terv_ccid AP_INVOICE_DISTRIBUTIONS_ALL.dist_code_combination_id%TYPE;

2618: -- Corr is done once.
2619: l_tipv_adj_lines_rec AP_RETRO_PRICING_PKG.invoice_lines_rec_type;
2620: l_tipv_adj_dists_list AP_RETRO_PRICING_PKG.invoice_dists_list_type;
2621: l_tipv_dists_list AP_RETRO_PRICING_PKG.invoice_dists_list_type;
2622: l_terv_ccid AP_INVOICE_DISTRIBUTIONS_ALL.dist_code_combination_id%TYPE;
2623: l_terv_dists_exist VARCHAR2(1);
2624: l_rows NUMBER;
2625: l_po_exchange_rate NUMBER;
2626: l_rcv_exchange_rate NUMBER;

Line 3244: FROM ap_invoice_distributions_all

3240: pay_awt_group_id, --bug6817107
3241: /* Bug#10416960 */
3242: summary_tax_line_id,
3243: detail_tax_dist_id
3244: FROM ap_invoice_distributions_all
3245: WHERE invoice_id = p_lines_rec.invoice_id
3246: AND invoice_line_number = p_lines_rec.line_number
3247: AND line_type_lookup_code IN ('ITEM', 'ACCRUAL');
3248:

Line 4606: debug_info := 'Insert_Zero_Amt_Adjustments Step 2. Insert into AP_INVOICE_DISTRIBUTIONS_ALL';

4602: AND d1.invoice_id = l1.invoice_id
4603: AND d1.invoice_line_number = l1.line_number));
4604: --
4605: ------------------------------------------------------------------------------
4606: debug_info := 'Insert_Zero_Amt_Adjustments Step 2. Insert into AP_INVOICE_DISTRIBUTIONS_ALL';
4607: ------------------------------------------------------------------------------
4608: INSERT INTO ap_invoice_distributions_all(
4609: accounting_date,
4610: accrual_posted_flag,

Line 4608: INSERT INTO ap_invoice_distributions_all(

4604: --
4605: ------------------------------------------------------------------------------
4606: debug_info := 'Insert_Zero_Amt_Adjustments Step 2. Insert into AP_INVOICE_DISTRIBUTIONS_ALL';
4607: ------------------------------------------------------------------------------
4608: INSERT INTO ap_invoice_distributions_all(
4609: accounting_date,
4610: accrual_posted_flag,
4611: amount,
4612: asset_book_type_code,

Line 6448: ||'AP_INVOICE_DISTRIBUTIONS_ALL ';

6444: -- AND adj_type = 'PPA';
6445: --
6446: ------------------------------------------------------------------------
6447: debug_info := 'Insert_Ppa_Invoices Step 5. Insert into '
6448: ||'AP_INVOICE_DISTRIBUTIONS_ALL ';
6449: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
6450: AP_IMPORT_UTILITIES_PKG.Print(
6451: AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
6452: END IF;

Line 6458: INSERT INTO ap_invoice_distributions_all(

6454: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6455: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,debug_info);
6456: END IF;
6457: ------------------------------------------------------------------------
6458: INSERT INTO ap_invoice_distributions_all(
6459: accounting_date,
6460: accrual_posted_flag,
6461: amount,
6462: asset_book_type_code,

Line 6841: l_uom_code ap_invoice_distributions_all.matched_uom_lookup_code%TYPE;

6837: l_po_distribution_id NUMBER;
6838: l_po_line_location_id NUMBER;
6839: l_amount_billed NUMBER;
6840: l_shipment_amount_billed NUMBER;
6841: l_uom_code ap_invoice_distributions_all.matched_uom_lookup_code%TYPE;
6842: l_last_update_login NUMBER;
6843: l_request_id NUMBER;
6844: l_api_name CONSTANT VARCHAR2(200) := 'Import_Retroprice_Adjustments';
6845: l_base_match_lines_rec AP_RETRO_PRICING_PKG.invoice_lines_rec_type; -- Bug 5525506