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_TE_EIS_PKG dependencies on AP_INVOICES

Line 15: from AP_INVOICES i,

11: BEGIN
12:
13: select nvl(SUM(d.amount),0)
14: into P_Result
15: from AP_INVOICES i,
16: AP_INVOICE_DISTRIBUTIONS d
17: where i.invoice_id = d.invoice_id
18: and i.invoice_type_lookup_code = 'EXPENSE REPORT'
19: and d.accounting_date >= P_Start_Date

Line 65: AP_INVOICES i

61: BEGIN
62: select SUM(P.amount)
63: into P_Result
64: from AP_INVOICE_PAYMENTS p,
65: AP_INVOICES i
66: where p.invoice_id = i.invoice_id
67: and p.set_of_books_id = P_Set_Of_Books_ID
68: and i.invoice_type_lookup_code = 'EXPENSE REPORT'
69: and p.accounting_date >= P_Start_Date

Line 90: AP_INVOICES i

86: BEGIN
87: select COUNT(p.invoice_payment_id)
88: into P_Result
89: from AP_INVOICE_PAYMENTS p,
90: AP_INVOICES i
91: where p.invoice_id = i.invoice_id
92: and p.set_of_books_id = P_Set_Of_Books_ID
93: and i.invoice_type_lookup_code = 'EXPENSE REPORT'
94: and p.accounting_date >= P_Start_Date

Line 113: AP_INVOICES i

109: BEGIN
110: select AVG(p.amount)
111: into P_Result
112: from AP_INVOICE_PAYMENTS p,
113: AP_INVOICES i
114: where p.invoice_id = i.invoice_id
115: and p.set_of_books_id = P_Set_Of_Books_ID
116: and i.invoice_type_lookup_code = 'EXPENSE REPORT'
117: and p.accounting_date >= P_Start_Date

Line 138: from AP_INVOICES I,

134: BEGIN
135:
136: select COUNT(DISTINCT(I.invoice_id))
137: into P_Result
138: from AP_INVOICES I,
139: AP_INVOICE_DISTRIBUTIONS D
140: where I.invoice_id = D.invoice_id
141: and D.Set_Of_Books_Id = P_Set_Of_Books_Id
142: and I.invoice_type_lookup_code = 'EXPENSE REPORT'

Line 164: from AP_INVOICES I,

160: BEGIN
161:
162: select COUNT(DISTINCT(I.invoice_id))
163: into P_Result
164: from AP_INVOICES I,
165: AP_INVOICE_DISTRIBUTIONS D
166: where I.invoice_id = D.invoice_id
167: and I.source = 'Oracle Project Accounting'
168: and D.set_of_books_id = P_Set_Of_Books_Id

Line 188: from AP_INVOICES I,

184: BEGIN
185:
186: select COUNT(DISTINCT(I.invoice_id))
187: into P_Result
188: from AP_INVOICES I,
189: AP_INVOICE_DISTRIBUTIONS D
190: where I.invoice_id = D.invoice_id
191: and D.Set_Of_Books_Id = P_Set_Of_Books_Id
192: and I.source = 'SelfService'