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

Object Details

Object Name:	POS_PO_OSP_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.POS_PO_OSP_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Fetches PO details related to items which need outside processing.

[View Source]

Columns

Name	Datatype	Length	Comments
PO_NUMBER	VARCHAR2	(61)	Document Number
VENDOR_ID	NUMBER		Supplier Unique identifier
VENDOR_SITE_ID	NUMBER		Supplier Site
VENDOR_CONTACT_ID	NUMBER		Supplier Contact
ITEM_NUMBER	VARCHAR2	(40)	Item Number
SUPPLIER_ITEM_NUMBER	VARCHAR2	(25)	Supplier Item Number
ITEM_DESCRIPTION	VARCHAR2	(240)	Item Description
NEED_BY_DATE	DATE		need by date on shipment
PROMISED_DATE	DATE		promised date on shipment
QUANTITY_ORDERED	NUMBER		Quantity Ordered
QUANTITY_DELIVERED	NUMBER		Quantity Delivered
UOM	VARCHAR2	(25)	Unit of measure
WIP_ENTITY_NAME	VARCHAR2	(240)	WIP job or repetitive assembly name or flow schedule reference code
WIP_ENTITY_TYPE	NUMBER		WIP entity type code
WIP_LINE_CODE	VARCHAR2	(10)	WIP line code
WIP_REPETITIVE_SCHEDULE_ID	NUMBER		Wip repetitive schedule id
WIP_OPERATION_SEQ_NUM	NUMBER		Sequence Number
COMPONENT	VARCHAR2	(4000)	Component
ATTACHMENT	VARCHAR2	(4000)	Attachment Type
PO_HEADER_ID	NUMBER		Document unique identifier
PO_RELEASE_ID	NUMBER		Document Release unique identifier
PO_LINE_ID	NUMBER		Document Line unique identifier
LINE_LOCATION_ID	NUMBER		Shipment unique identifier
PO_DISTRIBUTION_ID	NUMBER		Distribution unique identifier
ORGANIZATION_ID	NUMBER		Organization unique identifier
ITEM_ID	NUMBER		Item unique identifier
WIP_ENTITY_ID	NUMBER		WIp entity Id
WIP_LINE_ID	NUMBER		Wip Line Id
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
ORG_ID	NUMBER		Organization Id
PO_TYPE	VARCHAR2	(80)	Document Type
BUYER_ID	NUMBER	(9)	Buyer of the Purchase order
BASE_PO_NUM	VARCHAR2	(20)	Base Po Number
PO_RELEASE_NUMBER	NUMBER		Release Number
SHIP_TO_LOCATION_ID	NUMBER		Ship to location
SHIP_TO_ORGANIZATION_ID	NUMBER		Ship to organization
CARRIER_CODE	VARCHAR2	(25)	Carrier type
RESOURCE_SEQ_NUM	NUMBER		Resource Sequence Number
APPROVAL_STATUS	VARCHAR2	(25)	Approval Status
CLOSED_CODE	VARCHAR2	(30)	Closure Type
APPROVED_FLAG	VARCHAR2	(1)	Approval Flag
LINE_CLOSED_STATUS	VARCHAR2	(25)	Line CLosed Status
CANCEL_FLAG	VARCHAR2	(1)	Cancel Flag
FROZEN_FLAG	VARCHAR2	(1)	Frozen Flag
USER_HOLD_FLAG	VARCHAR2	(1)	User Hold Flag
LINE_EXPIRATION_DATE	DATE		Line Expiration Date
LINE_CANCEL_FLAG	VARCHAR2	(1)	Line Cancel flag

Query Text

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


SELECT PO_NUMBER
,      VENDOR_ID
,      VENDOR_SITE_ID
,      VENDOR_CONTACT_ID
,      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
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      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
,      APPROVAL_STATUS
,      CLOSED_CODE
,      APPROVED_FLAG
,      LINE_CLOSED_STATUS
,      CANCEL_FLAG
,      FROZEN_FLAG
,      USER_HOLD_FLAG
,      LINE_EXPIRATION_DATE
,      LINE_CANCEL_FLAG
FROM APPS.POS_PO_OSP_V;

Dependencies

[top of page]

APPS.POS_PO_OSP_V references the following:

APPS: FINANCIALS_SYSTEM_PARAMS_ALL; FND_ATTACHMENT_UTIL_PKG - show dependent code; FND_MESSAGE - show dependent code; MTL_SYSTEM_ITEMS_KFV; PO_DISTRIBUTIONS_ALL; PO_DOCUMENT_TYPES_ALL; PO_DOCUMENT_TYPES_ALL_VL; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_LINE_TYPES; PO_RELEASES_ALL; WIP_ENTITIES; WIP_LINES; WIP_WORK_ORDER_PVT - show dependent code

APPS.POS_PO_OSP_V is not referenced by any database object