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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OKL.OKL_TRX_AP_INVS_ALL_B

Object Details

Object Name:	OKL_TRX_AP_INVS_ALL_B
Object Type:	TABLE
Owner:	OKL
FND Design Data:	OKL.OKL_TRX_AP_INVS_ALL_B
Subobject Name:
Status:	VALID

Collection of all OKL transaction which generate Payables invoices
Subtype of an OKL internal transaction. Used for Funding
if PO is required then this is probably the mechanism for assets in CIP
progress payments, pre-payments, pay in stages create the asset payable
DEFINITION
Disbursements are payments to suppliers for the cost of equipment, a prepayment facility with lessor, maintenance, insurance and other services. It also a repayment of a loan provided by an investor. After the lessor bills its customers for the costs, it pays disbursements to its suppliers. PRM rules allow to automatically calculate disbursement amounts. Users can also create one-off manual disbursements. To pay disbursement, OKL creates an invoice in Payables.
EXAMPLE
1. Purchase of equipment on a new contract.
2. Paying syndicated investor.
3. A customer pays to the lessor for equipment maintenance as a part of a contract.
The lessor pay to a vendor which performs the maintenance work.
MISCELLANEOUS
Ways to create a disbursement
1. Automatic process to check Receivables invoices and payments for OKL pass-throughs
2. Automatic process to check Receivables invoices and payments for OKL shared funds
3. Manul screen to enter one-off disbursements
4. Pay-related transactions from various OKL modules
DEFINITION
Percentage of incoming stream which is paid by a lendor to vendors providing equipment and/or services
EXAMPLE
A customer pays rent charges to the lessor. The lessor pays percentage of this payment to a vendor which provides the actual rented property.
Service & Maintenance, Insurance, Rent
MISCELLANEOUS
Since pass-throughs are based on incoming streams, number of pass-through types is close to number of stream types
DEFINITION
Part of customer payments which needs to be passed to lessor's partners.
EXAMPLE
Syndicate, Evergreen, Premium, Residual
MISCELLANEOUS
Payment from a evergreen contract
DEFINITION
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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKL_TRX_AP_INVS_ALL_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID
OKL_TRX_AP_INVS_ALL_B_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ART_ID
OKL_TRX_AP_INVS_ALL_B_FK10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	IPVS_ID
OKL_TRX_AP_INVS_ALL_B_FK11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID
OKL_TRX_AP_INVS_ALL_B_FK12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	KHR_ID
OKL_TRX_AP_INVS_ALL_B_FK13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_METHOD_CODE
OKL_TRX_AP_INVS_ALL_B_FK14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QTE_ID
OKL_TRX_AP_INVS_ALL_B_FK15	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TAP_ID_REVERSES
OKL_TRX_AP_INVS_ALL_B_FK16	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TCN_ID
OKL_TRX_AP_INVS_ALL_B_FK17	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRY_ID
OKL_TRX_AP_INVS_ALL_B_FK18	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRX_STATUS_CODE
OKL_TRX_AP_INVS_ALL_B_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CCF_ID
OKL_TRX_AP_INVS_ALL_B_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CCT_ID
OKL_TRX_AP_INVS_ALL_B_FK4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CODE_COMBINATION_ID
OKL_TRX_AP_INVS_ALL_B_FK5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CPLV_ID
OKL_TRX_AP_INVS_ALL_B_FK6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CURRENCY_CODE
OKL_TRX_AP_INVS_ALL_B_FK7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FUNDING_TYPE_CODE
OKL_TRX_AP_INVS_ALL_B_FK8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICE_CATEGORY_CODE
OKL_TRX_AP_INVS_ALL_B_FK9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	IPPT_ID
OKL_TRX_AP_INVS_ALL_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_INVOICE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Primary key column
TRX_STATUS_CODE	VARCHAR2	(30)	Yes	Transaction status
VENDOR_INVOICE_NUMBER	VARCHAR2	(240)		Vendor invoice number
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code
PAYMENT_METHOD_CODE	VARCHAR2	(30)		Payment method code
FUNDING_TYPE_CODE	VARCHAR2	(30)		Types of funding transactions
PAY_GROUP_LOOKUP_CODE	VARCHAR2	(30)		Pay group lookup code
INVOICE_TYPE	VARCHAR2	(240)		Type of invoice: Credit or Standard
INVOICE_CATEGORY_CODE	VARCHAR2	(30)		Invoice category code
SET_OF_BOOKS_ID	NUMBER			Accounting books defining column
NETTABLE_YN	VARCHAR2	(3)		Nettable flag
TRY_ID	NUMBER		Yes	Foreign key to table OKL_TRX_TYPES_B
IPVS_ID	NUMBER		Yes	Foreign Key to view OKX_VENDOR_SITES_V
KHR_ID	NUMBER			Foreign key to table OKL_K_HEADERS
CCF_ID	NUMBER			Obsolete
CCT_ID	NUMBER			Obsolete
CPLV_ID	NUMBER			Foreign Key to view OKC_K_PARTY_ROLES_V
IPPT_ID	NUMBER			Foreign Key to view OKX_PAYABLES_TERMS_V
CODE_COMBINATION_ID	NUMBER			Key flexfield combination defining column
QTE_ID	NUMBER			Foreign key to table OKL_TRX_QUOTES_B
ART_ID	NUMBER			Foreign key to table OKL_ASSET_RETURNS_B
TCN_ID	NUMBER			Foreign key to table OKL_TRX_CONTRACTS
TAP_ID_REVERSES	NUMBER			Foreign Key to table OKL_TRX_AP_INVOICES_B
DATE_ENTERED	DATE		Yes	Invoice creation date
DATE_INVOICED	DATE		Yes	Invoice billing date
AMOUNT	NUMBER		Yes	Amount
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Column used for locking records during updates
DATE_REQUISITION	DATE			Date of asset requisition
DATE_FUNDING_APPROVED	DATE			Date on which the funding was approved
INVOICE_NUMBER	VARCHAR2	(50)		Invoice number for invoices received from vendors
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
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
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
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
VENDOR_ID	NUMBER			Supplier id
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Currency conversion type
CURRENCY_CONVERSION_RATE	NUMBER			Currency conversion rate
CURRENCY_CONVERSION_DATE	DATE			Currency conversion date
POX_ID	NUMBER			Foreign key to table OKL_POOL_TRANSACTIONS
ASSET_TAP_ID	NUMBER			Foreign key to table 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 the creation date column and is used in reconciliation reports.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ID
,      TRX_STATUS_CODE
,      VENDOR_INVOICE_NUMBER
,      CURRENCY_CODE
,      PAYMENT_METHOD_CODE
,      FUNDING_TYPE_CODE
,      PAY_GROUP_LOOKUP_CODE
,      INVOICE_TYPE
,      INVOICE_CATEGORY_CODE
,      SET_OF_BOOKS_ID
,      NETTABLE_YN
,      TRY_ID
,      IPVS_ID
,      KHR_ID
,      CCF_ID
,      CCT_ID
,      CPLV_ID
,      IPPT_ID
,      CODE_COMBINATION_ID
,      QTE_ID
,      ART_ID
,      TCN_ID
,      TAP_ID_REVERSES
,      DATE_ENTERED
,      DATE_INVOICED
,      AMOUNT
,      OBJECT_VERSION_NUMBER
,      DATE_REQUISITION
,      DATE_FUNDING_APPROVED
,      INVOICE_NUMBER
,      DATE_GL
,      WORKFLOW_YN
,      CONSOLIDATE_YN
,      WAIT_VENDOR_INVOICE_YN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORG_ID
,      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
,      VENDOR_ID
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      POX_ID
,      ASSET_TAP_ID
,      LEGAL_ENTITY_ID
,      MATCH_REQUIRED_YN
,      VPA_ID
,      IPT_ID
,      IPT_FREQUENCY
,      TRANSACTION_DATE
FROM OKL.OKL_TRX_AP_INVS_ALL_B;

Dependencies

[top of page]

OKL.OKL_TRX_AP_INVS_ALL_B does not reference any database object

OKL.OKL_TRX_AP_INVS_ALL_B is referenced by following:

OKL: OKL_TRX_AP_INVS_ALL_B#