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_ACST_LED

Line 10608: FROM cm_acst_led a,

10604: FROM
10605: (
10606: SELECT a.item_id,
10607: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
10608: FROM cm_acst_led a,
10609: ic_whse_mst b
10610: WHERE a.item_id IS NOT NULL
10611: AND a.whse_code = b.whse_code
10612: UNION

Line 12333: l_cm_acst_led VARCHAR2(32000) := 'SELECT ''CM_ACST_LED'' table_name,

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,
12337: ''Warehouse Code: ''|| whse_code parameters,

Line 12334: cm_acst_led.*

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,
12337: ''Warehouse Code: ''|| whse_code parameters,
12338: count(*) records

Line 12339: FROM cm_acst_led

12335: FROM (
12336: SELECT ''ORGANIZATION_ID'' column_name,
12337: ''Warehouse Code: ''|| whse_code parameters,
12338: count(*) records
12339: FROM cm_acst_led
12340: WHERE (organization_id IS NULL AND whse_code IS NOT NULL)
12341: GROUP BY whse_code
12342: HAVING count(*) > 0
12343: UNION

Line 12347: FROM cm_acst_led a, ic_item_mst b

12343: UNION
12344: SELECT ''INVENTORY_ITEM_ID'' column_name,
12345: ''Item No: ''|| b.item_no parameters,
12346: count(*) records
12347: FROM cm_acst_led a, ic_item_mst b
12348: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12349: AND b.item_id = a.item_id
12350: GROUP BY b.item_no
12351: HAVING count(*) > 0

Line 12356: FROM cm_acst_led

12352: UNION
12353: SELECT ''COST_TYPE_ID'' column_name,
12354: ''Cost Method Code: ''|| cost_mthd_code parameters,
12355: count(*) records
12356: FROM cm_acst_led
12357: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12358: GROUP BY cost_mthd_code
12359: HAVING count(*) > 0
12360: UNION

Line 12364: FROM cm_acst_led

12360: UNION
12361: SELECT ''PERIOD_ID'' column_name,
12362: ''Calendar Code: ''|| calendar_code ||'', Period Code: ''|| period_code parameters,
12363: count(*) records
12364: FROM cm_acst_led
12365: WHERE (period_id IS NULL AND calendar_code IS NOT NULL AND period_code IS NOT NULL)
12366: GROUP BY calendar_code, period_code
12367: HAVING count(*) > 0
12368: ) cm_acst_led';

Line 12368: ) cm_acst_led';

12364: FROM cm_acst_led
12365: WHERE (period_id IS NULL AND calendar_code IS NOT NULL AND period_code IS NOT NULL)
12366: GROUP BY calendar_code, period_code
12367: HAVING count(*) > 0
12368: ) cm_acst_led';
12369: l_gmf_lot_costs VARCHAR2(32000) := 'SELECT ''GMF_LOT_COSTS'' table_name,
12370: gmf_lot_costs.*
12371: FROM (
12372: SELECT ''ORGANIZATION_ID'' column_name,

Line 13228: * Migration Error Logging for table CM_ACST_LED *

13224: FROM cm_scst_led;
13225: END IF;
13226: END IF;
13227: /************************************************
13228: * Migration Error Logging for table CM_ACST_LED *
13229: ************************************************/
13230: IF l_table_name IN ('CM_ACST_LED') THEN
13231: IF p_log_level = 1 THEN
13232: l_sql_statement := l_sql_statement

Line 13230: IF l_table_name IN ('CM_ACST_LED') THEN

13226: END IF;
13227: /************************************************
13228: * Migration Error Logging for table CM_ACST_LED *
13229: ************************************************/
13230: IF l_table_name IN ('CM_ACST_LED') THEN
13231: IF p_log_level = 1 THEN
13232: l_sql_statement := l_sql_statement
13233: ||
13234: '( (organization_id IS NULL AND whse_code IS NOT NULL)

Line 13253: FROM cm_acst_led;

13249: INTO l_organization_count,
13250: l_inventory_item_count,
13251: l_cost_type_count,
13252: l_period_count
13253: FROM cm_acst_led;
13254: END IF;
13255: END IF;
13256: /************************************************
13257: * Migration Error Logging for table XLA_RULES_T *

Line 13667: ELSIF l_table_name = 'CM_ACST_LED' THEN

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;
13669: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13670: CLOSE cur_gmf_log_errors;
13671: ELSIF l_table_name = 'XLA_RULES_T' THEN

Line 13668: OPEN cur_gmf_log_errors FOR l_cm_acst_led;

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;
13669: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13670: CLOSE cur_gmf_log_errors;
13671: ELSIF l_table_name = 'XLA_RULES_T' THEN
13672: OPEN cur_gmf_log_errors FOR l_xla_rules_t;