DBA Data[Home] [Help]

APPS.OKL_UTIL dependencies on OKX_PARTY_SITE_USES_V

Line 22: OKX_PARTY_SITE_USES_V PARTY_SITE_USES,

18: OKC_LINE_STYLES_B FREEFORM2_LSE,
19: OKC_K_LINES_B INSTITEM_CLE,
20: OKC_LINE_STYLES_B INSTITEM_LSE,
21: OKL_TXL_ITM_INSTS OTITM ,
22: OKX_PARTY_SITE_USES_V PARTY_SITE_USES,
23: OKX_COUNTRIES_V OKX_COUNTRY
24: WHERE party_site_uses.country = okx_country.id1
25: AND party_site_uses.site_use_type = 'INSTALL_AT'
26: AND PARTY_SITE_USES.ID1 = OTITM.object_id1_new -- location

Line 72: OKX_PARTY_SITE_USES_V PARTY_SITES_USES

68: OKC_LINE_STYLES_B IB_LS,
69: CSI_ITEM_INSTANCES INSTALL_BASE,
70: OKC_K_ITEMS INSTANCE_ITEM,
71: HZ_PARTY_SITES PARTY_SITES,
72: OKX_PARTY_SITE_USES_V PARTY_SITES_USES
73: WHERE
74: PARTY_SITES_USES.site_use_type = 'INSTALL_AT'
75: AND PARTY_SITES_USES.PARTY_SITE_ID = PARTY_SITES.PARTY_SITE_ID
76: AND PARTY_SITES.PARTY_SITE_ID = INSTALL_BASE.INSTALL_LOCATION_ID