DBA Data[Home] [Help]

APPS.JL_JLCOPWHR_XMLP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 60: AP_INVOICE_DISTRIBUTIONS AID

56: JL_ZZ_AP_SUP_AWT_CD JZSAC,
57: JL_ZZ_AP_INV_DIS_WH JZIDW,
58: AP_TAX_CODES ATC2,
59: AP_INVOICES AI,
60: AP_INVOICE_DISTRIBUTIONS AID
61: WHERE AID.ACCOUNTING_DATE BETWEEN P_ACCOUNTING_DATE_FROM
62: AND P_ACCOUNTING_DATE_TO
63: AND AID.MATCH_STATUS_FLAG = 'A'
64: AND AID.LINE_TYPE_LOOKUP_CODE <> 'AWT'

Line 86: AP_INVOICE_DISTRIBUTIONS AID2

82: AND exists (
83: SELECT
84: 1
85: FROM
86: AP_INVOICE_DISTRIBUTIONS AID2
87: WHERE AID2.INVOICE_ID = AID.INVOICE_ID
88: AND AID2.MATCH_STATUS_FLAG = 'A'
89: AND AID2.LINE_TYPE_LOOKUP_CODE = 'AWT'
90: AND AID2.TAX_CODE_ID = ATC.TAX_ID