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


VIEW: APPS.MRP_ATP_SD_TEMP_V

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORDER_LINE_ID NUMBER

SESSION_ID NUMBER
Yes
SCENARIO_ID NUMBER
Yes
PEGGING_ID NUMBER

PARENT_PEGGING_ID NUMBER

ATP_LEVEL NUMBER

REQUEST_ITEM_ID NUMBER

REQUEST_ITEM_NAME VARCHAR2 (250)
INVENTORY_ITEM_ID NUMBER

INVENTORY_ITEM_NAME VARCHAR2 (250)
ORGANIZATION_ID NUMBER

ORGANIZATION_CODE VARCHAR2 (7)
DEPARTMENT_ID NUMBER

DEPARTMENT_CODE VARCHAR2 (10)
RESOURCE_ID NUMBER

RESOURCE_CODE VARCHAR2 (16)
SUPPLIER_ID NUMBER

SUPPLIER_NAME VARCHAR2 (80)
SUPPLIER_SITE_ID NUMBER

SUPPLIER_SITE_NAME VARCHAR2 (15)
FROM_ORGANIZATION_ID NUMBER

FROM_ORGANIZATION_CODE VARCHAR2 (3)
FROM_LOCATION_ID NUMBER

FROM_LOCATION_CODE VARCHAR2 (20)
TO_ORGANIZATION_ID NUMBER

TO_ORGANIZATION_CODE VARCHAR2 (3)
TO_LOCATION_ID NUMBER

TO_LOCATION_CODE VARCHAR2 (20)
SHIP_METHOD VARCHAR2 (30)
UOM_CODE VARCHAR2 (14)
IDENTIFIER1 NUMBER

IDENTIFIER2 NUMBER

IDENTIFIER3 NUMBER

IDENTIFIER4 NUMBER

SUPPLY_DEMAND_TYPE NUMBER

SUPPLY_DEMAND_DATE DATE

SUPPLY_DEMAND_QUANTITY NUMBER

SUPPLY_DEMAND_SOURCE_TYPE NUMBER

SUPPLY_DEMAND_SOURCE_TYPE_NAME VARCHAR2 (80)
ALLOCATED_QUANTITY NUMBER

SOURCE_TYPE NUMBER

RECORD_TYPE NUMBER

TOTAL_SUPPLY_QUANTITY NUMBER

TOTAL_DEMAND_QUANTITY NUMBER

PERIOD_START_DATE DATE

PERIOD_END_DATE DATE

PERIOD_QUANTITY NUMBER

CUMULATIVE_QUANTITY NUMBER

DISPOSITION_TYPE NUMBER

DISPOSITION_NAME VARCHAR2 (80)
ITEM_RESOURCE VARCHAR2 (250)
ITEM_RESOURCE_TYPE VARCHAR2 (80) Yes
END_PEGGING_ID NUMBER

End Pegging Id
FROM_DEMAND_CLASS VARCHAR2 (4000)
PLAN_ID NUMBER

DEMAND_CLASS VARCHAR2 (80)
CUSTOMER_CLASS VARCHAR2 (80)
CUSTOMER_NAME VARCHAR2 (80)
CUSTOMER_SITE VARCHAR2 (80)
SOURCE_TABLE VARCHAR2 (12)
CUSTOMER_ID NUMBER

Customer Identifier
CUSTOMER_SITE_ID NUMBER

Customer Site Identifier
DISPLAY_DEMAND_CLASS VARCHAR2 (4000)
Demand class name as displayed in ATP Supply/Demand window
DISPLAY_CUSTOMER_CLASS VARCHAR2 (4000)
Customer class name as displayed in ATP Supply/Demand window
PF_DISPLAY_FLAG NUMBER

ORIGINAL_DEMAND_DATE DATE

ORIG_REQUEST_DATE DATE

ORIG_DEMAND_CLASS VARCHAR2 (4000)
ORIG_CUSTOMER_NAME VARCHAR2 (60)
ORIG_CUSTOMER_SITE_NAME VARCHAR2 (255)
ORIGINAL_ITEM_ID NUMBER

Query Text

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


SELECT ORDER_LINE_ID
,      SESSION_ID
,      SCENARIO_ID
,      PEGGING_ID
,      PARENT_PEGGING_ID
,      ATP_LEVEL
,      REQUEST_ITEM_ID
,      REQUEST_ITEM_NAME
,      INVENTORY_ITEM_ID
,      INVENTORY_ITEM_NAME
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      RESOURCE_ID
,      RESOURCE_CODE
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE_NAME
,      FROM_ORGANIZATION_ID
,      FROM_ORGANIZATION_CODE
,      FROM_LOCATION_ID
,      FROM_LOCATION_CODE
,      TO_ORGANIZATION_ID
,      TO_ORGANIZATION_CODE
,      TO_LOCATION_ID
,      TO_LOCATION_CODE
,      SHIP_METHOD
,      UOM_CODE
,      IDENTIFIER1
,      IDENTIFIER2
,      IDENTIFIER3
,      IDENTIFIER4
,      SUPPLY_DEMAND_TYPE
,      SUPPLY_DEMAND_DATE
,      SUPPLY_DEMAND_QUANTITY
,      SUPPLY_DEMAND_SOURCE_TYPE
,      SUPPLY_DEMAND_SOURCE_TYPE_NAME
,      ALLOCATED_QUANTITY
,      SOURCE_TYPE
,      RECORD_TYPE
,      TOTAL_SUPPLY_QUANTITY
,      TOTAL_DEMAND_QUANTITY
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      PERIOD_QUANTITY
,      CUMULATIVE_QUANTITY
,      DISPOSITION_TYPE
,      DISPOSITION_NAME
,      ITEM_RESOURCE
,      ITEM_RESOURCE_TYPE
,      END_PEGGING_ID
,      FROM_DEMAND_CLASS
,      PLAN_ID
,      DEMAND_CLASS
,      CUSTOMER_CLASS
,      CUSTOMER_NAME
,      CUSTOMER_SITE
,      SOURCE_TABLE
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      DISPLAY_DEMAND_CLASS
,      DISPLAY_CUSTOMER_CLASS
,      PF_DISPLAY_FLAG
,      ORIGINAL_DEMAND_DATE
,      ORIG_REQUEST_DATE
,      ORIG_DEMAND_CLASS
,      ORIG_CUSTOMER_NAME
,      ORIG_CUSTOMER_SITE_NAME
,      ORIGINAL_ITEM_ID
FROM APPS.MRP_ATP_SD_TEMP_V;

Dependencies

[top of page]

APPS.MRP_ATP_SD_TEMP_V references the following:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymMRP_ATP_DETAILS_TEMP
PL/SQL PackageMSC_SCH_WB - show dependent code

APPS.MRP_ATP_SD_TEMP_V is not referenced by any database object