APPS.GMF_MIGRATION dependencies on CM_WHSE_ASC

Line 12075: * data in CM_WHSE_ASC *

12071: * Migrate_Cost_Warehouses *
12072: * *
12073: * DESCRIPTION: *
12074: * This PL/SQL procedure is used to transform the Cost Warehouses *
12075: * data in CM_WHSE_ASC *
12076: * *
12077: * PARAMETERS: *
12078: * P_migration_run_id - id to use to right to migration log *
12079: * x_exception_count - Number of exceptions occurred. *

Line 12129: cm_whse_asc d,

12125: DECODE(COUNT(e.whse_code), 0, 'N', 'Y') inv_warehouse
12126: FROM ic_whse_mst a,
12127: sy_orgn_mst b,
12128: ic_whse_mst c,
12129: cm_whse_asc d,
12130: cm_whse_asc e,
12131: cm_whse_asc f
12132: WHERE a.orgn_code = b.orgn_code
12133: AND c.orgn_code = a.orgn_code

Line 12130: cm_whse_asc e,

12126: FROM ic_whse_mst a,
12127: sy_orgn_mst b,
12128: ic_whse_mst c,
12129: cm_whse_asc d,
12130: cm_whse_asc e,
12131: cm_whse_asc f
12132: WHERE a.orgn_code = b.orgn_code
12133: AND c.orgn_code = a.orgn_code
12134: AND d.cost_whse_code(+) = a.whse_code

Line 12131: cm_whse_asc f

12127: sy_orgn_mst b,
12128: ic_whse_mst c,
12129: cm_whse_asc d,
12130: cm_whse_asc e,
12131: cm_whse_asc f
12132: WHERE a.orgn_code = b.orgn_code
12133: AND c.orgn_code = a.orgn_code
12134: AND d.cost_whse_code(+) = a.whse_code
12135: AND f.cost_whse_code(+) = c.whse_code

Line 12152: G_Table_name := 'CM_WHSE_ASC';

12148: ORDER BY a.whse_code;
12149: BEGIN
12150:
12151: G_Migration_run_id := P_migration_run_id;
12152: G_Table_name := 'CM_WHSE_ASC';
12153: G_Context := 'Cost Warehouses Migration';
12154: X_failure_count := 0;
12155:
12156: /********************************

Line 12206: UPDATE cm_whse_asc a

12202: SET a.cost_organization_id = l_costing_organization_id
12203: WHERE a.whse_code = i.whse_code;
12204: END LOOP;
12205:
12206: UPDATE cm_whse_asc a
12207: SET (
12208: a.organization_id
12209: )
12210: = (

Line 12224: UPDATE cm_whse_asc a

12220: FROM ic_whse_mst x
12221: WHERE x.whse_code = a.cost_whse_code
12222: );
12223:
12224: UPDATE cm_whse_asc a
12225: SET delete_mark = 1
12226: WHERE (
12227: ROWID NOT IN (
12228: SELECT MIN(ROWID)

Line 12229: FROM cm_whse_asc x

12225: SET delete_mark = 1
12226: WHERE (
12227: ROWID NOT IN (
12228: SELECT MIN(ROWID)
12229: FROM cm_whse_asc x
12230: WHERE x.cost_organization_id = a.cost_organization_id
12231: AND x.organization_id = a.organization_id
12232: AND x.delete_mark <> 1
12233: AND (

Line 12248: FROM cm_whse_asc

12244: **********************************************/
12245:
12246: SELECT count(*)
12247: INTO x_failure_count
12248: FROM cm_whse_asc
12249: WHERE (organization_id IS NULL AND whse_code IS NOT NULL)
12250: OR (cost_organization_id IS NULL AND cost_whse_code IS NOT NULL);
12251:
12252: IF nvl(x_failure_count,0) > 0 THEN