DBA Data[Home] [Help]

APPS.WSH_TRANSACTIONS_TPW_UTIL dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 1700: wsh_delivery_assignments_v wda,

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'
1704: AND wdd.Delivery_Detail_ID = wda.Delivery_Detail_ID

Line 1723: wsh_delivery_assignments_v wda,

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'
1727: AND nvl(wdd.inv_interfaced_flag,'N') <> 'Y'