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.

VIEW: APPS.OKL_VP_AGREEMENT_UV

Source

View Text - Preformatted


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')

View Text - HTML Formatted

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')