APPS.INV_GMI_MIGRATION dependencies on IC_WHSE_MST

Line 1887: FROM ic_whse_mst

1883: l_field_name := 'Organization/ Subinventory';
1884: l_field_value := 'Warehouse = '||adetail.whse_code;
1885: SELECT organization_id, subinventory_ind_flag, migrated_ind
1886: INTO l_organization_id, l_subinventory_ind_flag, l_migrated_ind
1887: FROM ic_whse_mst
1888: WHERE
1889: whse_code = adetail.whse_code;
1890: IF (nvl(l_migrated_ind,0) <> 1) THEN
1891: -- dbms_output.put_line ('Warehouse not mmigrated: '||adetail.whse_code);

Line 2374: FROM ic_whse_mst

2370: SELECT orgn_code, subinventory_ind_flag, loct_ctl,
2371: organization_id, migrated_ind, last_updated_by
2372: INTO l_orgn_code, l_subinventory_ind_flag, l_whse_loct_ctl,
2373: l_organization_id, l_migrated_ind, l_last_updated_by
2374: FROM ic_whse_mst
2375: WHERE
2376: whse_code = bal.whse_code;
2377:
2378: IF (l_migrated_ind is NULL or l_organization_id is NULL) THEN

Line 2672: FROM ic_loct_mst ol, mtl_item_locations dl, ic_whse_mst iwm

2668: organization_id in where clause
2669: */
2670: SELECT ol.locator_id, dl.subinventory_code
2671: INTO l_locator_id, l_subinventory_code
2672: FROM ic_loct_mst ol, mtl_item_locations dl, ic_whse_mst iwm
2673: WHERE
2674: ol.whse_code = bal.whse_code AND
2675: ol.location = bal.location AND
2676: ol.whse_code = iwm.whse_code AND