DBA Data[Home] [Help]

APPS.AP_TE_EIS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 16: AP_INVOICE_DISTRIBUTIONS d

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
20: and d.accounting_date <= P_End_Date;

Line 139: AP_INVOICE_DISTRIBUTIONS D

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'
143: and I.source in ('XpenseXpress', 'Manual Invoice Entry')

Line 165: AP_INVOICE_DISTRIBUTIONS D

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
169: and D.accounting_date >= P_Start_Date

Line 189: AP_INVOICE_DISTRIBUTIONS D

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'
193: and D.accounting_date >= P_Start_Date