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_LINE_STG_TEMP

Line 265: OKS_INT_LINE_STG_TEMP OLST,

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,
269: OKS_NOTES_INTERFACE ONI1,

Line 345: DELETE FROM OKS_INT_LINE_STG_TEMP;

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;
349: DELETE FROM OKS_COVERED_ACCOUNT_STG_TEMP;