APPS.GML_OPM_ROI_GRP dependencies on IC_WHSE_MST

Line 147: From ic_loct_inv ilv,ic_loct_mst ilm,ic_whse_mst iwm

143: l_default_location VARCHAR2(16);
144:
145: Cursor Cr_qoh_loct_not_null Is
146: Select sum(loct_onhand)
147: From ic_loct_inv ilv,ic_loct_mst ilm,ic_whse_mst iwm
148: Where ilv.item_id = p_opm_item_id
149: and ilv.whse_code = iwm.whse_code
150: and ilv.location = ilm.location
151: and iwm.mtl_organization_id = p_organization_id

Line 158: From ic_loct_inv ilv,ic_whse_mst iwm

154: having sum(loct_onhand) > 0;
155:
156: Cursor Cr_qoh_loct_null Is
157: Select sum(loct_onhand)
158: From ic_loct_inv ilv,ic_whse_mst iwm
159: Where ilv.item_id = p_opm_item_id
160: and ilv.whse_code = iwm.whse_code
161: and ilv.location = l_default_location
162: and iwm.mtl_organization_id = p_organization_id

Line 763: FROM IC_WHSE_MST

759:
760: x_return_status := fnd_api.g_ret_sts_success;
761:
762: SELECT whse_code INTO l_whse_code
763: FROM IC_WHSE_MST
764: WHERE mtl_organization_id = p_organization_id;
765:
766:
767: SELECT lot_status,status_ctl

Line 830: FROM IC_WHSE_MST W,SY_ORGN_MST S

826: IF l_inv_lot_status IS NOT NULL AND l_inv_lot_status <> l_default_lot_status
827: AND l_inv_loct_onhand = 0 THEN
828:
829: SELECT s.co_code,w.orgn_code INTO l_trans_rec.co_code,l_trans_rec.orgn_code
830: FROM IC_WHSE_MST W,SY_ORGN_MST S
831: WHERE w.whse_code = l_whse_code
832: and w.orgn_code = s.orgn_code;
833:
834: IF l_inv_debug = 1 THEN

Line 996: From po_Vend_mst pvm,ic_whse_mst iwm,sy_orgn_mst som

992: IF p_vendor_id IS NOT NULL and p_vendor_site_id IS NOT NULL THEN
993:
994: BEGIN
995: Select pvm.vendor_no INTO l_new_lot_rec.shipvendor_no
996: From po_Vend_mst pvm,ic_whse_mst iwm,sy_orgn_mst som
997: Where pvm.OF_VENDOR_ID = p_vendor_id
998: and pvm.OF_VENDOR_SITE_ID = p_vendor_site_id
999: and iwm.mtl_organization_id = p_organization_id
1000: and iwm.orgn_code = som.orgn_code