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_INVOICES_UTILITY_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 29: FROM ap_invoice_distributions

25: SELECT invoice_num
26: FROM ap_invoices
27: WHERE invoice_id =
28: (SELECT invoice_id
29: FROM ap_invoice_distributions
30: WHERE invoice_distribution_id = l_prepay_dist_id);
31: BEGIN
32:
33: OPEN c_prepay_number;

Line 64: FROM ap_invoice_distributions

60: l_prepay_dist_number VARCHAR2(50);
61:
62: CURSOR c_prepay_dist_number IS
63: SELECT distribution_line_number
64: FROM ap_invoice_distributions
65: WHERE invoice_distribution_id = l_prepay_dist_id;
66:
67: BEGIN
68:

Line 113: FROM ap_invoice_distributions_all aid,

109: -- eTax Uptake. Modified to exclude REC_TAX and NONREC_TAX
110: -- distributions created for prepayment applications
111: SELECT SUM(NVL(aid.amount,0))
112: INTO distribution_total
113: FROM ap_invoice_distributions_all aid,
114: ap_invoice_lines_all ail
115: WHERE ail.invoice_id = l_invoice_id
116: AND aid.invoice_id = ail.invoice_id
117: AND aid.invoice_line_number = ail.line_number

Line 150: | -- MOAC. Use ap_invoice_distributions_all table instead of SO view

146: | -- processing. The 'P' is to cover one specific case when some of
147: | -- the distributions are fully posting (Y) and some are unposting (N).
148: | -- The status should be partial (P).
149: | --
150: | -- MOAC. Use ap_invoice_distributions_all table instead of SO view
151: | -- since this procedure is called when policy context is not set to
152: | -- the corresponding OU for the invoice_id
153: |
154: | MODIFICATION HISTORY

Line 168: FROM ap_invoice_distributions_all

164:
165:
166: CURSOR posting_cursor IS
167: SELECT cash_posted_flag
168: FROM ap_invoice_distributions_all
169: WHERE invoice_id = l_invoice_id
170: AND l_cash_basis_flag = 'Y'
171: UNION
172: SELECT accrual_posted_flag

Line 173: FROM ap_invoice_distributions_all

169: WHERE invoice_id = l_invoice_id
170: AND l_cash_basis_flag = 'Y'
171: UNION
172: SELECT accrual_posted_flag
173: FROM ap_invoice_distributions_all
174: WHERE invoice_id = l_invoice_id
175: AND l_cash_basis_flag <>'Y'
176: UNION
177: SELECT 'P'

Line 178: FROM ap_invoice_distributions_all

