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

VIEW: APPS.OKL_BPD_AR_INV_LINES_V

Object Details
Object Name: OKL_BPD_AR_INV_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_BPD_AR_INV_LINES_V
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
CONTRACT_NUMBER VARCHAR2 (150)
Contract Number
CONTRACT_ID NUMBER

Contract identifier
CONTRACT_LINE_ID NUMBER

Contract Line identifier
RECEIVABLES_INVOICE_NUMBER VARCHAR2 (20) Yes Transaction number
RECEIVABLES_INVOICE_ID NUMBER (15) Yes Invoice identifier
INVOICE_ID NUMBER (15) Yes Invoice identifier
TXD_ID NUMBER
Yes Foreign key of OKL_TXD_AR_LN_DTLS_B.id
STREAM_ID NUMBER
Yes Foreign key of OKL_TXD_AR_LN_DTLS_B.id
AMOUNT_DUE_REMAINING NUMBER

remaining balance
AMOUNT_DUE_ORIGINAL NUMBER

original balance
DUE_DATE DATE
Yes Due date of this installment
STREAM_TYPE_ID NUMBER
Yes Foreign key of OKL_STRM_TYPE_B.id
LATE_CHARGE_ASS_YN VARCHAR2 (3)
Late charge assess Yes/No
LATE_CHARGE_ASSESS_DATE DATE

Late charge assess date
LATE_INT_ASS_YN VARCHAR2 (3)
Late interest assess Yes/No
LATE_INT_ASSESS_DATE DATE

Late interest assess Date
SEL_ID NUMBER

Foreign key to table OKL_STRM_ELEMENTS.id
ID NUMBER
Yes Foreign key of OKL_TXD_AR_LN_DTLS_B.id
TRX_NUMBER VARCHAR2 (20) Yes Transaction number
TIL_ID_DETAILS NUMBER

Foreign Key to table OKL_TXL_AR_INV_LNS_B.id
AMOUNT NUMBER

Total amount
INTERFACE_LINE_CONTEXT VARCHAR2 (30)
Interface line context
STY_ID NUMBER

Foreign key of OKL_STRM_TYPE_B.id
CLASS VARCHAR2 (20) Yes Lookup code for the class of the payment schedule
LINE_NUMBER NUMBER
Yes Invoice Line number
CURRENCY_CODE VARCHAR2 (15)
Invoice currency
RECEIVABLES_INVOICE_LINE_ID NUMBER (15) Yes Invoice Line identifier
IXX_ID NUMBER (15)
Customer identifier
TAX_AMOUNT NUMBER

Tax amount
AMOUNT_LINE_ITEMS_REMAINING NUMBER

Amount Line Items remaining
LINE_TYPE VARCHAR2 (150)
Invoice format Line Type
TXN_LINE_TYPE VARCHAR2 (20) Yes Invoice line type
ORG_ID NUMBER (15)
Operating unit identifier
LINE_AMOUNT_REMAINING_WOTAX NUMBER

Line amount remaining excluding tax
Query Text

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


SELECT CONTRACT_NUMBER
,      CONTRACT_ID
,      CONTRACT_LINE_ID
,      RECEIVABLES_INVOICE_NUMBER
,      RECEIVABLES_INVOICE_ID
,      INVOICE_ID
,      TXD_ID
,      STREAM_ID
,      AMOUNT_DUE_REMAINING
,      AMOUNT_DUE_ORIGINAL
,      DUE_DATE
,      STREAM_TYPE_ID
,      LATE_CHARGE_ASS_YN
,      LATE_CHARGE_ASSESS_DATE
,      LATE_INT_ASS_YN
,      LATE_INT_ASSESS_DATE
,      SEL_ID
,      ID
,      TRX_NUMBER
,      TIL_ID_DETAILS
,      AMOUNT
,      INTERFACE_LINE_CONTEXT
,      STY_ID
,      CLASS
,      LINE_NUMBER
,      CURRENCY_CODE
,      RECEIVABLES_INVOICE_LINE_ID
,      IXX_ID
,      TAX_AMOUNT
,      AMOUNT_LINE_ITEMS_REMAINING
,      LINE_TYPE
,      TXN_LINE_TYPE
,      ORG_ID
,      LINE_AMOUNT_REMAINING_WOTAX
FROM APPS.OKL_BPD_AR_INV_LINES_V;

Dependencies

[top of page]

APPS.OKL_BPD_AR_INV_LINES_V references the following:

SchemaAPPS
SynonymAR_PAYMENT_SCHEDULES_ALL
PL/SQL PackageOKL_BILLING_UTIL_PVT - show dependent code
SynonymOKL_STRM_TYPE_B
SynonymOKL_TXD_AR_LN_DTLS_B
SynonymOKL_TXL_AR_INV_LNS_B
SynonymRA_CUSTOMER_TRX_ALL
SynonymRA_CUSTOMER_TRX_LINES_ALL
APPS.OKL_BPD_AR_INV_LINES_V is referenced by following:

SchemaAPPS
Package BodyOKL_AM_CALC_QUOTE_STREAM_PVT - show dependent code
ViewOKL_BPD_AR_INV_LN_DTLS_V
ViewOKL_BPD_CONTRACT_INVOICES_V
ViewOKL_BPD_TRX_RCPT_HEADER_V
ViewOKL_BPD_TRX_SUM_RCPT_DTLS_UV
Package BodyOKL_LTE_CHRG_PVT - show dependent code
Package BodyOKL_LTE_INT_PVT - show dependent code
Package BodyOKL_PAY_INVOICES_DISB_PVT - show dependent code
PL/SQL PackageOKL_PAY_INVOICES_DISB_PVT - show dependent code
Package BodyOKL_SEEDED_FUNCTIONS_PVT - show dependent code
Package BodyOKL_SUBSIDY_PROCESS_PVT - show dependent code
Package BodyOKL_VARIABLE_INT_UTIL_PVT - show dependent code