View: OKC_TERMS_STRUCTURE_V

Product:	OKC - Contracts Core
Description:
Implementation/DBA Data:	APPS.OKC_TERMS_STRUCTURE_V

View Text

SELECT KART.ID
, OKC_TERMS_UTIL_PVT.GET_ARTICLE_NAME( KART.SAV_SAE_ID
, OKC_TERMS_UTIL_PVT.GET_LATEST_TMPL_ART_VERSION_ID( KART.SAV_SAE_ID
, TMPL.START_DATE
, TMPL.END_DATE
, TMPL.STATUS_CODE
, KART.DOCUMENT_TYPE
, KART.DOCUMENT_ID))
, KART.SCN_ID
, 'SECTION'
, KART.SAV_SAE_ID
, OKC_TERMS_UTIL_PVT.GET_LATEST_TMPL_ART_VERSION_ID( KART.SAV_SAE_ID
, TMPL.START_DATE
, TMPL.END_DATE
, TMPL.STATUS_CODE
, KART.DOCUMENT_TYPE
, KART.DOCUMENT_ID)
, KART.DISPLAY_SEQUENCE
, KART.LABEL
, 'ARTICLE'
, KART.DOCUMENT_ID
, KART.DOCUMENT_TYPE
, KART.MANDATORY_YN
, OKC_TERMS_UTIL_PVT.HAS_ALTERNATES( KART.SAV_SAE_ID
, TMPL.START_DATE
, TMPL.END_DATE
, TMPL.ORG_ID
, 'TEMPLATE')
, 'Y'
, KART.OBJECT_VERSION_NUMBER
, DECODE(KART.SOURCE_FLAG
, 'R'
, 'Y'
, 'N')
, KART.MANDATORY_RWA
, NULL
FROM OKC_K_ARTICLES_B KART
, OKC_TERMS_TEMPLATES_ALL TMPL
WHERE KART.DOCUMENT_TYPE = 'TEMPLATE'
AND KART.DOCUMENT_ID = TMPL.TEMPLATE_ID
AND NVL(KART.AMENDMENT_OPERATION_CODE
, '?') <> 'DELETED'
AND NVL(KART.SUMMARY_AMEND_OPERATION_CODE
, '?') <> 'DELETED' UNION ALL SELECT DOCUMENT_ID
, OKC_TERMS_UTIL_PVT.GET_MESSAGE('OKC'
, 'OKC_TERMS_CONTRACT_TERMS')
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, DOCUMENT_TYPE
, DOCUMENT_ID
, DOCUMENT_TYPE
, NULL
, NULL
, NULL
, OBJECT_VERSION_NUMBER
, NULL
, NULL
, NULL
FROM OKC_TEMPLATE_USAGES UNION ALL SELECT TEMPLATE_ID
, OKC_TERMS_UTIL_PVT.GET_MESSAGE('OKC'
, 'OKC_TERMS_CONTRACT_TERMS')
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, 'TEMPLATE'
, TEMPLATE_ID
, 'TEMPLATE'
, NULL
, NULL
, NULL
, OBJECT_VERSION_NUMBER
, NULL
, NULL
, NULL
FROM OKC_TERMS_TEMPLATES_ALL UNION ALL SELECT ID
, HEADING
, NVL(SCN_ID
, DOCUMENT_ID)
, DECODE(SCN_ID
, NULL
, DOCUMENT_TYPE
, 'SECTION')
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, SECTION_SEQUENCE
, LABEL
, 'SECTION'
, DOCUMENT_ID
, DOCUMENT_TYPE
, NULL
, NULL
, NULL
, OBJECT_VERSION_NUMBER
, NULL
, NULL
, NVL(DECODE (SEC.ORIG_SYSTEM_REFERENCE_CODE
, 'COPY'
, OKC_K_ENTITY_LOCKS_GRP.ISENTITYLOCKEDBYOTHERDOC('SECTION'
, SEC.ORIG_SYSTEM_REFERENCE_ID1
, SEC.DOCUMENT_TYPE
, SEC.DOCUMENT_ID)
, 'N')
, 'N')
FROM OKC_SECTIONS_B SEC
WHERE NVL(SEC.AMENDMENT_OPERATION_CODE
, '?') <> 'DELETED'
AND NVL(SEC.SUMMARY_AMEND_OPERATION_CODE
, '?') <> 'DELETED' UNION ALL SELECT KART.ID
, OKC_TERMS_UTIL_PVT.GET_ARTICLE_NAME(ART.ARTICLE_ID
, VER.ARTICLE_VERSION_ID)
, KART.SCN_ID
, 'SECTION'
, KART.SAV_SAE_ID
, KART.ARTICLE_VERSION_ID
, KART.DISPLAY_SEQUENCE
, KART.LABEL
, 'ARTICLE'
, KART.DOCUMENT_ID
, KART.DOCUMENT_TYPE
, KART.MANDATORY_YN
, DECODE(ART.STANDARD_YN
, 'N'
, 'N'
, OKC_TERMS_UTIL_PVT.HAS_ALTERNATES(ART.ARTICLE_ID
, USG.ARTICLE_EFFECTIVE_DATE
, NULL
, TMPL.ORG_ID
, USG.DOCUMENT_TYPE))
, ART.STANDARD_YN
, KART.OBJECT_VERSION_NUMBER
, DECODE(KART.SOURCE_FLAG
, 'R'
, 'Y'
, 'N')
, KART.MANDATORY_RWA
, NVL( DECODE(KART.ORIG_SYSTEM_REFERENCE_CODE
, 'COPY'
, OKC_K_ENTITY_LOCKS_GRP.ISENTITYLOCKEDBYOTHERDOC('CLAUSE'
, KART.ORIG_SYSTEM_REFERENCE_ID1
, KART.DOCUMENT_TYPE
, KART.DOCUMENT_ID)
, 'N')
, 'N')
FROM OKC_K_ARTICLES_B KART
, OKC_TEMPLATE_USAGES USG
, OKC_ARTICLE_VERSIONS VER
, OKC_ARTICLES_ALL ART
, OKC_TERMS_TEMPLATES_ALL TMPL
WHERE KART.ARTICLE_VERSION_ID = VER.ARTICLE_VERSION_ID
AND VER.ARTICLE_ID = ART.ARTICLE_ID
AND USG.DOCUMENT_TYPE <> 'TEMPLATE'
AND USG.DOCUMENT_TYPE = KART.DOCUMENT_TYPE
AND USG.DOCUMENT_ID = KART.DOCUMENT_ID
AND NVL(KART.AMENDMENT_OPERATION_CODE
, '?') <> 'DELETED'
AND NVL(KART.SUMMARY_AMEND_OPERATION_CODE
, '?') <> 'DELETED'
AND USG.TEMPLATE_ID = TMPL.TEMPLATE_ID

Columns