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

VIEW: APPS.OKL_TXL_AR_INV_LNS_V

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

View Type

A public view which may be useful for custom reporting or other data
requirements.



DEFINITION
Transaction lines to be included into Receivables invoices
EXAMPLE
MISCELLANEOUS


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Auto-generated by Headstart Utilities
ID NUMBER
Yes Primary key column
OBJECT_VERSION_NUMBER NUMBER (9) Yes Column used for locking records during updates
SFWT_FLAG VARCHAR2 (3) Yes Column used by the translation batch program
KLE_ID NUMBER

Foreign key to table OKL_K_LINES
TPL_ID NUMBER

Foreign key to table OKL_TXL_AP_INV_LNS_B
IBT_ID NUMBER

Not currently used; Bill_To site
ISL_ID NUMBER

Foreign Key to view OKL_AM_SALES_ORDERS_V
TIL_ID_REVERSES NUMBER

Foreign Key to table OKL_TXL_AR_INV_LNS_B
INV_RECEIV_LINE_CODE VARCHAR2 (30)
Line types are: line, tax, freight, or charges
STY_ID NUMBER

Foreign key to table OKL_STRM_TYPE_B
TAI_ID NUMBER
Yes Foreign key to table OKL_TRX_AR_INVOICES_B
CLL_ID NUMBER

Foreign key to table OKL_CNTR_LVLNG_LNS_B
ACN_ID_COST NUMBER

Foreign Key to table OKL_ASSET_CNDTN_LNS_B
AMOUNT NUMBER (14)
Amount
LINE_NUMBER NUMBER

Line number
QUANTITY NUMBER

Number of units shipped
DESCRIPTION VARCHAR2 (1995)
General description, usually supplied by the originating transaction.
ERROR_MESSAGE VARCHAR2 (3000)
Error Message
RECEIVABLES_INVOICE_ID NUMBER

Surrogate key used for primary unique identifiers
LATE_CHARGE_REC_ID NUMBER

Late Charge Record ID
AMOUNT_APPLIED NUMBER (14)
monetary amount
DATE_BILL_PERIOD_START DATE

Start date for bill period
DATE_BILL_PERIOD_END DATE

End date for bill period
INVENTORY_ITEM_ID NUMBER

Inventory item 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
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
INVENTORY_ORG_ID NUMBER

Inventory organization identifier
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
QTE_LINE_ID NUMBER

Quote line identifier
TXS_TRX_ID NUMBER

Transaction identifier
BANK_ACCT_ID NUMBER

Bank account identifier
TXL_AR_LINE_NUMBER NUMBER

Parent key to identify the children records of OKL internal billing details (OKL_TXD_AR_LN_DTLS_B) within the same OKL internal billing header (OKL_TRX_AR_INVOICES_B).
TXS_TRX_LINE_ID NUMBER

Foreign key of OKL_TAX_SOURCES.trx_line_id
UPGRADE_FROM_TWO_LEVEL_YN VARCHAR2 (1)
Upgrade from two level Yes/No flag
TAX_LINE_ID NUMBER

ID of zx_lines
Query Text

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


SELECT ROW_ID
,      ID
,      OBJECT_VERSION_NUMBER
,      SFWT_FLAG
,      KLE_ID
,      TPL_ID
,      IBT_ID
,      ISL_ID
,      TIL_ID_REVERSES
,      INV_RECEIV_LINE_CODE
,      STY_ID
,      TAI_ID
,      CLL_ID
,      ACN_ID_COST
,      AMOUNT
,      LINE_NUMBER
,      QUANTITY
,      DESCRIPTION
,      ERROR_MESSAGE
,      RECEIVABLES_INVOICE_ID
,      LATE_CHARGE_REC_ID
,      AMOUNT_APPLIED
,      DATE_BILL_PERIOD_START
,      DATE_BILL_PERIOD_END
,      INVENTORY_ITEM_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORG_ID
,      INVENTORY_ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      QTE_LINE_ID
,      TXS_TRX_ID
,      BANK_ACCT_ID
,      TXL_AR_LINE_NUMBER
,      TXS_TRX_LINE_ID
,      UPGRADE_FROM_TWO_LEVEL_YN
,      TAX_LINE_ID
FROM APPS.OKL_TXL_AR_INV_LNS_V;

Dependencies

[top of page]

APPS.OKL_TXL_AR_INV_LNS_V references the following:

SchemaAPPS
SynonymOKL_TXL_AR_INV_LNS_B
SynonymOKL_TXL_AR_INV_LNS_TL
APPS.OKL_TXL_AR_INV_LNS_V is referenced by following:

SchemaAPPS
Package BodyOKL_ACC_CALL_PVT - show dependent code
Package BodyOKL_AJL_PVT - show dependent code
Package BodyOKL_AM_CNTRCT_LN_TRMNT_PVT - show dependent code
Package BodyOKL_AM_INVOICES_PVT - show dependent code
Package BodyOKL_AM_LEASE_TRMNT_PVT - show dependent code
PL/SQL PackageOKL_ARINTF_PVT - show dependent code
Package BodyOKL_ARINTF_PVT - show dependent code
Package BodyOKL_BILLING_CONTROLLER_PVT - show dependent code
Package BodyOKL_BILLING_RECON_RPT_PVT - show dependent code
Package BodyOKL_BPD_ADVANCED_BILLING_PVT - show dependent code
Package BodyOKL_CONS_BILL - show dependent code
Package BodyOKL_CURE_CALC_PVT - show dependent code
ViewOKL_CURE_REFUNDS_DTLS_UV
PL/SQL PackageOKL_INTERNAL_TO_EXTERNAL - show dependent code
Package BodyOKL_INTERNAL_TO_EXTERNAL - show dependent code
Package BodyOKL_PAY_CURE_REFUNDS_PVT - show dependent code
Package BodyOKL_PAY_INVOICES_DISB_PVT - show dependent code
Package BodyOKL_PROP_TAX_ADJ_PVT - show dependent code
Package BodyOKL_REBOOK_CM_PVT - show dependent code
Package BodyOKL_REPORT_PVT - show dependent code
Package BodyOKL_STREAM_BILLING_PUB - show dependent code
Package BodyOKL_STREAM_BILLING_PVT - show dependent code
Package BodyOKL_SUBSIDY_PROCESS_PVT - show dependent code
PL/SQL PackageOKL_TIL_PVT - show dependent code
Package BodyOKL_TIL_PVT - show dependent code
Package BodyOKL_UBB_PVT - show dependent code
Package BodyOKL_VARIABLE_INTEREST_PVT - show dependent code
Package BodyOKL_VENDOR_REFUND_PVT - show dependent code