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: OKL.OKL_PARTY_ROLES_INTERFACE#

Source

View Text - Preformatted


select CONTRACT_NUMBER_OLD CONTRACT_NUMBER_OLD, LINE_NUMBER LINE_NUMBER, ASSET_VENDOR_NAME ASSET_VENDOR_NAME, ASSET_VENDOR_ID ASSET_VENDOR_ID, SERVICE_VENDOR_NAME SERVICE_VENDOR_NAME, SERVICE_VENDOR_ID SERVICE_VENDOR_ID, FEES_VENDOR_NAME FEES_VENDOR_NAME, FEES_VENDOR_ID FEES_VENDOR_ID, GUARANTOR_NUMBER GUARANTOR_NUMBER, GUARANTOR_ID GUARANTOR_ID, GUARANTOR_SITE_NUMBER GUARANTOR_SITE_NUMBER, GUARANTOR_SITE_ID GUARANTOR_SITE_ID, DEALER_NAME DEALER_NAME, DEALER_ID DEALER_ID, GUARANTOR_TYPE GUARANTOR_TYPE, GUARANTEE_TYPE GUARANTEE_TYPE, GUARANTEED_AMOUNT GUARANTEED_AMOUNT, GUARANTEE_DATE GUARANTEE_DATE, GUARANTEE_COMMENT GUARANTEE_COMMENT, BILLABLE_VENDOR_ID BILLABLE_VENDOR_ID, BILLABLE_VENDOR_NAME BILLABLE_VENDOR_NAME, VEND_AS_CUSTOMER_NUMBER VEND_AS_CUSTOMER_NUMBER, VEND_AS_CUSTOMER_ID VEND_AS_CUSTOMER_ID, VEND_AS_CUSTOMER_ACC_NUMBER VEND_AS_CUSTOMER_ACC_NUMBER, VEND_AS_CUSTOMER_ACC_ID VEND_AS_CUSTOMER_ACC_ID, VEND_BILL_TO_ADDR_ID VEND_BILL_TO_ADDR_ID, VEND_BILL_TO_ADDR VEND_BILL_TO_ADDR, VEND_PAYMENT_METHOD_ID VEND_PAYMENT_METHOD_ID, VEND_PAYMENT_METHOD VEND_PAYMENT_METHOD, VEND_BANK_ACC_ID VEND_BANK_ACC_ID, VEND_BANK_ACC_NUMBER VEND_BANK_ACC_NUMBER, VEND_INVOICE_FORMAT_ID VEND_INVOICE_FORMAT_ID, VEND_INVOICE_FORMAT_CODE VEND_INVOICE_FORMAT_CODE, VEND_REVIEW_INVOICE_FLAG VEND_REVIEW_INVOICE_FLAG, VEND_REASON_FOR_INV_REVIEW VEND_REASON_FOR_INV_REVIEW, VEND_INV_REVIEW_UNTIL_DATE VEND_INV_REVIEW_UNTIL_DATE, PTH_BASE_VENDOR_SITE_CODE PTH_BASE_VENDOR_SITE_CODE, PTH_BASE_VENDOR_SITE_CODE_1 PTH_BASE_VENDOR_SITE_CODE_1, PTH_BASE_VENDOR_SITE_ID PTH_BASE_VENDOR_SITE_ID, PTH_BASE_PAYGROUP_CODE PTH_BASE_PAYGROUP_CODE, PTH_BASE_PMNT_TERM_CODE PTH_BASE_PMNT_TERM_CODE, PTH_BASE_PMNT_TERM_ID PTH_BASE_PMNT_TERM_ID, PTH_BASE_PMNT_BASIS PTH_BASE_PMNT_BASIS, PTH_BASE_PMNT_START_DATE PTH_BASE_PMNT_START_DATE, PTH_BASE_PMNT_METHOD_CODE PTH_BASE_PMNT_METHOD_CODE, PTH_BASE_PMNT_FREQ PTH_BASE_PMNT_FREQ, PTH_BASE_PMNT_REMIT_DAYS PTH_BASE_PMNT_REMIT_DAYS, PTH_BASE_DISB_BASIS PTH_BASE_DISB_BASIS, PTH_BASE_DISB_FIXED_AMOUNT PTH_BASE_DISB_FIXED_AMOUNT, PTH_BASE_DISB_PCT PTH_BASE_DISB_PCT, PTH_BASE_PROC_FEE_BASIS PTH_BASE_PROC_FEE_BASIS, PTH_BASE_PROC_FEE_FIXED_AMT PTH_BASE_PROC_FEE_FIXED_AMT, PTH_BASE_PROC_PCT PTH_BASE_PROC_PCT, PTH_EVG_VENDOR_SITE_CODE PTH_EVG_VENDOR_SITE_CODE, PTH_EVG_VENDOR_SITE_ID PTH_EVG_VENDOR_SITE_ID, PTH_EVG_PAYGROUP_CODE PTH_EVG_PAYGROUP_CODE, PTH_EVG_PMNT_TERM_CODE PTH_EVG_PMNT_TERM_CODE, PTH_EVG_PMNT_TERM_ID PTH_EVG_PMNT_TERM_ID, PTH_EVG_PMNT_BASIS PTH_EVG_PMNT_BASIS, PTH_EVG_PMNT_START_DATE PTH_EVG_PMNT_START_DATE, PTH_EVG_PMNT_METHOD_CODE PTH_EVG_PMNT_METHOD_CODE, PTH_EVG_PMNT_FREQ PTH_EVG_PMNT_FREQ, PTH_EVG_PMNT_REMIT_DAYS PTH_EVG_PMNT_REMIT_DAYS, PTH_EVG_DISB_BASIS PTH_EVG_DISB_BASIS, PTH_EVG_DISB_FIXED_AMOUNT PTH_EVG_DISB_FIXED_AMOUNT, PTH_EVG_DISB_PCT PTH_EVG_DISB_PCT, PTH_EVG_PROC_FEE_BASIS PTH_EVG_PROC_FEE_BASIS, PTH_EVG_PROC_FEE_FIXED_AMT PTH_EVG_PROC_FEE_FIXED_AMT, PTH_EVG_PROC_PCT PTH_EVG_PROC_PCT, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15 from "OKL"."OKL_PARTY_ROLES_INTERFACE"

