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.GMF_MIGRATION dependencies on CM_SCST_LED

Line 10636: FROM cm_scst_led a,

10632: AND a.whse_code = b.whse_code
10633: UNION
10634: SELECT a.item_id,
10635: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
10636: FROM cm_scst_led a,
10637: ic_whse_mst b
10638: WHERE a.item_id IS NOT NULL
10639: AND a.whse_code = b.whse_code
10640: UNION

Line 12289: l_cm_scst_led VARCHAR2(32000) := 'SELECT ''CM_SCST_LED'' table_name,

12285: WHERE (period_id IS NULL AND calendar_code IS NOT NULL AND period_code IS NOT NULL)
12286: GROUP BY calendar_code, period_code
12287: HAVING count(*) > 0
12288: ) gl_item_cst';
12289: l_cm_scst_led VARCHAR2(32000) := 'SELECT ''CM_SCST_LED'' table_name,
12290: cm_scst_led.*
12291: FROM (
12292: SELECT ''ORGANIZATION_ID'' column_name,
12293: ''Warehouse Code: ''|| whse_code parameters,

Line 12290: cm_scst_led.*

12286: GROUP BY calendar_code, period_code
12287: HAVING count(*) > 0
12288: ) gl_item_cst';
12289: l_cm_scst_led VARCHAR2(32000) := 'SELECT ''CM_SCST_LED'' table_name,
12290: cm_scst_led.*
12291: FROM (
12292: SELECT ''ORGANIZATION_ID'' column_name,
12293: ''Warehouse Code: ''|| whse_code parameters,
12294: count(*) records

Line 12295: FROM cm_scst_led

12291: FROM (
12292: SELECT ''ORGANIZATION_ID'' column_name,
12293: ''Warehouse Code: ''|| whse_code parameters,
12294: count(*) records
12295: FROM cm_scst_led
12296: WHERE (organization_id IS NULL AND whse_code IS NOT NULL)
12297: GROUP BY whse_code
12298: HAVING count(*) > 0
12299: UNION

Line 12303: FROM cm_scst_led a, ic_item_mst b

12299: UNION
12300: SELECT ''INVENTORY_ITEM_ID'' column_name,
12301: ''Item No: ''|| b.item_no parameters,
12302: count(*) records
12303: FROM cm_scst_led a, ic_item_mst b
12304: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12305: AND b.item_id = a.item_id
12306: GROUP BY b.item_no
12307: HAVING count(*) > 0

Line 12312: FROM cm_scst_led

12308: UNION
12309: SELECT ''FORM_PROD_UOM'' column_name,
12310: ''Formula UM: ''|| form_prod_um parameters,
12311: count(*) records
12312: FROM cm_scst_led
12313: WHERE (form_prod_uom IS NULL AND form_prod_um IS NOT NULL)
12314: GROUP BY form_prod_um
12315: HAVING count(*) > 0
12316: UNION

Line 12320: FROM cm_scst_led

12316: UNION
12317: SELECT ''ITEM_FMQTY_UOM'' column_name,
12318: ''Item UOM: ''|| item_fmqty_um parameters,
12319: count(*) records
12320: FROM cm_scst_led
12321: WHERE (item_fmqty_uom IS NULL AND item_fmqty_um IS NOT NULL)
12322: GROUP BY item_fmqty_um
12323: HAVING count(*) > 0
12324: UNION

Line 12328: FROM cm_scst_led

12324: UNION
12325: SELECT ''USAGE_UOM'' column_name,
12326: ''Usage UOM: ''|| usage_um parameters,
12327: count(*) records
12328: FROM cm_scst_led
12329: WHERE (usage_uom IS NULL AND usage_um IS NOT NULL)
12330: GROUP BY usage_um
12331: HAVING count(*) > 0
12332: ) cm_scst_led';

Line 12332: ) cm_scst_led';

12328: FROM cm_scst_led
12329: WHERE (usage_uom IS NULL AND usage_um IS NOT NULL)
12330: GROUP BY usage_um
12331: HAVING count(*) > 0
12332: ) cm_scst_led';
12333: l_cm_acst_led VARCHAR2(32000) := 'SELECT ''CM_ACST_LED'' table_name,
12334: cm_acst_led.*
12335: FROM (
12336: SELECT ''ORGANIZATION_ID'' column_name,

Line 13196: * Migration Error Logging for table CM_SCST_LED *

13192: FROM gl_item_cst;
13193: END IF;
13194: END IF;
13195: /************************************************
13196: * Migration Error Logging for table CM_SCST_LED *
13197: ************************************************/
13198: IF l_table_name IN ('CM_SCST_LED') THEN
13199: IF p_log_level = 1 THEN
13200: l_sql_statement := l_sql_statement

Line 13198: IF l_table_name IN ('CM_SCST_LED') THEN

13194: END IF;
13195: /************************************************
13196: * Migration Error Logging for table CM_SCST_LED *
13197: ************************************************/
13198: IF l_table_name IN ('CM_SCST_LED') THEN
13199: IF p_log_level = 1 THEN
13200: l_sql_statement := l_sql_statement
13201: ||
13202: '( (organization_id IS NULL AND whse_code IS NOT NULL)

Line 13224: FROM cm_scst_led;

13220: l_inventory_item_count,
13221: l_uom_count1,
13222: l_uom_count2,
13223: l_uom_count3
13224: FROM cm_scst_led;
13225: END IF;
13226: END IF;
13227: /************************************************
13228: * Migration Error Logging for table CM_ACST_LED *

Line 13663: ELSIF l_table_name = 'CM_SCST_LED' THEN

13659: ELSIF l_table_name = 'GL_ITEM_CST' THEN
13660: OPEN cur_gmf_log_errors FOR l_gl_item_cst;
13661: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13662: CLOSE cur_gmf_log_errors;
13663: ELSIF l_table_name = 'CM_SCST_LED' THEN
13664: OPEN cur_gmf_log_errors FOR l_cm_scst_led;
13665: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13666: CLOSE cur_gmf_log_errors;
13667: ELSIF l_table_name = 'CM_ACST_LED' THEN

Line 13664: OPEN cur_gmf_log_errors FOR l_cm_scst_led;

13660: OPEN cur_gmf_log_errors FOR l_gl_item_cst;
13661: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13662: CLOSE cur_gmf_log_errors;
13663: ELSIF l_table_name = 'CM_SCST_LED' THEN
13664: OPEN cur_gmf_log_errors FOR l_cm_scst_led;
13665: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13666: CLOSE cur_gmf_log_errors;
13667: ELSIF l_table_name = 'CM_ACST_LED' THEN
13668: OPEN cur_gmf_log_errors FOR l_cm_acst_led;