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

Object Details

Object Name:	MSC_PO_REQUISITIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MSC.MSC_PO_REQUISITIONS_V
Subobject Name:
Status:	VALID

View Type

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

This view contains all the information necessary to create approved or unapproved requisitions in Oracle Purchasing. This view is used in XML-outbound

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SOURCE_LINE_ID	NUMBER			Source line id
ITEM_ID	NUMBER			Item identifier
ITEM_NAME	VARCHAR2	(250)		Item name
QUANTITY	NUMBER			Quantity ordered
NEED_BY_DATE	DATE			Date the requisition is needed internally
DELIVER_TO_LOCATION_ID	NUMBER			Deliver-to-location unique identifier
LOCATION_CODE	VARCHAR2	(60)		Location code
DELIVER_TO_PARTNER_NAME	VARCHAR2	(255)		Partner name
DELIVER_TO_REQUESTOR_ID	NUMBER	(9)		Requestor unique identifier
REQUESTOR_CODE	VARCHAR2	(10)		Requestor code
AUTHORIZATION_STATUS	VARCHAR2	(25)		Authorization status type
AUTHORIZATION_STATUS_CODE	NUMBER			Authorization status code
UOM_CODE	VARCHAR2	(3)		UOM code
CHARGE_ACCOUNT_ID	NUMBER			Charge account identifier
ITEM_REVISION	VARCHAR2	(3)		Item revision
DESTINATION_ORGANIZATION_ID	NUMBER			Destination organization identifier
DEST_ORG_CODE	VARCHAR2	(7)		Destination organization code
DEST_PARTNER_NAME	VARCHAR2	(255)		Destination Partner Name
SOURCE_ORGANIZATION_ID	NUMBER			Source organization id
SOURCE_ORG_CODE	VARCHAR2	(4000)		Source organization code
SUGGESTED_VENDOR_ID	NUMBER			Suggested supplier unique identifier
PARTNER_NAME	VARCHAR2	(4000)		Supplier name
SUGGESTED_VENDOR_SITE	VARCHAR2	(120)		Suggested supplier site name
VENDOR_SITE_ADDRESS	VARCHAR2	(0)		Supplier site address
PROJECT_ID	NUMBER			Project identifier
PROJECT_NUMBER	VARCHAR2	(4000)		Project Number
TASK_ID	NUMBER			Task identifier
TASK_NUMBER	VARCHAR2	(4000)		Task number
SR_INSTANCE_ID	NUMBER			Source application instance identifier
INSTANCE_CODE	VARCHAR2	(3)	Yes	Source instance code

Query Text

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


SELECT SOURCE_LINE_ID
,      ITEM_ID
,      ITEM_NAME
,      QUANTITY
,      NEED_BY_DATE
,      DELIVER_TO_LOCATION_ID
,      LOCATION_CODE
,      DELIVER_TO_PARTNER_NAME
,      DELIVER_TO_REQUESTOR_ID
,      REQUESTOR_CODE
,      AUTHORIZATION_STATUS
,      AUTHORIZATION_STATUS_CODE
,      UOM_CODE
,      CHARGE_ACCOUNT_ID
,      ITEM_REVISION
,      DESTINATION_ORGANIZATION_ID
,      DEST_ORG_CODE
,      DEST_PARTNER_NAME
,      SOURCE_ORGANIZATION_ID
,      SOURCE_ORG_CODE
,      SUGGESTED_VENDOR_ID
,      PARTNER_NAME
,      SUGGESTED_VENDOR_SITE
,      VENDOR_SITE_ADDRESS
,      PROJECT_ID
,      PROJECT_NUMBER
,      TASK_ID
,      TASK_NUMBER
,      SR_INSTANCE_ID
,      INSTANCE_CODE
FROM APPS.MSC_PO_REQUISITIONS_V;

Dependencies

[top of page]

APPS.MSC_PO_REQUISITIONS_V references the following:

APPS: MSC_APPS_INSTANCES; MSC_PLANNERS; MSC_PO_REQUISITIONS_INTERFACE; MSC_ST_UTIL - show dependent code; MSC_SYSTEM_ITEMS; MSC_TRADING_PARTNERS; MSC_TRADING_PARTNER_SITES

APPS.MSC_PO_REQUISITIONS_V is not referenced by any database object