APPS.OKL_UTIL dependencies on OKC_K_LINES_B

Line 17: OKC_K_LINES_B FREEFORM2_CLE,

13:
14: CURSOR c_install_site ( p_k_financial_line NUMBER)IS
15: SELECT party_site_uses.country
16: FROM
17: OKC_K_LINES_B FREEFORM2_CLE,
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 ,

Line 19: OKC_K_LINES_B INSTITEM_CLE,

15: SELECT party_site_uses.country
16: FROM
17: OKC_K_LINES_B FREEFORM2_CLE,
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

Line 65: OKC_K_LINES_B instance_CLE,

61:
62: CURSOR c_install_site ( p_k_financial_line NUMBER)IS
63: select PARTY_SITES_USES.country
64: from
65: OKC_K_LINES_B instance_CLE,
66: OKC_LINE_STYLES_B instance_LS,
67: OKC_K_LINES_B IB_CLE,
68: OKC_LINE_STYLES_B IB_LS,
69: CSI_ITEM_INSTANCES INSTALL_BASE,

Line 67: OKC_K_LINES_B IB_CLE,

63: select PARTY_SITES_USES.country
64: from
65: OKC_K_LINES_B instance_CLE,
66: OKC_LINE_STYLES_B instance_LS,
67: OKC_K_LINES_B IB_CLE,
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,

Line 90: OKC_K_LINES_B instance_CLE,

86: AND instance_CLE.cle_id = p_k_financial_line
87: union
88: select HZ_LOCATIONS.country
89: from
90: OKC_K_LINES_B instance_CLE,
91: OKC_LINE_STYLES_B instance_LS,
92: OKC_K_LINES_B IB_CLE,
93: OKC_LINE_STYLES_B IB_LS,
94: CSI_ITEM_INSTANCES INSTALL_BASE,

Line 92: OKC_K_LINES_B IB_CLE,

88: select HZ_LOCATIONS.country
89: from
90: OKC_K_LINES_B instance_CLE,
91: OKC_LINE_STYLES_B instance_LS,
92: OKC_K_LINES_B IB_CLE,
93: OKC_LINE_STYLES_B IB_LS,
94: CSI_ITEM_INSTANCES INSTALL_BASE,
95: OKC_K_ITEMS INSTANCE_ITEM,
96: HZ_LOCATIONS HZ_LOCATIONS