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.

APPS.OKC_TERMS_QA_PVT dependencies on OKC_VARIABLE_DOC_TYPES

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

1538: and var.cat_id=kart.id
1539: and var.variable_type IN ('S','D')
1540: and var.variable_code=busvar.variable_code
1541: and busdoc.document_type = kart.document_type
1542: and not exists (SELECT 'x' from OKC_VARIABLE_DOC_TYPES vo
1543: WHERE var.variable_code=vo.variable_code
1544: and doc_type=p_doc_type)
1545: and p_doc_type<>G_TMPL_DOC_TYPE
1546: and nvl(kart.amendment_operation_code,'?')<>G_AMEND_CODE_DELETED

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

1572: and vers.article_version_id=var.article_version_id
1573: and busvar.variable_code=var.variable_code
1574: and busvar.variable_type IN ('S','D')
1575: and busdoc.document_type = allwd.document_type
1576: and not exists (SELECT 'x' FROM OKC_VARIABLE_DOC_TYPES vo
1577: WHERE var.variable_code=vo.variable_code
1578: and doc_type=allwd.document_type)
1579: and p_doc_type=G_TMPL_DOC_TYPE
1580: and nvl(kart.amendment_operation_code,'?')<>G_AMEND_CODE_DELETED

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

1611: and var.variable_code=busvar.variable_code
1612: --Repository Enhancement 12.1 (For Validate Action)
1613: and busdoc.document_type = kart.document_type
1614: -- and busdoc.document_type = p_rep_doc_type
1615: and not exists (SELECT 'x' from OKC_VARIABLE_DOC_TYPES vo
1616: WHERE var.variable_code=vo.variable_code
1617: --Repository Enhancement 12.1 (For Validate Action)
1618: -- and doc_type=p_doc_type)
1619: and doc_type= p_rep_doc_type)

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

1658: and vers.article_version_id=var.article_version_id
1659: and busvar.variable_code=var.variable_code
1660: and busvar.variable_type IN ('S','D')
1661: and busdoc.document_type = allwd.document_type
1662: and not exists ((SELECT 'x' FROM OKC_VARIABLE_DOC_TYPES vo
1663: WHERE var.variable_code=vo.variable_code
1664: and doc_type=allwd.document_type)
1665: UNION ALL
1666: (SELECT 'x' FROM OKC_VARIABLE_DOC_TYPES vo

Line 1666: (SELECT 'x' FROM OKC_VARIABLE_DOC_TYPES vo

1662: and not exists ((SELECT 'x' FROM OKC_VARIABLE_DOC_TYPES vo
1663: WHERE var.variable_code=vo.variable_code
1664: and doc_type=allwd.document_type)
1665: UNION ALL
1666: (SELECT 'x' FROM OKC_VARIABLE_DOC_TYPES vo
1667: WHERE var.variable_code=vo.variable_code
1668: and doc_type like '%REPOSITORY%'))
1669: and p_doc_type=G_TMPL_DOC_TYPE
1670: and nvl(kart.amendment_operation_code,'?')<>G_AMEND_CODE_DELETED

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

1707: and var.article_version_id = vers.article_version_id
1708: and busvar.variable_code = var.variable_code
1709: and busvar.variable_type IN ('S','D')
1710: and busdoc.document_type = allwd.document_type
1711: and not exists (select 'x' from OKC_VARIABLE_DOC_TYPES vo
1712: where vo.variable_code=var.variable_code
1713: and vo.doc_type=allwd.document_type) ;
1714: */
1715:

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

2062: and var.cat_id=kart.id
2063: and busvar.variable_code=var.variable_code
2064: and nvl(kart.amendment_operation_code,'?')<>G_AMEND_CODE_DELETED
2065: and nvl(kart.summary_amend_operation_code,'?')<>G_AMEND_CODE_DELETED
2066: and ( (var.variable_type = 'U' AND busvar.variable_source = 'M') OR exists (( SELECT 'x' FROM okc_variable_doc_types vo
2067: WHERE vo.variable_code = var.variable_code
2068: AND vo.doc_type = p_doc_type
2069: )UNION all ( SELECT 'x' FROM okc_variable_doc_types vo
2070: WHERE vo.variable_code = var.variable_code

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

2065: and nvl(kart.summary_amend_operation_code,'?')<>G_AMEND_CODE_DELETED
2066: and ( (var.variable_type = 'U' AND busvar.variable_source = 'M') OR exists (( SELECT 'x' FROM okc_variable_doc_types vo
2067: WHERE vo.variable_code = var.variable_code
2068: AND vo.doc_type = p_doc_type
2069: )UNION all ( SELECT 'x' FROM okc_variable_doc_types vo
2070: WHERE vo.variable_code = var.variable_code
2071: AND vo.doc_type LIKE '%REPOSITORY%'))) ;
2072:
2073: