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

Line 50: FROM ap_invoice_distributions_all D

46: AND L.discarded_flag <> 'Y'
47: AND L.cancelled_flag <> 'Y'
48: AND (NVL(L.generate_dists, 'Y') <> 'D' OR
49: EXISTS (SELECT 'Unapproved matched dist'
50: FROM ap_invoice_distributions_all D
51: WHERE D.invoice_id = L.invoice_id
52: AND D.invoice_line_number = L.line_number
53: AND nvl(D.match_status_flag, 'X') NOT IN ('A', 'T'))
54: );

Line 130: FROM ap_invoice_distributions_all D

126: AND L.discarded_flag <> 'Y'
127: AND L.cancelled_flag <> 'Y'
128: AND (NVL(L.generate_dists, 'Y') = 'D'
129: AND NOT EXISTS (SELECT 'Unapproved matched dist'
130: FROM ap_invoice_distributions_all D
131: WHERE D.invoice_id = L.invoice_id
132: AND D.invoice_line_number = L.line_number
133: AND nvl(D.match_status_flag, 'X') NOT IN ('A', 'T'))
134: AND EXISTS (SELECT 'Holds other than Price Hold'

Line 361: FROM ap_invoice_distributions_all

357: BEGIN
358: debug_info := 'Get Existing Ppa_invoice_id';
359: SELECT count(*)
360: INTO l_count
361: FROM ap_invoice_distributions_all
362: WHERE invoice_id = p_invoice_id
363: AND invoice_line_number = p_line_number
364: AND line_type_lookup_code = 'IPV';
365:

Line 408: FROM ap_invoice_distributions_all

404: BEGIN
405: debug_info := 'IF Erv Dists Exist';
406: SELECT count(*)
407: INTO l_count
408: FROM ap_invoice_distributions_all
409: WHERE invoice_id = p_invoice_id
410: AND invoice_line_number = p_line_number
411: AND line_type_lookup_code = 'ERV';
412:

Line 935: FROM ap_invoice_distributions_all AID

931: AND ARL.to_invoice_line_number = p_invoice_line_number
932: AND ARL.chrg_invoice_line_number = AIL.line_number
933: AND AIL.line_type_lookup_code = 'TAX'
934: AND EXISTS (SELECT 1
935: FROM ap_invoice_distributions_all AID
936: WHERE AID.invoice_id = AIL.invoice_id
937: AND AID.invoice_line_number = AIL.line_number
938: AND AID.invoice_id = p_invoice_id
939: --Bug#10416960

Line 952: FROM ap_invoice_distributions_all d1

948: --
949: debug_info := 'IF tipv exist';
950: SELECT count(*)
951: INTO l_tipv_count
952: FROM ap_invoice_distributions_all d1
953: WHERE invoice_id = p_invoice_id
954: AND invoice_line_number <> p_invoice_line_number
955: --Bug#10416960
956: AND line_type_lookup_code in('TIPV','TRV','REC_TAX','TERV')

Line 959: FROM ap_invoice_distributions_all

955: --Bug#10416960
956: AND line_type_lookup_code in('TIPV','TRV','REC_TAX','TERV')
957: AND charge_applicable_to_dist_id IN
958: (SELECT invoice_distribution_id
959: FROM ap_invoice_distributions_all
960: WHERE invoice_id = p_invoice_id
961: AND invoice_line_number = p_invoice_line_number);
962: --
963: IF l_tipv_count > 0 THEN

Line 1034: FROM ap_invoice_distributions_all

1030: --
1031: debug_info := 'IF Terv Dists Exist';
1032: SELECT count(*)
1033: INTO l_count
1034: FROM ap_invoice_distributions_all
1035: WHERE invoice_id = p_invoice_id
1036: AND invoice_line_number = p_line_number
1037: AND line_type_lookup_code = 'TERV';
1038:

Line 1125: FROM ap_invoice_distributions_all

1121: BEGIN
1122: debug_info := 'Get ccid';
1123: SELECT dist_code_combination_id
1124: INTO l_ccid
1125: FROM ap_invoice_distributions_all
1126: WHERE invoice_distribution_id = p_invoice_distribution_id;
1127: --
1128: RETURN l_ccid;
1129: --

Line 1165: FROM ap_invoice_distributions_all

1161: debug_info := 'Get Dist_Type_lookup_code';
1162: SELECT DECODE(line_type_lookup_code, 'ITEM', 'RETROEXPENSE',
1163: 'ACCRUAL', 'RETROACCRUAL', 'RETROEXPENSE')
1164: INTO l_line_type_lookup_code
1165: FROM ap_invoice_distributions_all
1166: WHERE invoice_distribution_id = p_invoice_distribution_id;
1167:
1168: RETURN l_line_type_lookup_code;
1169:

Line 1341: FROM ap_invoice_distributions_all

1337: INTO l_dist_id
1338: FROM ap_ppa_invoice_dists_gt
1339: WHERE corrected_invoice_dist_id =
1340: (SELECT invoice_distribution_id --5485084
1341: FROM ap_invoice_distributions_all
1342: WHERE DECODE(p_match_type,
1343: 'PRICE_CORRECTION',corrected_invoice_dist_id,
1344: related_id) = p_ccid
1345: AND line_type_lookup_code = 'IPV')

Line 2529: FROM ap_invoice_distributions_all aid1

2525: BEGIN
2526: debug_info := 'Get ERV ccid';
2527: SELECT aid1.dist_code_combination_id
2528: INTO l_ccid
2529: FROM ap_invoice_distributions_all aid1
2530: WHERE aid1.line_type_lookup_code = 'ERV'
2531: AND aid1.related_id = (SELECT aid2.related_id
2532: FROM ap_invoice_distributions_all aid2
2533: WHERE aid2.line_type_lookup_code = 'IPV'

Line 2532: FROM ap_invoice_distributions_all aid2

2528: INTO l_ccid
2529: FROM ap_invoice_distributions_all aid1
2530: WHERE aid1.line_type_lookup_code = 'ERV'
2531: AND aid1.related_id = (SELECT aid2.related_id
2532: FROM ap_invoice_distributions_all aid2
2533: WHERE aid2.line_type_lookup_code = 'IPV'
2534: AND aid2.invoice_distribution_id =
2535: p_invoice_distribution_id);
2536: --

Line 2574: FROM ap_invoice_distributions_all aid1

2570: BEGIN
2571: debug_info := 'Get Terv ccid';
2572: SELECT aid1.dist_code_combination_id
2573: INTO l_ccid
2574: FROM ap_invoice_distributions_all aid1
2575: WHERE aid1.line_type_lookup_code = 'TERV'
2576: AND aid1.related_id = (SELECT aid2.related_id
2577: FROM ap_invoice_distributions_all aid2
2578: WHERE aid2.line_type_lookup_code = 'TIPV'

Line 2577: FROM ap_invoice_distributions_all aid2

2573: INTO l_ccid
2574: FROM ap_invoice_distributions_all aid1
2575: WHERE aid1.line_type_lookup_code = 'TERV'
2576: AND aid1.related_id = (SELECT aid2.related_id
2577: FROM ap_invoice_distributions_all aid2
2578: WHERE aid2.line_type_lookup_code = 'TIPV'
2579: AND aid2.invoice_distribution_id =
2580: p_invoice_distribution_id);
2581: --