DBA Data[Home] [Help]

APPS.CSD_PROCESS_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 868: mtl_system_items_b mtl,

864: wdd.delivery_detail_id,
865: wdd.requested_quantity,
866: mtl.serial_number_control_code
867: FROM csd_repairs cr,
868: mtl_system_items_b mtl,
869: cs_estimate_details ced,
870: wsh_delivery_details wdd,
871: --Changed to view from table, bug: 4341784
872: wsh_delivery_assignments_v wda

Line 9103: FROM Mtl_System_Items_B

9099: THEN
9100: BEGIN
9101: SELECT Serial_Number_Control_COde
9102: INTO l_Serial_num_COntrol_Code
9103: FROM Mtl_System_Items_B
9104: WHERE Inventory_Item_Id = l_Inventory_Item_Id
9105: AND Organization_id = Cs_Std.Get_Item_Valdn_Orgzn_Id;
9106: -- If item is serial controlled then raise error
9107: IF l_Serial_num_COntrol_Code > 1