APPS.GML_OPM_ROI_GRP dependencies on IC_LOCT_INV

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 801: FROM ic_loct_inv ilv

797:
798: BEGIN
799: SELECT lot_status, loct_onhand
800: INTO l_inv_lot_status, l_inv_loct_onhand
801: FROM ic_loct_inv ilv
802: WHERE ilv.item_id = p_lot_attribute_rec.opm_item_id
803: AND ilv.lot_id = p_lot_attribute_rec.lot_id
804: AND ilv.whse_code = l_whse_code
805: AND ilv.location = l_location;

Line 857: Update IC_LOCT_INV

853: Fetch Get_Reason_Code into l_trans_rec.reason_code;
854: If Get_Reason_Code%NOTFOUND Then
855: Close Get_Reason_Code;
856:
857: Update IC_LOCT_INV
858: Set lot_status = l_default_lot_status
859: Where item_id = p_lot_attribute_rec.opm_item_id
860: And whse_code = l_whse_code
861: And location = l_location