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
FND Design Data: ViewEAM.EAM_WORK_ORDER_REQ_PO_V
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 Mandatory 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
RQL_QUANTITY_CANCELLED NUMBER

Quantity Cancelled 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
,      RQL_QUANTITY_CANCELLED
,      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:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymMTL_UNITS_OF_MEASURE
SynonymPO_DISTRIBUTIONS_ALL
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_LINE_TYPES
SynonymPO_REQUISITION_HEADERS_ALL
SynonymPO_REQUISITION_LINES_ALL
ViewPO_VENDORS
ViewPO_VENDOR_CONTACTS
ViewPO_VENDOR_SITES_ALL
APPS.EAM_WORK_ORDER_REQ_PO_V is referenced by following:

SchemaAPPS
ViewEAM_DIRECT_ITEM_RECS_V