APPS.GMF_MIGRATION dependencies on CM_WHSE_ASC

Line 11744: * data in CM_WHSE_ASC *

11740: * Migrate_Cost_Warehouses *
11741: * *
11742: * DESCRIPTION: *
11743: * This PL/SQL procedure is used to transform the Cost Warehouses *
11744: * data in CM_WHSE_ASC *
11745: * *
11746: * PARAMETERS: *
11747: * P_migration_run_id - id to use to right to migration log *
11748: * x_exception_count - Number of exceptions occurred. *

Line 11798: cm_whse_asc d,

11794: DECODE(COUNT(e.whse_code), 0, 'N', 'Y') inv_warehouse
11795: FROM ic_whse_mst a,
11796: sy_orgn_mst b,
11797: ic_whse_mst c,
11798: cm_whse_asc d,
11799: cm_whse_asc e,
11800: cm_whse_asc f
11801: WHERE a.orgn_code = b.orgn_code
11802: AND c.orgn_code = a.orgn_code

Line 11799: cm_whse_asc e,

11795: FROM ic_whse_mst a,
11796: sy_orgn_mst b,
11797: ic_whse_mst c,
11798: cm_whse_asc d,
11799: cm_whse_asc e,
11800: cm_whse_asc f
11801: WHERE a.orgn_code = b.orgn_code
11802: AND c.orgn_code = a.orgn_code
11803: AND d.cost_whse_code(+) = a.whse_code

Line 11800: cm_whse_asc f

11796: sy_orgn_mst b,
11797: ic_whse_mst c,
11798: cm_whse_asc d,
11799: cm_whse_asc e,
11800: cm_whse_asc f
11801: WHERE a.orgn_code = b.orgn_code
11802: AND c.orgn_code = a.orgn_code
11803: AND d.cost_whse_code(+) = a.whse_code
11804: AND f.cost_whse_code(+) = c.whse_code

Line 11821: G_Table_name := 'CM_WHSE_ASC';

11817: ORDER BY a.whse_code;
11818: BEGIN
11819:
11820: G_Migration_run_id := P_migration_run_id;
11821: G_Table_name := 'CM_WHSE_ASC';
11822: G_Context := 'Cost Warehouses Migration';
11823: X_failure_count := 0;
11824:
11825: /********************************

Line 11875: UPDATE cm_whse_asc a

11871: SET a.cost_organization_id = l_costing_organization_id
11872: WHERE a.whse_code = i.whse_code;
11873: END LOOP;
11874:
11875: UPDATE cm_whse_asc a
11876: SET (
11877: a.organization_id
11878: )
11879: = (

Line 11893: UPDATE cm_whse_asc a

11889: FROM ic_whse_mst x
11890: WHERE x.whse_code = a.cost_whse_code
11891: );
11892:
11893: UPDATE cm_whse_asc a
11894: SET delete_mark = 1
11895: WHERE (
11896: ROWID NOT IN (
11897: SELECT MIN(ROWID)

Line 11898: FROM cm_whse_asc x

11894: SET delete_mark = 1
11895: WHERE (
11896: ROWID NOT IN (
11897: SELECT MIN(ROWID)
11898: FROM cm_whse_asc x
11899: WHERE x.cost_organization_id = a.cost_organization_id
11900: AND x.organization_id = a.organization_id
11901: AND x.delete_mark <> 1
11902: AND (

Line 11917: FROM cm_whse_asc

11913: **********************************************/
11914:
11915: SELECT count(*)
11916: INTO x_failure_count
11917: FROM cm_whse_asc
11918: WHERE (organization_id IS NULL AND whse_code IS NOT NULL)
11919: OR (cost_organization_id IS NULL AND cost_whse_code IS NOT NULL);
11920:
11921: IF nvl(x_failure_count,0) > 0 THEN