APPS.WMS_OTM_DOCK_SYNC dependencies on WSH_SHIP_FROM_ORGS_V
Line 45: FROM WSH_SHIP_FROM_ORGS_V
41: IS
42: -- Cursor to get the Location XID for the Organization
43: CURSOR l_org_loc_csr(l_organization_id NUMBER) IS
44: SELECT 'ORG-' || ORGANIZATION_ID ||'-'|| LOCATION_ID LOCATION_XID 45: FROM WSH_SHIP_FROM_ORGS_V 46: WHERE ORGANIZATION_ID = l_organization_id;
47:
48: -- Cursor to get the Location XID for the Organization
49: -- NVL function added for Description since OTM always expects a Dock Name