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

Object Details

Object Name:	WIP_EAM_OSP_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WIP.WIP_EAM_OSP_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 job or repetitive assembly identifier
OPERATION	NUMBER		WIP operation sequence number within a routing
RESOURCE_SEQ_NUM	NUMBER		WIP resource sequence number
ORGANIZATION_ID	NUMBER		Organization id unique identifier
PO_RELEASE_ID	NUMBER		PO Release Id
REQUISITION_NUMBER	VARCHAR2	(20)	Purchase Requisition Number
REQUISITION_HEADER_ID	NUMBER		Requisition Header Id
PO_NUMBER	VARCHAR2	(20)	Purchase Order Number
PO_HEADER_ID	NUMBER		PO Header Id
ITEM_DESCRIPTION	VARCHAR2	(240)	Outside Processing Item Description
UOM_CODE	VARCHAR2	(3)	Unit of Measure Code
UNIT_PRICE	NUMBER		Unit Price
CURRENCY_CODE	VARCHAR2	(15)	Currency Code
RQL_ORDERED	NUMBER		Quantity Ordered in Requisition Line
QUANTITY_ORDERED	NUMBER		Quantity Ordered
QUANTITY_RECEIVED	NUMBER		Quantity Received
LATEST_DELIVERY_DATE	DATE		Latest Delivery Date
PO_QUANTITY_ORDERED	NUMBER		Quantity Ordered in Purchase Order
PO_QUANTITY_CANCELLED	NUMBER		Quantity Cancelled in Purchase Order
SUPPLIER_NAME	VARCHAR2	(240)	Supplier Name
SUPPLIER_NUMBER	VARCHAR2	(30)	Supplier Number
LINE_LOCATION_ID	NUMBER		Line Location Id
PO_LINE_CANCEL_FLAG	VARCHAR2	(1)	Cancel flag for Purchase Order Line
ITEM_ID	NUMBER		Outside Processing Item ID
CLOSED_CODE	VARCHAR2	(25)	Closed Code
PO_CLOSED_CODE	VARCHAR2	(25)	Purchase Order Closed Code
REQ_AUTHORIZATION_STATUS	VARCHAR2	(25)	Requisition Authorization Status
PO_AUTHORIZATION_STATUS	VARCHAR2	(25)	Purchase Order Authorization Status
PO_LINE_ID	NUMBER		Purchase Order Line ID

Query Text

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


SELECT WIP_ENTITY_ID
,      OPERATION
,      RESOURCE_SEQ_NUM
,      ORGANIZATION_ID
,      PO_RELEASE_ID
,      REQUISITION_NUMBER
,      REQUISITION_HEADER_ID
,      PO_NUMBER
,      PO_HEADER_ID
,      ITEM_DESCRIPTION
,      UOM_CODE
,      UNIT_PRICE
,      CURRENCY_CODE
,      RQL_ORDERED
,      QUANTITY_ORDERED
,      QUANTITY_RECEIVED
,      LATEST_DELIVERY_DATE
,      PO_QUANTITY_ORDERED
,      PO_QUANTITY_CANCELLED
,      SUPPLIER_NAME
,      SUPPLIER_NUMBER
,      LINE_LOCATION_ID
,      PO_LINE_CANCEL_FLAG
,      ITEM_ID
,      CLOSED_CODE
,      PO_CLOSED_CODE
,      REQ_AUTHORIZATION_STATUS
,      PO_AUTHORIZATION_STATUS
,      PO_LINE_ID
FROM APPS.WIP_EAM_OSP_V;

Dependencies

[top of page]

APPS.WIP_EAM_OSP_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_REQ_DISTRIBUTIONS_ALL; PO_VENDORS

APPS.WIP_EAM_OSP_V is not referenced by any database object