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 10966: FROM cm_scst_led a,

10962: AND a.whse_code = b.whse_code
10963: UNION
10964: SELECT a.item_id,
10965: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
10966: FROM cm_scst_led a,
10967: ic_whse_mst b
10968: WHERE a.item_id IS NOT NULL
10969: AND a.whse_code = b.whse_code
10970: UNION

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

12616: WHERE (period_id IS NULL AND calendar_code IS NOT NULL AND period_code IS NOT NULL)
12617: GROUP BY calendar_code, period_code
12618: HAVING count(*) > 0
12619: ) gl_item_cst';
12620: l_cm_scst_led VARCHAR2(32000) := 'SELECT ''CM_SCST_LED'' table_name,
12621: cm_scst_led.*
12622: FROM (
12623: SELECT ''ORGANIZATION_ID'' column_name,
12624: ''Warehouse Code: ''|| whse_code parameters,

Line 12621: cm_scst_led.*

12617: GROUP BY calendar_code, period_code
12618: HAVING count(*) > 0
12619: ) gl_item_cst';
12620: l_cm_scst_led VARCHAR2(32000) := 'SELECT ''CM_SCST_LED'' table_name,
12621: cm_scst_led.*
12622: FROM (
12623: SELECT ''ORGANIZATION_ID'' column_name,
12624: ''Warehouse Code: ''|| whse_code parameters,
12625: count(*) records

Line 12626: FROM cm_scst_led

12622: FROM (
12623: SELECT ''ORGANIZATION_ID'' column_name,
12624: ''Warehouse Code: ''|| whse_code parameters,
12625: count(*) records
12626: FROM cm_scst_led
12627: WHERE (organization_id IS NULL AND whse_code IS NOT NULL)
12628: GROUP BY whse_code
12629: HAVING count(*) > 0
12630: UNION

Line 12634: FROM cm_scst_led a, ic_item_mst b

12630: UNION
12631: SELECT ''INVENTORY_ITEM_ID'' column_name,
12632: ''Item No: ''|| b.item_no parameters,
12633: count(*) records
12634: FROM cm_scst_led a, ic_item_mst b
12635: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12636: AND b.item_id = a.item_id
12637: GROUP BY b.item_no
12638: HAVING count(*) > 0

Line 12643: FROM cm_scst_led

12639: UNION
12640: SELECT ''FORM_PROD_UOM'' column_name,
12641: ''Formula UM: ''|| form_prod_um parameters,
12642: count(*) records
12643: FROM cm_scst_led
12644: WHERE (form_prod_uom IS NULL AND form_prod_um IS NOT NULL)
12645: GROUP BY form_prod_um
12646: HAVING count(*) > 0
12647: UNION

Line 12651: FROM cm_scst_led

12647: UNION
12648: SELECT ''ITEM_FMQTY_UOM'' column_name,
12649: ''Item UOM: ''|| item_fmqty_um parameters,
12650: count(*) records
12651: FROM cm_scst_led
12652: WHERE (item_fmqty_uom IS NULL AND item_fmqty_um IS NOT NULL)
12653: GROUP BY item_fmqty_um
12654: HAVING count(*) > 0
12655: UNION

Line 12659: FROM cm_scst_led

12655: UNION
12656: SELECT ''USAGE_UOM'' column_name,
12657: ''Usage UOM: ''|| usage_um parameters,
12658: count(*) records
12659: FROM cm_scst_led
12660: WHERE (usage_uom IS NULL AND usage_um IS NOT NULL)
12661: GROUP BY usage_um
12662: HAVING count(*) > 0
12663: ) cm_scst_led';

Line 12663: ) cm_scst_led';

12659: FROM cm_scst_led
12660: WHERE (usage_uom IS NULL AND usage_um IS NOT NULL)
12661: GROUP BY usage_um
12662: HAVING count(*) > 0
12663: ) cm_scst_led';
12664: l_cm_acst_led VARCHAR2(32000) := 'SELECT ''CM_ACST_LED'' table_name,
12665: cm_acst_led.*
12666: FROM (
12667: SELECT ''ORGANIZATION_ID'' column_name,

Line 13527: * Migration Error Logging for table CM_SCST_LED *

13523: FROM gl_item_cst;
13524: END IF;
13525: END IF;
13526: /************************************************
13527: * Migration Error Logging for table CM_SCST_LED *
13528: ************************************************/
13529: IF l_table_name IN ('CM_SCST_LED') THEN
13530: IF p_log_level = 1 THEN
13531: l_sql_statement := l_sql_statement

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

13525: END IF;
13526: /************************************************
13527: * Migration Error Logging for table CM_SCST_LED *
13528: ************************************************/
13529: IF l_table_name IN ('CM_SCST_LED') THEN
13530: IF p_log_level = 1 THEN
13531: l_sql_statement := l_sql_statement
13532: ||
13533: '( (organization_id IS NULL AND whse_code IS NOT NULL)

Line 13555: FROM cm_scst_led;

13551: l_inventory_item_count,
13552: l_uom_count1,
13553: l_uom_count2,
13554: l_uom_count3
13555: FROM cm_scst_led;
13556: END IF;
13557: END IF;
13558: /************************************************
13559: * Migration Error Logging for table CM_ACST_LED *

Line 13994: ELSIF l_table_name = 'CM_SCST_LED' THEN

13990: ELSIF l_table_name = 'GL_ITEM_CST' THEN
13991: OPEN cur_gmf_log_errors FOR l_gl_item_cst;
13992: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13993: CLOSE cur_gmf_log_errors;
13994: ELSIF l_table_name = 'CM_SCST_LED' THEN
13995: OPEN cur_gmf_log_errors FOR l_cm_scst_led;
13996: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13997: CLOSE cur_gmf_log_errors;
13998: ELSIF l_table_name = 'CM_ACST_LED' THEN

Line 13995: OPEN cur_gmf_log_errors FOR l_cm_scst_led;

13991: OPEN cur_gmf_log_errors FOR l_gl_item_cst;
13992: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13993: CLOSE cur_gmf_log_errors;
13994: ELSIF l_table_name = 'CM_SCST_LED' THEN
13995: OPEN cur_gmf_log_errors FOR l_cm_scst_led;
13996: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13997: CLOSE cur_gmf_log_errors;
13998: ELSIF l_table_name = 'CM_ACST_LED' THEN
13999: OPEN cur_gmf_log_errors FOR l_cm_acst_led;