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_WORK_ORDER_REQ_PO_V

Object Details

Object Name:	EAM_WORK_ORDER_REQ_PO_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

View shows purchase order and requisition details of a work order.

[View Source]

Columns

Name	Datatype	Length	Comments
WIP_ENTITY_ID	NUMBER		Work order number
OPERATION_SEQ_NUM	NUMBER		Operation sequence number
ORGANIZATION_ID	NUMBER		Organization 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		Quantity ordered in the requisition
QUANTITY_ORDERED	NUMBER		Quantity ordered in the purchase order
QUANTITY_RECEIVED	NUMBER		Quantity received for a purchase order
PO_QUANTITY_ORDERED	NUMBER		Actual quantity ordered as recorded in purchase order distributions
PO_QUANTITY_CANCELLED	NUMBER		Quantity canceled as recorded in the purchase order distributions
ITEM_ID	NUMBER		Item identifier
DIRECT_ITEM_SEQUENCE_ID	NUMBER		Direct Item Sequence ID
VENDOR_ID	NUMBER		Vendor ID
VENDOR_NAME	VARCHAR2	(240)	Vendor Name
VENDOR_SITE_ID	NUMBER		Vendor Site identifier
VENDOR_SITE	VARCHAR2	(240)	Vendor Site Name
VENDOR_CONTACT_ID	NUMBER		Vendor Contact Identifier
VENDOR_CONTACT	VARCHAR2	(80)	Vendor Contact Name
VENDOR_PHONE	VARCHAR2	(40)	Vendor Phone Number
VENDOR_ITEM_NUM	VARCHAR2	(25)	Vendor Item Number
REQUISITON_LINE_ID	NUMBER		Requisition Line ID
PO_LINE_ID	NUMBER		Purchase order line ID
REQUISITION_HEADER_ID	NUMBER		Requisition Header ID
PO_HEADER_ID	NUMBER		Purchase Order Header ID
PO_RELEASE_ID	NUMBER		Purchase Order Release ID
CATEGORY_ID	NUMBER		Purchasing Category Id
NEED_BY_DATE	DATE		Need By Date
ORDER_TYPE_LOOKUP_CODE	VARCHAR2	(25)	Order type of PO
AMOUNT	NUMBER		Amount on PO line/Req line
AMOUNT_DELIVERED	NUMBER		Amount Delivered
RQL_AMOUNT_ORDERED	NUMBER		Amount on Requistion Line
PO_AMOUNT_ORDERED	NUMBER		Amount on PO Line

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
,      QUANTITY_ORDERED
,      QUANTITY_RECEIVED
,      PO_QUANTITY_ORDERED
,      PO_QUANTITY_CANCELLED
,      ITEM_ID
,      DIRECT_ITEM_SEQUENCE_ID
,      VENDOR_ID
,      VENDOR_NAME
,      VENDOR_SITE_ID
,      VENDOR_SITE
,      VENDOR_CONTACT_ID
,      VENDOR_CONTACT
,      VENDOR_PHONE
,      VENDOR_ITEM_NUM
,      REQUISITON_LINE_ID
,      PO_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
FROM APPS.EAM_WORK_ORDER_REQ_PO_V;

Dependencies

[top of page]

APPS.EAM_WORK_ORDER_REQ_PO_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; PO_VENDORS; PO_VENDOR_CONTACTS; PO_VENDOR_SITES_ALL

APPS.EAM_WORK_ORDER_REQ_PO_V is referenced by following:

APPS: EAM_DIRECT_ITEM_RECS_V