DBA Data[Home] [Help]

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 1968: FROM mtl_system_items_b

1964: SELECT lot_control_code,
1965: serial_number_control_code
1966: INTO l_lot_control_code,
1967: l_serial_control_code
1968: FROM mtl_system_items_b
1969: WHERE inventory_item_id = p_document_rec.inventory_item_id
1970: AND organization_id = p_document_rec.organization_id;
1971:
1972: l_progress := 290;