DBA Data[Home] [Help]

APPS.OKL_RELEASE_PVT dependencies on OKL_CNSLD_AR_HDRS_B

Line 2594: OKL_CNSLD_AR_HDRS_B HD,

2590: SELECT INVOICE_DATE FROM( SELECT MAX(HD.DATE_CONSOLIDATED) INVOICE_DATE
2591: FROM AR_PAYMENT_SCHEDULES_ALL PS,
2592: OKL_CNSLD_AR_STRMS_B ST,
2593: OKL_CNSLD_AR_LINES_B LN,
2594: OKL_CNSLD_AR_HDRS_B HD,
2595: OKC_K_HEADERS_B CN
2596: WHERE PS.CLASS = 'INV'
2597: AND ST.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID
2598: AND LN.ID = ST.LLN_ID