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

353: BEGIN
354: debug_info := 'Get Existing Ppa_invoice_id';
355: SELECT count(*)
356: INTO l_count
357: FROM ap_invoice_distributions_all
358: WHERE invoice_id = p_invoice_id
359: AND invoice_line_number = p_line_number
360: AND line_type_lookup_code = 'IPV';
361:

Line 404: FROM ap_invoice_distributions_all

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

Line 930: FROM ap_invoice_distributions_all AID

926: AND ARL.to_invoice_line_number = p_invoice_line_number
927: AND ARL.chrg_invoice_line_number = AIL.line_number
928: AND AIL.line_type_lookup_code = 'TAX'
929: AND EXISTS (SELECT 1
930: FROM ap_invoice_distributions_all AID
931: WHERE AID.invoice_id = AIL.invoice_id
932: AND AID.invoice_line_number = AIL.line_number
933: AND AID.invoice_id = p_invoice_id
934: AND AID.line_type_lookup_code = 'TIPV');

Line 946: FROM ap_invoice_distributions_all d1

942: --
943: debug_info := 'IF tipv exist';
944: SELECT count(*)
945: INTO l_tipv_count
946: FROM ap_invoice_distributions_all d1
947: WHERE invoice_id = p_invoice_id
948: AND invoice_line_number <> p_invoice_line_number
949: AND line_type_lookup_code = 'TIPV'
950: AND charge_applicable_to_dist_id IN

Line 952: FROM ap_invoice_distributions_all

948: AND invoice_line_number <> p_invoice_line_number
949: AND line_type_lookup_code = 'TIPV'
950: AND charge_applicable_to_dist_id IN
951: (SELECT invoice_distribution_id
952: FROM ap_invoice_distributions_all
953: WHERE invoice_id = p_invoice_id
954: AND invoice_line_number = p_invoice_line_number);
955: --
956: IF l_tipv_count > 0 THEN

Line 1027: FROM ap_invoice_distributions_all

1023: --
1024: debug_info := 'IF Terv Dists Exist';
1025: SELECT count(*)
1026: INTO l_count
1027: FROM ap_invoice_distributions_all
1028: WHERE invoice_id = p_invoice_id
1029: AND invoice_line_number = p_line_number
1030: AND line_type_lookup_code = 'TERV';
1031:

Line 1118: FROM ap_invoice_distributions_all

1114: BEGIN
1115: debug_info := 'Get ccid';
1116: SELECT dist_code_combination_id
1117: INTO l_ccid
1118: FROM ap_invoice_distributions_all
1119: WHERE invoice_distribution_id = p_invoice_distribution_id;
1120: --
1121: RETURN l_ccid;
1122: --

Line 1158: FROM ap_invoice_distributions_all

1154: debug_info := 'Get Dist_Type_lookup_code';
1155: SELECT DECODE(line_type_lookup_code, 'ITEM', 'RETROEXPENSE',
1156: 'ACCRUAL', 'RETROACCRUAL', 'RETROEXPENSE')
1157: INTO l_line_type_lookup_code
1158: FROM ap_invoice_distributions_all
1159: WHERE invoice_distribution_id = p_invoice_distribution_id;
1160:
1161: RETURN l_line_type_lookup_code;
1162:

Line 1326: FROM ap_invoice_distributions_all

1322: INTO l_dist_id
1323: FROM ap_ppa_invoice_dists_gt
1324: WHERE corrected_invoice_dist_id =
1325: (SELECT invoice_distribution_id --5485084
1326: FROM ap_invoice_distributions_all
1327: WHERE DECODE(p_match_type,
1328: 'PRICE_CORRECTION',corrected_invoice_dist_id,
1329: related_id) = p_ccid
1330: AND line_type_lookup_code = 'IPV')

Line 2536: FROM ap_invoice_distributions_all aid1

2532: BEGIN
2533: debug_info := 'Get ERV ccid';
2534: SELECT aid1.dist_code_combination_id
2535: INTO l_ccid
2536: FROM ap_invoice_distributions_all aid1
2537: WHERE aid1.line_type_lookup_code = 'ERV'
2538: AND aid1.related_id = (SELECT aid2.related_id
2539: FROM ap_invoice_distributions_all aid2
2540: WHERE aid2.line_type_lookup_code = 'IPV'

Line 2539: FROM ap_invoice_distributions_all aid2

2535: INTO l_ccid
2536: FROM ap_invoice_distributions_all aid1
2537: WHERE aid1.line_type_lookup_code = 'ERV'
2538: AND aid1.related_id = (SELECT aid2.related_id
2539: FROM ap_invoice_distributions_all aid2
2540: WHERE aid2.line_type_lookup_code = 'IPV'
2541: AND aid2.invoice_distribution_id =
2542: p_invoice_distribution_id);
2543: --

Line 2579: FROM ap_invoice_distributions_all aid1

2575: BEGIN
2576: debug_info := 'Get Terv ccid';
2577: SELECT aid1.dist_code_combination_id
2578: INTO l_ccid
2579: FROM ap_invoice_distributions_all aid1
2580: WHERE aid1.line_type_lookup_code = 'TERV'
2581: AND aid1.related_id = (SELECT aid2.related_id
2582: FROM ap_invoice_distributions_all aid2
2583: WHERE aid2.line_type_lookup_code = 'TIPV'

Line 2582: FROM ap_invoice_distributions_all aid2

2578: INTO l_ccid
2579: FROM ap_invoice_distributions_all aid1
2580: WHERE aid1.line_type_lookup_code = 'TERV'
2581: AND aid1.related_id = (SELECT aid2.related_id
2582: FROM ap_invoice_distributions_all aid2
2583: WHERE aid2.line_type_lookup_code = 'TIPV'
2584: AND aid2.invoice_distribution_id =
2585: p_invoice_distribution_id);
2586: --