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


VIEW: APPS.JAI_PLA_ENTRY_AEL_V

Object Details
Object Name: JAI_PLA_ENTRY_AEL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJA.JAI_PLA_ENTRY_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 (16)
Event Type
TRX_CLASS CHAR (16)
Transaction class
TRX_CLASS_NAME CHAR (16)
Transaction class name
TRX_HDR_ID NUMBER
Yes Transaction header id
TRX_HDR_TABLE CHAR (19)
Transaction header table
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
LEDGER_ID NUMBER (15) Yes Identifies the ledger
JE_BATCH_ID NUMBER (15)
Journal batch id
JE_HEADER_ID NUMBER (15) Yes Journal header id
JE_LINE_NUM NUMBER (15) Yes Journal line number
CURRENCY_CODE VARCHAR2 (15) Yes Currency Code
ENTERED_CR NUMBER

Credit amount
ENTERED_DR NUMBER

Debit amount
ACCOUNTED_CR NUMBER

Accounted credit amount
ACCOUNTED_DR NUMBER

Accounted debit amount
CURRENCY_CONVERSION_DATE DATE

Currency conversion date
CURRENCY_CONVERSION_RATE NUMBER

Currency conversion rate
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency conversion type
CODE_COMBINATION_ID NUMBER (15) Yes Code combination id
ACCOUNTING_DATE DATE
Yes Accounting Date
CURRENCY_USER_CONVERSION_TYPE VARCHAR2 (30) Yes User conversion type
SOURCE_ID NUMBER
Yes Source ID
SOURCE_TABLE CHAR (20)
Source table
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
GL_TRANSFER_STATUS CHAR (1)
Status of GL transfer
GL_TRANSFER_STATUS_NAME VARCHAR2 (80) Yes GL transfer status name
ORG_ID VARCHAR2 (150)
Identifies the operating unit
THIRD_PARTY_ID NUMBER (15)
Third party id
THIRD_PARTY_NAME VARCHAR2 (360)
Name of the third party
THIRD_PARTY_NUMBER VARCHAR2 (1)
Third party number
THIRD_PARTY_SUB_ID NUMBER (15)
Third party sub id
THIRD_PARTY_SUB_NAME VARCHAR2 (40)
Third party sub name
TRX_DATE DATE
Yes The date on which transaction is made
REFERENCE_NO NUMBER (15)
The reference number
INVOICE_NO VARCHAR2 (200)
Invoice Number
INVOICE_DATE DATE

Date on which invoice is created
ORG_NAME VARCHAR2 (240) Yes The name of the organization name
ITEM_ID NUMBER (15)
identifies the Item
SERIAL_NO NUMBER (15) Yes The serial number
TRANSACTION_TYPE VARCHAR2 (7)
Identifies the type of transaction
ISSUE_TYPE VARCHAR2 (8)
Issue type
LOCATION_ID NUMBER (15) Yes Identifies the location
LOCATION_NAME VARCHAR2 (240)
Name of the location
INVENTORY_ORGANIZATION_CODE VARCHAR2 (3)
code of the Inventory organization
INVENTORY_ORGANIZATION_ID NUMBER

Identifies the inventory organization
Query Text

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


SELECT APPLICATION_ID
,      EVENT_TYPE
,      TRX_CLASS
,      TRX_CLASS_NAME
,      TRX_HDR_ID
,      TRX_HDR_TABLE
,      JE_CATEGORY
,      USER_JE_CATEGORY_NAME
,      JE_SOURCE
,      USER_JE_SOURCE_NAME
,      LEDGER_ID
,      JE_BATCH_ID
,      JE_HEADER_ID
,      JE_LINE_NUM
,      CURRENCY_CODE
,      ENTERED_CR
,      ENTERED_DR
,      ACCOUNTED_CR
,      ACCOUNTED_DR
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      CODE_COMBINATION_ID
,      ACCOUNTING_DATE
,      CURRENCY_USER_CONVERSION_TYPE
,      SOURCE_ID
,      SOURCE_TABLE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      GL_TRANSFER_STATUS
,      GL_TRANSFER_STATUS_NAME
,      ORG_ID
,      THIRD_PARTY_ID
,      THIRD_PARTY_NAME
,      THIRD_PARTY_NUMBER
,      THIRD_PARTY_SUB_ID
,      THIRD_PARTY_SUB_NAME
,      TRX_DATE
,      REFERENCE_NO
,      INVOICE_NO
,      INVOICE_DATE
,      ORG_NAME
,      ITEM_ID
,      SERIAL_NO
,      TRANSACTION_TYPE
,      ISSUE_TYPE
,      LOCATION_ID
,      LOCATION_NAME
,      INVENTORY_ORGANIZATION_CODE
,      INVENTORY_ORGANIZATION_ID
FROM APPS.JAI_PLA_ENTRY_AEL_V;

Dependencies

[top of page]

APPS.JAI_PLA_ENTRY_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
ViewGL_LOOKUPS
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL
SynonymHR_ORGANIZATION_INFORMATION
PL/SQL PackageHR_SECURITY - show dependent code
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_PARTIES
SynonymJAI_CMN_RG_PLA_TRXS
SynonymMTL_SYSTEM_ITEMS_B
ViewORG_ORGANIZATION_DEFINITIONS
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
APPS.JAI_PLA_ENTRY_AEL_V is referenced by following:

SchemaAPPS
ViewJAI_PLA_ENTRY_AEL_GL_V
ViewJAI_PLA_ENTRY_AEL_SL_V