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_PF_ATP_V

Object Details

Object Name:	MRP_PF_ATP_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MRP.MRP_PF_ATP_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
ROW_ID	ROWID	(10)		Row identifier
ATP_GROUP_ID	NUMBER			Identifies a group of items that will be passed to the ATP function as a group
ORGANIZATION_ID	NUMBER			Organization identifier
INVENTORY_ITEM_ID	NUMBER			Inventory item identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
ATP_RULE_ID	NUMBER			ATP rule identifier
REQUEST_QUANTITY	NUMBER		Yes	Quantity requested for ATP check
REQUEST_DATE_ATP_QUANTITY	NUMBER			Available quantity on the request date
EARLIEST_ATP_DATE	DATE			The earliest date that can satisfy the requested quantity regardless of the request date
EARLIEST_ATP_DATE_QUANTITY	NUMBER			Maximum quantity available on the Earliest ATP Date
REQUEST_ATP_DATE	DATE			First date on/after the required date that has enough to satisfy the requested quantity
REQUEST_ATP_DATE_QUANTITY	NUMBER			Maximum available quantity on the Request ATP Date
GROUP_AVAILABLE_DATE	DATE			The earliest date that all the requested quantity for each item in the group can be satisfied
ACCUMULATION_WINDOW	NUMBER			Maximum number of days that available supply should be accumulated. Accumulate Available must be set to Yes on the ATP Rule for this to be considered
ATP_LEAD_TIME	NUMBER			Number of days earlier than the parent requirement date that a component must be available to allow
AVAILABLE_TO_ATP	NUMBER			Flag to indicate if row should be ATP checked
INFINITE_TIME_FENCE_DATE	DATE			On and after this date an infinite supply is assumed
UOM_CODE	VARCHAR2	(3)		Unit of measure code of the request quantity
GROUP_ATP_CHECK	NUMBER			Flag to indicate if all the items under the same group id will be treated as a group atp
LINE_NUMBER	VARCHAR2	(30)		User identifier of demand source
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
C_COLUMN1	VARCHAR2	(240)		(not currently used)
C_COLUMN2	VARCHAR2	(240)		(not currently used)
C_COLUMN3	VARCHAR2	(240)		(not currently used)
C_COLUMN4	VARCHAR2	(240)		(not currently used)
C_COLUMN5	VARCHAR2	(240)		(not currently used)
C_COLUMN6	VARCHAR2	(240)		(not currently used)
N_COLUMN1	NUMBER			Column used to identify record that originated from Supply Demand Inquiry
N_COLUMN2	NUMBER			(not currently used)
N_COLUMN3	NUMBER			(not currently used)
N_COLUMN4	NUMBER			Column used to mark record and its detail in MTL_SUPPLY_DEMAND_TEMP for deletion
N_COLUMN5	NUMBER			Column used to create an unique sequence for array management while processing
D_COLUMN1	DATE			(not currently used)
D_COLUMN2	DATE			(not currently used)
D_COLUMN3	DATE			(not currently used)
D_COLUMN4	DATE			(not currently used)
D_COLUMN5	DATE			(not currently used)
REQUEST_DATE	DATE			Earliest acceptable date
ERROR_CODE	NUMBER			Error code
ERR_EXPLANATION	VARCHAR2	(240)		Error explanation text.
DEMAND_CLASS	VARCHAR2	(30)		Demand class used to restrict selection of supply and demand if the ATP rule specifies demand class
DEMAND_SOURCE_TYPE	NUMBER			Code to indicate the source of the demand.
DEMAND_SOURCE_HEADER_ID	NUMBER			Header ID for the source of the demand.
DEMAND_SOURCE_LINE	VARCHAR2	(30)		Line id of demand source
DEMAND_SOURCE_DELIVERY	VARCHAR2	(30)		For Sales Order demand, Line id of Sales order line detail row.
DEMAND_SOURCE_NAME	VARCHAR2	(30)		Identifier of user-defined Source Type
LATEST_ACCEPTABLE_DATE	DATE			The ATP date should be on/before this date so that users can accept it.
ATP_CALENDAR_ORGANIZATION_ID	NUMBER			Identifier for the organization that ATP will use to get the calendar for ATP computations
REQUEST_PRIMARY_UOM_QUANTITY	NUMBER			Request quantity in item's primary uom
SESSION_ID	NUMBER			Session identifier
SCHEDULE_GROUP_ID	NUMBER			Schedule group identifier
SUPPLY_HEADER_ID	NUMBER			Header id of reservation supply source

Query Text

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


SELECT ROW_ID
,      ATP_GROUP_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ATP_RULE_ID
,      REQUEST_QUANTITY
,      REQUEST_DATE_ATP_QUANTITY
,      EARLIEST_ATP_DATE
,      EARLIEST_ATP_DATE_QUANTITY
,      REQUEST_ATP_DATE
,      REQUEST_ATP_DATE_QUANTITY
,      GROUP_AVAILABLE_DATE
,      ACCUMULATION_WINDOW
,      ATP_LEAD_TIME
,      AVAILABLE_TO_ATP
,      INFINITE_TIME_FENCE_DATE
,      UOM_CODE
,      GROUP_ATP_CHECK
,      LINE_NUMBER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      C_COLUMN1
,      C_COLUMN2
,      C_COLUMN3
,      C_COLUMN4
,      C_COLUMN5
,      C_COLUMN6
,      N_COLUMN1
,      N_COLUMN2
,      N_COLUMN3
,      N_COLUMN4
,      N_COLUMN5
,      D_COLUMN1
,      D_COLUMN2
,      D_COLUMN3
,      D_COLUMN4
,      D_COLUMN5
,      REQUEST_DATE
,      ERROR_CODE
,      ERR_EXPLANATION
,      DEMAND_CLASS
,      DEMAND_SOURCE_TYPE
,      DEMAND_SOURCE_HEADER_ID
,      DEMAND_SOURCE_LINE
,      DEMAND_SOURCE_DELIVERY
,      DEMAND_SOURCE_NAME
,      LATEST_ACCEPTABLE_DATE
,      ATP_CALENDAR_ORGANIZATION_ID
,      REQUEST_PRIMARY_UOM_QUANTITY
,      SESSION_ID
,      SCHEDULE_GROUP_ID
,      SUPPLY_HEADER_ID
FROM APPS.MRP_PF_ATP_V;

Dependencies

[top of page]

APPS.MRP_PF_ATP_V references the following:

APPS: MTL_DEMAND_INTERFACE; MTL_PARAMETERS; MTL_SYSTEM_ITEMS

APPS.MRP_PF_ATP_V is referenced by following:

APPS: MRP_PF_ATP_ITEMS_ALL_V