DBA Data[Home] [Help]

APPS.GMD_QM_UOM dependencies on MTL_SYSTEM_ITEMS_KFV

Line 123: mtl_system_items_kfv K

119: gmd_event_spec_disp F,
120: gmd_sampling_events H,
121: mtl_parameters I,
122: mtl_item_locations_kfv MIL,
123: mtl_system_items_kfv K
124: where e.EVENT_SPEC_DISP_ID = l_event_key and
125: e.EVENT_SPEC_DISP_ID = f.event_spec_disp_id and
126: f.sampling_event_id = h.SAMPLING_EVENT_ID and
127: I.organization_id = H.organization_id and

Line 212: from mtl_system_items_kfv

208: AND lookup_code = mon_source_in ;
209: --SCHANDRU INVCONV START
210: Cursor control (item_no_in number) is
211: select LOT_CONTROL_CODE
212: from mtl_system_items_kfv
213: where inventory_item_id = item_no_in;
214:
215: --SCHANDRU INVCONV END
216: cursor get_child_lots (l_item_id_in number, l_organization_id_in number,l_parent_lot_number_in varchar2) is