APPS.OKL_LLA_UTIL_PVT dependencies on HZ_LOCATIONS

Line 975: FROM HZ_LOCATIONS HL,

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

Line 996: AND CSI.INSTALL_LOCATION_TYPE_CODE = 'HZ_LOCATIONS'

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

Line 1001: FROM HZ_LOCATIONS HL,

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

Line 1087: FROM HZ_LOCATIONS HL,

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

Line 1110: AND CSI.INSTALL_LOCATION_TYPE_CODE = 'HZ_LOCATIONS'

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

Line 1116: FROM HZ_LOCATIONS HL,

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

Line 1298: ,hz_locations hzl

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

Line 1324: ,hz_locations hzl

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