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

Object Details

Object Name:	MRP_SCATP_SUPPLY_SOURCES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MRP.MRP_SCATP_SUPPLY_SOURCES_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
SESSION_ID	NUMBER		Session identifier
SCHEDULE_GROUP_ID	NUMBER		Schedule group identifier
ATP_GROUP_ID	NUMBER		Identifies a group of items and/or resources that will be passed to the ATP function as a group
ORGANIZATION_ID	NUMBER		Organization identifier
ORGANIZATION_CODE	VARCHAR2	(3)	Organization code
SHIP_METHOD	VARCHAR2	(30)	Ship method
SHIP_METHOD_TEXT	VARCHAR2	(80)	Ship method description
INTRANSIT_LEAD_TIME	NUMBER		Intransit lead time
VENDOR_ID	NUMBER		Supplier identifier
VENDOR_NAME	VARCHAR2	(240)	Supplier name
VENDOR_SITE_ID	NUMBER		Supplier site identifier
VENDOR_SITE_CODE	VARCHAR2	(15)	Supplier site code
GROUP_AVAILABLE_DATE	DATE		The earliest date that all the requested quantity for each item/resource in the group can be satisfied
GROUP_ATP_CHECK	NUMBER		Flag to indicate if all the items under the same group id will be treated as a group ATP (i.e. return the same GROUP_AVAILABLE_DATE)

Query Text

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


SELECT SESSION_ID
,      SCHEDULE_GROUP_ID
,      ATP_GROUP_ID
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      SHIP_METHOD
,      SHIP_METHOD_TEXT
,      INTRANSIT_LEAD_TIME
,      VENDOR_ID
,      VENDOR_NAME
,      VENDOR_SITE_ID
,      VENDOR_SITE_CODE
,      GROUP_AVAILABLE_DATE
,      GROUP_ATP_CHECK
FROM APPS.MRP_SCATP_SUPPLY_SOURCES_V;

Dependencies

[top of page]

APPS.MRP_SCATP_SUPPLY_SOURCES_V references the following:

APPS: FND_COMMON_LOOKUPS; FND_GLOBAL - show dependent code; MTL_DEMAND_INTERFACE; MTL_PARAMETERS; PO_VENDORS; PO_VENDOR_SITES_ALL

APPS.MRP_SCATP_SUPPLY_SOURCES_V is not referenced by any database object