DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_WEB dependencies on OKX_COUNTRIES_V

Line 1309: OKX_COUNTRIES_V okxCountry

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,
1309: OKX_COUNTRIES_V okxCountry
1310: WHERE hdr.ID=p_contract_id
1311: AND CS.SITE_USE_ID = hdr.BILL_TO_SITE_USE_ID
1312: AND CA.CUST_ACCT_SITE_ID = CS.CUST_ACCT_SITE_ID
1313: AND PS.PARTY_SITE_ID = CA.PARTY_SITE_ID

Line 1329: OKX_COUNTRIES_V okxCountry

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,
1329: OKX_COUNTRIES_V okxCountry
1330: WHERE
1331: hdr.ID=p_contract_id
1332: AND CS.SITE_USE_ID = hdr.SHIP_TO_SITE_USE_ID
1333: AND CA.CUST_ACCT_SITE_ID = CS.CUST_ACCT_SITE_ID

Line 1530: from OKX_COUNTRIES_V okxCountry

1526:
1527: CURSOR country_name_cur(p_country_code VARCHAR2)
1528: IS
1529: select okxCountry.Name CountryName
1530: from OKX_COUNTRIES_V okxCountry
1531: where okxCountry.ID1=p_country_code;
1532:
1533:
1534: CURSOR cntrct_line_addr_cur(p_line_id NUMBER)