DBA Data[Home] [Help]

APPS.WSH_WV_PVT dependencies on SO_LINES_ALL

Line 406: so_lines_all l

402: CURSOR dpw_loose_ato(x_dep_id NUMBER) IS
403: SELECT l.line_id ato_line_id,
404: sum(ld.quantity) qty
405: FROM so_line_details ld,
406: so_lines_all l
407: WHERE ld.departure_id = x_dep_id
408: AND ld.delivery_id IS NULL
409: AND ld.included_item_flag = 'N'
410: AND l.line_id = ld.line_id

Line 439: so_lines_all l,

435: NULL) volume_uom
436: FROM so_picking_line_details pld,
437: so_picking_lines_all pl,
438: so_line_details ld,
439: so_lines_all l,
440: mtl_system_items i_msi, -- configuration item
441: mtl_system_items m_msi -- model
442: WHERE pld.departure_id = x_dep_id
443: AND pld.delivery_id IS NULL

Line 537: so_lines_all l,

533: NULL) volume_uom
534: FROM so_picking_line_details pld,
535: so_picking_lines_all pl,
536: so_line_details ld,
537: so_lines_all l,
538: mtl_system_items i_msi, -- configuration item
539: mtl_system_items m_msi -- model
540: WHERE pld.departure_id = x_dep_id
541: AND pld.delivery_id IS NULL

Line 1006: so_lines_all l

1002: CURSOR dpw_unpacked_ato(x_del_id NUMBER) IS
1003: SELECT l.line_id ato_line_id,
1004: sum(NVL(ld.quantity, 0)) qty
1005: FROM so_line_details ld,
1006: so_lines_all l
1007: WHERE ld.delivery_id = x_del_id
1008: AND ld.master_container_item_id IS NULL -- no default containers may
1009: AND ld.detail_container_item_id IS NULL -- mean that it is unpacked.
1010: AND ld.included_item_flag = 'N'

Line 1022: so_lines_all l,

1018: sum(NVL(pld.requested_quantity, 0)) qty
1019: FROM so_picking_line_details pld,
1020: so_picking_lines_all pl,
1021: so_line_details ld,
1022: so_lines_all l,
1023: mtl_system_items i_msi, -- configuration item
1024: mtl_system_items m_msi -- model
1025: WHERE pld.delivery_id = x_del_id
1026: AND pld.container_id IS NULL

Line 1074: so_lines_all l,

1070: x_wv_mode * pld.requested_quantity)) qty
1071: FROM so_picking_line_details pld,
1072: so_picking_lines_all pl,
1073: so_line_details ld,
1074: so_lines_all l,
1075: mtl_system_items i_msi, -- configuration item
1076: mtl_system_items m_msi -- model
1077: WHERE pld.delivery_id = x_del_id
1078: AND pld.container_id IS NULL

Line 1255: so_lines_all l

1251: CURSOR ato(x_del_id NUMBER) IS
1252: SELECT l.line_id ato_line_id,
1253: sum(ld.quantity) qty
1254: FROM so_line_details ld,
1255: so_lines_all l
1256: WHERE ld.delivery_id = x_del_id
1257: AND ld.included_item_flag = 'N'
1258: AND l.line_id = ld.line_id
1259: AND l.ato_flag = 'Y'

Line 1269: so_lines_all l,

1265: sum(NVL(pld.requested_quantity, 0)) qty
1266: FROM so_picking_line_details pld,
1267: so_picking_lines_all pl,
1268: so_line_details ld,
1269: so_lines_all l,
1270: mtl_system_items i_msi, -- configuration item
1271: mtl_system_items m_msi -- model
1272: WHERE pld.delivery_id = x_del_id
1273: AND pl.picking_line_id = pld.picking_line_id

Line 1689: so_lines_all l,

1685: x_wv_mode * pld.requested_quantity)) qty
1686: FROM so_picking_line_details pld,
1687: so_picking_lines_all pl,
1688: so_line_details ld,
1689: so_lines_all l,
1690: mtl_system_items i_msi, -- configuration item
1691: mtl_system_items m_msi -- model
1692: WHERE pld.delivery_id = x_del_id
1693: AND pld.container_id = x_cont_id

Line 1861: so_lines_all l,

1857: x_wv_mode * pld.requested_quantity)) qty
1858: FROM so_picking_line_details pld,
1859: so_picking_lines_all pl,
1860: so_line_details ld,
1861: so_lines_all l,
1862: mtl_system_items i_msi, -- configuration item
1863: mtl_system_items m_msi -- model
1864: WHERE pld.delivery_id = x_del_id
1865: AND pld.container_id IS NULL -- not packed in any container