[Home] [Help]
View: MTL_GROUP_ATPS_VIEW
Product: | INV - Inventory |
Description: | This view is used for ATP and derived from MTL_DEMAND_INTERFACE |
Implementation/DBA Data: |
APPS.MTL_GROUP_ATPS_VIEW
|
View Text
SELECT ROWID
, ATP_GROUP_ID
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ATP_RULE_ID
, LINE_ITEM_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
, ATP_CHECK
, INFINITE_TIME_FENCE_DATE
, LINE_ITEM_UOM
, GROUP_ATP_CHECK
, USER_LINE_NUM
, 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
, REQUIREMENT_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
, PRIMARY_UOM_QUANTITY
, SESSION_ID
, SCHEDULE_GROUP_ID
FROM MTL_DEMAND_INTERFACE
Columns
Name |
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 |