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

VIEW: APPS.OKL_CS_BPD_INV_DTL_V

Object Details
Object Name: OKL_CS_BPD_INV_DTL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_CS_BPD_INV_DTL_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

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

Invoice header id
CHR_ID NUMBER

Foreign key to view OKL_K_HEADERS_V
LSM_ID NUMBER

Foreign key to view OKL_CNSLD_AR_STRMS_V for old invoices and ltd_id for new invoices
INVOICE_NUMBER VARCHAR2 (90)
Combination of consolidated and AR invoice numbers
INVOICE_CURRENCY_CODE VARCHAR2 (15)
Currency Code
DUE_DATE DATE

Invoice due date
INVOICE_AMOUNT NUMBER

Header Invoice amount
AR_INVOICE_ID NUMBER

AR invoice id
INVOICE_DATE DATE

Invoice date
BILL_TO_SITE_USE_ID NUMBER

Foreign Key to table OKX_CUST_SITE_USES_V
CUSTOMER_ACCT_ID NUMBER

Foreign Key to table OKX_CUSTOMER_ACCOUNTS_V
ORG_ID NUMBER (15)
Operating unit id
INVOICE_TYPE VARCHAR2 (12)
Invoice type identifier
CONTRACT_NUMBER VARCHAR2 (150)
Contract Number
PAYMENT_TERM CHAR (9)
Payment term
STY_ID NUMBER

Foreign key to view OKL_STRM_TYPE_V
KLE_ID NUMBER

Foreign key to view OKL_K_LINES_V
LINE_AMOUNT NUMBER

Invoice line original amount due
TAX_AMOUNT NUMBER

Original tax amount
TAX_REMAINING NUMBER

Tax remaining
LINE_IDENTIFIER NUMBER

Combination of AR invoice numbers and line number
AMOUNT_ORIGINAL NUMBER

Invoice line amount including tax
INVOICE_LINE_ID NUMBER (15)
AR invoice line id
AMOUNT_APPLIED NUMBER

Applied amount
AMOUNT_CREDITED NUMBER

Amount Credited
AMOUNT_REMAINING NUMBER

Remaining amount
AMOUNT_ADJUSTED NUMBER

Amount Adjusted from Invloce
TRX_STATUS VARCHAR2 (80)
Transaction status
INVOICE_PULL_YN VARCHAR2 (3)
Query Text

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


SELECT INVOICE_ID
,      CHR_ID
,      LSM_ID
,      INVOICE_NUMBER
,      INVOICE_CURRENCY_CODE
,      DUE_DATE
,      INVOICE_AMOUNT
,      AR_INVOICE_ID
,      INVOICE_DATE
,      BILL_TO_SITE_USE_ID
,      CUSTOMER_ACCT_ID
,      ORG_ID
,      INVOICE_TYPE
,      CONTRACT_NUMBER
,      PAYMENT_TERM
,      STY_ID
,      KLE_ID
,      LINE_AMOUNT
,      TAX_AMOUNT
,      TAX_REMAINING
,      LINE_IDENTIFIER
,      AMOUNT_ORIGINAL
,      INVOICE_LINE_ID
,      AMOUNT_APPLIED
,      AMOUNT_CREDITED
,      AMOUNT_REMAINING
,      AMOUNT_ADJUSTED
,      TRX_STATUS
,      INVOICE_PULL_YN
FROM APPS.OKL_CS_BPD_INV_DTL_V;

Dependencies

[top of page]

APPS.OKL_CS_BPD_INV_DTL_V references the following:

SchemaAPPS
SynonymAR_PAYMENT_SCHEDULES_ALL
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymOKC_K_HEADERS_B
PL/SQL PackageOKL_BILLING_UTIL_PVT - show dependent code
SynonymOKL_CNSLD_AR_HDRS_B
SynonymOKL_CNSLD_AR_LINES_B
SynonymOKL_CNSLD_AR_STRMS_B
SynonymOKL_TRX_AR_INVOICES_B
SynonymOKL_TXD_AR_LN_DTLS_B
SynonymOKL_TXL_AR_INV_LNS_B
SynonymRA_CUSTOMER_TRX_ALL
SynonymRA_CUSTOMER_TRX_LINES_ALL
APPS.OKL_CS_BPD_INV_DTL_V is referenced by following:

SchemaAPPS
ViewOKL_CS_ACCOUNT_CONT_INV_UV
ViewOKL_CS_ACCOUNT_INV_UV
ViewOKL_CS_BILLINGTRX_UV
Package BodyOKL_CS_LC_CONTRACT_PVT - show dependent code
Package BodyOKL_SEEDED_FUNCTIONS_PVT - show dependent code