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

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

113: | -- accrual) for the distributions. The rest is to cover one specific
114: | -- case when some of the distributions are fully posting (Y) and some
115: | -- are unposting (N). The status should be partial (P).
116: | --
117: | -- MOAC. Use ap_invoice_distributions_all table instead of SO view
118: | -- since this procedure is called when policy context is not set to
119: | -- the corresponding OU for the invoice_id
120: |
121: | MODIFICATION HISTORY

Line 140: FROM ap_invoice_distributions_all

136:
137:
138: CURSOR posting_cursor IS
139: SELECT cash_posted_flag
140: FROM ap_invoice_distributions_all
141: WHERE invoice_id = p_invoice_id
142: AND invoice_line_number = p_line_number
143: AND l_cash_basis_flag = 'Y'
144: UNION

Line 146: FROM ap_invoice_distributions_all

142: AND invoice_line_number = p_line_number
143: AND l_cash_basis_flag = 'Y'
144: UNION
145: SELECT accrual_posted_flag
146: FROM ap_invoice_distributions_all
147: WHERE invoice_id = p_invoice_id
148: AND invoice_line_number = p_line_number
149: AND l_cash_basis_flag <> 'Y'
150: UNION

Line 152: FROM ap_invoice_distributions_all

148: AND invoice_line_number = p_line_number
149: AND l_cash_basis_flag <> 'Y'
150: UNION
151: SELECT 'P'
152: FROM ap_invoice_distributions_all
153: WHERE invoice_id = p_invoice_id
154: AND invoice_line_number = p_line_number
155: AND ( (cash_posted_flag = 'Y'
156: AND l_cash_basis_flag = 'Y')

Line 162: FROM ap_invoice_distributions_all

158: (accrual_posted_flag = 'Y'
159: AND l_cash_basis_flag <> 'Y'))
160: AND EXISTS
161: (SELECT 'An N is also in the valid flags'
162: FROM ap_invoice_distributions_all
163: WHERE invoice_id = p_invoice_id
164: AND invoice_line_number = p_line_number
165: AND ((cash_posted_flag = 'N'
166: AND l_cash_basis_flag = 'Y')

Line 269: FROM ap_invoice_distributions_all

265: -- (NULL). The status should be needs reapproval (N).
266: --
267: CURSOR approval_cursor IS
268: SELECT nvl(match_status_flag, 'N')
269: FROM ap_invoice_distributions_all
270: WHERE invoice_id = p_invoice_id
271: AND invoice_line_number = p_line_number;
272:
273: BEGIN

Line 330: FROM ap_invoice_distributions_all aid

326: -- only if the count is more than 0.
327: --
328: SELECT count(*)
329: INTO match_flag_cnt
330: FROM ap_invoice_distributions_all aid
331: WHERE aid.invoice_id = p_invoice_id
332: AND aid.invoice_line_number = p_line_number
333: AND aid.match_status_flag IS NOT NULL
334: AND rownum < 2;

Line 653: ap_invoice_distributions_all AID

649:
650: SELECT count(*)
651: INTO l_rcv_dist_count
652: FROM rcv_transactions RT,
653: ap_invoice_distributions_all AID
654: WHERE RT.transaction_id = AID.rcv_transaction_id
655: AND AID.invoice_id = p_line_rec.invoice_id
656: AND AID.invoice_line_number = p_line_rec.line_number
657: AND AID.rcv_transaction_id is not null

Line 669: FROM ap_invoice_distributions_all aid1

665: nvl( AID1.corrected_quantity,0 ) +
666: nvl( AID1.quantity_invoiced,0 )
667: )
668: )
669: FROM ap_invoice_distributions_all aid1
670: WHERE aid1.invoice_id = aid.invoice_id
671: AND aid1.invoice_line_number = aid.invoice_line_number
672: AND aid1.rcv_transaction_id=aid.rcv_transaction_id
673: )

Line 677: FROM ap_invoice_distributions_all aid2

673: )
674: OR
675: NVL(rt.amount_billed,0) < (
676: SELECT SUM(NVL(AID2.amount,0))
677: FROM ap_invoice_distributions_all aid2
678: WHERE aid2.invoice_id = aid.invoice_id
679: AND aid2.invoice_line_number = aid.invoice_line_number
680: AND aid2.rcv_transaction_id=aid.rcv_transaction_id
681: )

Line 1146: debug_info := 'Select from ap_invoice_distributions_all';

1142: current_calling_sequence :=
1143: 'AP_INVOICE_LINES_UTILITY_PKG.IS_LINE_DISTS_TRANS_FA<-'
1144: ||p_Calling_Sequence;
1145:
1146: debug_info := 'Select from ap_invoice_distributions_all';
1147:
1148: Select count(*)
1149: Into dummy
1150: From ap_invoice_distributions_all

Line 1150: From ap_invoice_distributions_all

1146: debug_info := 'Select from ap_invoice_distributions_all';
1147:
1148: Select count(*)
1149: Into dummy
1150: From ap_invoice_distributions_all
1151: Where invoice_id = p_Invoice_Id
1152: And invoice_line_number = p_Line_Number
1153: And assets_addition_flag = 'Y';
1154:

Line 1203: debug_info := 'Select from ap_invoice_distributions_all';

1199: current_calling_sequence :=
1200: 'AP_INVOICE_LINES_UTILITY_PKG.LINE_DISTS_ACCT_EVENT_CREATED<-'
1201: ||p_Calling_Sequence;
1202:
1203: debug_info := 'Select from ap_invoice_distributions_all';
1204:
1205: Select count(*)
1206: Into dummy
1207: From ap_invoice_distributions_all

Line 1207: From ap_invoice_distributions_all

1203: debug_info := 'Select from ap_invoice_distributions_all';
1204:
1205: Select count(*)
1206: Into dummy
1207: From ap_invoice_distributions_all
1208: Where invoice_id = p_Invoice_Id
1209: And invoice_line_number = p_Line_Number
1210: And accounting_event_id Is Not Null;
1211:

Line 1322: From ap_invoice_distributions_all AID

1318: debug_info := 'Select from ap_invoic_distributions_all';
1319:
1320: Select count(*)
1321: Into dummy
1322: From ap_invoice_distributions_all AID
1323: Where NVL(AID.cancellation_flag, 'N') <> 'Y'
1324: And NVL(AID.reversal_flag, 'N') <> 'Y'
1325: And AID.invoice_id = p_invoice_id
1326: And AID.invoice_line_number <> p_line_number

Line 1330: From ap_invoice_distributions_all AID2

1326: And AID.invoice_line_number <> p_line_number
1327: And AID.charge_applicable_to_dist_id IS NOT NULL
1328: And AID.charge_applicable_to_dist_id In
1329: (Select AID2.invoice_distribution_id
1330: From ap_invoice_distributions_all AID2
1331: Where AID2.invoice_id = p_Invoice_Id
1332: And AID2.invoice_line_number = p_Line_Number
1333: And NVL(AID2.cancellation_flag, 'N') <> 'Y'
1334: And NVL(AID2.reversal_flag, 'N') <> 'Y' );

Line 1447: From ap_invoice_distributions_all

1443: debug_info := 'Select from ap_invoic_distributions_all';
1444:
1445: Select count(*)
1446: Into dummy
1447: From ap_invoice_distributions_all
1448: Where invoice_id = p_Invoice_Id
1449: And invoice_line_number = p_Line_Number
1450: And pa_addition_flag In ('T', 'Y', 'Z') ;
1451:

Line 2200: l_awt_flag ap_invoice_distributions_all.awt_flag%TYPE;

2196: p_invoice_id IN NUMBER,
2197: p_line_number IN NUMBER )
2198: RETURN VARCHAR2
2199: IS
2200: l_awt_flag ap_invoice_distributions_all.awt_flag%TYPE;
2201:
2202: BEGIN
2203:
2204: SELECT awt_flag

Line 2206: FROM ap_invoice_distributions_all

2202: BEGIN
2203:
2204: SELECT awt_flag
2205: INTO l_awt_flag
2206: FROM ap_invoice_distributions_all
2207: WHERE invoice_id = p_invoice_id
2208: AND invoice_line_number = p_line_number
2209: AND rownum = 1;
2210: