[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKL_TXL_AP_INV_LNS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  OKL.OKL_TXL_AP_INV_LNS_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Transaction lines to be included into Payables invoices
Subtype of an OKL internal transaction line. Used for Funding
Money passed from customer invoices and receipts to vendors
Manually entered supplier invoice
DEFINITION
The disposition of the security deposit. Triggered by the Termination quote process or Asset Return process.
EXAMPLE
MISCELLANEOUS
DEFINITION
The transaction lines to pay any remarket sharing amount to external remarketers.
EXAMPLE
MISCELLANEOUS
DEFINITION
The transaction lines to pay any remarket commission amount to external remarketers.
EXAMPLE
MISCELLANEOUS
Upon reversing of a contract, all paying transactions associated with the contract need to be reversed. It is accomplished by creating a transaction with opposite amount for every existing contract transaction.
DEFINITION
A subtype of "transaction", but a supertype of all OKL transaction lines.
EXAMPLE
MISCELLANEOUS
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Auto-generated by Headstart Utilities | |
| ID | NUMBER | Yes | Primary key column | |
| OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
| SFWT_FLAG | VARCHAR2 | (3) | Yes | Column used by the translation batch program |
| CODE_COMBINATION_ID | NUMBER | Key flexfield combination defining column | ||
| ITC_ID | NUMBER | Foreign Key to table OKX_TAX_CODES_V | ||
| DISBURSEMENT_BASIS_CODE | VARCHAR2 | (30) | Disbursement basis: bill date, due date or cash receipt date | |
| KLE_ID | NUMBER | Foreign key to table OKL_K_LINES | ||
| LSM_ID | NUMBER | Foreign key to table OKL_CNSLD_AR_STRMS_B | ||
| TPL_ID_REVERSES | NUMBER | Foreign Key to table OKL_TXL_AP_INV_LNS_B | ||
| INV_DISTR_LINE_CODE | VARCHAR2 | (30) | Invoice distribution line type | |
| STY_ID | NUMBER | Foreign key to table OKL_STRM_TYPE_B | ||
| TAP_ID | NUMBER | Yes | Foreign key to table OKL_TRX_AP_INVOICES_B | |
| DATE_ACCOUNTING | DATE | Accounting date | ||
| AMOUNT | NUMBER | Amount | ||
| LINE_NUMBER | NUMBER | Yes | Line number | |
| PAYABLES_INVOICE_ID | NUMBER | Surrogate key used for primary unique identifiers | ||
| DESCRIPTION | VARCHAR2 | (1995) | A general description of something | |
| FUNDING_REFERENCE_TYPE_CODE | VARCHAR2 | (30) | Type of original funding document | |
| FUNDING_REFERENCE_NUMBER | VARCHAR2 | (50) | Pointer to the original funding document | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column | |
| ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column | |
| REQUEST_ID | NUMBER | (15) | Concurrent Manager column | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Manager column | |
| PROGRAM_ID | NUMBER | (15) | Concurrent Manager column | |
| PROGRAM_UPDATE_DATE | DATE | Concurrent Manager column | ||
| ORG_ID | NUMBER | (15) | Operating unit identifier | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column |
| CREATION_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
| ERROR_MESSAGE | VARCHAR2 | (3000) | Error message | |
| SEL_ID | NUMBER | Foreign key to table OKL_STRM_ELEMENTS | ||
| KHR_ID | NUMBER | Foreign key to table OKL_K_HEADERS | ||
| TAXABLE_YN | VARCHAR2 | (3) | Indicates if the line is taxable. | |
| REF_LINE_NUMBER | NUMBER | A pointer to the original line of which this line is a tax line. | ||
| CNSLD_AP_INV_ID | NUMBER | Pointer to the consolidated invoice to which this line belongs. | ||
| CNSLD_LINE_NUMBER | NUMBER | Sequence of the line on the consolidated invoice. | ||
| TLD_ID | NUMBER | Foreign key of okl_txd_ar_ln_dtls_b.id |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, OBJECT_VERSION_NUMBER
, SFWT_FLAG
, CODE_COMBINATION_ID
, ITC_ID
, DISBURSEMENT_BASIS_CODE
, KLE_ID
, LSM_ID
, TPL_ID_REVERSES
, INV_DISTR_LINE_CODE
, STY_ID
, TAP_ID
, DATE_ACCOUNTING
, AMOUNT
, LINE_NUMBER
, PAYABLES_INVOICE_ID
, DESCRIPTION
, FUNDING_REFERENCE_TYPE_CODE
, FUNDING_REFERENCE_NUMBER
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ERROR_MESSAGE
, SEL_ID
, KHR_ID
, TAXABLE_YN
, REF_LINE_NUMBER
, CNSLD_AP_INV_ID
, CNSLD_LINE_NUMBER
, TLD_ID
FROM APPS.OKL_TXL_AP_INV_LNS_V;
APPS
OKL_TXL_AP_INV_LNS_B
OKL_TXL_AP_INV_LNS_TL
APPS
OKL_BPD_AP_DISBURS_SMRY_UV
OKL_BPD_AP_DISB_DTL_LN_UV
OKL_BPD_TERMINATION_ADJ_PVT
- show dependent code
OKL_INVESTOR_INVOICE_DISB_PUB
- show dependent code
OKL_INVESTOR_INVOICE_DISB_PVT
- show dependent code
OKL_TPL_PVT
- show dependent code
OKL_TPL_PVT
- show dependent code
OKL_XLP_PVT
- show dependent code
|
|
|
|