DBA Data[Home] [Help]

APPS.CSD_PROCESS_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 896: mtl_system_items_b mtl,

892: wdd.delivery_detail_id,
893: wdd.requested_quantity,
894: mtl.serial_number_control_code
895: FROM csd_repairs cr,
896: mtl_system_items_b mtl,
897: cs_estimate_details ced,
898: wsh_delivery_details wdd,
899: --Changed to view from table, bug: 4341784
900: wsh_delivery_assignments_v wda

Line 9258: FROM Mtl_System_Items_B

9254: THEN
9255: BEGIN
9256: SELECT Serial_Number_Control_COde
9257: INTO l_Serial_num_COntrol_Code
9258: FROM Mtl_System_Items_B
9259: WHERE Inventory_Item_Id = l_Inventory_Item_Id
9260: AND Organization_id = Cs_Std.Get_Item_Valdn_Orgzn_Id;
9261: -- If item is serial controlled then raise error
9262: IF l_Serial_num_COntrol_Code > 1