[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKL_TRX_AP_INVOICES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  OKL.OKL_TRX_AP_INVOICES_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
NITION
Manually entered one-off payables payment
EXAMPLE
Payment to a lawyer for legal assistance during contract negotiations
MISCELLANEOUS
May be used by lease authoring for entering vendor bills
DEFINITION
The disposition of the security deposit. Triggered by the Termination quote process or Asset Return process.
EXAMPLE
MISCELLANEOUS
DEFINITION
The transaction to pay any remarket sharing amount to external remarketers.
EXAMPLE
MISCELLANEOUS
DEFINITION
The transaction 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
super type entity for headers of internal contracts transactions
EXAMPLE
MISCELLANEOUS
DEFINITION
The supertype of OKL transactions.
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 |
| CCT_ID | NUMBER | Obsolete | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency conversion type | |
| CURRENCY_CONVERSION_RATE | NUMBER | Currency conversion rate | ||
| CURRENCY_CONVERSION_DATE | DATE | Currency conversion date | ||
| TRX_STATUS_CODE | VARCHAR2 | (30) | Yes | Transaction status |
| CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency code |
| PAY_GROUP_LOOKUP_CODE | VARCHAR2 | (30) | Pay group lookup code | |
| VENDOR_ID | NUMBER | Vendor id | ||
| VENDOR_INVOICE_NUMBER | VARCHAR2 | (240) | Vendor invoice number | |
| INVOICE_TYPE | VARCHAR2 | (240) | Type of invoice: Credit or Standard | |
| NETTABLE_YN | VARCHAR2 | (3) | Nettable flag | |
| SET_OF_BOOKS_ID | NUMBER | Accounting books defining column | ||
| TRY_ID | NUMBER | Yes | Foreign key to table OKL_TRX_TYPES_B | |
| CCF_ID | NUMBER | Obsolete | ||
| FUNDING_TYPE_CODE | VARCHAR2 | (30) | Types of funding transactions | |
| KHR_ID | NUMBER | Foreign key to table OKL_K_HEADERS | ||
| ART_ID | NUMBER | Foreign key to table OKL_ASSET_RETURNS_B | ||
| TAP_ID_REVERSES | NUMBER | Foreign Key to table OKL_TRX_AP_INVOICES_B | ||
| IPPT_ID | NUMBER | Foreign Key to view OKX_PAYABLES_TERMS_V | ||
| CODE_COMBINATION_ID | NUMBER | Key flexfield combination defining column | ||
| IPVS_ID | NUMBER | Yes | Foreign Key to view OKX_VENDOR_SITES_V | |
| TCN_ID | NUMBER | Foreign key to table OKL_TRX_CONTRACTS | ||
| QTE_ID | NUMBER | Foreign key to table OKL_TRX_QUOTES_B | ||
| POX_ID | NUMBER | Foreign key to table OKL_POOL_TRANSACTIONS | ||
| INVOICE_CATEGORY_CODE | VARCHAR2 | (30) | Invoice category code | |
| PAYMENT_METHOD_CODE | VARCHAR2 | (30) | Payment method code | |
| CPLV_ID | NUMBER | Foreign Key to view OKC_K_PARTY_ROLES_V | ||
| AMOUNT | NUMBER | Yes | Amount | |
| DATE_INVOICED | DATE | Yes | Invoice billing date | |
| INVOICE_NUMBER | VARCHAR2 | (50) | Invoice number for invoices received from vendors | |
| DATE_FUNDING_APPROVED | DATE | Date on which the funding was approved | ||
| DATE_GL | DATE | Accounting date to default to invoice distributions | ||
| WORKFLOW_YN | VARCHAR2 | (3) | Flag that indicates if the Payables Open Interface Workflow should process the record | |
| CONSOLIDATE_YN | VARCHAR2 | (3) | Flag that indicates whether to create a separate invoice for a transaction | |
| WAIT_VENDOR_INVOICE_YN | VARCHAR2 | (3) | Flag to indicate whether payment is held untill vendor invoice is received | |
| DATE_REQUISITION | DATE | Date of asset requisition | ||
| DESCRIPTION | VARCHAR2 | (1995) | A general description of something | |
| 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 | |
| DATE_ENTERED | DATE | Yes | Invoice creation date | |
| 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 | |
| ASSET_TAP_ID | NUMBER | Foreign key to OKL_TRX_AP_INVOICES_B | ||
| LEGAL_ENTITY_ID | NUMBER | Stores the Legal Entity Id. Foreign Key to XLE_ENTITY_PROFILES | ||
| MATCH_REQUIRED_YN | VARCHAR2 | (3) | Flag that indicates whether OLM invoice needs to be matched with a payable invoice created in AP. | |
| VPA_ID | NUMBER | Vendor Program Id | ||
| IPT_ID | NUMBER | Insurance Policy Id | ||
| IPT_FREQUENCY | VARCHAR2 | (3) | Insurance Policy Frequency | |
| TRANSACTION_DATE | DATE | Stores the date on which the transaction occurred. Equivalent of the creation date column and is used in reconciliation reports. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, OBJECT_VERSION_NUMBER
, SFWT_FLAG
, CCT_ID
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE
, TRX_STATUS_CODE
, CURRENCY_CODE
, PAY_GROUP_LOOKUP_CODE
, VENDOR_ID
, VENDOR_INVOICE_NUMBER
, INVOICE_TYPE
, NETTABLE_YN
, SET_OF_BOOKS_ID
, TRY_ID
, CCF_ID
, FUNDING_TYPE_CODE
, KHR_ID
, ART_ID
, TAP_ID_REVERSES
, IPPT_ID
, CODE_COMBINATION_ID
, IPVS_ID
, TCN_ID
, QTE_ID
, POX_ID
, INVOICE_CATEGORY_CODE
, PAYMENT_METHOD_CODE
, CPLV_ID
, AMOUNT
, DATE_INVOICED
, INVOICE_NUMBER
, DATE_FUNDING_APPROVED
, DATE_GL
, WORKFLOW_YN
, CONSOLIDATE_YN
, WAIT_VENDOR_INVOICE_YN
, DATE_REQUISITION
, DESCRIPTION
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, DATE_ENTERED
, 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
, ASSET_TAP_ID
, LEGAL_ENTITY_ID
, MATCH_REQUIRED_YN
, VPA_ID
, IPT_ID
, IPT_FREQUENCY
, TRANSACTION_DATE
FROM APPS.OKL_TRX_AP_INVOICES_V;
APPS
OKL_TRX_AP_INVOICES_B
OKL_TRX_AP_INVOICES_TL
APPS
OKL_ART_PVT
- show dependent code
OKL_BPD_AP_DISBURS_SMRY_UV
OKL_BPD_AP_DISB_DTL_LN_UV
OKL_BPD_TERMINATION_ADJ_PVT
- show dependent code
OKL_CURE_REFUNDS_SUMRY_UV
OKL_DAILY_INTEREST_CALC_PVT
- show dependent code
OKL_INVESTOR_INVOICE_DISB_PUB
- show dependent code
OKL_INVESTOR_INVOICE_DISB_PVT
- show dependent code
OKL_PAY_INVOICES_CONS_PVT
- show dependent code
OKL_TAP_PVT
- show dependent code
OKL_TAP_PVT
- show dependent code
OKL_VARIABLE_INTEREST_PVT
- show dependent code
OKL_XLP_PVT
- show dependent code
|
|
|
|