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 35: FROM ap_invoice_distributions

31: SELECT invoice_num
32: FROM ap_invoices
33: WHERE invoice_id =
34: (SELECT invoice_id
35: FROM ap_invoice_distributions
36: WHERE invoice_distribution_id = l_prepay_dist_id);
37: BEGIN
38:
39: OPEN c_prepay_number;

Line 70: FROM ap_invoice_distributions

66: l_prepay_dist_number VARCHAR2(50);
67:
68: CURSOR c_prepay_dist_number IS
69: SELECT distribution_line_number
70: FROM ap_invoice_distributions
71: WHERE invoice_distribution_id = l_prepay_dist_id;
72:
73: BEGIN
74:

Line 119: FROM ap_invoice_distributions_all aid,

115: -- eTax Uptake. Modified to exclude REC_TAX and NONREC_TAX
116: -- distributions created for prepayment applications
117: SELECT SUM(NVL(aid.amount,0))
118: INTO distribution_total
119: FROM ap_invoice_distributions_all aid,
120: ap_invoice_lines_all ail
121: WHERE ail.invoice_id = l_invoice_id
122: AND aid.invoice_id = ail.invoice_id
123: AND aid.invoice_line_number = ail.line_number

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

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

Line 174: FROM ap_invoice_distributions_all

170:
171:
172: CURSOR posting_cursor IS
173: SELECT cash_posted_flag
174: FROM ap_invoice_distributions_all
175: WHERE invoice_id = l_invoice_id
176: AND l_cash_basis_flag = 'Y'
177: UNION
178: SELECT accrual_posted_flag

Line 179: FROM ap_invoice_distributions_all

175: WHERE invoice_id = l_invoice_id
176: AND l_cash_basis_flag = 'Y'
177: UNION
178: SELECT accrual_posted_flag
179: FROM ap_invoice_distributions_all
180: WHERE invoice_id = l_invoice_id
181: AND l_cash_basis_flag <>'Y'
182: UNION
183: SELECT 'P'

Line 184: FROM ap_invoice_distributions_all

180: WHERE invoice_id = l_invoice_id
181: AND l_cash_basis_flag <>'Y'
182: UNION
183: SELECT 'P'
184: FROM ap_invoice_distributions_all
185: WHERE invoice_id = l_invoice_id
186: AND ((cash_posted_flag = 'Y' AND l_cash_basis_flag = 'Y')
187: OR
188: (accrual_posted_flag = 'Y' AND l_cash_basis_flag <> 'Y'))

Line 191: FROM ap_invoice_distributions_all

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

Line 245: FROM ap_invoice_distributions_all

