DBA Data[Home] [Help]

APPS.JL_JLCOPCWT_XMLP_PKG dependencies on AP_INVOICES_ALL

Line 263: AP_INVOICES_ALL AI,

259: AP_TAX_CODES_ALL ATC,
260: JL_ZZ_AP_SUP_AWT_CD_ALL JZSAC,
261: JL_ZZ_AP_INV_DIS_WH_ALL JZIDW,
262: AP_TAX_CODES_ALL ATC2,
263: AP_INVOICES_ALL AI,
264: AP_INVOICE_DISTRIBUTIONS_ALL AID
265: WHERE AI.LEGAL_ENTITY_ID = DECODE(P_REPORTING_LEVEL
266: ,'2000'
267: ,P_REPORTING_CONTEXT

Line 315: AP_INVOICES_ALL AI,

311: AP_TAX_CODES_ALL ATC,
312: JL_ZZ_AP_SUP_AWT_CD_ALL JZSAC,
313: JL_ZZ_AP_INV_DIS_WH_ALL JZIDW,
314: AP_TAX_CODES_ALL ATC2,
315: AP_INVOICES_ALL AI,
316: AP_INVOICE_DISTRIBUTIONS_ALL AID
317: WHERE '0' NOT IN (
318: SELECT
319: P_ORGS

Line 321: AP_INVOICES_ALL INV

317: WHERE '0' NOT IN (
318: SELECT
319: P_ORGS
320: FROM
321: AP_INVOICES_ALL INV
322: WHERE AI.INVOICE_ID = INV.INVOICE_ID )
323: AND AID.ACCOUNTING_DATE >= NVL(TO_DATE(P_DATE_FROM
324: ,'RRRR/MM/DD HH24:MI:SS')
325: ,AID.ACCOUNTING_DATE)