DBA Data[Home] [Help]

APPS.WSH_SC_PLD_PKG dependencies on SO_PICKING_LINES_ALL

Line 52: so_picking_lines_all pl,

48: -- to check if the item is under serial number control
49: CURSOR check_serial(X_Pk_Line_Detail_Id NUMBER) is
50: SELECT msi.serial_number_control_code
51: FROM mtl_system_items msi,
52: so_picking_lines_all pl,
53: so_picking_line_details pld
54: WHERE pl.inventory_item_id = msi.inventory_item_id
55: AND pl.warehouse_id = msi.organization_id
56: AND msi.serial_number_control_code in (2,5,6)