241: (accrual_posted_flag = 'N'
242: AND l_cash_basis_flag <> 'Y'))
243: UNION /*Added for bug 10039729*/
244: SELECT 'An N is also in the valid flags'
245: FROM ap_invoice_distributions_all
246: WHERE invoice_id = l_invoice_id
247: AND ((cash_posted_flag = 'N'
248: AND l_cash_basis_flag = 'Y')
249: OR

Line 272: FROM ap_invoice_distributions_all

268: AND transaction_type = 'PREPAYMENT APPLICATION ADJ'
269: AND posted_flag = 'Y'
270: AND EXISTS
271: (SELECT 'An N is also in the valid flags'
272: FROM ap_invoice_distributions_all
273: WHERE invoice_id = l_invoice_id
274: AND ((cash_posted_flag = 'N'
275: AND l_cash_basis_flag = 'Y')
276: OR

Line 352: FROM ap_invoice_distributions_all AID,

348:
349: BEGIN
350: SELECT 'D'
351: INTO invoice_posting_flag
352: FROM ap_invoice_distributions_all AID,
353: xla_events XE
354: WHERE AID.invoice_id = l_invoice_id
355: AND AID.accounting_event_id = XE.event_id
356: AND ((AID.accrual_posted_flag = 'N' AND l_cash_basis_flag = 'N') OR

Line 596: FROM ap_invoice_distributions_all

592: select sum(l_count)
593: from
594: (
595: SELECT count(*) l_count
596: FROM ap_invoice_distributions_all
597: WHERE invoice_id = l_invoice_id
598: AND nvl(match_status_flag, 'Z') = l_status
599: UNION
600: SELECT count(*) l_count

Line 671: FROM ap_invoice_distributions_all aid

667: -- only if the count is more than 0.
668: --
669: SELECT count(*)
670: INTO match_flag_cnt
671: FROM ap_invoice_distributions_all aid
672: WHERE aid.invoice_id = l_invoice_id
673: AND aid.match_status_flag IS NOT NULL
674: AND rownum < 2;
675:

Line 742: FROM ap_invoice_distributions_all aid

738: IF match_flag_cnt > 0 THEN
739:
740: SELECT count(*)
741: INTO l_validated_cnt
742: FROM ap_invoice_distributions_all aid
743: WHERE aid.invoice_id = l_invoice_id
744: AND aid.match_status_flag = 'N'
745: AND rownum < 2;
746:

Line 775: FROM ap_invoice_distributions_all aid

771: FROM ap_invoice_lines_all ail
772: WHERE ail.invoice_id = l_invoice_id
773: AND ail.amount <>
774: ( SELECT NVL(SUM(NVL(aid.amount,0)),0)
775: FROM ap_invoice_distributions_all aid
776: WHERE aid.invoice_id = ail.invoice_id
777: AND aid.invoice_line_number = ail.line_number
778: --bugfix:4959567
779: AND ( aid.line_type_lookup_code <> 'RETAINAGE'

Line 856: FROM ap_invoice_distributions_all aid,

852: IF (encumbrance_flag = 'Y') AND (invoice_approval_flag = 'A') THEN
853:
854: SELECT NVL(SUM(nvl(aid.amount,0)), 0)
855: INTO sum_distributions
856: FROM ap_invoice_distributions_all aid,
857: ap_invoice_lines_all ail
858: WHERE ail.invoice_id = l_invoice_id
859: AND aid.invoice_id = ail.invoice_id
860: AND aid.invoice_line_number = ail.line_number

Line 1304: from ap_invoice_distributions_all /Bug 16316552/

1300: BEGIN
1301:
1302: select (0 - sum(nvl(amount,0)))
1303: into amount_withheld
1304: from ap_invoice_distributions_all /*Bug 16316552*/
1305: where invoice_id = l_invoice_id
1306: and line_type_lookup_code = 'AWT';
1307:
1308: return(amount_withheld);

Line 1583: FROM ap_invoice_distributions

1579: l_org_id FINANCIALS_SYSTEM_PARAMS_ALL.ORG_ID%TYPE;
1580:
1581: CURSOR encumbrance_flag_cursor is
1582: SELECT nvl(encumbered_flag,'N')
1583: FROM ap_invoice_distributions
1584: WHERE invoice_id = l_invoice_id;
1585:
1586: /*7388641 - Checking encumbrance for invoice having just self
1587: assessed tax distributions, not a normal distributions and

Line 2217: FROM ap_invoice_distributions_all aid,ap_invoices_all ai

2213: IS
2214: l_prepay_amount_remaining number:=0;
2215: cursor c_prepay_amount_remaining IS
2216: SELECT SUM(nvl(prepay_amount_remaining,amount))
2217: FROM ap_invoice_distributions_all aid,ap_invoices_all ai
2218: WHERE aid.invoice_id = P_invoice_id
2219: AND aid.line_type_lookup_code IN ('ITEM','TAX')
2220: AND nvl(aid.reversal_flag,'N') <> 'Y'
2221: AND ai.invoice_id = P_invoice_id

Line 2291: from ap_invoice_distributions

2287: l_packet_id number := '';
2288:
2289: cursor packet_id_cursor is
2290: select decode(count(distinct(packet_id)),1,max(packet_id),'')
2291: from ap_invoice_distributions
2292: where invoice_id = P_Invoice_Id
2293: and packet_id is not null;
2294:
2295: BEGIN

Line 2456: from ap_invoice_distributions aid

2452: l_secondary_acctg_method = 'Cash')) THEN
2453:
2454: select count(*)
2455: into l_count_prepaid_posted
2456: from ap_invoice_distributions aid
2457: where aid.posted_flag <> 'N'
2458: and aid.invoice_id = p_invoice_id
2459: and aid.line_type_lookup_code = 'PREPAY';
2460: END IF;

Line 2501: FROM ap_invoice_distributions aid1, ap_invoice_distributions aid2

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

Line 2537: FROM ap_invoice_distributions

2533: BEGIN
2534:
2535: SELECT count(invoice_distribution_id)
2536: INTO l_count_distributions
2537: FROM ap_invoice_distributions
2538: WHERE invoice_id = p_invoice_id;
2539:
2540: RETURN l_count_distributions;
2541:

Line 2576: FROM ap_invoice_distributions aid1, ap_invoice_distributions aid2

2572: BEGIN
2573:
2574: SELECT SUM(aid1.amount * -1)
2575: INTO l_prepay_amt_applied
2576: FROM ap_invoice_distributions aid1, ap_invoice_distributions aid2
2577: WHERE aid1.invoice_id = P_invoice_id
2578: AND aid1.line_type_lookup_code = 'PREPAY'
2579: AND aid1.prepay_distribution_id = aid2.invoice_distribution_id
2580: AND aid2.invoice_id = P_prepay_id;

Line 2891: FROM ap_invoice_distributions D1

2887: AND ail1.amount <> 0
2888: AND LINE_TYPE_LOOKUP_CODE not in ('TAX', 'AWT') -- bug 9582952 --bug16090813
2889: AND (EXISTS
2890: (SELECT 'UNPOSTED'
2891: FROM ap_invoice_distributions D1
2892: WHERE D1.invoice_id = ail1.invoice_id
2893: AND D1.invoice_line_number = ail1.line_number
2894: AND NVL(D1.posted_flag, 'N') = 'N') OR
2895: (NOT EXISTS

Line 2897: FROM ap_invoice_distributions D2

2893: AND D1.invoice_line_number = ail1.line_number
2894: AND NVL(D1.posted_flag, 'N') = 'N') OR
2895: (NOT EXISTS
2896: (SELECT 'X'
2897: FROM ap_invoice_distributions D2
2898: WHERE D2.invoice_id = ail1.invoice_id
2899: AND D2.invoice_line_number = ail1.line_number)))
2900: ORDER BY ail1.base_amount desc;
2901:

Line 3364: from ap_invoice_distributions

3360: BEGIN
3361:
3362: select nvl(max(distribution_line_number),0)
3363: into l_max_dist_line_num
3364: from ap_invoice_distributions
3365: where invoice_id = P_invoice_id
3366: and invoice_line_number = P_invoice_line_number;
3367:
3368: return(l_max_dist_line_num);

Line 3418: FROM ap_invoice_distributions_all aid

3414: BEGIN
3415:
3416: SELECT SUM(NVL(amount,0))
3417: INTO retained_total
3418: FROM ap_invoice_distributions_all aid
3419: WHERE aid.invoice_id = p_invoice_id
3420: AND aid.line_type_lookup_code = 'RETAINAGE'
3421: AND EXISTS
3422: (SELECT 'X' FROM ap_invoice_lines_all ail

Line 3554: from ap_invoice_distributions_all

3550: BEGIN
3551:
3552: select sum(nvl(amount,0))
3553: into prepay_app_total
3554: from ap_invoice_distributions_all
3555: where invoice_id = p_invoice_id
3556: and org_id = p_org_id
3557: and line_type_lookup_code = 'PREPAY';
3558: