[Home] [Help]
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'
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'
1051:
1052: CURSOR c_get_calendar_code IS
1053: SELECT WCA.CALENDAR_CODE,
1054: WCA.ENABLED_FLAG
1055: FROM WSH_CALENDAR_ASSIGNMENTS WCA ,
1056: PO_VENDORS POV ,
1057: PO_VENDOR_SITES_all POVS ,
1058: hr_organization_units HR
1059: WHERE WCA.ASSOCIATION_TYPE = 'VENDOR_SITE'
1070: UNION ALL
1071:
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
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
1109: AND HPS.LOCATION_ID = WLO.source_location_id(+)
1121: UNION ALL
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: ----
1136: WCA.LOCATION_ID =p_location_id)
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