APPS.WMS_POSTALLOC_PVT dependencies on WSH_INV_DELIVERY_DETAILS_V

Line 6363: || ' , wsh_inv_delivery_details_v wdd'

6359: l_count NUMBER := 0;
6360: l_pick_slip_sql VARCHAR2(2000) := 'SELECT ';
6361: l_pickslip_base VARCHAR2(2000) := ' FROM mtl_material_transactions_temp mmtt'
6362: || ' , mtl_txn_request_lines mtrl'
6363: || ' , wsh_inv_delivery_details_v wdd'
6364: || ' WHERE mtrl.header_id = :mo_header_id'
6365: || ' AND mmtt.move_order_line_id = mtrl.line_id'
6366: || ' AND wdd.move_order_line_id = mtrl.line_id';
6367: l_ps_group_by VARCHAR2(2000) := ' GROUP BY ';

Line 6375: || ' , wsh_inv_delivery_details_v wdd '

6371: || ' , inv_salesorder.get_salesorder_for_oeheader(wdd.oe_header_id)'
6372: || ' , wdd.oe_line_id'
6373: || ' FROM mtl_material_transactions_temp mmtt'
6374: || ' , mtl_txn_request_lines mtrl'
6375: || ' , wsh_inv_delivery_details_v wdd '
6376: || ' WHERE mtrl.header_id = :mo_header_id'
6377: || ' AND mmtt.move_order_line_id = mtrl.line_id'
6378: || ' AND wdd.move_order_line_id = mtrl.line_id'
6379: || ' AND mmtt.parent_line_id IS NULL'; -- non-bulk tasks

Line 6677: , wsh_inv_delivery_details_v wdd

6673: , inv_salesorder.get_salesorder_for_oeheader(wdd.oe_header_id)
6674: , wdd.oe_line_id
6675: FROM mtl_material_transactions_temp mmtt
6676: , mtl_txn_request_lines mol
6677: , wsh_inv_delivery_details_v wdd
6678: WHERE mmtt.move_order_line_id = mol.line_id
6679: AND mol.header_id = p_mo_header_id
6680: AND wdd.move_order_line_id = mol.line_id
6681: AND mmtt.parent_line_id IS NULL; -- exclude bulk pick child tasks