APPS.GMF_MIGRATION dependencies on GL_ITEM_CST

Line 10982: FROM gl_item_cst a,

10978: AND c.whse_code(+) = a.whse_code
10979: UNION
10980: SELECT a.item_id,
10981: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
10982: FROM gl_item_cst a,
10983: ic_whse_mst b
10984: WHERE a.item_id IS NOT NULL
10985: AND a.whse_code = b.whse_code
10986: UNION

Line 12584: l_gl_item_cst VARCHAR2(32000) := 'SELECT ''GL_ITEM_CST'' table_name,

12580: WHERE (burden_uom IS NULL AND burden_um IS NOT NULL)
12581: GROUP BY burden_um
12582: HAVING count(*) > 0
12583: ) cm_brdn_dtl';
12584: l_gl_item_cst VARCHAR2(32000) := 'SELECT ''GL_ITEM_CST'' table_name,
12585: gl_item_cst.*
12586: FROM (
12587: SELECT ''ORGANIZATION_ID'' column_name,
12588: ''Warehouse Code: ''|| whse_code parameters,

Line 12585: gl_item_cst.*

12581: GROUP BY burden_um
12582: HAVING count(*) > 0
12583: ) cm_brdn_dtl';
12584: l_gl_item_cst VARCHAR2(32000) := 'SELECT ''GL_ITEM_CST'' table_name,
12585: gl_item_cst.*
12586: FROM (
12587: SELECT ''ORGANIZATION_ID'' column_name,
12588: ''Warehouse Code: ''|| whse_code parameters,
12589: count(*) records

Line 12590: FROM gl_item_cst

12586: FROM (
12587: SELECT ''ORGANIZATION_ID'' column_name,
12588: ''Warehouse Code: ''|| whse_code parameters,
12589: count(*) records
12590: FROM gl_item_cst
12591: WHERE (organization_id IS NULL AND whse_code IS NOT NULL)
12592: GROUP BY whse_code
12593: HAVING count(*) > 0
12594: UNION

Line 12598: FROM gl_item_cst a, ic_item_mst b

12594: UNION
12595: SELECT ''INVENTORY_ITEM_ID'' column_name,
12596: ''Item No: ''|| b.item_no parameters,
12597: count(*) records
12598: FROM gl_item_cst a, ic_item_mst b
12599: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12600: AND b.item_id = a.item_id
12601: GROUP BY b.item_no
12602: HAVING count(*) > 0

Line 12607: FROM gl_item_cst

12603: UNION
12604: SELECT ''COST_TYPE_ID'' column_name,
12605: ''Cost Method Code: ''|| cost_mthd_code parameters,
12606: count(*) records
12607: FROM gl_item_cst
12608: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12609: GROUP BY cost_mthd_code
12610: HAVING count(*) > 0
12611: UNION

Line 12615: FROM gl_item_cst

12611: UNION
12612: SELECT ''PERIOD_ID'' column_name,
12613: ''Calendar Code: ''|| calendar_code ||'', Period Code: ''|| period_code parameters,
12614: count(*) records
12615: FROM gl_item_cst
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';

Line 12619: ) gl_item_cst';

12615: FROM gl_item_cst
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,

Line 13498: * Migration Error Logging for table GL_ITEM_CST *

13494: FROM cm_brdn_dtl;
13495: END IF;
13496: END IF;
13497: /************************************************
13498: * Migration Error Logging for table GL_ITEM_CST *
13499: ************************************************/
13500: IF l_table_name IN ('GL_ITEM_CST') THEN
13501: IF p_log_level = 1 THEN
13502: l_sql_statement := l_sql_statement

Line 13500: IF l_table_name IN ('GL_ITEM_CST') THEN

13496: END IF;
13497: /************************************************
13498: * Migration Error Logging for table GL_ITEM_CST *
13499: ************************************************/
13500: IF l_table_name IN ('GL_ITEM_CST') THEN
13501: IF p_log_level = 1 THEN
13502: l_sql_statement := l_sql_statement
13503: ||
13504: '( (organization_id IS NULL AND whse_code IS NOT NULL)

Line 13523: FROM gl_item_cst;

13519: INTO l_organization_count,
13520: l_inventory_item_count,
13521: l_cost_type_count,
13522: l_period_count
13523: FROM gl_item_cst;
13524: END IF;
13525: END IF;
13526: /************************************************
13527: * Migration Error Logging for table CM_SCST_LED *

Line 13990: ELSIF l_table_name = 'GL_ITEM_CST' THEN

13986: ELSIF l_table_name = 'CM_BRDN_DTL' THEN
13987: OPEN cur_gmf_log_errors FOR l_cm_brdn_dtl;
13988: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13989: CLOSE cur_gmf_log_errors;
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

Line 13991: OPEN cur_gmf_log_errors FOR l_gl_item_cst;

13987: OPEN cur_gmf_log_errors FOR l_cm_brdn_dtl;
13988: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13989: CLOSE cur_gmf_log_errors;
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;