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

VIEW: MSC.MSC_ATP_PEGGING#

Object Details
Object Name: MSC_ATP_PEGGING#
Object Type: VIEW
Owner: MSC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes
SR_INSTANCE_ID NUMBER
Yes
REFERENCE_ITEM_ID NUMBER
Yes
INVENTORY_ITEM_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
SALES_ORDER_LINE_ID NUMBER
Yes
BOM_ITEM_TYPE NUMBER

SALES_ORDER_QTY NUMBER

TRANSACTION_DATE DATE

DEMAND_ID NUMBER

DEMAND_QUANTITY NUMBER

DISPOSITION_ID NUMBER

DEMAND_CLASS VARCHAR2 (34)
CONSUMED_QTY NUMBER

OVERCONSUMPTION_QTY NUMBER

SUPPLY_ID NUMBER

SUPPLY_QUANTITY NUMBER

ALLOCATED_QUANTITY NUMBER

RESOURCE_ID NUMBER

DEPARTMENT_ID NUMBER

RESOURCE_HOURS NUMBER

DAILY_RESOURCE_HOURS NUMBER

START_DATE DATE

END_DATE DATE

RELIEF_TYPE NUMBER

RELIEF_QUANTITY NUMBER

DAILY_RELIEF_QTY NUMBER

PEGGING_ID NUMBER

PREV_PEGGING_ID NUMBER

END_PEGGING_ID NUMBER

CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
CUSTOMER_ID NUMBER

CUSTOMER_SITE_ID NUMBER

DEMAND_SOURCE_TYPE NUMBER

END_DEMAND_ID NUMBER

ORIGINAL_ITEM_ID NUMBER

ORIGINAL_DATE DATE

OFFSET_SUPPLY_ID NUMBER

OFFSET_TYPE NUMBER

Query Text

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


SELECT PLAN_ID
,      SR_INSTANCE_ID
,      REFERENCE_ITEM_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SALES_ORDER_LINE_ID
,      BOM_ITEM_TYPE
,      SALES_ORDER_QTY
,      TRANSACTION_DATE
,      DEMAND_ID
,      DEMAND_QUANTITY
,      DISPOSITION_ID
,      DEMAND_CLASS
,      CONSUMED_QTY
,      OVERCONSUMPTION_QTY
,      SUPPLY_ID
,      SUPPLY_QUANTITY
,      ALLOCATED_QUANTITY
,      RESOURCE_ID
,      DEPARTMENT_ID
,      RESOURCE_HOURS
,      DAILY_RESOURCE_HOURS
,      START_DATE
,      END_DATE
,      RELIEF_TYPE
,      RELIEF_QUANTITY
,      DAILY_RELIEF_QTY
,      PEGGING_ID
,      PREV_PEGGING_ID
,      END_PEGGING_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      DEMAND_SOURCE_TYPE
,      END_DEMAND_ID
,      ORIGINAL_ITEM_ID
,      ORIGINAL_DATE
,      OFFSET_SUPPLY_ID
,      OFFSET_TYPE
FROM MSC.MSC_ATP_PEGGING#;

Dependencies

[top of page]

MSC.MSC_ATP_PEGGING# references the following:

SchemaMSC
TableMSC_ATP_PEGGING
MSC.MSC_ATP_PEGGING# is referenced by following:

SchemaAPPS
SynonymMSC_ATP_PEGGING