DBA Data[Home] [Help]

APPS.JAI_OPM_GMD_TRIGGER_PKG dependencies on MTL_SYSTEM_ITEMS

Line 47: from mtl_system_items

43: WHERE osp_header_id = pr_new.batch_id;
44:
45: Cursor C_Inv_Ind(cp_organization_id number, cp_inventory_item_id number) IS
46: select decode(inventory_item_flag, 'Y', 0, 1) noninv_ind
47: from mtl_system_items
48: where organization_id = cp_organization_id
49: and inventory_item_id = cp_inventory_item_id;
50: --SELECT noninv_ind FROM ic_item_mst
51: --WHERE item_id = p_item_id;