View: OKL_TRX_EXTENSION_V

Product:	OKL - Leasing and Finance Management
Description:	Transaction header extension view
Implementation/DBA Data:	APPS.OKL_TRX_EXTENSION_V

View Text

SELECT TEH.ROWID ROW_ID
, TEH.HEADER_EXTENSION_ID HEADER_EXTENSION_ID
, TEH.SOURCE_ID SOURCE_ID
, TEH.SOURCE_TABLE SOURCE_TABLE
, TEH.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TEHL.LANGUAGE LANGUAGE
, TEH.CONTRACT_NUMBER CONTRACT_NUMBER
, TEH.INV_AGRMNT_NUMBER INV_AGRMNT_NUMBER
, TEH.CONTRACT_CURRENCY_CODE CONTRACT_CURRENCY_CODE
, TEH.INV_AGRMNT_CURRENCY_CODE INV_AGRMNT_CURRENCY_CODE
, TEH.CONTRACT_EFFECTIVE_FROM CONTRACT_EFFECTIVE_FROM
, TEH.INV_AGRMNT_EFFECTIVE_FROM INV_AGRMNT_EFFECTIVE_FROM
, TEH.CUSTOMER_NAME CUSTOMER_NAME
, TEH.SALES_REP_NAME SALES_REP_NAME
, TEH.CUSTOMER_ACCOUNT_NUMBER CUSTOMER_ACCOUNT_NUMBER
, TEH.BILL_TO_ADDRESS_NUM BILL_TO_ADDRESS_NUM
, TEH.INT_CALC_METHOD_CODE INT_CALC_METHOD_CODE
, TEH.REV_REC_METHOD_CODE REV_REC_METHOD_CODE
, TEH.CONVERTED_NUMBER CONVERTED_NUMBER
, TEH.ASSIGNABLE_FLAG ASSIGNABLE_FLAG
, TEH.CREDIT_LINE_NUMBER CREDIT_LINE_NUMBER
, TEH.MASTER_LEASE_NUMBER MASTER_LEASE_NUMBER
, TEH.PO_ORDER_NUMBER PO_ORDER_NUMBER
, TEH.VENDOR_PROGRAM_NUMBER VENDOR_PROGRAM_NUMBER
, TEH.INS_POLICY_TYPE_CODE INS_POLICY_TYPE_CODE
, TEH.INS_POLICY_NUMBER INS_POLICY_NUMBER
, TEH.TERM_QUOTE_ACCEPT_DATE TERM_QUOTE_ACCEPT_DATE
, TEH.TERM_QUOTE_NUM TERM_QUOTE_NUM
, TEH.TERM_QUOTE_TYPE_CODE TERM_QUOTE_TYPE_CODE
, TEH.CONVERTED_ACCOUNT_FLAG CONVERTED_ACCOUNT_FLAG
, TEH.ACCRUAL_OVERRIDE_FLAG ACCRUAL_OVERRIDE_FLAG
, TEH.CUST_ATTRIBUTE_CATEGORY CUST_ATTRIBUTE_CATEGORY
, TEH.CUST_ATTRIBUTE1 CUST_ATTRIBUTE1
, TEH.CUST_ATTRIBUTE2 CUST_ATTRIBUTE2
, TEH.CUST_ATTRIBUTE3 CUST_ATTRIBUTE3
, TEH.CUST_ATTRIBUTE4 CUST_ATTRIBUTE4
, TEH.CUST_ATTRIBUTE5 CUST_ATTRIBUTE5
, TEH.CUST_ATTRIBUTE6 CUST_ATTRIBUTE6
, TEH.CUST_ATTRIBUTE7 CUST_ATTRIBUTE7
, TEH.CUST_ATTRIBUTE8 CUST_ATTRIBUTE8
, TEH.CUST_ATTRIBUTE9 CUST_ATTRIBUTE9
, TEH.CUST_ATTRIBUTE10 CUST_ATTRIBUTE10
, TEH.CUST_ATTRIBUTE11 CUST_ATTRIBUTE11
, TEH.CUST_ATTRIBUTE12 CUST_ATTRIBUTE12
, TEH.CUST_ATTRIBUTE13 CUST_ATTRIBUTE13
, TEH.CUST_ATTRIBUTE14 CUST_ATTRIBUTE14
, TEH.CUST_ATTRIBUTE15 CUST_ATTRIBUTE15
, TEH.RENT_IA_CONTRACT_NUMBER RENT_IA_CONTRACT_NUMBER
, TEH.RES_IA_CONTRACT_NUMBER RES_IA_CONTRACT_NUMBER
, TEH.INV_AGRMNT_POOL_NUMBER INV_AGRMNT_POOL_NUMBER
, TEH.RENT_IA_PRODUCT_NAME RENT_IA_PRODUCT_NAME
, TEH.RES_IA_PRODUCT_NAME RES_IA_PRODUCT_NAME
, TEH.RENT_IA_ACCOUNTING_CODE RENT_IA_ACCOUNTING_CODE
, TEH.RES_IA_ACCOUNTING_CODE RES_IA_ACCOUNTING_CODE
, TEH.INV_AGRMNT_SYND_CODE INV_AGRMNT_SYND_CODE
, TEH.CREATED_BY CREATED_BY
, TEH.CREATION_DATE CREATION_DATE
, TEH.LAST_UPDATED_BY LAST_UPDATED_BY
, TEH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TEH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TEHL.CONTRACT_STATUS CONTRACT_STATUS
, TEHL.INV_AGRMNT_STATUS INV_AGRMNT_STATUS
, TEHL.CHR_OPERATING_UNIT_NAME CHR_OPERATING_UNIT_NAME
, TEHL.TRANSACTION_TYPE_NAME TRANSACTION_TYPE_NAME
, TEH.CONTRACT_STATUS_CODE CONTRACT_STATUS_CODE
, TEH.INV_AGRMNT_STATUS_CODE INV_AGRMNT_STATUS_CODE
, TEH.TRX_TYPE_CLASS_CODE TRX_TYPE_CLASS_CODE
, TEH.CHR_OPERATING_UNIT_CODE CHR_OPERATING_UNIT_CODE
, TEH.PARTY_ID PARTY_ID
, TEH.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, TEH.CUST_SITE_USE_ID CUST_SITE_USE_ID
FROM OKL_TRX_EXTENSION_B TEH
, OKL_TRX_EXTENSION_TL TEHL
WHERE TEH.HEADER_EXTENSION_ID = TEHL.HEADER_EXTENSION_ID

Columns