DBA Data[Home] [Help]

APPS.OKS_IMPORT_INSERT dependencies on HZ_CUST_SITE_USES_ALL

Line 1566: ,HZ_CUST_SITE_USES_ALL CSTSITE

1562:
1563: FROM OKS_INT_LINE_STG_TEMP OLSTG
1564: ,OKS_INT_HEADER_STG_TEMP OHSTG
1565: ,OKC_K_HEADERS_ALL_B OKCHDRB
1566: ,HZ_CUST_SITE_USES_ALL CSTSITE
1567: ,HZ_CUST_ACCT_SITES_ALL CSTACCT
1568: ,(SELECT trunc(MONTHS_BETWEEN(LINSTG.END_DATE, LINSTG.START_DATE)/12) NYEARS, LINE_INTERFACE_ID
1569: FROM OKS_INT_LINE_STG_TEMP LINSTG
1570: WHERE LINSTG.LSE_ID in (1,12,14,19,46,7,8,9,10,11,13,18,25,35)) INNER_Q