174: WHERE invoice_id = l_invoice_id
175: AND l_cash_basis_flag <>'Y'
176: UNION
177: SELECT 'P'
178: FROM ap_invoice_distributions_all
179: WHERE invoice_id = l_invoice_id
180: AND ((cash_posted_flag = 'Y'
181: AND l_cash_basis_flag = 'Y')
182: OR

Line 187: FROM ap_invoice_distributions_all

183: (accrual_posted_flag = 'Y'
184: AND l_cash_basis_flag <> 'Y'))
185: AND EXISTS
186: (SELECT 'An N is also in the valid flags'
187: FROM ap_invoice_distributions_all
188: WHERE invoice_id = l_invoice_id
189: AND ((cash_posted_flag = 'N'
190: AND l_cash_basis_flag = 'Y')
191: OR

Line 279: FROM ap_invoice_distributions_all AID,

275:
276: BEGIN
277: SELECT 'D'
278: INTO invoice_posting_flag
279: FROM ap_invoice_distributions_all AID,
280: xla_events XE
281: WHERE AID.invoice_id = l_invoice_id
282: AND AID.accounting_event_id = XE.event_id
283: AND ((AID.accrual_posted_flag = 'N' AND l_cash_basis_flag = 'N') OR

Line 498: FROM ap_invoice_distributions_all

494: -- NULL and 'N' are the same.
495:
496: CURSOR approval_cursor IS
497: SELECT nvl(match_status_flag, 'N')
498: FROM ap_invoice_distributions_all
499: WHERE invoice_id = l_invoice_id;
500:
501: BEGIN
502:

Line 563: FROM ap_invoice_distributions_all aid

559: -- only if the count is more than 0.
560: --
561: SELECT count(*)
562: INTO match_flag_cnt
563: FROM ap_invoice_distributions_all aid
564: WHERE aid.invoice_id = l_invoice_id
565: AND aid.match_status_flag IS NOT NULL
566: AND rownum < 2;
567:

Line 693: FROM ap_invoice_distributions_all aid

689: IF match_flag_cnt > 0 THEN
690:
691: SELECT count(*)
692: INTO l_validated_cnt
693: FROM ap_invoice_distributions_all aid
694: WHERE aid.invoice_id = l_invoice_id
695: AND aid.match_status_flag = 'N'
696: AND rownum < 2;
697:

Line 726: FROM ap_invoice_distributions_all aid

722: FROM ap_invoice_lines_all ail
723: WHERE ail.invoice_id = l_invoice_id
724: AND ail.amount <>
725: ( SELECT NVL(SUM(NVL(aid.amount,0)),0)
726: FROM ap_invoice_distributions_all aid
727: WHERE aid.invoice_id = ail.invoice_id
728: AND aid.invoice_line_number = ail.line_number
729: --bugfix:4959567
730: AND ( aid.line_type_lookup_code <> 'RETAINAGE'

Line 807: FROM ap_invoice_distributions_all aid,

803: IF (encumbrance_flag = 'Y') AND (invoice_approval_flag = 'A') THEN
804:
805: SELECT NVL(SUM(nvl(aid.amount,0)), 0)
806: INTO sum_distributions
807: FROM ap_invoice_distributions_all aid,
808: ap_invoice_lines_all ail
809: WHERE ail.invoice_id = l_invoice_id
810: AND aid.invoice_id = ail.invoice_id
811: AND aid.invoice_line_number = ail.line_number

Line 1232: from ap_invoice_distributions

1228: BEGIN
1229:
1230: select (0 - sum(nvl(amount,0)))
1231: into amount_withheld
1232: from ap_invoice_distributions
1233: where invoice_id = l_invoice_id
1234: and line_type_lookup_code = 'AWT';
1235:
1236: return(amount_withheld);

Line 1511: FROM ap_invoice_distributions

1507: l_org_id FINANCIALS_SYSTEM_PARAMS_ALL.ORG_ID%TYPE;
1508:
1509: CURSOR encumbrance_flag_cursor is
1510: SELECT nvl(encumbered_flag,'N')
1511: FROM ap_invoice_distributions
1512: WHERE invoice_id = l_invoice_id;
1513:
1514: /*7388641 - Checking encumbrance for invoice having just self
1515: assessed tax distributions, not a normal distributions and

Line 2145: FROM ap_invoice_distributions_all aid,ap_invoices_all ai

2141: IS
2142: l_prepay_amount_remaining number:=0;
2143: cursor c_prepay_amount_remaining IS
2144: SELECT SUM(nvl(prepay_amount_remaining,amount))
2145: FROM ap_invoice_distributions_all aid,ap_invoices_all ai
2146: WHERE aid.invoice_id = P_invoice_id
2147: AND aid.line_type_lookup_code IN ('ITEM','TAX')
2148: AND nvl(aid.reversal_flag,'N') <> 'Y'
2149: AND ai.invoice_id = P_invoice_id

Line 2219: from ap_invoice_distributions

2215: l_packet_id number := '';
2216:
2217: cursor packet_id_cursor is
2218: select decode(count(distinct(packet_id)),1,max(packet_id),'')
2219: from ap_invoice_distributions
2220: where invoice_id = P_Invoice_Id
2221: and packet_id is not null;
2222:
2223: BEGIN

Line 2384: from ap_invoice_distributions aid

2380: l_secondary_acctg_method = 'Cash')) THEN
2381:
2382: select count(*)
2383: into l_count_prepaid_posted
2384: from ap_invoice_distributions aid
2385: where aid.posted_flag <> 'N'
2386: and aid.invoice_id = p_invoice_id
2387: and aid.line_type_lookup_code = 'PREPAY';
2388: END IF;

Line 2429: FROM ap_invoice_distributions aid1, ap_invoice_distributions aid2

2425: BEGIN
2426:
2427: SELECT SUM(aid1.amount * -1)
2428: INTO l_prepay_amt_applied
2429: FROM ap_invoice_distributions aid1, ap_invoice_distributions aid2
2430: WHERE aid1.invoice_id = P_invoice_id
2431: AND aid1.line_type_lookup_code = 'PREPAY'
2432: AND aid1.prepay_distribution_id = aid2.invoice_distribution_id
2433: AND aid2.invoice_id = P_prepay_id

Line 2465: FROM ap_invoice_distributions

2461: BEGIN
2462:
2463: SELECT count(invoice_distribution_id)
2464: INTO l_count_distributions
2465: FROM ap_invoice_distributions
2466: WHERE invoice_id = p_invoice_id;
2467:
2468: RETURN l_count_distributions;
2469:

Line 2504: FROM ap_invoice_distributions aid1, ap_invoice_distributions aid2

2500: BEGIN
2501:
2502: SELECT SUM(aid1.amount * -1)
2503: INTO l_prepay_amt_applied
2504: FROM ap_invoice_distributions aid1, ap_invoice_distributions aid2
2505: WHERE aid1.invoice_id = P_invoice_id
2506: AND aid1.line_type_lookup_code = 'PREPAY'
2507: AND aid1.prepay_distribution_id = aid2.invoice_distribution_id
2508: AND aid2.invoice_id = P_prepay_id;

Line 2818: FROM ap_invoice_distributions D1

2814: WHERE ail1.invoice_id = X_invoice_id
2815: AND ail1.amount <> 0
2816: AND (EXISTS
2817: (SELECT 'UNPOSTED'
2818: FROM ap_invoice_distributions D1
2819: WHERE D1.invoice_id = ail1.invoice_id
2820: AND D1.invoice_line_number = ail1.line_number
2821: AND NVL(D1.posted_flag, 'N') = 'N') OR
2822: (NOT EXISTS

Line 2824: FROM ap_invoice_distributions D2

2820: AND D1.invoice_line_number = ail1.line_number
2821: AND NVL(D1.posted_flag, 'N') = 'N') OR
2822: (NOT EXISTS
2823: (SELECT 'X'
2824: FROM ap_invoice_distributions D2
2825: WHERE D2.invoice_id = ail1.invoice_id
2826: AND D2.invoice_line_number = ail1.line_number)))
2827: ORDER BY ail1.base_amount desc;
2828:

Line 3291: from ap_invoice_distributions

3287: BEGIN
3288:
3289: select nvl(max(distribution_line_number),0)
3290: into l_max_dist_line_num
3291: from ap_invoice_distributions
3292: where invoice_id = P_invoice_id
3293: and invoice_line_number = P_invoice_line_number;
3294:
3295: return(l_max_dist_line_num);

Line 3345: FROM ap_invoice_distributions_all aid

3341: BEGIN
3342:
3343: SELECT SUM(NVL(amount,0))
3344: INTO retained_total
3345: FROM ap_invoice_distributions_all aid
3346: WHERE aid.invoice_id = p_invoice_id
3347: AND aid.line_type_lookup_code = 'RETAINAGE'
3348: AND EXISTS
3349: (SELECT 'X' FROM ap_invoice_lines_all ail

Line 3481: from ap_invoice_distributions_all

3477: BEGIN
3478:
3479: select sum(nvl(amount,0))
3480: into prepay_app_total
3481: from ap_invoice_distributions_all
3482: where invoice_id = p_invoice_id
3483: and org_id = p_org_id
3484: and line_type_lookup_code = 'PREPAY';
3485: