APPS.OKL_LLA_UTIL_PVT dependencies on HZ_PARTY_SITES

Line 1001: HZ_PARTY_SITES HPS,

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

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

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

Line 1090: hz_party_sites hps

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

Line 1116: HZ_PARTY_SITES HPS,

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

Line 1139: AND CSI.INSTALL_LOCATION_TYPE_CODE = 'HZ_PARTY_SITES'

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

Line 1294: hz_party_sites hzps

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

Line 1321: hz_party_sites hzps

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