DBA Data[Home] [Help]

APPS.OKC_TERMS_COPY_PVT dependencies on OKC_BUS_VARIABLES_B

Line 215: OKC_BUS_VARIABLES_B BUSVAR

211: get_variable_value_id(KART.ID,VAR.VARIABLE_CODE)) VARIABLE_VALUE_ID,
212: 'N' OVERRIDE_GLOBAL_YN
213: FROM OKC_ARTICLE_VARIABLES VAR,
214: OKC_K_ARTICLES_B KART,
215: OKC_BUS_VARIABLES_B BUSVAR
216: WHERE KART.ARTICLE_VERSION_ID=VAR.ARTICLE_VERSION_ID
217: AND KART.DOCUMENT_TYPE=p_target_doc_type
218: AND KART.DOCUMENT_ID=p_target_doc_id
219: AND BUSVAR.VARIABLE_CODE=VAR.VARIABLE_CODE

Line 235: OKC_BUS_VARIABLES_B BUSVAR

231: VAR.OVERRIDE_GLOBAL_YN
232: FROM OKC_K_ART_VARIABLES VAR,
233: OKC_K_ARTICLES_B KART,
234: OKC_K_ARTICLES_B KART1,
235: OKC_BUS_VARIABLES_B BUSVAR
236: WHERE KART.DOCUMENT_TYPE=p_target_doc_type
237: AND KART.DOCUMENT_ID=p_target_doc_id
238: AND KART1.DOCUMENT_TYPE=p_source_doc_type
239: AND KART1.DOCUMENT_ID=p_source_doc_id