APPS.OKL_UTIL dependencies on OKC_LINE_STYLES_B

Line 18: OKC_LINE_STYLES_B FREEFORM2_LSE,

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 ,
22: OKX_PARTY_SITE_USES_V PARTY_SITE_USES,

Line 20: OKC_LINE_STYLES_B INSTITEM_LSE,

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
24: WHERE party_site_uses.country = okx_country.id1

Line 66: OKC_LINE_STYLES_B instance_LS,

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,
70: OKC_K_ITEMS INSTANCE_ITEM,

Line 68: OKC_LINE_STYLES_B IB_LS,

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,
72: OKX_PARTY_SITE_USES_V PARTY_SITES_USES

Line 91: OKC_LINE_STYLES_B instance_LS,

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,
95: OKC_K_ITEMS INSTANCE_ITEM,

Line 93: OKC_LINE_STYLES_B IB_LS,

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
97: WHERE