APPS.GML_OPM_ROI_GRP dependencies on IC_LOCT_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 786: FROM IC_LOCT_MST

782:
783: IF p_locator_id is not null THEN
784: BEGIN
785: SELECT location INTO l_location
786: FROM IC_LOCT_MST
787: WHERE inventory_location_id = p_locator_id;
788:
789: EXCEPTION
790: WHEN OTHERS THEN