DBA Data[Home] [Help]

APPS.WSH_TRANSACTIONS_TPW_UTIL dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 1448: wsh_delivery_assignments_v wda,

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

Line 1471: wsh_delivery_assignments_v wda,

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