View Text - HTML Formatted

SELECT CONTRACT_NUMBER_OLD CONTRACT_NUMBER_OLD
, LINE_NUMBER LINE_NUMBER
, ASSET_VENDOR_NAME ASSET_VENDOR_NAME
, ASSET_VENDOR_ID ASSET_VENDOR_ID
, SERVICE_VENDOR_NAME SERVICE_VENDOR_NAME
, SERVICE_VENDOR_ID SERVICE_VENDOR_ID
, FEES_VENDOR_NAME FEES_VENDOR_NAME
, FEES_VENDOR_ID FEES_VENDOR_ID
, GUARANTOR_NUMBER GUARANTOR_NUMBER
, GUARANTOR_ID GUARANTOR_ID
, GUARANTOR_SITE_NUMBER GUARANTOR_SITE_NUMBER
, GUARANTOR_SITE_ID GUARANTOR_SITE_ID
, DEALER_NAME DEALER_NAME
, DEALER_ID DEALER_ID
, GUARANTOR_TYPE GUARANTOR_TYPE
, GUARANTEE_TYPE GUARANTEE_TYPE
, GUARANTEED_AMOUNT GUARANTEED_AMOUNT
, GUARANTEE_DATE GUARANTEE_DATE
, GUARANTEE_COMMENT GUARANTEE_COMMENT
, BILLABLE_VENDOR_ID BILLABLE_VENDOR_ID
, BILLABLE_VENDOR_NAME BILLABLE_VENDOR_NAME
, VEND_AS_CUSTOMER_NUMBER VEND_AS_CUSTOMER_NUMBER
, VEND_AS_CUSTOMER_ID VEND_AS_CUSTOMER_ID
, VEND_AS_CUSTOMER_ACC_NUMBER VEND_AS_CUSTOMER_ACC_NUMBER
, VEND_AS_CUSTOMER_ACC_ID VEND_AS_CUSTOMER_ACC_ID
, VEND_BILL_TO_ADDR_ID VEND_BILL_TO_ADDR_ID
, VEND_BILL_TO_ADDR VEND_BILL_TO_ADDR
, VEND_PAYMENT_METHOD_ID VEND_PAYMENT_METHOD_ID
, VEND_PAYMENT_METHOD VEND_PAYMENT_METHOD
, VEND_BANK_ACC_ID VEND_BANK_ACC_ID
, VEND_BANK_ACC_NUMBER VEND_BANK_ACC_NUMBER
, VEND_INVOICE_FORMAT_ID VEND_INVOICE_FORMAT_ID
, VEND_INVOICE_FORMAT_CODE VEND_INVOICE_FORMAT_CODE
, VEND_REVIEW_INVOICE_FLAG VEND_REVIEW_INVOICE_FLAG
, VEND_REASON_FOR_INV_REVIEW VEND_REASON_FOR_INV_REVIEW
, VEND_INV_REVIEW_UNTIL_DATE VEND_INV_REVIEW_UNTIL_DATE
, PTH_BASE_VENDOR_SITE_CODE PTH_BASE_VENDOR_SITE_CODE
, PTH_BASE_VENDOR_SITE_CODE_1 PTH_BASE_VENDOR_SITE_CODE_1
, PTH_BASE_VENDOR_SITE_ID PTH_BASE_VENDOR_SITE_ID
, PTH_BASE_PAYGROUP_CODE PTH_BASE_PAYGROUP_CODE
, PTH_BASE_PMNT_TERM_CODE PTH_BASE_PMNT_TERM_CODE
, PTH_BASE_PMNT_TERM_ID PTH_BASE_PMNT_TERM_ID
, PTH_BASE_PMNT_BASIS PTH_BASE_PMNT_BASIS
, PTH_BASE_PMNT_START_DATE PTH_BASE_PMNT_START_DATE
, PTH_BASE_PMNT_METHOD_CODE PTH_BASE_PMNT_METHOD_CODE
, PTH_BASE_PMNT_FREQ PTH_BASE_PMNT_FREQ
, PTH_BASE_PMNT_REMIT_DAYS PTH_BASE_PMNT_REMIT_DAYS
, PTH_BASE_DISB_BASIS PTH_BASE_DISB_BASIS
, PTH_BASE_DISB_FIXED_AMOUNT PTH_BASE_DISB_FIXED_AMOUNT
, PTH_BASE_DISB_PCT PTH_BASE_DISB_PCT
, PTH_BASE_PROC_FEE_BASIS PTH_BASE_PROC_FEE_BASIS
, PTH_BASE_PROC_FEE_FIXED_AMT PTH_BASE_PROC_FEE_FIXED_AMT
, PTH_BASE_PROC_PCT PTH_BASE_PROC_PCT
, PTH_EVG_VENDOR_SITE_CODE PTH_EVG_VENDOR_SITE_CODE
, PTH_EVG_VENDOR_SITE_ID PTH_EVG_VENDOR_SITE_ID
, PTH_EVG_PAYGROUP_CODE PTH_EVG_PAYGROUP_CODE
, PTH_EVG_PMNT_TERM_CODE PTH_EVG_PMNT_TERM_CODE
, PTH_EVG_PMNT_TERM_ID PTH_EVG_PMNT_TERM_ID
, PTH_EVG_PMNT_BASIS PTH_EVG_PMNT_BASIS
, PTH_EVG_PMNT_START_DATE PTH_EVG_PMNT_START_DATE
, PTH_EVG_PMNT_METHOD_CODE PTH_EVG_PMNT_METHOD_CODE
, PTH_EVG_PMNT_FREQ PTH_EVG_PMNT_FREQ
, PTH_EVG_PMNT_REMIT_DAYS PTH_EVG_PMNT_REMIT_DAYS
, PTH_EVG_DISB_BASIS PTH_EVG_DISB_BASIS
, PTH_EVG_DISB_FIXED_AMOUNT PTH_EVG_DISB_FIXED_AMOUNT
, PTH_EVG_DISB_PCT PTH_EVG_DISB_PCT
, PTH_EVG_PROC_FEE_BASIS PTH_EVG_PROC_FEE_BASIS
, PTH_EVG_PROC_FEE_FIXED_AMT PTH_EVG_PROC_FEE_FIXED_AMT
, PTH_EVG_PROC_PCT PTH_EVG_PROC_PCT
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
FROM "OKL"."OKL_PARTY_ROLES_INTERFACE"