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 10938: FROM cm_acst_led a,

10934: FROM
10935: (
10936: SELECT a.item_id,
10937: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
10938: FROM cm_acst_led a,
10939: ic_whse_mst b
10940: WHERE a.item_id IS NOT NULL
10941: AND a.whse_code = b.whse_code
10942: UNION

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

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

Line 12665: cm_acst_led.*

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

Line 12670: FROM cm_acst_led

12666: FROM (
12667: SELECT ''ORGANIZATION_ID'' column_name,
12668: ''Warehouse Code: ''|| whse_code parameters,
12669: count(*) records
12670: FROM cm_acst_led
12671: WHERE (organization_id IS NULL AND whse_code IS NOT NULL)
12672: GROUP BY whse_code
12673: HAVING count(*) > 0
12674: UNION

Line 12678: FROM cm_acst_led a, ic_item_mst b

12674: UNION
12675: SELECT ''INVENTORY_ITEM_ID'' column_name,
12676: ''Item No: ''|| b.item_no parameters,
12677: count(*) records
12678: FROM cm_acst_led a, ic_item_mst b
12679: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12680: AND b.item_id = a.item_id
12681: GROUP BY b.item_no
12682: HAVING count(*) > 0

Line 12687: FROM cm_acst_led

12683: UNION
12684: SELECT ''COST_TYPE_ID'' column_name,
12685: ''Cost Method Code: ''|| cost_mthd_code parameters,
12686: count(*) records
12687: FROM cm_acst_led
12688: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12689: GROUP BY cost_mthd_code
12690: HAVING count(*) > 0
12691: UNION

Line 12695: FROM cm_acst_led

12691: UNION
12692: SELECT ''PERIOD_ID'' column_name,
12693: ''Calendar Code: ''|| calendar_code ||'', Period Code: ''|| period_code parameters,
12694: count(*) records
12695: FROM cm_acst_led
12696: WHERE (period_id IS NULL AND calendar_code IS NOT NULL AND period_code IS NOT NULL)
12697: GROUP BY calendar_code, period_code
12698: HAVING count(*) > 0
12699: ) cm_acst_led';

Line 12699: ) cm_acst_led';

12695: FROM cm_acst_led
12696: WHERE (period_id IS NULL AND calendar_code IS NOT NULL AND period_code IS NOT NULL)
12697: GROUP BY calendar_code, period_code
12698: HAVING count(*) > 0
12699: ) cm_acst_led';
12700: l_gmf_lot_costs VARCHAR2(32000) := 'SELECT ''GMF_LOT_COSTS'' table_name,
12701: gmf_lot_costs.*
12702: FROM (
12703: SELECT ''ORGANIZATION_ID'' column_name,

Line 13559: * Migration Error Logging for table CM_ACST_LED *

13555: FROM cm_scst_led;
13556: END IF;
13557: END IF;
13558: /************************************************
13559: * Migration Error Logging for table CM_ACST_LED *
13560: ************************************************/
13561: IF l_table_name IN ('CM_ACST_LED') THEN
13562: IF p_log_level = 1 THEN
13563: l_sql_statement := l_sql_statement

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

13557: END IF;
13558: /************************************************
13559: * Migration Error Logging for table CM_ACST_LED *
13560: ************************************************/
13561: IF l_table_name IN ('CM_ACST_LED') THEN
13562: IF p_log_level = 1 THEN
13563: l_sql_statement := l_sql_statement
13564: ||
13565: '( (organization_id IS NULL AND whse_code IS NOT NULL)

Line 13584: FROM cm_acst_led;

13580: INTO l_organization_count,
13581: l_inventory_item_count,
13582: l_cost_type_count,
13583: l_period_count
13584: FROM cm_acst_led;
13585: END IF;
13586: END IF;
13587: /************************************************
13588: * Migration Error Logging for table XLA_RULES_T *

Line 13998: ELSIF l_table_name = 'CM_ACST_LED' THEN

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;
14000: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14001: CLOSE cur_gmf_log_errors;
14002: ELSIF l_table_name = 'XLA_RULES_T' THEN

Line 13999: OPEN cur_gmf_log_errors FOR l_cm_acst_led;

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;
14000: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
14001: CLOSE cur_gmf_log_errors;
14002: ELSIF l_table_name = 'XLA_RULES_T' THEN
14003: OPEN cur_gmf_log_errors FOR l_xla_rules_t;