APPS.OKL_LLA_UTIL_PVT dependencies on HZ_LOCATIONS

Line 974: FROM HZ_LOCATIONS HL,

970: CURSOR l_get_booked_Astloc_csr IS
971: SELECT SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL,HL.ADDRESS1,HL.ADDRESS2,HL.ADDRESS3,
972: HL.ADDRESS4,HL.CITY,HL.COUNTY,HL.STATE,HL.PROVINCE,HL.POSTAL_CODE,NULL,HL.COUNTRY,
973: NULL, NULL,NULL,NULL,NULL,NULL,NULL,'N','N',80,1,1),1,80) DESCRIPTION
974: FROM HZ_LOCATIONS HL,
975: CSI_ITEM_INSTANCES CSI,
976: OKC_K_ITEMS CIM
977: WHERE CIM.CLE_ID = (SELECT A.ID
978: FROM OKC_K_LINES_V A,

Line 995: AND CSI.INSTALL_LOCATION_TYPE_CODE = 'HZ_LOCATIONS'

991: AND CIM.OBJECT1_ID1 = CSI.INSTANCE_ID
992: AND CIM.OBJECT1_ID2 = '#'
993: AND CIM.JTOT_OBJECT1_CODE = 'OKX_IB_ITEM'
994: AND CSI.INSTALL_LOCATION_ID = HL.LOCATION_ID
995: AND CSI.INSTALL_LOCATION_TYPE_CODE = 'HZ_LOCATIONS'
996: UNION
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

Line 1000: FROM HZ_LOCATIONS HL,

996: UNION
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

Line 1086: FROM HZ_LOCATIONS HL,

1082: WHERE ID = p_khr_id;
1083:
1084: CURSOR l_get_booked_Astloc_csr IS
1085: SELECT psu.party_site_use_id
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

Line 1109: AND CSI.INSTALL_LOCATION_TYPE_CODE = 'HZ_LOCATIONS'

1105: AND CIM.OBJECT1_ID1 = CSI.INSTANCE_ID
1106: AND CIM.OBJECT1_ID2 = '#'
1107: AND CIM.JTOT_OBJECT1_CODE = 'OKX_IB_ITEM'
1108: AND CSI.INSTALL_LOCATION_ID = HL.LOCATION_ID
1109: AND CSI.INSTALL_LOCATION_TYPE_CODE = 'HZ_LOCATIONS'
1110: AND psu.site_use_type ='INSTALL_AT'
1111: AND psu.party_site_id = hps.party_site_id
1112: AND hps.location_id = hl.location_id
1113: UNION

Line 1115: FROM HZ_LOCATIONS HL,

1111: AND psu.party_site_id = hps.party_site_id
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

Line 1297: ,hz_locations hzl

1293: from
1294: hz_party_sites hzps
1295: ,hz_parties hz
1296: ,ap_suppliers aps
1297: ,hz_locations hzl
1298: where
1299: hzps.party_id = hz.party_id
1300: and hzps.IDENTIFYING_ADDRESS_FLAG = 'Y'
1301: and hz.party_id = aps.party_id

Line 1323: ,hz_locations hzl

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
1326: and party_site_id = p_party_site_id
1327: and hzps.location_id = hzl.location_id;