APPS.GMF_MIGRATION dependencies on GL_ITEM_CST

Line 10652: FROM gl_item_cst a,

10648: AND c.whse_code(+) = a.whse_code
10649: UNION
10650: SELECT a.item_id,
10651: NVL(DECODE(b.cost_organization_id, -1, b.mtl_organization_id, b.cost_organization_id), b.mtl_organization_id) organization_id
10652: FROM gl_item_cst a,
10653: ic_whse_mst b
10654: WHERE a.item_id IS NOT NULL
10655: AND a.whse_code = b.whse_code
10656: UNION

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

12249: WHERE (burden_uom IS NULL AND burden_um IS NOT NULL)
12250: GROUP BY burden_um
12251: HAVING count(*) > 0
12252: ) cm_brdn_dtl';
12253: l_gl_item_cst VARCHAR2(32000) := 'SELECT ''GL_ITEM_CST'' table_name,
12254: gl_item_cst.*
12255: FROM (
12256: SELECT ''ORGANIZATION_ID'' column_name,
12257: ''Warehouse Code: ''|| whse_code parameters,

Line 12254: gl_item_cst.*

12250: GROUP BY burden_um
12251: HAVING count(*) > 0
12252: ) cm_brdn_dtl';
12253: l_gl_item_cst VARCHAR2(32000) := 'SELECT ''GL_ITEM_CST'' table_name,
12254: gl_item_cst.*
12255: FROM (
12256: SELECT ''ORGANIZATION_ID'' column_name,
12257: ''Warehouse Code: ''|| whse_code parameters,
12258: count(*) records

Line 12259: FROM gl_item_cst

12255: FROM (
12256: SELECT ''ORGANIZATION_ID'' column_name,
12257: ''Warehouse Code: ''|| whse_code parameters,
12258: count(*) records
12259: FROM gl_item_cst
12260: WHERE (organization_id IS NULL AND whse_code IS NOT NULL)
12261: GROUP BY whse_code
12262: HAVING count(*) > 0
12263: UNION

Line 12267: FROM gl_item_cst a, ic_item_mst b

12263: UNION
12264: SELECT ''INVENTORY_ITEM_ID'' column_name,
12265: ''Item No: ''|| b.item_no parameters,
12266: count(*) records
12267: FROM gl_item_cst a, ic_item_mst b
12268: WHERE (a.inventory_item_id IS NULL AND a.item_id IS NOT NULL)
12269: AND b.item_id = a.item_id
12270: GROUP BY b.item_no
12271: HAVING count(*) > 0

Line 12276: FROM gl_item_cst

12272: UNION
12273: SELECT ''COST_TYPE_ID'' column_name,
12274: ''Cost Method Code: ''|| cost_mthd_code parameters,
12275: count(*) records
12276: FROM gl_item_cst
12277: WHERE (cost_type_id IS NULL AND cost_mthd_code IS NOT NULL)
12278: GROUP BY cost_mthd_code
12279: HAVING count(*) > 0
12280: UNION

Line 12284: FROM gl_item_cst

12280: UNION
12281: SELECT ''PERIOD_ID'' column_name,
12282: ''Calendar Code: ''|| calendar_code ||'', Period Code: ''|| period_code parameters,
12283: count(*) records
12284: FROM gl_item_cst
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';

Line 12288: ) gl_item_cst';

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

Line 13167: * Migration Error Logging for table GL_ITEM_CST *

13163: FROM cm_brdn_dtl;
13164: END IF;
13165: END IF;
13166: /************************************************
13167: * Migration Error Logging for table GL_ITEM_CST *
13168: ************************************************/
13169: IF l_table_name IN ('GL_ITEM_CST') THEN
13170: IF p_log_level = 1 THEN
13171: l_sql_statement := l_sql_statement

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

13165: END IF;
13166: /************************************************
13167: * Migration Error Logging for table GL_ITEM_CST *
13168: ************************************************/
13169: IF l_table_name IN ('GL_ITEM_CST') THEN
13170: IF p_log_level = 1 THEN
13171: l_sql_statement := l_sql_statement
13172: ||
13173: '( (organization_id IS NULL AND whse_code IS NOT NULL)

Line 13192: FROM gl_item_cst;

13188: INTO l_organization_count,
13189: l_inventory_item_count,
13190: l_cost_type_count,
13191: l_period_count
13192: FROM gl_item_cst;
13193: END IF;
13194: END IF;
13195: /************************************************
13196: * Migration Error Logging for table CM_SCST_LED *

Line 13659: ELSIF l_table_name = 'GL_ITEM_CST' THEN

13655: ELSIF l_table_name = 'CM_BRDN_DTL' THEN
13656: OPEN cur_gmf_log_errors FOR l_cm_brdn_dtl;
13657: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13658: CLOSE cur_gmf_log_errors;
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

Line 13660: OPEN cur_gmf_log_errors FOR l_gl_item_cst;

13656: OPEN cur_gmf_log_errors FOR l_cm_brdn_dtl;
13657: FETCH cur_gmf_log_errors bulk collect INTO l_error_tbl;
13658: CLOSE cur_gmf_log_errors;
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;