APPS.EAM_MTL_TXN_PROCESS dependencies on MTL_SYSTEM_ITEMS

Line 51: -- with MTL_SYSTEM_ITEMS or MTL_TRANSACTION_LOTS_TEMP

47: x_status NUMBER; -- holds the status returned from every transaction API call
48: x_status_flag VARCHAR2(240);
49: x_header_id NUMBER; -- holds the header id from MMTT table
50: x_ser_txn_id NUMBER; -- holds Serial transaction id which will lind MTL_SERIAL_NUMBERS_TEMP
51: -- with MTL_SYSTEM_ITEMS or MTL_TRANSACTION_LOTS_TEMP
52: x_wip_ret_status VARCHAR2(250); -- holds the status returned from WIP Transaction API
53: x_future_date NUMBER;
54:
55: x_locator_ctrl NUMBER ; -- Holds the Locator Control information

Line 202: from mtl_system_items_b_kfv

198: /* Finding out Item ID from Name */
199: if(p_item_id IS NULL and p_item IS NOT NULL) then
200: begin
201: select inventory_item_id into p_item_id
202: from mtl_system_items_b_kfv
203: where
204: concatenated_segments = p_item
205: and organization_id = p_org_id;
206: exception

Line 863: FROM MTL_SYSTEM_ITEMS

859: Begin
860: SELECT
861: location_control_code,restrict_locators_code into
862: x_item_ctrl,x_restrict_flag
863: FROM MTL_SYSTEM_ITEMS
864: WHERE
865: inventory_item_id = p_item_id and
866: organization_id = p_org;
867: Exception