APPS.WMS_STRATEGY_PVT dependencies on WSH_DELIVERY_DETAILS

Line 1688: FROM wsh_delivery_details

1684: AND trx_source_line_id = p_trx_source_line_id;
1685:
1686: SELECT source_line_set_id,source_header_id
1687: into l_source_line_set_id,l_source_header_id
1688: FROM wsh_delivery_details
1689: WHERE source_line_id = p_trx_source_line_id
1690: AND source_code = 'OE'
1691: AND container_flag = 'N'
1692: AND released_status <> 'D'

Line 1710: (SELECT wdd.source_line_id FROM wsh_delivery_details wdd

1706: WHERE mmtt.organization_id = p_organization_id
1707: AND mmtt.inventory_item_id = p_inventory_item_id
1708: AND mmtt.transaction_action_id = 28
1709: AND mmtt.trx_source_line_id IN
1710: (SELECT wdd.source_line_id FROM wsh_delivery_details wdd
1711: WHERE wdd.source_line_set_id =l_source_line_set_id
1712: AND wdd.source_line_id <> p_trx_source_line_id
1713: AND wdd.source_code = 'OE'
1714: AND wdd.container_flag = 'N'

Line 1721: FROM wsh_delivery_details wdd

1717: SELECT SUM(wdd.requested_quantity)
1718: , NVL(SUM(wdd.requested_quantity2),0)
1719: INTO l_requested_qty
1720: , l_requested_sec_qty
1721: FROM wsh_delivery_details wdd
1722: WHERE wdd.source_line_set_id =l_source_line_set_id
1723: AND wdd.released_status NOT IN ( 'C','Y','D')
1724: AND wdd.source_line_id <> p_trx_source_line_id
1725: AND wdd.source_code = 'OE'