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

VIEW: APPS.MRP_ATP_BASE_V

Object Details
Object Name: MRP_ATP_BASE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRP_ATP_BASE_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory 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/resource 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
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. return the same 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 computations
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
CUSTOMER_ID NUMBER

Customer identifier associated with demand
ACTION_CODE NUMBER

An interface code to activate one of the inventory demand functions
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
,      CUSTOMER_ID
,      ACTION_CODE
FROM APPS.MRP_ATP_BASE_V;

Dependencies

[top of page]

APPS.MRP_ATP_BASE_V references the following:

SchemaAPPS
SynonymBOM_DEPARTMENTS
SynonymBOM_RESOURCES
SynonymMTL_DEMAND_INTERFACE
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS
SynonymWIP_LINES
APPS.MRP_ATP_BASE_V is referenced by following:

SchemaAPPS
ViewMRP_ATP_ITEMS_ALL_V
ViewMRP_ATP_ITEMS_RESOURCE_V
ViewMRP_ATP_PERIOD_V