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 911: FROM ap_invoice_distributions_all

907: PA_CC_AR_INVOICE_ID,
908: PA_CC_AR_INVOICE_LINE_NUM,
909: PA_CC_PROCESSED_CODE,
910: pay_awt_group_id --bug6817107
911: FROM ap_invoice_distributions_all
912: WHERE invoice_id = p_existing_ppa_lines_rec.invoice_id
913: AND invoice_line_number = p_existing_ppa_lines_rec.line_number
914: AND NVL(cancellation_flag, 'N' ) <> 'Y'
915: AND NVL(reversal_flag, 'N' ) <> 'Y';

Line 1963: FROM ap_invoice_distributions_all aid1,

1959: aid1.PA_CC_AR_INVOICE_ID,
1960: aid1.PA_CC_AR_INVOICE_LINE_NUM,
1961: aid1.PA_CC_PROCESSED_CODE,
1962: aid1.pay_awt_group_id --bug6817107
1963: FROM ap_invoice_distributions_all aid1,
1964: (SELECT rownum r FROM ap_invoice_distributions_all WHERE ROWNUM <= c_rows) aid2
1965: WHERE aid1.invoice_id = p_lines_rec.invoice_id
1966: AND aid1.invoice_line_number = p_lines_rec.line_number
1967: AND aid2.r <= c_rows

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

1960: aid1.PA_CC_AR_INVOICE_LINE_NUM,
1961: aid1.PA_CC_PROCESSED_CODE,
1962: aid1.pay_awt_group_id --bug6817107
1963: FROM ap_invoice_distributions_all aid1,
1964: (SELECT rownum r FROM ap_invoice_distributions_all WHERE ROWNUM <= c_rows) aid2
1965: WHERE aid1.invoice_id = p_lines_rec.invoice_id
1966: AND aid1.invoice_line_number = p_lines_rec.line_number
1967: AND aid2.r <= c_rows
1968: AND aid1.line_type_lookup_code = 'IPV'

Line 1972: FROM ap_invoice_distributions_all aid3

1968: AND aid1.line_type_lookup_code = 'IPV'
1969: AND NVL(aid1.cancellation_flag, 'N' ) <> 'Y'
1970: AND NVL( aid1.reversal_flag, 'N' ) <> 'Y'
1971: AND NOT EXISTS (SELECT 1
1972: FROM ap_invoice_distributions_all aid3
1973: WHERE aid3.corrected_invoice_dist_id = aid1.invoice_distribution_id
1974: AND aid3.line_type_lookup_code IN ('RETROACCRUAL', 'RETROEXPENSE')
1975: );
1976: -- Distribution should not have been Adjusted by prior PPA's. Adjustment

Line 2433: FROM ap_invoice_distributions_all aid1,

2429: aid1.PA_CC_AR_INVOICE_ID,
2430: aid1.PA_CC_AR_INVOICE_LINE_NUM,
2431: aid1.PA_CC_PROCESSED_CODE,
2432: aid1.pay_awt_group_id --bugu6817107
2433: FROM ap_invoice_distributions_all aid1,
2434: (SELECT rownum r FROM ap_invoice_distributions_all WHERE ROWNUM <= c_rows) aid2
2435: WHERE aid1.invoice_id = p_tax_lines_rec.invoice_id
2436: AND aid1.invoice_line_number = p_tax_lines_rec.line_number
2437: AND aid2.r <= c_rows

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

2430: aid1.PA_CC_AR_INVOICE_LINE_NUM,
2431: aid1.PA_CC_PROCESSED_CODE,
2432: aid1.pay_awt_group_id --bugu6817107
2433: FROM ap_invoice_distributions_all aid1,
2434: (SELECT rownum r FROM ap_invoice_distributions_all WHERE ROWNUM <= c_rows) aid2
2435: WHERE aid1.invoice_id = p_tax_lines_rec.invoice_id
2436: AND aid1.invoice_line_number = p_tax_lines_rec.line_number
2437: AND aid2.r <= c_rows
2438: AND aid1.line_type_lookup_code = 'TIPV'

Line 2442: FROM ap_invoice_distributions_all aid3

