eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OKC_TERMS_QA_PVT dependencies on OKC_VARIABLE_DOC_TYPES

Line 1561: and not exists (SELECT 'x' from OKC_VARIABLE_DOC_TYPES vo

1557: and var.cat_id=kart.id
1558: and var.variable_type IN ('S','D')
1559: and var.variable_code=busvar.variable_code
1560: and busdoc.document_type = kart.document_type
1561: and not exists (SELECT 'x' from OKC_VARIABLE_DOC_TYPES vo
1562: WHERE var.variable_code=vo.variable_code
1563: and doc_type=p_doc_type)
1564: and p_doc_type<>G_TMPL_DOC_TYPE
1565: and nvl(kart.amendment_operation_code,'?')<>G_AMEND_CODE_DELETED

Line 1595: and not exists (SELECT 'x' FROM OKC_VARIABLE_DOC_TYPES vo

1591: and vers.article_version_id=var.article_version_id
1592: and busvar.variable_code=var.variable_code
1593: and busvar.variable_type IN ('S','D')
1594: and busdoc.document_type = allwd.document_type
1595: and not exists (SELECT 'x' FROM OKC_VARIABLE_DOC_TYPES vo
1596: WHERE var.variable_code=vo.variable_code
1597: and doc_type=allwd.document_type)
1598: and p_doc_type=G_TMPL_DOC_TYPE
1599: and nvl(kart.amendment_operation_code,'?')<>G_AMEND_CODE_DELETED

Line 1634: and not exists (SELECT 'x' from OKC_VARIABLE_DOC_TYPES vo

1630: and var.variable_code=busvar.variable_code
1631: --Repository Enhancement 12.1 (For Validate Action)
1632: and busdoc.document_type = kart.document_type
1633: -- and busdoc.document_type = p_rep_doc_type
1634: and not exists (SELECT 'x' from OKC_VARIABLE_DOC_TYPES vo
1635: WHERE var.variable_code=vo.variable_code
1636: --Repository Enhancement 12.1 (For Validate Action)
1637: -- and doc_type=p_doc_type)
1638: and doc_type= p_rep_doc_type)

Line 1681: and not exists ((SELECT 'x' FROM OKC_VARIABLE_DOC_TYPES vo

1677: and vers.article_version_id=var.article_version_id
1678: and busvar.variable_code=var.variable_code
1679: and busvar.variable_type IN ('S','D')
1680: and busdoc.document_type = allwd.document_type
1681: and not exists ((SELECT 'x' FROM OKC_VARIABLE_DOC_TYPES vo
1682: WHERE var.variable_code=vo.variable_code
1683: and doc_type=allwd.document_type)
1684: UNION ALL
1685: (SELECT 'x' FROM OKC_VARIABLE_DOC_TYPES vo

Line 1685: (SELECT 'x' FROM OKC_VARIABLE_DOC_TYPES vo

1681: and not exists ((SELECT 'x' FROM OKC_VARIABLE_DOC_TYPES vo
1682: WHERE var.variable_code=vo.variable_code
1683: and doc_type=allwd.document_type)
1684: UNION ALL
1685: (SELECT 'x' FROM OKC_VARIABLE_DOC_TYPES vo
1686: WHERE var.variable_code=vo.variable_code
1687: and doc_type like '%REPOSITORY%'))
1688: and p_doc_type=G_TMPL_DOC_TYPE
1689: and nvl(kart.amendment_operation_code,'?')<>G_AMEND_CODE_DELETED

Line 1730: and not exists (select 'x' from OKC_VARIABLE_DOC_TYPES vo

1726: and var.article_version_id = vers.article_version_id
1727: and busvar.variable_code = var.variable_code
1728: and busvar.variable_type IN ('S','D')
1729: and busdoc.document_type = allwd.document_type
1730: and not exists (select 'x' from OKC_VARIABLE_DOC_TYPES vo
1731: where vo.variable_code=var.variable_code
1732: and vo.doc_type=allwd.document_type) ;
1733: */
1734:

Line 2088: and ( (var.variable_type = 'U' AND busvar.variable_source = 'M') OR exists (( SELECT 'x' FROM okc_variable_doc_types vo

2084: and var.cat_id=kart.id
2085: and busvar.variable_code=var.variable_code
2086: and nvl(kart.amendment_operation_code,'?')<>G_AMEND_CODE_DELETED
2087: and nvl(kart.summary_amend_operation_code,'?')<>G_AMEND_CODE_DELETED
2088: and ( (var.variable_type = 'U' AND busvar.variable_source = 'M') OR exists (( SELECT 'x' FROM okc_variable_doc_types vo
2089: WHERE vo.variable_code = var.variable_code
2090: AND vo.doc_type = p_doc_type
2091: )UNION all ( SELECT 'x' FROM okc_variable_doc_types vo
2092: WHERE vo.variable_code = var.variable_code

Line 2091: )UNION all ( SELECT 'x' FROM okc_variable_doc_types vo

2087: and nvl(kart.summary_amend_operation_code,'?')<>G_AMEND_CODE_DELETED
2088: and ( (var.variable_type = 'U' AND busvar.variable_source = 'M') OR exists (( SELECT 'x' FROM okc_variable_doc_types vo
2089: WHERE vo.variable_code = var.variable_code
2090: AND vo.doc_type = p_doc_type
2091: )UNION all ( SELECT 'x' FROM okc_variable_doc_types vo
2092: WHERE vo.variable_code = var.variable_code
2093: AND vo.doc_type LIKE '%REPOSITORY%'))) ;
2094:
2095: