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


VIEW: APPS.OKL_AP_INVOICE_LINES_V

Object Details
Object Name: OKL_AP_INVOICE_LINES_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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.

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.OKL_AP_INVOICE_LINES_V references the following:

SchemaAPPS
SynonymAP_INVOICES_ALL
SynonymAP_INVOICE_LINES_ALL
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymOKC_K_HEADERS_ALL_B
ViewOKC_K_LINES_V
PL/SQL PackageOKL_ACCOUNTING_UTIL - show dependent code
SynonymOKL_CNSLD_AP_INVS_ALL
SynonymOKL_CURE_REFUNDS
SynonymOKL_INS_POLICIES_B
SynonymOKL_INS_PRODUCTS_B
SynonymOKL_K_HEADERS
SynonymOKL_POOLS_ALL
SynonymOKL_POOL_CONTENTS
ViewOKL_STRM_TYPE_V
SynonymOKL_TRX_AP_INVS_ALL_B
SynonymOKL_TXL_AP_INV_LNS_ALL_B

APPS.OKL_AP_INVOICE_LINES_V is not referenced by any database object