APPS.OKL_LLA_UTIL_PVT dependencies on HZ_PARTY_SITES

Line 1002: HZ_PARTY_SITES HPS,

998: SELECT SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL,HL.ADDRESS1,HL.ADDRESS2,HL.ADDRESS3,
999: HL.ADDRESS4,HL.CITY,HL.COUNTY,HL.STATE,HL.PROVINCE,HL.POSTAL_CODE,NULL,HL.COUNTRY,
1000: NULL, NULL,NULL,NULL,NULL,NULL,NULL,'N','N',80,1,1),1,80) DESCRIPTION
1001: FROM HZ_LOCATIONS HL,
1002: HZ_PARTY_SITES HPS,
1003: CSI_ITEM_INSTANCES CSI,
1004: OKC_K_ITEMS CIM
1005: WHERE CIM.CLE_ID = (SELECT A.ID
1006: FROM OKC_K_LINES_V A,

Line 1024: AND CSI.INSTALL_LOCATION_TYPE_CODE = 'HZ_PARTY_SITES';

1020: AND CIM.OBJECT1_ID2 = '#'
1021: AND CIM.JTOT_OBJECT1_CODE = 'OKX_IB_ITEM'
1022: AND CSI.INSTALL_LOCATION_ID = HPS.PARTY_SITE_ID
1023: AND HPS.LOCATION_ID = HL.LOCATION_ID
1024: AND CSI.INSTALL_LOCATION_TYPE_CODE = 'HZ_PARTY_SITES';
1025:
1026: CURSOR l_get_nonbooked_Astloc_csr IS
1027: SELECT B.DESCRIPTION
1028: FROM OKX_PARTY_SITE_USES_V B

Line 1091: hz_party_sites hps

1087: FROM HZ_LOCATIONS HL,
1088: CSI_ITEM_INSTANCES CSI,
1089: OKC_K_ITEMS CIM,
1090: hz_party_site_uses psu,
1091: hz_party_sites hps
1092: WHERE CIM.CLE_ID in (SELECT A.ID
1093: FROM OKC_K_LINES_V A,
1094: OKC_LINE_STYLES_B B
1095: WHERE CLE_ID in (SELECT A.ID

Line 1117: HZ_PARTY_SITES HPS,

1113: AND hps.location_id = hl.location_id
1114: UNION
1115: SELECT psu.party_site_use_id
1116: FROM HZ_LOCATIONS HL,
1117: HZ_PARTY_SITES HPS,
1118: HZ_PARTY_SITE_USES PSU,
1119: CSI_ITEM_INSTANCES CSI,
1120: OKC_K_ITEMS CIM
1121: WHERE CIM.CLE_ID in (SELECT A.ID

Line 1140: AND CSI.INSTALL_LOCATION_TYPE_CODE = 'HZ_PARTY_SITES'

1136: AND CIM.OBJECT1_ID2 = '#'
1137: AND CIM.JTOT_OBJECT1_CODE = 'OKX_IB_ITEM'
1138: AND CSI.INSTALL_LOCATION_ID = HPS.PARTY_SITE_ID
1139: AND HPS.LOCATION_ID = HL.LOCATION_ID
1140: AND CSI.INSTALL_LOCATION_TYPE_CODE = 'HZ_PARTY_SITES'
1141: AND psu.party_site_id = hps.party_site_id
1142: AND psu.site_use_type = 'INSTALL_AT';
1143:
1144: CURSOR l_get_nonbooked_Astloc_csr IS

Line 1295: hz_party_sites hzps

1291: ,hzl.county
1292: ,hzl.address_style
1293: ,hzl.province
1294: from
1295: hz_party_sites hzps
1296: ,hz_parties hz
1297: ,ap_suppliers aps
1298: ,hz_locations hzl
1299: where

Line 1322: hz_party_sites hzps

1318: ,hzl.county
1319: ,hzl.address_style
1320: ,hzl.province
1321: from
1322: hz_party_sites hzps
1323: ,ap_suppliers aps
1324: ,hz_locations hzl
1325: where
1326: hzps.party_id = aps.party_id