[Home] [Help] [Dependency Information]
Object Name: | OKL_AP_INVOICE_LINES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVOICE_ID | NUMBER | (15) | AP invoice ID | |
INVOICE_NUMBER | VARCHAR2 | (50) | AP Invoice Number | |
INVOICE_LINE_NUMBER | NUMBER | AP Invoice Line Number | ||
INVOICE_LINE_TYPE | VARCHAR2 | (25) | AP invoice line type | |
DISBURSEMENT_TYPE | VARCHAR2 | (4000) | Lease Management Disbursement Transaction Type | |
STREAM_TYPE | VARCHAR2 | (150) | Lease Management Disbursement Stream Type | |
CONTRACT_NUMBER | VARCHAR2 | (120) | Lease Contract Number | |
VENDOR_PROGRAM | VARCHAR2 | (120) | Lease Contract Vendor Program | |
INVESTOR_AGREEMENT_NUMBER | VARCHAR2 | (120) | If Contract Number exists, this is the Investor Agreement Number that associated with Lease Contract through Lease Investor Pool; if Contract Number is null, this is the Investor Agreement Number for Investor invoice. | |
ASSET_NUMBER | VARCHAR2 | (150) | Lease Contract Asset Number | |
SERVICE_ITEM | VARCHAR2 | (150) | Lease Contract passthrough Service Item (Fee or Service Line that associated with the passthrough parameters) | |
FUNDING_REQUEST_NUMBER | VARCHAR2 | (240) | Lease Contract Funding Request Number | |
INSURANCE_PRODUCT | VARCHAR2 | (80) | Lease Contract Insurance Policy associated Insurance Product | |
INSURANCE_POLICY_NUMBER | VARCHAR2 | (20) | Lease Contract Insurance Policy Number | |
REFUND_NUMBER | VARCHAR2 | (120) | Cure Refund Number that originated for the invoice |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_ID
, INVOICE_NUMBER
, INVOICE_LINE_NUMBER
, INVOICE_LINE_TYPE
, DISBURSEMENT_TYPE
, STREAM_TYPE
, CONTRACT_NUMBER
, VENDOR_PROGRAM
, INVESTOR_AGREEMENT_NUMBER
, ASSET_NUMBER
, SERVICE_ITEM
, FUNDING_REQUEST_NUMBER
, INSURANCE_PRODUCT
, INSURANCE_POLICY_NUMBER
, REFUND_NUMBER
FROM APPS.OKL_AP_INVOICE_LINES_V;
APPS.OKL_AP_INVOICE_LINES_V is not referenced by any database object
|
|
|