VIEW: APPS.OKC_EBIZ_KHEADERS_V

Source

View Text - Preformatted

SELECT chrb.rowid ROW_ID, CHRB.ID CONTRACT_ID, CHRB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CHRB.STS_CODE STATUS_CODE, STS.MEANING STATUS_MEANING, CHRB.SCS_CODE SUBCLASS_CODE, SC.MEANING subclass_meaning, CHRB.QCL_ID QCL_ID, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER, CHRB.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER, CHRB.estimated_amount Contract_Amount, chrb.currency_code currency_code, CHRB.CUST_PO_NUMBER_REQ_YN CUST_PO_NUMBER_REQ_YN, CHRB.PRE_PAY_REQ_YN PRE_PAY_REQ_YN, CHRB.CUST_PO_NUMBER CUST_PO_NUMBER, CHRT.SHORT_DESCRIPTION SHORT_DESCRIPTION, CHRT.COMMENTS COMMENTS, CHRT.DESCRIPTION DESCRIPTION, CHRB.DPAS_RATING DPAS_RATING, CHRT.COGNOMEN KNOWN_AS, CHRB.TEMPLATE_YN TEMPLATE_YN, CHRB.TEMPLATE_USED TEMPLATE_USED, CHRB.DATE_APPROVED DATE_APPROVED, CHRB.DATETIME_CANCELLED DATETIME_CANCELLED, CHRB.AUTO_RENEW_DAYS AUTO_RENEW_DAYS, CHRB.DATE_SIGNED DATE_SIGNED, CHRB.DATE_TERMINATED DATE_TERMINATED, CHRB.DATE_RENEWED DATE_RENEWED, CHRB.TRN_CODE TRN_CODE, CHRB.START_DATE START_DATE, CHRB.END_DATE END_DATE, CHRB.AUTHORING_ORG_ID AUTHORING_ORG_ID, okc_util.get_k_access_level(chrb.id, chrb.scs_code) user_access_level, chrb.application_id application_id, CHRB.CREATED_BY CREATED_BY, CHRB.CREATION_DATE CREATION_DATE, CHRB.LAST_UPDATED_BY LAST_UPDATED_BY, CHRB.LAST_UPDATE_DATE LAST_UPDATE_DATE, CHRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CHRB.ORG_ID ORG_ID, HR.NAME OPERATING_UNIT FROM OKC_STATUSES_TL STS, OKC_SUBCLASSES_TL SC, OKC_K_HEADERS_ALL_B CHRB, OKC_K_HEADERS_TL CHRT , HR_ALL_ORGANIZATION_UNITS_TL HR WHERE CHRB.ID = CHRT.ID AND CHRT.LANGUAGE = USERENV('LANG') AND sts.code = chrb.sts_code and sts.language = USERENV('LANG') and sc.code = chrb.scs_code and sc.language = USERENV('LANG') and hr.organization_id = chrb.org_id and hr.language = USERENV('LANG')

View Text - HTML Formatted

SELECT CHRB.ROWID ROW_ID
, CHRB.ID CONTRACT_ID
, CHRB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CHRB.STS_CODE STATUS_CODE
, STS.MEANING STATUS_MEANING
, CHRB.SCS_CODE SUBCLASS_CODE
, SC.MEANING SUBCLASS_MEANING
, CHRB.QCL_ID QCL_ID
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, CHRB.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, CHRB.ESTIMATED_AMOUNT CONTRACT_AMOUNT
, CHRB.CURRENCY_CODE CURRENCY_CODE
, CHRB.CUST_PO_NUMBER_REQ_YN CUST_PO_NUMBER_REQ_YN
, CHRB.PRE_PAY_REQ_YN PRE_PAY_REQ_YN
, CHRB.CUST_PO_NUMBER CUST_PO_NUMBER
, CHRT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, CHRT.COMMENTS COMMENTS
, CHRT.DESCRIPTION DESCRIPTION
, CHRB.DPAS_RATING DPAS_RATING
, CHRT.COGNOMEN KNOWN_AS
, CHRB.TEMPLATE_YN TEMPLATE_YN
, CHRB.TEMPLATE_USED TEMPLATE_USED
, CHRB.DATE_APPROVED DATE_APPROVED
, CHRB.DATETIME_CANCELLED DATETIME_CANCELLED
, CHRB.AUTO_RENEW_DAYS AUTO_RENEW_DAYS
, CHRB.DATE_SIGNED DATE_SIGNED
, CHRB.DATE_TERMINATED DATE_TERMINATED
, CHRB.DATE_RENEWED DATE_RENEWED
, CHRB.TRN_CODE TRN_CODE
, CHRB.START_DATE START_DATE
, CHRB.END_DATE END_DATE
, CHRB.AUTHORING_ORG_ID AUTHORING_ORG_ID
, OKC_UTIL.GET_K_ACCESS_LEVEL(CHRB.ID
, CHRB.SCS_CODE) USER_ACCESS_LEVEL
, CHRB.APPLICATION_ID APPLICATION_ID
, CHRB.CREATED_BY CREATED_BY
, CHRB.CREATION_DATE CREATION_DATE
, CHRB.LAST_UPDATED_BY LAST_UPDATED_BY
, CHRB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CHRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CHRB.ORG_ID ORG_ID
, HR.NAME OPERATING_UNIT
FROM OKC_STATUSES_TL STS
, OKC_SUBCLASSES_TL SC
, OKC_K_HEADERS_ALL_B CHRB
, OKC_K_HEADERS_TL CHRT
, HR_ALL_ORGANIZATION_UNITS_TL HR
WHERE CHRB.ID = CHRT.ID
AND CHRT.LANGUAGE = USERENV('LANG')
AND STS.CODE = CHRB.STS_CODE
AND STS.LANGUAGE = USERENV('LANG')
AND SC.CODE = CHRB.SCS_CODE
AND SC.LANGUAGE = USERENV('LANG')
AND HR.ORGANIZATION_ID = CHRB.ORG_ID
AND HR.LANGUAGE = USERENV('LANG')