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_V

Object Details

Object Name:	MRP_ATP_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MRP.MRP_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	Comments
ROW_ID	ROWID	(10)	Row 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
INVENTORY_ITEM_ID	NUMBER		Inventory item identifier
REQUEST_ITEM_ID	NUMBER		Inventory item identifier of the item requested by ATP check
DEPARTMENT_ID	NUMBER		Department identifier
DEPARTMENT_CODE	VARCHAR2	(10)	Department code
DEPARTMENT_DESCRIPTION	VARCHAR2	(240)	Department description
OWNING_DEPARTMENT_ID	NUMBER		Owning Department Identifier
RESOURCE_ID	NUMBER		Resource identifier
RESOURCE_CODE	VARCHAR2	(10)	Resource code
RESOURCE_DESCRIPTION	VARCHAR2	(240)	Resource description
LINE_ID	NUMBER		Line identifier
LINE_CODE	VARCHAR2	(10)	Line code
LINE_DESCRIPTION	VARCHAR2	(240)	Line Description
ENTITY_ID	NUMBER		Entity identifier
LAST_UPDATE_DATE	DATE		Standard Who column
LAST_UPDATED_BY	NUMBER		Standard Who column
CREATION_DATE	DATE		Standard Who column
CREATED_BY	NUMBER		Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Standard Who column
ATP_RULE_ID	NUMBER		ATP rule identifier
REQUEST_QUANTITY	NUMBER		Quantity requested in 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		Max 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		The max 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 data that a component must be available to allow for assembly of the parent
AVAILABLE_TO_ATP	NUMBER		Flag to indicate if the item in the row should be ATP checked
INFINITE_TIME_FENCE_DATE	DATE		On and after this date an infinite supply is assumed, use to determine if available date is from infinite supply
UOM_CODE	VARCHAR2	(3)	Unit of Measure code
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. GROUP_AVAILABLE_DATE)
LINE_NUMBER	VARCHAR2	(30)	For sales order demand, this is SO_LINES.LINE_NUMBER
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 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 date that demand should be scheduled
ERROR_CODE	NUMBER		Error code
ERR_EXPLANATION	VARCHAR2	(240)	Error explanation text
DEMAND_CLASS	VARCHAR2	(30)	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. For sales order demand: MTL_SALES_ORDERS.SALES_ORDER_ID, For account number: GL_CODE_COMBINATIONS.CODE_COMBINATION_ID, For account alias:MTL_GENERIC_DISPOSITIONS.DISPOSITION_ID
DEMAND_SOURCE_LINE	VARCHAR2	(30)	Line ID of demand source. For sales order demand this is: SO_LINES.LINE_ID
DEMAND_SOURCE_DELIVERY	VARCHAR2	(30)	For sales order demand, line id of sales order line detail row (SO_LINE_DETAILS.LINE_DETAIL_ID)
DEMAND_SOURCE_NAME	VARCHAR2	(30)	Identifier of user-defined source type
LATEST_ACCEPTABLE_DATE	DATE		Latest date that demand should be scheduled
ATP_CALENDAR_ORGANIZATION_ID	NUMBER		Identifier for the organization that ATP will use to get the calendar for ATP computions
REQUEST_PRIMARY_UOM_QUANTITY	NUMBER		The line item quantity with respect to the item's primary UOM
SESSION_ID	NUMBER		Session identifier
SCHEDULE_GROUP_ID	NUMBER		Schedule group identifier
RESOURCE_BASIS_TYPE	NUMBER		Resource basis type
RESOURCE_USAGE_RATE_OR_AMOUNT	NUMBER		Resource usage rate or amount
AVAILABLE_24_HOURS_FLAG	NUMBER		Flag to show if resource is available 24 hours or by shifts
SUPPLY_HEADER_ID	NUMBER		Header id of reservation supply source
RES_UOM	VARCHAR2	(3)	Unit of measure for resource
SHIP_METHOD	VARCHAR2	(30)	Ship method
INTRANSIT_LEAD_TIME	NUMBER		Intransit lead time
VENDOR_ID	NUMBER		Supplier identifier
VENDOR_SITE_ID	NUMBER		Supplier site identifier
CUSTOMER_ID	NUMBER		Customer identifier associated with demand
LOCK_FLAG	NUMBER		Used by demand functions to lock a parent row when updating so that other processes will not update this parent and its children rows at the same time
ACTION_CODE	NUMBER		An interface code to activate one of the inventory demand functions
TRANSACTION_MODE	NUMBER		A flag to indicate processing mode: 1 - Online; 2 - Immediate concurrent program mode; 3 - Batch
PROCESS_FLAG	NUMBER		A flag to indicate if the reservation should reserve the request quantity from a single lot

Query Text

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


SELECT ROW_ID
,      ATP_GROUP_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      REQUEST_ITEM_ID
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      DEPARTMENT_DESCRIPTION
,      OWNING_DEPARTMENT_ID
,      RESOURCE_ID
,      RESOURCE_CODE
,      RESOURCE_DESCRIPTION
,      LINE_ID
,      LINE_CODE
,      LINE_DESCRIPTION
,      ENTITY_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
,      RESOURCE_BASIS_TYPE
,      RESOURCE_USAGE_RATE_OR_AMOUNT
,      AVAILABLE_24_HOURS_FLAG
,      SUPPLY_HEADER_ID
,      RES_UOM
,      SHIP_METHOD
,      INTRANSIT_LEAD_TIME
,      VENDOR_ID
,      VENDOR_SITE_ID
,      CUSTOMER_ID
,      LOCK_FLAG
,      ACTION_CODE
,      TRANSACTION_MODE
,      PROCESS_FLAG
FROM APPS.MRP_ATP_V;

Dependencies

[top of page]

APPS.MRP_ATP_V references the following:

APPS: BOM_BILL_OF_MATERIALS; BOM_CALENDAR_DATES; BOM_DEPARTMENTS; BOM_DEPARTMENT_RESOURCES; BOM_INVENTORY_COMPONENTS; BOM_OPERATIONAL_ROUTINGS; BOM_OPERATION_RESOURCES; BOM_OPERATION_SEQUENCES; BOM_RESOURCES; FND_GLOBAL - show dependent code; FND_PROFILE - show dependent code; MTL_DEMAND_INTERFACE; MTL_PARAMETERS; MTL_SYSTEM_ITEMS; MTL_UOM_CONVERSIONS; WIP_LINES

APPS.MRP_ATP_V is not referenced by any database object