APPS.OKS_IMPORT_CONTRACTS_WORKER dependencies on OKS_NOTES_INTERFACE

Line 269: OKS_NOTES_INTERFACE ONI1,

265: OKS_INT_LINE_STG_TEMP OLST,
266: OKS_INT_SALES_CREDIT_STG_TEMP OSCST,
267: OKS_INT_COVERED_LEVEL_STG_TEMP OCLST,
268: OKS_INT_USAGE_COUNTER_STG_TEMP OUCST,
269: OKS_NOTES_INTERFACE ONI1,
270: OKS_NOTES_INTERFACE ONI2
271: WHERE OHST.HEADER_INTERFACE_ID = OLST.HEADER_INTERFACE_ID (+)
272: AND OHST.HEADER_INTERFACE_ID = OSCST.HEADER_INTERFACE_ID (+)
273: AND OLST.LINE_INTERFACE_ID = OCLST.LINE_INTERFACE_ID (+)

Line 270: OKS_NOTES_INTERFACE ONI2

266: OKS_INT_SALES_CREDIT_STG_TEMP OSCST,
267: OKS_INT_COVERED_LEVEL_STG_TEMP OCLST,
268: OKS_INT_USAGE_COUNTER_STG_TEMP OUCST,
269: OKS_NOTES_INTERFACE ONI1,
270: OKS_NOTES_INTERFACE ONI2
271: WHERE OHST.HEADER_INTERFACE_ID = OLST.HEADER_INTERFACE_ID (+)
272: AND OHST.HEADER_INTERFACE_ID = OSCST.HEADER_INTERFACE_ID (+)
273: AND OLST.LINE_INTERFACE_ID = OCLST.LINE_INTERFACE_ID (+)
274: AND OLST.LINE_INTERFACE_ID = OUCST.LINE_INTERFACE_ID (+)

Line 302: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_NOTES_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) NOTES_INVALID

298: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_LINES_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) LINES_INVALID,
299: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_COVERED_LEVELS_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) COVERED_LEVELS_INVALID,
300: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_USAGE_COUNTERS_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) USAGE_COUNTERS_INVALID,
301: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_SALES_CREDITS_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) SALES_CREDITS_INVALID,
302: nvl(SUM(decode(INVALID_Q.INTERFACE_SOURCE_TABLE, 'OKS_NOTES_INTERFACE', INVALID_Q.INVALID_COUNT, 0)), 0) NOTES_INVALID
303: FROM (SELECT distinct INTERFACE_SOURCE_TABLE,
304: count(distinct INTERFACE_ID) over (partition by INTERFACE_SOURCE_TABLE) INVALID_COUNT
305: FROM OKS_INT_ERROR_STG_TEMP) INVALID_Q;
306: