DBA Data[Home] [Help]

APPS.WSH_CAL_ASG_VALIDATIONS dependencies on WSH_LOCATIONS

Line 1078: wsh_locations wl

1074: FROM WSH_CALENDAR_ASSIGNMENTS WCA,
1075: hz_relationships rel,
1076: hz_party_sites hps,
1077: hz_party_site_uses hpsu,
1078: wsh_locations wl
1079: WHERE WCA.ASSOCIATION_TYPE = 'VENDOR_LOCATION'
1080: AND WCA.LOCATION_ID = WL.WSH_LOCATION_ID
1081: AND hps.party_id = rel.subject_id
1082: AND hps.party_site_id = hpsu.party_site_id

Line 1104: WSH_LOCATIONS WLO,

1100: FROM HZ_CUST_ACCT_SITES_ALL HCAS,
1101: HZ_CUST_SITE_USES_ALL HCSU,
1102: HZ_PARTY_SITES HPS,
1103: HZ_CUST_ACCOUNTS HCA,
1104: WSH_LOCATIONS WLO,
1105: WSH_CALENDAR_ASSIGNMENTS WCA
1106: WHERE HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
1107: and HCAS.PARTY_SITE_ID = HPS.PARTY_SITE_ID
1108: AND HCAS.cust_account_id = hca.cust_account_id

Line 1126: WSH_LOCATIONS WLO

1122:
1123: SELECT WCA.CALENDAR_CODE,
1124: WCA.ENABLED_FLAG
1125: FROM WSH_CALENDAR_ASSIGNMENTS WCA ,
1126: WSH_LOCATIONS WLO
1127: WHERE WCA.ASSOCIATION_TYPE = 'HR_LOCATION'
1128: AND WCA.LOCATION_ID = WLO.WSH_LOCATION_ID(+)
1129: ----
1130: AND 'ORGANIZATION' = l_entity_type