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_SD_TEMP_V

Object Details

Object Name:	MRP_ATP_SD_TEMP_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MRP.MRP_ATP_SD_TEMP_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ORDER_LINE_ID	NUMBER
SESSION_ID	NUMBER		Yes
SCENARIO_ID	NUMBER		Yes
PEGGING_ID	NUMBER
PARENT_PEGGING_ID	NUMBER
ATP_LEVEL	NUMBER
REQUEST_ITEM_ID	NUMBER
REQUEST_ITEM_NAME	VARCHAR2	(250)
INVENTORY_ITEM_ID	NUMBER
INVENTORY_ITEM_NAME	VARCHAR2	(250)
ORGANIZATION_ID	NUMBER
ORGANIZATION_CODE	VARCHAR2	(7)
DEPARTMENT_ID	NUMBER
DEPARTMENT_CODE	VARCHAR2	(10)
RESOURCE_ID	NUMBER
RESOURCE_CODE	VARCHAR2	(16)
SUPPLIER_ID	NUMBER
SUPPLIER_NAME	VARCHAR2	(80)
SUPPLIER_SITE_ID	NUMBER
SUPPLIER_SITE_NAME	VARCHAR2	(15)
FROM_ORGANIZATION_ID	NUMBER
FROM_ORGANIZATION_CODE	VARCHAR2	(3)
FROM_LOCATION_ID	NUMBER
FROM_LOCATION_CODE	VARCHAR2	(20)
TO_ORGANIZATION_ID	NUMBER
TO_ORGANIZATION_CODE	VARCHAR2	(3)
TO_LOCATION_ID	NUMBER
TO_LOCATION_CODE	VARCHAR2	(20)
SHIP_METHOD	VARCHAR2	(30)
UOM_CODE	VARCHAR2	(14)
IDENTIFIER1	NUMBER
IDENTIFIER2	NUMBER
IDENTIFIER3	NUMBER
IDENTIFIER4	NUMBER
SUPPLY_DEMAND_TYPE	NUMBER
SUPPLY_DEMAND_DATE	DATE
SUPPLY_DEMAND_QUANTITY	NUMBER
SUPPLY_DEMAND_SOURCE_TYPE	NUMBER
SUPPLY_DEMAND_SOURCE_TYPE_NAME	VARCHAR2	(80)
ALLOCATED_QUANTITY	NUMBER
SOURCE_TYPE	NUMBER
RECORD_TYPE	NUMBER
TOTAL_SUPPLY_QUANTITY	NUMBER
TOTAL_DEMAND_QUANTITY	NUMBER
PERIOD_START_DATE	DATE
PERIOD_END_DATE	DATE
PERIOD_QUANTITY	NUMBER
CUMULATIVE_QUANTITY	NUMBER
DISPOSITION_TYPE	NUMBER
DISPOSITION_NAME	VARCHAR2	(80)
ITEM_RESOURCE	VARCHAR2	(250)
ITEM_RESOURCE_TYPE	VARCHAR2	(80)	Yes
END_PEGGING_ID	NUMBER			End Pegging Id
FROM_DEMAND_CLASS	VARCHAR2	(4000)
PLAN_ID	NUMBER
DEMAND_CLASS	VARCHAR2	(80)
CUSTOMER_CLASS	VARCHAR2	(80)
CUSTOMER_NAME	VARCHAR2	(80)
CUSTOMER_SITE	VARCHAR2	(80)
SOURCE_TABLE	VARCHAR2	(12)
CUSTOMER_ID	NUMBER			Customer Identifier
CUSTOMER_SITE_ID	NUMBER			Customer Site Identifier
DISPLAY_DEMAND_CLASS	VARCHAR2	(4000)		Demand class name as displayed in ATP Supply/Demand window
DISPLAY_CUSTOMER_CLASS	VARCHAR2	(4000)		Customer class name as displayed in ATP Supply/Demand window
PF_DISPLAY_FLAG	NUMBER
ORIGINAL_DEMAND_DATE	DATE
ORIG_REQUEST_DATE	DATE
ORIG_DEMAND_CLASS	VARCHAR2	(4000)
ORIG_CUSTOMER_NAME	VARCHAR2	(60)
ORIG_CUSTOMER_SITE_NAME	VARCHAR2	(255)
ORIGINAL_ITEM_ID	NUMBER

Query Text

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


SELECT ORDER_LINE_ID
,      SESSION_ID
,      SCENARIO_ID
,      PEGGING_ID
,      PARENT_PEGGING_ID
,      ATP_LEVEL
,      REQUEST_ITEM_ID
,      REQUEST_ITEM_NAME
,      INVENTORY_ITEM_ID
,      INVENTORY_ITEM_NAME
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      RESOURCE_ID
,      RESOURCE_CODE
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE_NAME
,      FROM_ORGANIZATION_ID
,      FROM_ORGANIZATION_CODE
,      FROM_LOCATION_ID
,      FROM_LOCATION_CODE
,      TO_ORGANIZATION_ID
,      TO_ORGANIZATION_CODE
,      TO_LOCATION_ID
,      TO_LOCATION_CODE
,      SHIP_METHOD
,      UOM_CODE
,      IDENTIFIER1
,      IDENTIFIER2
,      IDENTIFIER3
,      IDENTIFIER4
,      SUPPLY_DEMAND_TYPE
,      SUPPLY_DEMAND_DATE
,      SUPPLY_DEMAND_QUANTITY
,      SUPPLY_DEMAND_SOURCE_TYPE
,      SUPPLY_DEMAND_SOURCE_TYPE_NAME
,      ALLOCATED_QUANTITY
,      SOURCE_TYPE
,      RECORD_TYPE
,      TOTAL_SUPPLY_QUANTITY
,      TOTAL_DEMAND_QUANTITY
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      PERIOD_QUANTITY
,      CUMULATIVE_QUANTITY
,      DISPOSITION_TYPE
,      DISPOSITION_NAME
,      ITEM_RESOURCE
,      ITEM_RESOURCE_TYPE
,      END_PEGGING_ID
,      FROM_DEMAND_CLASS
,      PLAN_ID
,      DEMAND_CLASS
,      CUSTOMER_CLASS
,      CUSTOMER_NAME
,      CUSTOMER_SITE
,      SOURCE_TABLE
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      DISPLAY_DEMAND_CLASS
,      DISPLAY_CUSTOMER_CLASS
,      PF_DISPLAY_FLAG
,      ORIGINAL_DEMAND_DATE
,      ORIG_REQUEST_DATE
,      ORIG_DEMAND_CLASS
,      ORIG_CUSTOMER_NAME
,      ORIG_CUSTOMER_SITE_NAME
,      ORIGINAL_ITEM_ID
FROM APPS.MRP_ATP_SD_TEMP_V;