DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_WEB dependencies on HZ_PARTY_SITES

Line 214: HZ_PARTY_SITES PSE,

210: SELECT PSE.PARTY_SITE_ID ID1
211: FROM OKC_K_PARTY_ROLES_B rle,
212: OKC_K_HEADERS_ALL_V hdr1,
213: okc_k_items itm,
214: HZ_PARTY_SITES PSE,
215: HZ_LOCATIONS LCN
216: WHERE rle.jtot_object1_code ='OKX_PARTY'
217: and rle.object1_id1 =to_number(p_party_id)
218: and rle.rle_code in ('CUSTOMER', 'SUBSCRIBER')

Line 542: HZ_PARTY_SITES PSE,

538: LCN.CITY,LCN.COUNTY,LCN.STATE,LCN.PROVINCE,LCN.POSTAL_CODE,NULL,LCN.COUNTRY,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'N','N',80,1,1),1,80) DESCRIPTION
539: FROM OKC_K_PARTY_ROLES_B rle,
540: OKC_K_HEADERS_ALL_V hdr1,
541: okc_k_items itm,
542: HZ_PARTY_SITES PSE,
543: HZ_LOCATIONS LCN
544: WHERE rle.jtot_object1_code = 'OKX_PARTY'
545: and rle.object1_id1 = to_number(p_party_id)
546: and rle.rle_code in ('CUSTOMER', 'SUBSCRIBER')

Line 1304: HZ_PARTY_SITES PS,

1300: IS
1301:
1302: SELECT okxCountry.Name BillToCountry
1303: FROM HZ_CUST_SITE_USES_ALL CS,
1304: HZ_PARTY_SITES PS,
1305: HZ_LOCATIONS L,
1306: HZ_CUST_ACCT_SITES_ALL CA,
1307: OKX_CUSTOMER_ACCOUNTS_V cus_b,
1308: OKC_K_HEADERS_ALL_B hdr,

Line 1324: HZ_PARTY_SITES PS,

1320: IS
1321:
1322: SELECT okxCountry.Name BillToCountry
1323: FROM HZ_CUST_SITE_USES_ALL CS,
1324: HZ_PARTY_SITES PS,
1325: HZ_LOCATIONS L,
1326: HZ_CUST_ACCT_SITES_ALL CA,
1327: OKX_CUSTOMER_ACCOUNTS_V cus_b,
1328: OKC_K_HEADERS_ALL_B hdr,

Line 1359: HZ_PARTY_SITES PS,

1355: decode(L.POSTAL_CODE,NULL,NULL,' '||L.POSTAL_CODE)
1356: BillToCityStateZip
1357: FROM
1358: HZ_CUST_SITE_USES_ALL CS,
1359: HZ_PARTY_SITES PS,
1360: HZ_LOCATIONS L,
1361: HZ_CUST_ACCT_SITES_ALL CA,
1362: OKX_CUSTOMER_ACCOUNTS_V cus_b,
1363: OKC_K_HEADERS_ALL_V hdr

Line 1391: HZ_PARTY_SITES PS,

1387: ShipToCityStateZip
1388: FROM
1389: OKX_CUSTOMER_ACCOUNTS_V cus_s,
1390: HZ_CUST_SITE_USES_ALL CS,
1391: HZ_PARTY_SITES PS,
1392: HZ_LOCATIONS L,
1393: HZ_CUST_ACCT_SITES_ALL CA,
1394: OKC_K_HEADERS_ALL_V hdr
1395: WHERE

Line 1550: HZ_PARTY_SITES PS,

1546: L.POSTAL_CODE ZipCode,
1547: L.COUNTRY Country
1548: FROM
1549: HZ_CUST_SITE_USES_ALL CS,
1550: HZ_PARTY_SITES PS,
1551: HZ_LOCATIONS L,
1552: HZ_CUST_ACCT_SITES_ALL CA,
1553: OKC_K_LINES_B okcLn
1554: WHERE okcLn.id = p_line_id

Line 2226: HZ_PARTY_SITES PS,

2222: From
2223: OKC_K_LINES_B okcLn,
2224: OKC_K_HEADERS_ALL_B hdr,
2225: HZ_CUST_SITE_USES_ALL CS,
2226: HZ_PARTY_SITES PS,
2227: HZ_LOCATIONS L,
2228: HZ_CUST_ACCT_SITES_ALL CA,
2229: OKX_CUSTOMER_ACCOUNTS_V cus
2230: Where