FND Design Data [Home] [Help]

View: OKL_TAA_REQUEST_DETAILS_V

Product: OKL - Lease and Finance Management
Description: View for Transfer and assumption request details
Implementation/DBA Data: ViewAPPS.OKL_TAA_REQUEST_DETAILS_V
View Text

SELECT TAA.ID
, TAA.TCN_ID
, TAA.NEW_CONTRACT_NUMBER
, TAA.BILL_TO_SITE_ID
, TAA.CUST_ACCT_ID
, TAA.BANK_ACCT_ID
, TAA.INVOICE_FORMAT_ID
, TAA.PAYMENT_MTHD_ID
, TAA.MLA_ID
, TAA.CREDIT_LINE_ID
, TAA.INSURANCE_YN
, TAA.LEASE_POLICY_YN
, TAA.IPY_TYPE
, TAA.POLICY_NUMBER
, TAA.COVERED_AMT
, TAA.DEDUCTIBLE_AMT
, TAA.EFFECTIVE_TO_DATE
, TAA.EFFECTIVE_FROM_DATE
, TAA.PROOF_PROVIDED_DATE
, TAA.PROOF_REQUIRED_DATE
, TAA.LESSOR_INSURED_YN
, TAA.LESSOR_PAYEE_YN
, TAA.INT_ID
, TAA.ISU_ID
, TAA.AGENCY_SITE_ID
, TAA.AGENT_SITE_ID
, TAA.TERRITORY_CODE
, TAA.ATTRIBUTE_CATEGORY
, TAA.ATTRIBUTE1
, TAA.ATTRIBUTE2
, TAA.ATTRIBUTE3
, TAA.ATTRIBUTE4
, TAA.ATTRIBUTE5
, TAA.ATTRIBUTE6
, TAA.ATTRIBUTE7
, TAA.ATTRIBUTE8
, TAA.ATTRIBUTE9
, TAA.ATTRIBUTE10
, TAA.ATTRIBUTE11
, TAA.ATTRIBUTE12
, TAA.ATTRIBUTE13
, TAA.ATTRIBUTE14
, TAA.ATTRIBUTE15
, TAA.CREATED_BY
, TAA.CREATION_DATE
, TAA.LAST_UPDATED_BY
, TAA.LAST_UPDATE_DATE
, TAA.LAST_UPDATE_LOGIN
FROM OKL_TAA_REQUEST_DETAILS_B TAA

Columns

Name
ID
TCN_ID
NEW_CONTRACT_NUMBER
BILL_TO_SITE_ID
CUST_ACCT_ID
BANK_ACCT_ID
INVOICE_FORMAT_ID
PAYMENT_MTHD_ID
MLA_ID
CREDIT_LINE_ID
INSURANCE_YN
LEASE_POLICY_YN
IPY_TYPE
POLICY_NUMBER
COVERED_AMT
DEDUCTIBLE_AMT
EFFECTIVE_TO_DATE
EFFECTIVE_FROM_DATE
PROOF_PROVIDED_DATE
PROOF_REQUIRED_DATE
LESSOR_INSURED_YN
LESSOR_PAYEE_YN
INT_ID
ISU_ID
AGENCY_SITE_ID
AGENT_SITE_ID
TERRITORY_CODE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN