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_TRX_EXTENSION_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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