DBA Data[Home] [Help]

APPS.INV_GMI_MIGRATION dependencies on IC_WHSE_MST

Line 1795: FROM ic_whse_mst

1791: l_field_name := 'Organization/ Subinventory';
1792: l_field_value := 'Warehouse = '||adetail.whse_code;
1793: SELECT organization_id, subinventory_ind_flag, migrated_ind
1794: INTO l_organization_id, l_subinventory_ind_flag, l_migrated_ind
1795: FROM ic_whse_mst
1796: WHERE
1797: whse_code = adetail.whse_code;
1798: IF (nvl(l_migrated_ind,0) <> 1) THEN
1799: -- dbms_output.put_line ('Warehouse not mmigrated: '||adetail.whse_code);

Line 2260: FROM ic_whse_mst

2256: SELECT orgn_code, subinventory_ind_flag, loct_ctl,
2257: organization_id, migrated_ind, last_updated_by
2258: INTO l_orgn_code, l_subinventory_ind_flag, l_whse_loct_ctl,
2259: l_organization_id, l_migrated_ind, l_last_updated_by
2260: FROM ic_whse_mst
2261: WHERE
2262: whse_code = bal.whse_code;
2263:
2264: IF (l_migrated_ind is NULL or l_organization_id is NULL) THEN