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_ALL

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 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 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: