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_VALIDATE dependencies on OKS_INT_USAGE_COUNTER_STG_TEMP

Line 4647: INTO OKS_INT_USAGE_COUNTER_STG_TEMP

4643:
4644: l_stmt_num := 10;
4645: INSERT ALL
4646: WHEN (1=1) THEN
4647: INTO OKS_INT_USAGE_COUNTER_STG_TEMP
4648: (USAGE_COUNTER_INTERFACE_ID
4649: ,LINE_INTERFACE_ID
4650: ,HEADER_INTERFACE_ROWID
4651: ,LINE_INTERFACE_ROWID

Line 5140: SELECT count(1) INTO l_int_count FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUCI

5136:
5137:
5138: IF G_STMT_LOG THEN
5139:
5140: SELECT count(1) INTO l_int_count FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUCI
5141: WHERE EXISTS (SELECT 'X' FROM OKS_INT_LINE_STG_TEMP
5142: WHERE LINE_INTERFACE_ID = OUCI.LINE_INTERFACE_ID);
5143:
5144: SELECT count(1) INTO l_stg_count FROM OKS_INT_USAGE_COUNTER_STG_TEMP;

Line 5144: SELECT count(1) INTO l_stg_count FROM OKS_INT_USAGE_COUNTER_STG_TEMP;

5140: SELECT count(1) INTO l_int_count FROM OKS_INT_USAGE_COUNTER_STG_TEMP OUCI
5141: WHERE EXISTS (SELECT 'X' FROM OKS_INT_LINE_STG_TEMP
5142: WHERE LINE_INTERFACE_ID = OUCI.LINE_INTERFACE_ID);
5143:
5144: SELECT count(1) INTO l_stg_count FROM OKS_INT_USAGE_COUNTER_STG_TEMP;
5145: /* to avoid gscc failure */
5146: IF G_STMT_LOG THEN
5147: fnd_log.string(fnd_log.level_statement,
5148: G_MODULE_HEAD || l_routine || '.' ||l_stmt_num,