APPS.WMS_OP_INBOUND_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 77: FROM mtl_system_items_b

73: ) IS
74:
75: CURSOR c_item_details(v_inventory_item_id NUMBER,v_organization_id NUMBER) IS
76: SELECT nvl(lot_control_code,1)lot_control_code,nvl(serial_number_control_code,1) serial_number_control_code
77: FROM mtl_system_items_b
78: WHERE inventory_item_id = v_inventory_item_id
79: AND organization_id = v_organization_id;
80:
81: CURSOR c_mtlt_rec IS

Line 2018: FROM mtl_system_items_b

2014: SELECT lot_control_code,
2015: serial_number_control_code
2016: INTO l_lot_control_code,
2017: l_serial_control_code
2018: FROM mtl_system_items_b
2019: WHERE inventory_item_id = p_document_rec.inventory_item_id
2020: AND organization_id = p_document_rec.organization_id;
2021:
2022: l_progress := 290;