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.EAM_WO_REQ_PO_LITE_V

Object Details

Object Name:	EAM_WO_REQ_PO_LITE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EAM.EAM_WO_REQ_PO_LITE_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
WIP_ENTITY_ID	NUMBER		Wip entity Id
OPERATION_SEQ_NUM	NUMBER		Operation Sequence Number
ORGANIZATION_ID	NUMBER		Organziation Id
REQUISITION_NUMBER	VARCHAR2	(20)	Requisition Number
PO_NUMBER	VARCHAR2	(20)	Purchase Order Number
ITEM_DESCRIPTION	VARCHAR2	(240)	Item Description
UOM_CODE	VARCHAR2	(3)	Unit of Measure code
UNIT_PRICE	NUMBER		Unit Price
CURRENCY_CODE	VARCHAR2	(15)	Currency Code
RQL_QUANTITY_ORDERED	NUMBER		Requisition quantity ordered
RQL_QUANTITY_CANCELLED	NUMBER
QUANTITY_ORDERED	NUMBER		Quantity Ordered
QUANTITY_RECEIVED	NUMBER		Quantity Received
PO_QUANTITY_ORDERED	NUMBER		Quantity ordered on PO
PO_QUANTITY_CANCELLED	NUMBER		Quantity cancelled on PO
ITEM_ID	NUMBER		Inventory Item Id
DIRECT_ITEM_SEQUENCE_ID	NUMBER		Direct item sequence id
VENDOR_ID	NUMBER		Vendor Id
VENDOR_NAME	VARCHAR2	(240)	Vendor Name
REQUISITON_LINE_ID	NUMBER		Requisition Line Id
REQUISITION_HEADER_ID	NUMBER		Requisition Header Id
PO_HEADER_ID	NUMBER		PO Header Id
PO_RELEASE_ID	NUMBER		PO Release Id
CATEGORY_ID	NUMBER		Category Id
NEED_BY_DATE	DATE		Need By Date
ORDER_TYPE_LOOKUP_CODE	VARCHAR2	(25)	Line type of the Req/PO (Amount based, Quantity based etc)
AMOUNT	NUMBER		Amount (If line type is amount based)
AMOUNT_DELIVERED	NUMBER		Amount delivered
RQL_AMOUNT_ORDERED	NUMBER		Requisition amount ordered
PO_AMOUNT_ORDERED	NUMBER		PO Amount Ordered
REQUISITION_STATUS	VARCHAR2	(25)
PO_STATUS	VARCHAR2	(25)

Query Text

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


SELECT WIP_ENTITY_ID
,      OPERATION_SEQ_NUM
,      ORGANIZATION_ID
,      REQUISITION_NUMBER
,      PO_NUMBER
,      ITEM_DESCRIPTION
,      UOM_CODE
,      UNIT_PRICE
,      CURRENCY_CODE
,      RQL_QUANTITY_ORDERED
,      RQL_QUANTITY_CANCELLED
,      QUANTITY_ORDERED
,      QUANTITY_RECEIVED
,      PO_QUANTITY_ORDERED
,      PO_QUANTITY_CANCELLED
,      ITEM_ID
,      DIRECT_ITEM_SEQUENCE_ID
,      VENDOR_ID
,      VENDOR_NAME
,      REQUISITON_LINE_ID
,      REQUISITION_HEADER_ID
,      PO_HEADER_ID
,      PO_RELEASE_ID
,      CATEGORY_ID
,      NEED_BY_DATE
,      ORDER_TYPE_LOOKUP_CODE
,      AMOUNT
,      AMOUNT_DELIVERED
,      RQL_AMOUNT_ORDERED
,      PO_AMOUNT_ORDERED
,      REQUISITION_STATUS
,      PO_STATUS
FROM APPS.EAM_WO_REQ_PO_LITE_V;

Dependencies

[top of page]

APPS.EAM_WO_REQ_PO_LITE_V references the following:

APPS: MTL_UNITS_OF_MEASURE; PO_DISTRIBUTIONS_ALL; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_LINE_TYPES; PO_REQUISITION_HEADERS_ALL; PO_REQUISITION_LINES_ALL

APPS.EAM_WO_REQ_PO_LITE_V is referenced by following:

APPS: EAM_DIRECT_ITEMS_RECS_LITE_V