DBA Data[Home] [Help]

APPS.WSH_WVX_PVT dependencies on SO_LINE_DETAILS

Line 75: so_line_details ld,

71: -- if qty is NULL, it must be 0 here.
72: sum(NVL(pld.shipped_quantity, 0)) qty
73: FROM so_picking_line_details pld,
74: so_picking_lines_all pl,
75: so_line_details ld,
76: so_lines_all l,
77: so_headers_all h,
78: mtl_system_items i_msi, -- configuration item
79: mtl_system_items m_msi -- model

Line 196: FROM so_line_details sld,

192: msi.primary_uom_code,
193: sld.quantity,
194: sld.inventory_item_id) ) weight,
195: msi.weight_uom_code uom
196: FROM so_line_details sld,
197: so_lines_all sl,
198: mtl_system_items msi
199: WHERE sl.ato_line_id = x_a_line_id
200: AND sld.line_id = sl.line_id

Line 214: FROM so_line_details sld,

210: msi.primary_uom_code,
211: sld.quantity,
212: sld.inventory_item_id) ) volume,
213: msi.volume_uom_code uom
214: FROM so_line_details sld,
215: so_lines_all sl,
216: mtl_system_items msi
217: WHERE sl.ato_line_id = x_a_line_id
218: AND sld.line_id = sl.line_id

Line 750: so_line_details ld,

746: sum(NVL(pld.shipped_quantity,
747: x_ship_f*pld.requested_quantity)) qty
748: FROM so_picking_line_details pld,
749: so_picking_lines_all pl,
750: so_line_details ld,
751: so_lines_all l,
752: mtl_system_items i_msi, -- configuration item
753: mtl_system_items m_msi -- model
754: WHERE pld.delivery_id = x_del_id