APPS.WSH_TRANSACTIONS_TPW_UTIL dependencies on WSH_DELIVERY_DETAILS

Line 1699: FROM wsh_delivery_details wdd,

1695: AND Delivery_ID = c_Delivery_ID;
1696:
1697: CURSOR l_del_details_cur (c_Delivery_ID NUMBER, c_Org_ID NUMBER) IS
1698: SELECT 'X'
1699: FROM wsh_delivery_details wdd,
1700: wsh_delivery_assignments_v wda,
1701: wsh_new_deliveries wnd
1702: WHERE wdd.container_flag = 'N'
1703: AND wdd.source_code = 'WSH'

Line 1722: FROM wsh_delivery_details wdd,

1718: and action_type = 'A');
1719:
1720: CURSOR get_delivery_details(cp_entity_id NUMBER) IS
1721: SELECT 'X'
1722: FROM wsh_delivery_details wdd,
1723: wsh_delivery_assignments_v wda,
1724: mtl_system_items msi
1725: WHERE wdd.container_flag = 'N'
1726: AND wdd.released_status <> 'D'