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

VIEW: APPS.OKL_TRX_AR_INVOICES_V

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

View Type

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



DEFINITION
Collection of all OKL transaction which generate 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
TRX_STATUS_CODE VARCHAR2 (30) Yes Transaction status
TRX_NUMBER VARCHAR2 (240)
Invoice number if required
CURRENCY_CODE VARCHAR2 (15)
Currency code
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency Conversion Type
CURRENCY_CONVERSION_RATE NUMBER

Currency Conversion Rate
CURRENCY_CONVERSION_DATE DATE

Currency Conversion Date
SET_OF_BOOKS_ID NUMBER

Accounting books defining column
TRY_ID NUMBER
Yes Foreign key to table OKL_TRX_TYPES_B
KHR_ID NUMBER

Foreign key to table OKL_K_HEADERS
CRA_ID NUMBER

Foreign key to table OKL_CURE_REPORT_AMOUNTS
POX_ID NUMBER

Foreign key to table OKL_POOL_TRANSACTIONS
TAP_ID NUMBER

Foreign key to table OKL_TRX_AP_INVOICES_B
QTE_ID NUMBER

Foreign key to table OKL_TRX_QUOTES_B
TCN_ID NUMBER

Foreign key to table OKL_TRX_CONTRACTS
CPY_ID NUMBER

Foreign key to table OKL_CURE_PAYMENTS_B
TAI_ID_REVERSES NUMBER

Foreign Key to table OKL_TRX_AR_INVOICES_B
IBT_ID NUMBER

Foreign Key to view OKX_CUST_SITE_USES_V
IXX_ID NUMBER

Foreign Key to view OKX_CUSTOMER_ACCOUNTS_V
IRM_ID NUMBER

Foreign Key to view OKX_RECEIPT_METHODS_V
IRT_ID NUMBER

Foreign Key to view OKX_RECEIVABLES_TERMS_V
SVF_ID NUMBER

Foreign key to table OKL_SERVICE_FEES_B
IPY_ID NUMBER

Foreign key to table OKL_INS_POLICIES_B
AMOUNT NUMBER (14) Yes Amount
CLG_ID NUMBER

Foreign key to table OKL_CNTR_LVLNG_GRPS_B
DATE_INVOICED DATE
Yes Date when transaction should be invoiced
AMOUNT_APPLIED NUMBER (14)
Amount paid by customer for the invoice
DESCRIPTION VARCHAR2 (1995)
General description, usually supplied by orginiating transaction
SOURCE_TABLE VARCHAR2 (90)
Source Table
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
DATE_ENTERED DATE
Yes Creation date
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
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
LEGAL_ENTITY_ID NUMBER

Stores the Legal Entity Id. Foreign Key to XLE_ENTITY_PROFILES
INF_ID NUMBER

Foreign key of okl_invoice_formats_b.ID
INVOICE_PULL_YN VARCHAR2 (3)
Foreign key of OKL_CNSLD_AR_HDRS_B.invoice_pull_yn
DUE_DATE DATE

Foreign key of OKL_CNSLD_AR_HDRS_B.due_date
ISI_ID NUMBER

Foreign key of RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID
RECEIVABLES_INVOICE_ID NUMBER

Foreign key of ra_customer_trx_all.trx_number
CUST_TRX_TYPE_ID NUMBER (15)
Foreign key of ra_customer_trx_lines_all.cust_trx_type_id
CUSTOMER_BANK_ACCOUNT_ID NUMBER (15)
Foreign key of AP_BANK_ACCOUNTS_ALL.BANK_ACCOUNT_ID
TAX_EXEMPT_FLAG VARCHAR2 (1)
Tax exempt flag
TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
Foreign key: lookup_code of fnd_lookups.lookup_type = 'OKL_TAX_EXEMPT'
REFERENCE_LINE_ID NUMBER (15)
For credit memos, to point to original invoice
PRIVATE_LABEL VARCHAR2 (4000)
Private Label to be displayed on the invoice
CONSOLIDATED_INVOICE_NUMBER VARCHAR2 (90)
OKL Consolidated bill number
OKL_SOURCE_BILLING_TRX VARCHAR2 (30)
Source of OKL billing transaction. Refer to fnd_lookups.lookup_type = 'OKL_SOURCE_BILLING_TRX'
INVESTOR_AGREEMENT_NUMBER VARCHAR2 (120)
Foreign key of okc_k_headers_b.contract_number
INVESTOR_NAME VARCHAR2 (360)
foreign key of hz_parties.party_name
TRANSACTION_DATE DATE

Stores the date on which the transaction occurred. Equivalent of the the creation date column and is used in reconciliation reports.
Query Text

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


SELECT ROW_ID
,      ID
,      OBJECT_VERSION_NUMBER
,      SFWT_FLAG
,      TRX_STATUS_CODE
,      TRX_NUMBER
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      SET_OF_BOOKS_ID
,      TRY_ID
,      KHR_ID
,      CRA_ID
,      POX_ID
,      TAP_ID
,      QTE_ID
,      TCN_ID
,      CPY_ID
,      TAI_ID_REVERSES
,      IBT_ID
,      IXX_ID
,      IRM_ID
,      IRT_ID
,      SVF_ID
,      IPY_ID
,      AMOUNT
,      CLG_ID
,      DATE_INVOICED
,      AMOUNT_APPLIED
,      DESCRIPTION
,      SOURCE_TABLE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DATE_ENTERED
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LEGAL_ENTITY_ID
,      INF_ID
,      INVOICE_PULL_YN
,      DUE_DATE
,      ISI_ID
,      RECEIVABLES_INVOICE_ID
,      CUST_TRX_TYPE_ID
,      CUSTOMER_BANK_ACCOUNT_ID
,      TAX_EXEMPT_FLAG
,      TAX_EXEMPT_REASON_CODE
,      REFERENCE_LINE_ID
,      PRIVATE_LABEL
,      CONSOLIDATED_INVOICE_NUMBER
,      OKL_SOURCE_BILLING_TRX
,      INVESTOR_AGREEMENT_NUMBER
,      INVESTOR_NAME
,      TRANSACTION_DATE
FROM APPS.OKL_TRX_AR_INVOICES_V;

Dependencies

[top of page]

APPS.OKL_TRX_AR_INVOICES_V references the following:

SchemaAPPS
SynonymOKL_TRX_AR_INVOICES_B
SynonymOKL_TRX_AR_INVOICES_TL
APPS.OKL_TRX_AR_INVOICES_V is referenced by following:

SchemaAPPS
Package BodyOKL_ACC_CALL_PVT - show dependent code
Package BodyOKL_AM_INVOICES_PVT - show dependent code
Package BodyOKL_AM_QUOTES_WF - 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_BILL_UPFRONT_TAX_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
Package BodyOKL_EXT_BILLING_CHARGES_PVT - show dependent code
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
Package BodyOKL_TAI_PVT - show dependent code
PL/SQL PackageOKL_TAI_PVT - show dependent code
Package BodyOKL_UBB_PVT - show dependent code
Package BodyOKL_VARIABLE_INTEREST_PVT - show dependent code
Package BodyOKL_VAR_INT_FLOAT_PVT - show dependent code
Package BodyOKL_VENDOR_REFUND_PVT - show dependent code