DBA Data[Home] [Help]

APPS.INV_TXN_MANAGER_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 261: , mtl_system_items_b msi

257: , mti.kanban_card_id
258: , mti.transaction_mode --J-dev
259: FROM mtl_transactions_interface mti
260: , mtl_transaction_lots_interface mtli
261: , mtl_system_items_b msi
262: WHERE mti.transaction_interface_id = p_interface_id
263: AND mti.transaction_interface_id = mtli.transaction_interface_id
264: AND mti.organization_id = msi.organization_id
265: AND mti.inventory_item_id = msi.inventory_item_id

Line 6116: FROM mtl_system_items_b

6112: SELECT lot_control_code,
6113: revision_qty_control_code
6114: INTO l_lctrl,
6115: l_rctrl
6116: FROM mtl_system_items_b
6117: WHERE organization_id = l_org_id
6118: AND inventory_item_id = l_item_id;
6119: EXCEPTION
6120: WHEN NO_DATA_FOUND THEN