APPS.INV_OPM_LOT_MIGRATION dependencies on IC_WHSE_MST

Line 469: FROM ic_whse_mst

465: END IF;
466:
467: IF p_whse_code IS NOT NULL THEN
468: SELECT orgn_code INTO l_whse_orgn_code
469: FROM ic_whse_mst
470: WHERE whse_code = p_whse_code;
471: END IF;
472:
473: UPDATE ic_lots_mst_mig

Line 765: FROM ic_whse_mst

761: -- when whse is migrated as the subinventory
762: -- The whse is later used to get the organization_id back.
763: SELECT whse_code
764: INTO l_whse_code
765: FROM ic_whse_mst
766: WHERE
767: organization_id = p_organization_id AND
768: migrated_ind = 1 AND
769: ROWNUM = 1;

Line 777: FROM ic_loct_mst l, ic_whse_mst w

773: l_field_value := p_locator_id;
774:
775: SELECT l.whse_code, l.location, w.organization_id
776: INTO l_location_whse, l_location, l_loc_organization_id
777: FROM ic_loct_mst l, ic_whse_mst w
778: WHERE
779: inventory_location_id = p_locator_id AND
780: l.whse_code = w.whse_code;
781:

Line 1107: FROM ic_whse_mst

1103: IF (p_whse_code IS NOT NULL) THEN
1104: BEGIN
1105: SELECT organization_id, migrated_ind
1106: INTO l_organization_id, l_whse_migrated_ind
1107: FROM ic_whse_mst
1108: WHERE
1109: whse_code = p_whse_code;
1110:
1111: IF (l_organization_id is NULL or l_whse_migrated_ind = 0) THEN