APPS.OKC_TERMS_QA_PVT dependencies on OKC_BUS_DOC_TYPES_V

Line 1535: okc_bus_doc_types_v busdoc

1531: busdoc.name doc_type
1532: FROM okc_k_articles_b kart,
1533: okc_k_art_variables var,
1534: okc_bus_variables_vl busvar,
1535: okc_bus_doc_types_v busdoc
1536: WHERE kart.document_type=p_doc_type
1537: and kart.document_id=p_doc_id
1538: and var.cat_id=kart.id
1539: and var.variable_type IN ('S','D')

Line 1562: okc_bus_doc_types_v busdoc

1558: okc_article_versions vers,
1559: okc_allowed_tmpl_usages allwd ,
1560: okc_article_variables var,
1561: okc_bus_variables_vl busvar ,
1562: okc_bus_doc_types_v busdoc
1563: WHERE kart.document_type=G_TMPL_DOC_TYPE
1564: and kart.document_id=p_doc_id
1565: and allwd.template_id=kart.document_id
1566: and kart.sav_sae_id=vers.article_id

Line 1606: okc_bus_doc_types_v busdoc

1602: busdoc.name doc_type
1603: FROM okc_k_articles_b kart,
1604: okc_k_art_variables var,
1605: okc_bus_variables_vl busvar,
1606: okc_bus_doc_types_v busdoc
1607: WHERE kart.document_type=p_doc_type
1608: and kart.document_id=p_doc_id
1609: and var.cat_id=kart.id
1610: and var.variable_type IN ('S','D')

Line 1638: okc_bus_doc_types_v busdoc

1634: okc_article_versions vers,
1635: okc_allowed_tmpl_usages allwd ,
1636: okc_article_variables var,
1637: okc_bus_variables_vl busvar ,
1638: okc_bus_doc_types_v busdoc
1639: WHERE kart.document_type=G_TMPL_DOC_TYPE
1640: and kart.document_id=p_doc_id
1641: and allwd.template_id=kart.document_id
1642: and kart.sav_sae_id=vers.article_id

Line 1695: okc_bus_doc_types_v busdoc

1691: okc_allowed_tmpl_usages allwd ,
1692: okc_article_versions vers,
1693: okc_article_variables var,
1694: okc_bus_variables_vl busvar ,
1695: okc_bus_doc_types_v busdoc
1696: WHERE rule.template_id = p_doc_id
1697: and allwd.template_id=p_doc_id
1698: and vers.article_id = rule.clause_id
1699: and vers.article_version_id =