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_ICX_OSP_WORKBENCH_V

Object Details

Object Name:	WIP_ICX_OSP_WORKBENCH_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WIP.WIP_ICX_OSP_WORKBENCH_V
Subobject Name:
Status:	VALID

View Type

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

WIP_ICX_OSP_WORKBENCH_V shows WIP outside processing purchase orders information, and it is used for Self Service Web Applications.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PO_NUMBER	VARCHAR2	(61)		Purchase order number
ITEM_NUMBER	VARCHAR2	(40)		Purchased item number
SUPPLIER_ITEM_NUMBER	VARCHAR2	(25)		Supplier item number
ITEM_DESCRIPTION	VARCHAR2	(240)		Purchased item description
NEED_BY_DATE	DATE			Need by date for the shipment schedule
PROMISED_DATE	DATE			Supplier promised delivery date
QUANTITY_ORDERED	NUMBER			Quantity ordered
QUANTITY_DELIVERED	NUMBER			Quantity delivered
UOM	VARCHAR2	(25)		Unit of measure
WIP_ENTITY_NAME	VARCHAR2	(240)	Yes	WIP job or repetitive assembly name
WIP_ENTITY_TYPE	NUMBER		Yes	WIP entity type code
WIP_LINE_CODE	VARCHAR2	(10)		WIP line name
WIP_REPETITIVE_SCHEDULE_ID	NUMBER			WI repetitive schedule identifier
WIP_OPERATION_SEQ_NUM	NUMBER			WIP operation sequence number within a routing
COMPONENT	VARCHAR2	(4000)		Whether or not components exist for an operation
ATTACHMENT	VARCHAR2	(4000)		Whether or not attachments exist for an operation
PO_HEADER_ID	NUMBER		Yes	Document header unique identifier
PO_RELEASE_ID	NUMBER			Blanket purchase order release identifier
PO_LINE_ID	NUMBER			Document line unique identifier
LINE_LOCATION_ID	NUMBER			Document shipment schedule unique identifier
PO_DISTRIBUTION_ID	NUMBER		Yes	DOcument distribution unique identifier
ORGANIZATION_ID	NUMBER			Organization identifier
ITEM_ID	NUMBER			Purchased item ID
WIP_ENTITY_ID	NUMBER			WIP job or repetitive schedule identifier
WIP_LINE_ID	NUMBER			WIP line identifier
VENDOR_CONTACT_ID	NUMBER			Vendor contact identifier
VENDOR_ID	NUMBER			Vendor identifier
VENDOR_SITE_ID	NUMBER			Vendor site identifier
ORG_ID	NUMBER			Operating unit unique identifier
PO_TYPE	VARCHAR2	(80)	Yes	Purchase order type code
BUYER_ID	NUMBER	(9)	Yes	Buyer unique identifier
BASE_PO_NUM	VARCHAR2	(20)	Yes	PO number
PO_RELEASE_NUMBER	NUMBER			PO release numner
SHIP_TO_LOCATION_ID	NUMBER			Ship-to location identifier
SHIP_TO_ORGANIZATION_ID	NUMBER			Ship-to organization identifier
CARRIER_CODE	VARCHAR2	(25)		Carrier code
RESOURCE_SEQ_NUM	NUMBER			Resource sequence number
QA_PLAN	VARCHAR2	(4000)		Quality Plan
VENDOR_NAME	VARCHAR2	(240)		Vendor name
ASSEMBLY_ITEM_ID	NUMBER			Assembly item Identifier
ASSEMBLY_ITEM_NUMBER	VARCHAR2	(40)		Assembly item number
ASSEMBLY_ITEM_REVISION	VARCHAR2	(4000)		Assembly item revision
ASSEMBLY_QUANTITY_ORDERED	NUMBER			Quantity ordered in terms of end assembly
ASSEMBLY_PRIMARY_UOM	VARCHAR2	(25)		Assembly primary unit of measure
ASSEMBLY_DESCRIPTION	VARCHAR2	(240)		Assembly Description
CREATION_DATE	DATE			Standard who column
CREATED_BY	NUMBER			Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
START_DATE	DATE			Start Date
STATUS	VARCHAR2	(25)		Status
BOM_REVISION	VARCHAR2	(3)		Revision of the BOM
OPERATING_UNIT_CODE	VARCHAR2	(240)	Yes	Operating unit code
OPERATION_STATUS_LINK	VARCHAR2	(19)		Operation Status Link
OPERATIONSTATUS	VARCHAR2	(80)	Yes	Operation Status
OPERATIONCOMPLETED	VARCHAR2	(1)		Flag to indicate operation completeded or not
OPSEQNUM	NUMBER			Operation Sequence Number
WORK_ORDER_NAME	VARCHAR2	(281)		Name of Work Order

Query Text

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


SELECT PO_NUMBER
,      ITEM_NUMBER
,      SUPPLIER_ITEM_NUMBER
,      ITEM_DESCRIPTION
,      NEED_BY_DATE
,      PROMISED_DATE
,      QUANTITY_ORDERED
,      QUANTITY_DELIVERED
,      UOM
,      WIP_ENTITY_NAME
,      WIP_ENTITY_TYPE
,      WIP_LINE_CODE
,      WIP_REPETITIVE_SCHEDULE_ID
,      WIP_OPERATION_SEQ_NUM
,      COMPONENT
,      ATTACHMENT
,      PO_HEADER_ID
,      PO_RELEASE_ID
,      PO_LINE_ID
,      LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      ORGANIZATION_ID
,      ITEM_ID
,      WIP_ENTITY_ID
,      WIP_LINE_ID
,      VENDOR_CONTACT_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      ORG_ID
,      PO_TYPE
,      BUYER_ID
,      BASE_PO_NUM
,      PO_RELEASE_NUMBER
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_ORGANIZATION_ID
,      CARRIER_CODE
,      RESOURCE_SEQ_NUM
,      QA_PLAN
,      VENDOR_NAME
,      ASSEMBLY_ITEM_ID
,      ASSEMBLY_ITEM_NUMBER
,      ASSEMBLY_ITEM_REVISION
,      ASSEMBLY_QUANTITY_ORDERED
,      ASSEMBLY_PRIMARY_UOM
,      ASSEMBLY_DESCRIPTION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      START_DATE
,      STATUS
,      BOM_REVISION
,      OPERATING_UNIT_CODE
,      OPERATION_STATUS_LINK
,      OPERATIONSTATUS
,      OPERATIONCOMPLETED
,      OPSEQNUM
,      WORK_ORDER_NAME
FROM APPS.WIP_ICX_OSP_WORKBENCH_V;

Dependencies

[top of page]

APPS.WIP_ICX_OSP_WORKBENCH_V references the following:

APPS: BOM_REVISIONS - show dependent code; FND_ATTACHMENT_UTIL_PKG - show dependent code; FND_MESSAGE - show dependent code; HR_ALL_ORGANIZATION_UNITS_TL; MFG_LOOKUPS; MTL_SYSTEM_ITEMS_KFV; PO_DISTRIBUTIONS_ALL; PO_DOCUMENT_TYPES_ALL; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_RELEASES_ALL; PO_VENDORS; QA_SS_OSP - show dependent code; WIP_DISCRETE_JOBS; WIP_ENTITIES; WIP_LINES; WIP_OPERATIONS; WIP_OPERATION_RESOURCES; WIP_OSP - show dependent code; WIP_REPETITIVE_SCHEDULES; WIP_WORK_ORDER_PVT - show dependent code

APPS.WIP_ICX_OSP_WORKBENCH_V is referenced by following:

APPS: QA_SS_OSP - show dependent code