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

VIEW: APPS.MRP_ATP_PERIOD_V

Object Details
Object Name: MRP_ATP_PERIOD_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRP_ATP_PERIOD_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
SEQ_NUM NUMBER

Group sequence id
ATP_PERIOD_START_DATE DATE

Start date of an ATP period
ATP_PERIOD_END_DATE DATE

End date of an ATP period
ATP_PERIOD_TOTAL_SUPPLY NUMBER

Total supply for an item in an ATP period
ATP_PERIOD_TOTAL_DEMAND NUMBER

Total demand for an item in an ATP period
PERIOD_NET_AVAILABLE NUMBER

ATP_PERIOD_TOTAL_SUPPLY - ATP_PERIOD_TOTAL_DEMAND
ATP NUMBER

ATP quantity (available to promise quantity for an ATP period)
ENTITY_ID NUMBER

Entity identifier
ENTITY_NAME VARCHAR2 (4000)
Entity name
ORGANIZATION_ID NUMBER

Organization identifier
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
REQUEST_ITEM_ID NUMBER

Inventory item identifier of the item requested by ATP check
REQUEST_ITEM_NUMBER VARCHAR2 (40)
Request item number
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
INVENTORY_ITEM_NUMBER VARCHAR2 (40)
Inventory item number
RESOURCE_ID NUMBER

Resource identifier
RESOURCE_CODE VARCHAR2 (10)
Resource code
DEPARTMENT_ID NUMBER

Department identifier
DEPARTMENT_CODE VARCHAR2 (10)
Department code
LINE_ID NUMBER

Line identifier
LINE_CODE VARCHAR2 (10)
Line code
UOM_CODE VARCHAR2 (3)
Unit of measure code
GROUP_AVAILABLE_DATE DATE

The earliest date that all the requested quantity for each item/resource in the group can be satisfied
Query Text

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


SELECT ROW_ID
,      SEQ_NUM
,      ATP_PERIOD_START_DATE
,      ATP_PERIOD_END_DATE
,      ATP_PERIOD_TOTAL_SUPPLY
,      ATP_PERIOD_TOTAL_DEMAND
,      PERIOD_NET_AVAILABLE
,      ATP
,      ENTITY_ID
,      ENTITY_NAME
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      REQUEST_ITEM_ID
,      REQUEST_ITEM_NUMBER
,      INVENTORY_ITEM_ID
,      INVENTORY_ITEM_NUMBER
,      RESOURCE_ID
,      RESOURCE_CODE
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      LINE_ID
,      LINE_CODE
,      UOM_CODE
,      GROUP_AVAILABLE_DATE
FROM APPS.MRP_ATP_PERIOD_V;

Dependencies

[top of page]

APPS.MRP_ATP_PERIOD_V references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
ViewMRP_ATP_BASE_V
SynonymMTL_PARAMETERS
SynonymMTL_SUPPLY_DEMAND_TEMP
SynonymMTL_SYSTEM_ITEMS_KFV

APPS.MRP_ATP_PERIOD_V is not referenced by any database object