APPS.OKS_IMPORT_CONTRACTS_WORKER dependencies on OKS_INT_HEADER_STG_TEMP

Line 61: UPDATE OKS_INT_HEADER_STG_TEMP hst

57: END IF;
58:
59: l_stmt_num := 10;
60:
61: UPDATE OKS_INT_HEADER_STG_TEMP hst
62: SET hst.INTERFACE_STATUS = (CASE WHEN EXISTS (SELECT 'X' FROM OKS_INT_ERROR_STG_TEMP
63: WHERE hst.HEADER_INTERFACE_ROWID = HEADER_INTERFACE_ROWID)
64: THEN 'E'
65: ELSE 'S'

Line 264: FROM OKS_INT_HEADER_STG_TEMP OHST,

260: count(distinct OUCST.rowid) over (partition by OHST.INTERFACE_STATUS) USAGE_COUNTERS_COUNT,
261: count(distinct OSCST.rowid) over (partition by OHST.INTERFACE_STATUS) SALES_CREDITS_COUNT,
262: count(distinct ONI1.rowid) over (partition by OHST.INTERFACE_STATUS) NOTES1_COUNT,
263: count(distinct ONI2.rowid) over (partition by OHST.INTERFACE_STATUS) NOTES2_COUNT
264: FROM OKS_INT_HEADER_STG_TEMP OHST,
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,

Line 344: DELETE FROM OKS_INT_HEADER_STG_TEMP;

340:
341: l_stmt_num := 10;
342:
343: /* Replace with TRUNCATE statement */
344: DELETE FROM OKS_INT_HEADER_STG_TEMP;
345: DELETE FROM OKS_INT_LINE_STG_TEMP;
346: DELETE FROM OKS_COVERED_INSTANCE_STG_TEMP;
347: DELETE FROM OKS_COVERED_ITEM_STG_TEMP;
348: DELETE FROM OKS_COVERED_PARTY_STG_TEMP;