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_ATP_SOURCES_V

Object Details

Object Name:	MRP_ATP_SOURCES_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
SOURCE_ORGANIZATION_ID	NUMBER
SOURCE_ORGANIZATION_CODE	VARCHAR2	(7)
VENDOR_ID	NUMBER
VENDOR_NAME	VARCHAR2	(80)
VENDOR_SITE_ID	NUMBER
VENDOR_SITE_NAME	VARCHAR2	(240)
SHIP_METHOD	VARCHAR2	(30)
SHIP_METHOD_TEXT	VARCHAR2	(240)
DELIVERY_LEAD_TIME	NUMBER
CUSTOMER_ID	NUMBER
CUSTOMER_SITE_ID	NUMBER
INSTANCE_ID1	NUMBER
SR_INSTANCE_ID	NUMBER
ORGANIZATION_ID	NUMBER
SESSION_ID	NUMBER		Yes
STATUS_FLAG	NUMBER

Query Text

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


SELECT SOURCE_ORGANIZATION_ID
,      SOURCE_ORGANIZATION_CODE
,      VENDOR_ID
,      VENDOR_NAME
,      VENDOR_SITE_ID
,      VENDOR_SITE_NAME
,      SHIP_METHOD
,      SHIP_METHOD_TEXT
,      DELIVERY_LEAD_TIME
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      INSTANCE_ID1
,      SR_INSTANCE_ID
,      ORGANIZATION_ID
,      SESSION_ID
,      STATUS_FLAG
FROM APPS.MRP_ATP_SOURCES_V;

Dependencies

[top of page]

APPS.MRP_ATP_SOURCES_V references the following:

APPS: MRP_ATP_SCHEDULE_TEMP

APPS.MRP_ATP_SOURCES_V is not referenced by any database object