eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_IMPORT_CONTRACTS_WORKER dependencies on OKS_INT_COVERED_LEVEL_STG_TEMP

Line 267: OKS_INT_COVERED_LEVEL_STG_TEMP OCLST,

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,
269: OKS_NOTES_INTERFACE ONI1,
270: OKS_NOTES_INTERFACE ONI2
271: WHERE OHST.HEADER_INTERFACE_ID = OLST.HEADER_INTERFACE_ID (+)

Line 352: DELETE FROM OKS_INT_COVERED_LEVEL_STG_TEMP;

348: DELETE FROM OKS_COVERED_PARTY_STG_TEMP;
349: DELETE FROM OKS_COVERED_ACCOUNT_STG_TEMP;
350: DELETE FROM OKS_COVERED_SITE_STG_TEMP;
351: DELETE FROM OKS_COVERED_SYSTEM_STG_TEMP;
352: DELETE FROM OKS_INT_COVERED_LEVEL_STG_TEMP;
353: DELETE FROM OKS_INT_USAGE_COUNTER_STG_TEMP;
354: DELETE FROM OKS_INT_ERROR_STG_TEMP;
355: DELETE FROM OKS_INT_SALES_CREDIT_STG_TEMP;
356: