DBA Data[Home] [Help]

APPS.WSH_CAL_ASG_VALIDATIONS dependencies on HZ_PARTY_SITES

Line 1076: hz_party_sites hps,

1072: SELECT WCA.CALENDAR_CODE,
1073: WCA.ENABLED_FLAG
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

Line 1102: HZ_PARTY_SITES HPS,

1098: SELECT WCA.CALENDAR_CODE,
1099: WCA.ENABLED_FLAG
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

Line 1141: HZ_PARTY_SITES HPS

1137: UNION ALL
1138: SELECT WCA.CALENDAR_CODE,
1139: WCA.ENABLED_FLAG
1140: FROM WSH_CALENDAR_ASSIGNMENTS WCA ,
1141: HZ_PARTY_SITES HPS
1142: WHERE WCA.ASSOCIATION_TYPE = 'CARRIER_SITE'
1143: AND WCA.CARRIER_ID = HPS.PARTY_ID
1144: AND WCA.CARRIER_SITE_ID = HPS.PARTY_SITE_ID
1145: ----