eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.JAI_PO_OSPM_AEL_V

Object Details

Object Name:	JAI_PO_OSPM_AEL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JA.JAI_PO_OSPM_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
EVENT_TYPE	CHAR	(23)		Event Type
APPLICATION_ID	NUMBER			Identifier of Application
SET_OF_BOOK_ID	NUMBER	(15)	Yes	Identifier for the Set of Books
INV_ORG_ID	NUMBER	(15)		Inventory Org ID
INV_ORG_CODE	VARCHAR2	(3)		Inventory Org code
TRX_CLASS	CHAR	(12)		Transaction class
TRX_CLASS_NAME	CHAR	(16)		Transaction class name
TRX_HDR_ID	NUMBER		Yes	Transaction header id
TRX_HDR_TABLE	CHAR	(15)		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
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_DEBIT	NUMBER			Debit amount
ENTERED_CREDIT	NUMBER			Credit amount
ACCOUNT_DEBIT	NUMBER			Accounted debit amount
ACCOUNT_CREDIT	NUMBER			Accounted credit amount
ACCOUNT_ID	NUMBER	(15)	Yes	Account ID
ACCOUNTING_DATE	DATE		Yes	Accounting 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
CURRENCY_CONVERSION_DATE	DATE			Currency conversion date
DISPATCH_REGISTER	VARCHAR2	(30)		The dispatch register id
DISPATCH_ENTRY_NUMBER	NUMBER	(15)		Dispatch entry number
RECEIPT_REGISTER	VARCHAR2	(30)		The register for receipt entry
RECEIPT_ENTRY_NUMBER	NUMBER	(15)		Receipt entry number
LINE_ID	NUMBER		Yes	Identifies the line
JOB_ID	NUMBER			Identifies the job
JOB_NAME	VARCHAR2	(240)	Yes	Job name
ITEM_ID	NUMBER		Yes	identifies the Item
SUPPLIER_ID	NUMBER		Yes	identifies the supplier
SUPPLIER_NUMBER	VARCHAR2	(30)	Yes	The supplier number
SUPPLIER_NAME	VARCHAR2	(240)		The supplier name
SUPPLIER_SITE_ID	NUMBER		Yes	The supplier site id
SUPPLIER_SITE	VARCHAR2	(15)	Yes	The supplier site
PO_HEADER_ID	NUMBER			Identifies the purchase order
PO_NUMBER	VARCHAR2	(20)	Yes	The purchase order number
UOM	VARCHAR2	(25)	Yes	The Unit of Measurement
ORIGINAL_QUANTITY	NUMBER			The original quantity
DISPATCHED_QUANTITY	NUMBER			The Quantity dispatched
RETURN_QUANTITY	NUMBER			The Quantity returned
FORM_NUMBER	NUMBER			Form number
FORM_DATE	DATE			Form date
DISPATCH_DATE	DATE			The date on which the quantity is dispatched
RECEIVE_UPTO	DATE			The date by which quantity has to be received
PRIMARY_FORM_ID	NUMBER			Primary form id
PRIMARY_FORM_NUMBER	NUMBER			Primary form number
CREATION_DATE	DATE			Standard who column
CREATED_BY	NUMBER			Standard who column
LAST_UPDATE_DATE	DATE			Standard who column
LAST_UPDATED_BY	NUMBER			Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column

Query Text

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


SELECT EVENT_TYPE
,      APPLICATION_ID
,      SET_OF_BOOK_ID
,      INV_ORG_ID
,      INV_ORG_CODE
,      TRX_CLASS
,      TRX_CLASS_NAME
,      TRX_HDR_ID
,      TRX_HDR_TABLE
,      JE_CATEGORY
,      USER_JE_CATEGORY_NAME
,      JE_SOURCE
,      USER_JE_SOURCE_NAME
,      JE_HEADER_ID
,      JE_LINE_NUM
,      ENTERED_CURRENCY
,      ENTERED_DEBIT
,      ENTERED_CREDIT
,      ACCOUNT_DEBIT
,      ACCOUNT_CREDIT
,      ACCOUNT_ID
,      ACCOUNTING_DATE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_USER_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      DISPATCH_REGISTER
,      DISPATCH_ENTRY_NUMBER
,      RECEIPT_REGISTER
,      RECEIPT_ENTRY_NUMBER
,      LINE_ID
,      JOB_ID
,      JOB_NAME
,      ITEM_ID
,      SUPPLIER_ID
,      SUPPLIER_NUMBER
,      SUPPLIER_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE
,      PO_HEADER_ID
,      PO_NUMBER
,      UOM
,      ORIGINAL_QUANTITY
,      DISPATCHED_QUANTITY
,      RETURN_QUANTITY
,      FORM_NUMBER
,      FORM_DATE
,      DISPATCH_DATE
,      RECEIVE_UPTO
,      PRIMARY_FORM_ID
,      PRIMARY_FORM_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.JAI_PO_OSPM_AEL_V;

Dependencies

[top of page]

APPS.JAI_PO_OSPM_AEL_V references the following:

APPS: AP_SUPPLIER_SITES_ALL; GL_DAILY_CONVERSION_TYPES; GL_IMPORT_REFERENCES; GL_JE_CATEGORIES; GL_JE_HEADERS; GL_JE_LINES; GL_JE_SOURCES; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; JAI_PO_OSP_HDRS; JAI_PO_OSP_LINES; ORG_ORGANIZATION_DEFINITIONS; PO_HEADERS_ALL; PO_VENDORS; WIP_ENTITIES

APPS.JAI_PO_OSPM_AEL_V is referenced by following:

APPS: JAI_PO_OSPM_AEL_GL_V; JAI_PO_OSPM_AEL_SL_V