APPS.INV_OPM_LOT_MIGRATION dependencies on IC_WHSE_MST

Line 561: FROM ic_whse_mst

557: END IF;
558:
559: IF p_whse_code IS NOT NULL THEN
560: SELECT orgn_code INTO l_whse_orgn_code
561: FROM ic_whse_mst
562: WHERE whse_code = p_whse_code;
563: END IF;
564:
565: UPDATE ic_lots_mst_mig

Line 859: FROM ic_whse_mst

855: -- when whse is migrated as the subinventory
856: -- The whse is later used to get the organization_id back.
857: SELECT whse_code
858: INTO l_whse_code
859: FROM ic_whse_mst
860: WHERE
861: organization_id = p_organization_id AND
862: migrated_ind = 1 AND
863: ROWNUM = 1;

Line 871: FROM ic_loct_mst l, ic_whse_mst w

867: l_field_value := p_locator_id;
868:
869: SELECT l.whse_code, l.location, w.organization_id
870: INTO l_location_whse, l_location, l_loc_organization_id
871: FROM ic_loct_mst l, ic_whse_mst w
872: WHERE
873: inventory_location_id = p_locator_id AND
874: l.whse_code = w.whse_code;
875:

Line 1201: FROM ic_whse_mst

1197: IF (p_whse_code IS NOT NULL) THEN
1198: BEGIN
1199: SELECT organization_id, migrated_ind
1200: INTO l_organization_id, l_whse_migrated_ind
1201: FROM ic_whse_mst
1202: WHERE
1203: whse_code = p_whse_code;
1204:
1205: IF (l_organization_id is NULL or l_whse_migrated_ind = 0) THEN