APPS.OKC_TERMS_QA_PVT dependencies on OKC_BUS_DOC_TYPES_V

Line 1554: okc_bus_doc_types_v busdoc

1550: busdoc.name doc_type
1551: FROM okc_k_articles_b kart,
1552: okc_k_art_variables var,
1553: okc_bus_variables_vl busvar,
1554: okc_bus_doc_types_v busdoc
1555: WHERE kart.document_type=p_doc_type
1556: and kart.document_id=p_doc_id
1557: and var.cat_id=kart.id
1558: and var.variable_type IN ('S','D')

Line 1581: okc_bus_doc_types_v busdoc

1577: okc_article_versions vers,
1578: okc_allowed_tmpl_usages allwd ,
1579: okc_article_variables var,
1580: okc_bus_variables_vl busvar ,
1581: okc_bus_doc_types_v busdoc
1582: WHERE kart.document_type=G_TMPL_DOC_TYPE
1583: and kart.document_id=p_doc_id
1584: and allwd.template_id=kart.document_id
1585: and kart.sav_sae_id=vers.article_id

Line 1625: okc_bus_doc_types_v busdoc

1621: busdoc.name doc_type
1622: FROM okc_k_articles_b kart,
1623: okc_k_art_variables var,
1624: okc_bus_variables_vl busvar,
1625: okc_bus_doc_types_v busdoc
1626: WHERE kart.document_type=p_doc_type
1627: and kart.document_id=p_doc_id
1628: and var.cat_id=kart.id
1629: and var.variable_type IN ('S','D')

Line 1657: okc_bus_doc_types_v busdoc

1653: okc_article_versions vers,
1654: okc_allowed_tmpl_usages allwd ,
1655: okc_article_variables var,
1656: okc_bus_variables_vl busvar ,
1657: okc_bus_doc_types_v busdoc
1658: WHERE kart.document_type=G_TMPL_DOC_TYPE
1659: and kart.document_id=p_doc_id
1660: and allwd.template_id=kart.document_id
1661: and kart.sav_sae_id=vers.article_id

Line 1714: okc_bus_doc_types_v busdoc

1710: okc_allowed_tmpl_usages allwd ,
1711: okc_article_versions vers,
1712: okc_article_variables var,
1713: okc_bus_variables_vl busvar ,
1714: okc_bus_doc_types_v busdoc
1715: WHERE rule.template_id = p_doc_id
1716: and allwd.template_id=p_doc_id
1717: and vers.article_id = rule.clause_id
1718: and vers.article_version_id =