2438: AND aid1.line_type_lookup_code = 'TIPV'
2439: AND NVL(aid1.cancellation_flag, 'N' ) <> 'Y'
2440: AND NVL( aid1.reversal_flag, 'N' ) <> 'Y'
2441: AND NOT EXISTS (SELECT 1
2442: FROM ap_invoice_distributions_all aid3
2443: WHERE aid3.corrected_invoice_dist_id = aid1.invoice_distribution_id
2444: AND aid3.line_type_lookup_code IN ('RETROTAX'))
2445: AND aid1.charge_applicable_to_dist_id IN
2446: (SELECT invoice_distribution_id

Line 2447: FROM ap_invoice_distributions_all

2443: WHERE aid3.corrected_invoice_dist_id = aid1.invoice_distribution_id
2444: AND aid3.line_type_lookup_code IN ('RETROTAX'))
2445: AND aid1.charge_applicable_to_dist_id IN
2446: (SELECT invoice_distribution_id
2447: FROM ap_invoice_distributions_all
2448: WHERE invoice_id = p_lines_rec.invoice_id
2449: --Bug5485084 replaced p_tax_lines_rec with p_lines_rec
2450: AND invoice_line_number = p_lines_rec.line_number);
2451: -- Distribution should not have been Adjusted by prior PPA's. Adjustment

Line 2456: l_terv_ccid AP_INVOICE_DISTRIBUTIONS_ALL.dist_code_combination_id%TYPE;

2452: -- Corr is done once.
2453: l_tipv_adj_lines_rec AP_RETRO_PRICING_PKG.invoice_lines_rec_type;
2454: l_tipv_adj_dists_list AP_RETRO_PRICING_PKG.invoice_dists_list_type;
2455: l_tipv_dists_list AP_RETRO_PRICING_PKG.invoice_dists_list_type;
2456: l_terv_ccid AP_INVOICE_DISTRIBUTIONS_ALL.dist_code_combination_id%TYPE;
2457: l_terv_dists_exist VARCHAR2(1);
2458: l_rows NUMBER;
2459: l_po_exchange_rate NUMBER;
2460: l_rcv_exchange_rate NUMBER;

Line 2995: FROM ap_invoice_distributions_all

2991: PA_CC_AR_INVOICE_ID,
2992: PA_CC_AR_INVOICE_LINE_NUM,
2993: PA_CC_PROCESSED_CODE,
2994: pay_awt_group_id --bug6817107
2995: FROM ap_invoice_distributions_all
2996: WHERE invoice_id = p_lines_rec.invoice_id
2997: AND invoice_line_number = p_lines_rec.line_number
2998: AND line_type_lookup_code IN ('ITEM', 'ACCRUAL');
2999:

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

4324: WHERE instruction_id = p_instruction_id
4325: AND adj_type = 'ADJ';
4326: --
4327: ------------------------------------------------------------------------------
4328: debug_info := 'Insert_Zero_Amt_Adjustments Step 2. Insert into AP_INVOICE_DISTRIBUTIONS_ALL';
4329: ------------------------------------------------------------------------------
4330: INSERT INTO ap_invoice_distributions_all(
4331: accounting_date,
4332: accrual_posted_flag,

Line 4330: INSERT INTO ap_invoice_distributions_all(

4326: --
4327: ------------------------------------------------------------------------------
4328: debug_info := 'Insert_Zero_Amt_Adjustments Step 2. Insert into AP_INVOICE_DISTRIBUTIONS_ALL';
4329: ------------------------------------------------------------------------------
4330: INSERT INTO ap_invoice_distributions_all(
4331: accounting_date,
4332: accrual_posted_flag,
4333: amount,
4334: asset_book_type_code,

Line 5989: ||'AP_INVOICE_DISTRIBUTIONS_ALL ';

5985: AND adj_type = 'PPA';
5986: --
5987: ------------------------------------------------------------------------
5988: debug_info := 'Insert_Ppa_Invoices Step 5. Insert into '
5989: ||'AP_INVOICE_DISTRIBUTIONS_ALL ';
5990: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
5991: AP_IMPORT_UTILITIES_PKG.Print(
5992: AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
5993: END IF;

Line 5999: INSERT INTO ap_invoice_distributions_all(

5995: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5996: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,debug_info);
5997: END IF;
5998: ------------------------------------------------------------------------
5999: INSERT INTO ap_invoice_distributions_all(
6000: accounting_date,
6001: accrual_posted_flag,
6002: amount,
6003: asset_book_type_code,

Line 6370: l_uom_code ap_invoice_distributions_all.matched_uom_lookup_code%TYPE;

6366: l_po_distribution_id NUMBER;
6367: l_po_line_location_id NUMBER;
6368: l_amount_billed NUMBER;
6369: l_shipment_amount_billed NUMBER;
6370: l_uom_code ap_invoice_distributions_all.matched_uom_lookup_code%TYPE;
6371: l_last_update_login NUMBER;
6372: l_request_id NUMBER;
6373: l_api_name CONSTANT VARCHAR2(200) := 'Import_Retroprice_Adjustments';
6374: l_base_match_lines_rec AP_RETRO_PRICING_PKG.invoice_lines_rec_type; -- Bug 5525506