View: OKL_VP_AGREEMENT_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_VP_AGREEMENT_UV

View Text

SELECT CHRB.ID ID
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, CHRB.AUTHORING_ORG_ID AUTHORING_ORG_ID
, CHRB.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, CHRB.CHR_ID_RESPONSE CHR_ID_RESPONSE
, CHRB.CHR_ID_AWARD CHR_ID_AWARD
, CHRB.CHR_ID_RENEWED CHR_ID_RENEWED
, CHRB.INV_ORGANIZATION_ID INV_ORGANIZATION_ID
, CHRB.STS_CODE STS_CODE
, CHRB.QCL_ID QCL_ID
, CHRB.SCS_CODE SCS_CODE
, CHRB.TRN_CODE TRN_CODE
, CHRB.CURRENCY_CODE CURRENCY_CODE
, CHRB.ARCHIVED_YN ARCHIVED_YN
, CHRB.DELETED_YN DELETED_YN
, CHRB.TEMPLATE_YN TEMPLATE_YN
, CHRB.CHR_TYPE CHR_TYPE
, CHRB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, 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
, CHRB.DPAS_RATING DPAS_RATING
, CHRB.TEMPLATE_USED TEMPLATE_USED
, CHRB.DATE_APPROVED DATE_APPROVED
, CHRB.DATETIME_CANCELLED DATETIME_CANCELLED
, CHRB.AUTO_RENEW_DAYS AUTO_RENEW_DAYS
, CHRB.DATE_ISSUED DATE_ISSUED
, CHRB.DATETIME_RESPONDED DATETIME_RESPONDED
, CHRB.RFP_TYPE RFP_TYPE
, CHRB.KEEP_ON_MAIL_LIST KEEP_ON_MAIL_LIST
, CHRB.SET_ASIDE_PERCENT SET_ASIDE_PERCENT
, CHRB.RESPONSE_COPIES_REQ RESPONSE_COPIES_REQ
, CHRB.DATE_CLOSE_PROJECTED DATE_CLOSE_PROJECTED
, CHRB.DATETIME_PROPOSED DATETIME_PROPOSED
, CHRB.DATE_SIGNED DATE_SIGNED
, CHRB.DATE_TERMINATED DATE_TERMINATED
, CHRB.DATE_RENEWED DATE_RENEWED
, CHRB.START_DATE START_DATE
, CHRB.END_DATE END_DATE
, CHRB.BUY_OR_SELL BUY_OR_SELL
, CHRB.ISSUE_OR_RECEIVE ISSUE_OR_RECEIVE
, CHRB.ESTIMATED_AMOUNT ESTIMATED_AMOUNT
, CHRB.CHR_ID_RENEWED_TO CHR_ID_RENEWED_TO
, CHRB.ESTIMATED_AMOUNT_RENEWED ESTIMATED_AMOUNT_RENEWED
, CHRB.CURRENCY_CODE_RENEWED CURRENCY_CODE_RENEWED
, CHRB.UPG_ORIG_SYSTEM_REF UPG_ORIG_SYSTEM_REF
, CHRB.UPG_ORIG_SYSTEM_REF_ID UPG_ORIG_SYSTEM_REF_ID
, CHRB.APPLICATION_ID APPLICATION_ID
, CHRB.RESOLVED_UNTIL RESOLVED_UNTIL
, CHRB.ORIG_SYSTEM_SOURCE_CODE ORIG_SYSTEM_SOURCE_CODE
, CHRB.ORIG_SYSTEM_ID1 ORIG_SYSTEM_ID1
, CHRB.ORIG_SYSTEM_REFERENCE1 ORIG_SYSTEM_REFERENCE1
, CHRB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CHRB.PROGRAM_ID PROGRAM_ID
, CHRB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CHRB.REQUEST_ID REQUEST_ID
, CHRB.PRICE_LIST_ID PRICE_LIST_ID
, CHRB.PRICING_DATE PRICING_DATE
, CHRB.TOTAL_LINE_LIST_PRICE TOTAL_LINE_LIST_PRICE
, CHRB.SIGN_BY_DATE SIGN_BY_DATE
, CHRB.USER_ESTIMATED_AMOUNT USER_ESTIMATED_AMOUNT
, CHRT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, CHRT.COMMENTS COMMENTS
, CHRT.DESCRIPTION DESCRIPTION
, CHRT.COGNOMEN COGNOMEN
, CHRT.NON_RESPONSE_REASON NON_RESPONSE_REASON
, CHRT.NON_RESPONSE_EXPLAIN NON_RESPONSE_EXPLAIN
, CHRT.SET_ASIDE_REASON SET_ASIDE_REASON
, POV.VENDOR_NAME VENDOR_NAME
, NULL USER_ACCESS_LEVEL
, PROB.PDF_ID
, SCST.MEANING CATEGORY
, STST.MEANING STATUS
, STSB.STE_CODE STE_CODE
, CHRB1.ID CHR_ID_REFERRED
, CHRB1.CONTRACT_NUMBER PARENT_CONTRACT_NUMBER
, QAC.SHORT_DESCRIPTION QA_CHECK_NAME
, PDF.DESCRIPTION WORKFLOW_NAME
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKC_TERMINATION_REASON'
, CHRB.TRN_CODE
, 510
, 0) TERMINATION_REASON
FROM OKC_K_HEADERS_B CHRB
, OKC_K_HEADERS_ALL_B CHRB1
, OKC_K_HEADERS_TL CHRT
, OKC_GOVERNANCES GOVB
, OKC_K_PROCESSES PROB
, OKC_SUBCLASSES_B SCSB
, OKC_SUBCLASSES_TL SCST
, OKC_STATUSES_B STSB
, OKC_STATUSES_TL STST
, OKC_QA_CHECK_LISTS_TL QAC
, OKC_PROCESS_DEFS_TL PDF
, OKC_K_PARTY_ROLES_B KPR
, PO_VENDORS POV
WHERE CHRB.ID = CHRT.ID
AND CHRB.ID = GOVB.CHR_ID(+)
AND GOVB.CHR_ID_REFERRED = CHRB1.ID(+)
AND CHRB.ID = PROB.CHR_ID(+)
AND SCSB.CODE = SCST.CODE(+)
AND SCSB.CODE(+) = CHRB.SCS_CODE
AND STSB.CODE = STST.CODE(+)
AND STSB.CODE(+) = CHRB.STS_CODE
AND QAC.ID(+) = CHRB.QCL_ID
AND PDF.ID(+) = PROB.PDF_ID
AND (CHRB.ID = KPR.DNZ_CHR_ID(+)
AND KPR.RLE_CODE(+) = 'OKL_VENDOR')
AND KPR.OBJECT1_ID1 = POV.VENDOR_ID(+)
AND QAC.LANGUAGE(+) = USERENV('LANG')
AND PDF.LANGUAGE(+) = USERENV('LANG')
AND SCST.LANGUAGE(+) = USERENV('LANG')
AND CHRT.LANGUAGE(+) = USERENV('LANG')
AND STST.LANGUAGE(+) = USERENV('LANG')

Columns