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_OSP_REQS_POS_V

Object Details

Object Name:	WIP_OSP_REQS_POS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WIP.WIP_OSP_REQS_POS_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	Comments
PO_NUMBER	VARCHAR2	(61)	PO number
PO_REQ_TYPE	VARCHAR2	(25)	Whether it is purchase order or requisition
APPROVAL_STATUS	VARCHAR2	(80)	Approval status
APPROVAL_STATUS_CODE	VARCHAR2	(25)	Approval status code
OLD_NEED_BY_DATE	DATE		Current need by date
OLD_PROMISED_DATE	DATE		Current promised date by supplier
NEW_NEED_BY_DATE	DATE		New need by date required on shop floor
ASSEMBLY_QTY_PENDING	NUMBER		Quantity to be received in terms of end assembly
ASSEMBLY_PRIMARY_UOM	VARCHAR2	(25)	Assembly primary unit of measure
WIP_ENTITY_ID	NUMBER		WIP job or repetitive schedule identifier
REPETITIVE_SCHEDULE_ID	NUMBER		Repetitive schedule iendifier
ORGANIZATION_ID	NUMBER		Organization identifier
OPERATION_SEQ_NUM	NUMBER		Operation sequence number within a routing
RESOURCE_SEQ_NUM	NUMBER		Resource sequence number within an operation
OPERATION_CODE	VARCHAR2	(4)	Operation code
PO_HEADER_ID	NUMBER		Document header identifier
PO_RELEASE_ID	NUMBER		Document release identifier
PO_LINE_ID	NUMBER		Document line identifier
LINE_LOCATION_ID	NUMBER		Document shipment schedule identifier
PO_DISTRIBUTION_ID	NUMBER		Document distribution identifier
ORG_ID	NUMBER		Operating unit identifier
OSP_ITEM_ID	NUMBER		Purchased item identifier
OSP_ITEM_QTY_ORDERED	NUMBER		Quantity ordered interms of purchased item
OSP_ITEM_UOM	VARCHAR2	(25)	Purchased item unit of measure
REQ_NUMBER	VARCHAR2	(20)	Requisition number
REQUISITION_HEADER_ID	NUMBER		Requisition header identifier
REQUISITION_LINE_ID	NUMBER		Requisition line identifier
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
CANCEL_FLAG	VARCHAR2	(1)	Cancel Flag

Query Text

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


SELECT PO_NUMBER
,      PO_REQ_TYPE
,      APPROVAL_STATUS
,      APPROVAL_STATUS_CODE
,      OLD_NEED_BY_DATE
,      OLD_PROMISED_DATE
,      NEW_NEED_BY_DATE
,      ASSEMBLY_QTY_PENDING
,      ASSEMBLY_PRIMARY_UOM
,      WIP_ENTITY_ID
,      REPETITIVE_SCHEDULE_ID
,      ORGANIZATION_ID
,      OPERATION_SEQ_NUM
,      RESOURCE_SEQ_NUM
,      OPERATION_CODE
,      PO_HEADER_ID
,      PO_RELEASE_ID
,      PO_LINE_ID
,      LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      ORG_ID
,      OSP_ITEM_ID
,      OSP_ITEM_QTY_ORDERED
,      OSP_ITEM_UOM
,      REQ_NUMBER
,      REQUISITION_HEADER_ID
,      REQUISITION_LINE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CANCEL_FLAG
FROM APPS.WIP_OSP_REQS_POS_V;

Dependencies

[top of page]

APPS.WIP_OSP_REQS_POS_V references the following:

APPS: BOM_CALENDAR_DATES; BOM_STANDARD_OPERATIONS; FND_GLOBAL - show dependent code; MTL_PARAMETERS; MTL_SYSTEM_ITEMS; PO_DISTRIBUTIONS_ALL; PO_DOCUMENT_TYPES_ALL; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_LOOKUP_CODES; PO_RELEASES_ALL; PO_REQUISITION_HEADERS_ALL; PO_REQUISITION_LINES_ALL; WIP_ENTITIES; WIP_OPERATIONS; WIP_OPERATION_RESOURCES; WIP_OSP - show dependent code

APPS.WIP_OSP_REQS_POS_V is not referenced by any database object