APPS.WSH_TRANSACTIONS_TPW_UTIL dependencies on WSH_NEW_DELIVERIES

Line 625: FROM wsh_new_deliveries

621:
622: CURSOR l_new_del_status_cur (c_Delivery_Name VARCHAR2,
623: c_Organization_ID NUMBER) IS
624: SELECT status_code, Delivery_ID
625: FROM wsh_new_deliveries
626: WHERE Organization_id = c_Organization_ID
627: AND Name = c_Delivery_Name;
628: /*
629:

Line 1441: FROM wsh_new_deliveries

1437: AND Document_Type = 'SR');
1438:
1439: CURSOR l_new_del_status_cur ( c_Delivery_ID VARCHAR2, c_Organization_ID NUMBER ) IS
1440: SELECT Name, status_code
1441: FROM wsh_new_deliveries
1442: WHERE Organization_id = c_Organization_ID
1443: AND Delivery_ID = c_Delivery_ID;
1444:
1445: CURSOR l_del_details_cur (c_Delivery_ID NUMBER, c_Org_ID NUMBER) IS

Line 1449: wsh_new_deliveries wnd

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
1453: AND wda.Delivery_ID = wnd.Delivery_ID