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


VIEW: APPS.JAI_PO_REC_VENDOR_AEL_V

Object Details
Object Name: JAI_PO_REC_VENDOR_AEL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJA.JAI_PO_REC_VENDOR_AEL_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

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER

Identifier of Application
EVENT_TYPE CHAR (10)
Event Type
EVENT_DESCRIPTION VARCHAR2 (240)
Event Description
TRX_CLASS CHAR (10)
Transaction class
TRX_CLASS_NAME CHAR (10)
Transaction class name
TRX_TYPE VARCHAR2 (25) Yes Transaction type
TRX_HDR_ID NUMBER
Yes Transaction header id
TRX_HDR_TABLE CHAR (20)
Transaction header table
INVENTORY_ORG_ID NUMBER (15)
Inventory Org ID
SET_OF_BOOKS_ID NUMBER (15) Yes Identifier for the Set of Books
JE_CATEGORY VARCHAR2 (25) Yes Journal Category
USER_JE_CATEGORY_NAME VARCHAR2 (25) Yes Journal Category Name
JE_SOURCE VARCHAR2 (25) Yes Journal Source for GL
USER_JE_SOURCE_NAME VARCHAR2 (25) Yes Journal Source name
JE_HEADER_ID NUMBER (15) Yes Journal header id
JE_LINE_NUM NUMBER (15) Yes Journal line number
ENTERED_CURRENCY VARCHAR2 (15) Yes Currency Code
ENTERED_DR NUMBER

Debit amount
ENTERED_CR NUMBER

Credit amount
ACCOUNTED_DR NUMBER

Accounted debit amount
ACCOUNTED_CR NUMBER

Accounted credit amount
CURRENCY_CONVERSION_DATE DATE

Currency conversion date
CURRENCY_CONVERSION_RATE NUMBER

Currency conversion rate
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency conversion type
CURRENCY_USER_CONVERSION_TYPE VARCHAR2 (30) Yes User conversion type
ACCOUNT_ID NUMBER (15) Yes Account ID
ACCOUNTING_DATE DATE
Yes Accounting Date
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
CREATION_DATE DATE

Standard who column
CREATED_BY NUMBER (15)
Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
RECEIPT_LINE_NUMBER NUMBER
Yes Receipt Line Number
ITEM_ID NUMBER (15)
identifies the Item
UOM VARCHAR2 (25)
The Unit of Measurement
QUANTITY NUMBER

Quantity
LOCATION VARCHAR2 (240)
Location
SUB_INVENTORY VARCHAR2 (10)
Sub Inventory
EXCISE_INV_NUM VARCHAR2 (30)
Excise Invoice Number
EXCISE_INVOICE_DATE DATE

Excise Invoice date
VAT_INV_NUM VARCHAR2 (100)
Vat Invoice number
VAT_INVOICE_DATE DATE

Vat Invoice Date
PARTY_NAME VARCHAR2 (360)
The name of the party
PARTY_NUMBER VARCHAR2 (30)
The party number
PARTY_SITE VARCHAR2 (40)
Identifies the party site
RECEIPT_NUM VARCHAR2 (30)
Receipt number
RECEIPT_DATE DATE

Receipt Date
SHIPMENT_NUM VARCHAR2 (30)
Shipment Number
SHIPMENT_DATE DATE

Shipment Date
Query Text

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


SELECT APPLICATION_ID
,      EVENT_TYPE
,      EVENT_DESCRIPTION
,      TRX_CLASS
,      TRX_CLASS_NAME
,      TRX_TYPE
,      TRX_HDR_ID
,      TRX_HDR_TABLE
,      INVENTORY_ORG_ID
,      SET_OF_BOOKS_ID
,      JE_CATEGORY
,      USER_JE_CATEGORY_NAME
,      JE_SOURCE
,      USER_JE_SOURCE_NAME
,      JE_HEADER_ID
,      JE_LINE_NUM
,      ENTERED_CURRENCY
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_USER_CONVERSION_TYPE
,      ACCOUNT_ID
,      ACCOUNTING_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      RECEIPT_LINE_NUMBER
,      ITEM_ID
,      UOM
,      QUANTITY
,      LOCATION
,      SUB_INVENTORY
,      EXCISE_INV_NUM
,      EXCISE_INVOICE_DATE
,      VAT_INV_NUM
,      VAT_INVOICE_DATE
,      PARTY_NAME
,      PARTY_NUMBER
,      PARTY_SITE
,      RECEIPT_NUM
,      RECEIPT_DATE
,      SHIPMENT_NUM
,      SHIPMENT_DATE
FROM APPS.JAI_PO_REC_VENDOR_AEL_V;

Dependencies

[top of page]

APPS.JAI_PO_REC_VENDOR_AEL_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymGL_DAILY_CONVERSION_TYPES
SynonymGL_IMPORT_REFERENCES
SynonymGL_JE_CATEGORIES
SynonymGL_JE_HEADERS
SynonymGL_JE_LINES
SynonymGL_JE_SOURCES
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
SynonymHZ_CUST_SITE_USES_ALL
ViewJAI_CUSTOMERS_V
SynonymJAI_RCV_HEADERS
SynonymJAI_RCV_TRANSACTIONS
ViewMTL_UNITS_OF_MEASURE_VL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
SynonymRCV_SHIPMENT_LINES
APPS.JAI_PO_REC_VENDOR_AEL_V is referenced by following:

SchemaAPPS
ViewJAI_PO_REC_VENDOR_AEL_GL_V
ViewJAI_PO_REC_VENDOR_AEL_SL_V