DBA Data[Home] [Help]

APPS.EAM_MTL_TXN_PROCESS dependencies on MTL_SYSTEM_ITEMS

Line 50: -- with MTL_SYSTEM_ITEMS or MTL_TRANSACTION_LOTS_TEMP

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

Line 120: from mtl_system_items_b_kfv

116: /* Finding out Item ID from Name */
117: if(p_item_id IS NULL and p_item IS NOT NULL) then
118: begin
119: select inventory_item_id into p_item_id
120: from mtl_system_items_b_kfv
121: where
122: concatenated_segments = p_item
123: and organization_id = p_org_id;
124: exception

Line 504: FROM MTL_SYSTEM_ITEMS

500: Begin
501: SELECT
502: location_control_code,restrict_locators_code into
503: x_item_ctrl,x_restrict_flag
504: FROM MTL_SYSTEM_ITEMS
505: WHERE
506: inventory_item_id = p_item_id and
507: organization_id = p_org;
508: Exception