DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.MTL_GROUP_ATPS_VIEW

Object Details
Object Name: MTL_GROUP_ATPS_VIEW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.MTL_GROUP_ATPS_VIEW
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)
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, validator populated if null
REQUEST_QUANTITY NUMBER
Yes Quantity requested for ATP check
REQUEST_DATE_ATP_QUANTITY NUMBER

Available quantity on the request date, populated by ATP
EARLIEST_ATP_DATE DATE

The earliest date that can satisfy the requested quantity regardless of the request date, populated by ATP
EARLIEST_ATP_DATE_QUANTITY NUMBER

Maximum quantity available on the Earliest ATP Date, populated by ATP
REQUEST_ATP_DATE DATE

First date on/after the required date that has enough to satisfy the requested quantity, populated by ATP
REQUEST_ATP_DATE_QUANTITY NUMBER

Maximum available qty on the Request ATP Date, populated by ATP
GROUP_AVAILABLE_DATE DATE

The earliest date that all the requested quantity for each item in the group can be satisfied
ACCUMULATION_WINDOW NUMBER

(not currently used, comes from ATP Rule)
ATP_LEAD_TIME NUMBER

Number of days earlier than the parent requirement date that a component must be available to allow for assembly of the parent
AVAILABLE_TO_ATP NUMBER

Flag to indicate if row should be ATP checked. MTL_DEMAND_INTERFACE.ATP_CHECK
INFINITE_TIME_FENCE_DATE DATE

On and after this date an infinite supply is assumed, populated by ATP
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, if not passed, validator populates with 2 (No).
LINE_NUMBER VARCHAR2 (30)
User line number. MTL_DEMAND_INTERFACE.USER_LINE_NUM
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 acceptable date. MTL_DEMAND_INTERFACE.REQUIREMENT_DATE
ERROR_CODE NUMBER

Error code returned by the ATP function.
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 ATP
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

An organization workday calendar used by ATP process to accomodate group ATP check across multiple organizations.
REQUEST_PRIMARY_UOM_QUANTITY NUMBER

Request quantity in item's primary uom
SESSION_ID NUMBER

Session identifier
SCHEDULE_GROUP_ID NUMBER

The schedule group identifier
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
FROM APPS.MTL_GROUP_ATPS_VIEW;

Dependencies

[top of page]

APPS.MTL_GROUP_ATPS_VIEW references the following:

SchemaAPPS
SynonymMTL_DEMAND_INTERFACE
APPS.MTL_GROUP_ATPS_VIEW is referenced by following:

SchemaAPPS
Package BodyCZ_ATP_UTIL - show dependent code
Package BodyFLM_SUPPLY_DEMAND - show dependent code
Package BodyINVWATP - show dependent code
Package BodyWPS_SUPPLY_DEMAND - show dependent code