APPS.WSH_TRANSACTIONS_TPW_UTIL dependencies on WSH_DELIVERY_DETAILS

Line 1447: FROM wsh_delivery_details wdd,

1443: AND Delivery_ID = c_Delivery_ID;
1444:
1445: CURSOR l_del_details_cur (c_Delivery_ID NUMBER, c_Org_ID NUMBER) IS
1446: SELECT 'X'
1447: FROM wsh_delivery_details wdd,
1448: wsh_delivery_assignments_v wda,
1449: wsh_new_deliveries wnd
1450: WHERE wdd.container_flag = 'N'
1451: AND wdd.source_code = 'WSH'

Line 1470: FROM wsh_delivery_details wdd,

1466: and action_type = 'A');
1467:
1468: CURSOR get_delivery_details(cp_entity_id NUMBER) IS
1469: SELECT 'X'
1470: FROM wsh_delivery_details wdd,
1471: wsh_delivery_assignments_v wda,
1472: mtl_system_items msi
1473: WHERE wdd.container_flag = 'N'
1474: AND wdd.released_status <> 'D'