eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_CAL_ASG_VALIDATIONS dependencies on WSH_CALENDAR_ASSIGNMENTS

Line 142: FROM wsh_calendar_assignments

138: -- selected last.
139:
140: CURSOR customer_cal IS
141: SELECT calendar_code
142: FROM wsh_calendar_assignments
143: WHERE customer_id = p_entity_id AND
144: calendar_type = 'RECEIVING' AND
145: nvl(location_id, nvl(p_location_id, -1)) = nvl(p_location_id, -1) AND
146: enabled_flag = 'Y'

Line 151: FROM wsh_calendar_assignments

147: ORDER BY location_id;
148:
149: CURSOR org_cal IS
150: SELECT calendar_code
151: FROM wsh_calendar_assignments
152: WHERE organization_id = p_entity_id AND
153: calendar_type = 'SHIPPING' AND
154: nvl(location_id, nvl(p_location_id, -1)) = nvl(p_location_id,-1) AND
155: enabled_flag = 'Y'

Line 1234: FROM WSH_CALENDAR_ASSIGNMENTS WCA ,

1230:
1231: CURSOR c_get_calendar_code IS
1232: SELECT WCA.CALENDAR_CODE,
1233: WCA.ENABLED_FLAG
1234: FROM WSH_CALENDAR_ASSIGNMENTS WCA ,
1235: PO_VENDORS POV ,
1236: PO_VENDOR_SITES_all POVS ,
1237: hr_organization_units HR
1238: WHERE WCA.ASSOCIATION_TYPE = 'VENDOR_SITE'

Line 1253: FROM WSH_CALENDAR_ASSIGNMENTS WCA,

1249: UNION ALL
1250:
1251: SELECT WCA.CALENDAR_CODE,
1252: WCA.ENABLED_FLAG
1253: FROM WSH_CALENDAR_ASSIGNMENTS WCA,
1254: hz_relationships rel,
1255: hz_party_sites hps,
1256: hz_party_site_uses hpsu,
1257: wsh_locations wl

Line 1284: WSH_CALENDAR_ASSIGNMENTS WCA

1280: HZ_CUST_SITE_USES_ALL HCSU,
1281: HZ_PARTY_SITES HPS,
1282: HZ_CUST_ACCOUNTS HCA,
1283: WSH_LOCATIONS WLO,
1284: WSH_CALENDAR_ASSIGNMENTS WCA
1285: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
1286: and HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID
1287: AND HCAS.cust_account_id = hca.cust_account_id
1288: AND HPS.LOCATION_ID = WLO.source_location_id(+)

Line 1304: FROM WSH_CALENDAR_ASSIGNMENTS WCA ,

1300: UNION ALL
1301:
1302: SELECT WCA.CALENDAR_CODE,
1303: WCA.ENABLED_FLAG
1304: FROM WSH_CALENDAR_ASSIGNMENTS WCA ,
1305: WSH_LOCATIONS WLO
1306: WHERE WCA.ASSOCIATION_TYPE = 'HR_LOCATION'
1307: AND WCA.LOCATION_ID = WLO.WSH_LOCATION_ID(+)
1308: ----

Line 1319: FROM WSH_CALENDAR_ASSIGNMENTS WCA ,

1315: WCA.LOCATION_ID =p_location_id)
1316: UNION ALL
1317: SELECT WCA.CALENDAR_CODE,
1318: WCA.ENABLED_FLAG
1319: FROM WSH_CALENDAR_ASSIGNMENTS WCA ,
1320: HZ_PARTY_SITES HPS
1321: WHERE WCA.ASSOCIATION_TYPE = 'CARRIER_SITE'
1322: AND WCA.CARRIER_ID = HPS.PARTY_ID
1323: AND WCA.CARRIER_SITE_ID = HPS.PARTY_SITE_ID

Line 1341: wsh_calendar_assignments WCA

1337: HZ_CUST_SITE_USES_ALL HCSU,
1338: HZ_CUST_ACCOUNTS HCA,
1339: HZ_PARTY_SITES HPS,
1340: WSH_LOCATIONS WLO,
1341: wsh_calendar_assignments WCA
1342: WHERE HCAS.party_site_id = HPS.party_site_id
1343: AND HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
1344: AND HCAS.cust_account_id = hca.cust_account_id
1345: AND (HCSU.SITE_USE_ID = l_site_id OR

Line 1361: FROM WSH_CALENDAR_ASSIGNMENTS WCA ,

1357: UNION ALL
1358:
1359: SELECT WCA.CALENDAR_CODE,
1360: WCA.ENABLED_FLAG
1361: FROM WSH_CALENDAR_ASSIGNMENTS WCA ,
1362: WSH_LOCATIONS WLO,
1363: HR_ORGANIZATION_UNITS HOU
1364: WHERE HOU.LOCATION_ID = WLO.source_LOCATION_ID
1365: And wlo.location_source_code='HR'