VIEW: APPS.MTL_GROUP_ATPS_VIEW

Source

View Text - Preformatted

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

View Text - HTML Formatted

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