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

VIEW: MRP.MRP_ATP_SCHEDULE_TEMP#

Object Details
Object Name: MRP_ATP_SCHEDULE_TEMP#
Object Type: VIEW
Owner: MRP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ACTION NUMBER

CALLING_MODULE NUMBER

SESSION_ID NUMBER
Yes
ORDER_HEADER_ID NUMBER

ORDER_LINE_ID NUMBER

INVENTORY_ITEM_ID NUMBER
Yes
ORGANIZATION_ID NUMBER

SR_INSTANCE_ID NUMBER

ORGANIZATION_CODE VARCHAR2 (7)
ORDER_NUMBER NUMBER

SOURCE_ORGANIZATION_ID NUMBER

CUSTOMER_ID NUMBER

CUSTOMER_SITE_ID NUMBER

DESTINATION_TIME_ZONE VARCHAR2 (30)
QUANTITY_ORDERED NUMBER

UOM_CODE VARCHAR2 (3)
REQUESTED_SHIP_DATE DATE

REQUESTED_ARRIVAL_DATE DATE

LATEST_ACCEPTABLE_DATE DATE

DELIVERY_LEAD_TIME NUMBER

FREIGHT_CARRIER VARCHAR2 (30)
SHIP_METHOD VARCHAR2 (30)
DEMAND_CLASS VARCHAR2 (30)
SHIP_SET_NAME VARCHAR2 (30)
SHIP_SET_ID NUMBER

ARRIVAL_SET_NAME VARCHAR2 (30)
ARRIVAL_SET_ID NUMBER

OVERRIDE_FLAG VARCHAR2 (1)
SCHEDULED_SHIP_DATE DATE

SCHEDULED_ARRIVAL_DATE DATE

AVAILABLE_QUANTITY NUMBER

REQUESTED_DATE_QUANTITY NUMBER

GROUP_SHIP_DATE DATE

GROUP_ARRIVAL_DATE DATE

VENDOR_ID NUMBER

VENDOR_SITE_ID NUMBER

INSERT_FLAG NUMBER

ERROR_CODE VARCHAR2 (240)
ERROR_MESSAGE VARCHAR2 (240)
SEQUENCE_NUMBER NUMBER

FIRM_FLAG NUMBER

INVENTORY_ITEM_NAME VARCHAR2 (250)
SOURCE_ORGANIZATION_CODE VARCHAR2 (7)
INSTANCE_ID1 NUMBER

ORDER_LINE_NUMBER NUMBER

SHIPMENT_NUMBER NUMBER

OPTION_NUMBER NUMBER

PROMISE_DATE DATE

CUSTOMER_NAME VARCHAR2 (255)
CUSTOMER_LOCATION VARCHAR2 (40)
OLD_LINE_SCHEDULE_DATE DATE

OLD_SOURCE_ORGANIZATION_CODE VARCHAR2 (7)
SCENARIO_ID NUMBER
Yes
VENDOR_NAME VARCHAR2 (80)
VENDOR_SITE_NAME VARCHAR2 (240)
STATUS_FLAG NUMBER

MDI_ROWID VARCHAR2 (30)
DEMAND_SOURCE_TYPE NUMBER

DEMAND_SOURCE_DELIVERY VARCHAR2 (30)
ATP_LEAD_TIME NUMBER

OE_FLAG VARCHAR2 (1)
ITEM_DESC VARCHAR2 (240)
INTRANSIT_LEAD_TIME NUMBER

SHIP_METHOD_TEXT VARCHAR2 (240)
END_PEGGING_ID NUMBER

PROJECT_ID NUMBER

TASK_ID NUMBER

PROJECT_NUMBER VARCHAR2 (25)
TASK_NUMBER VARCHAR2 (25)
EXCEPTION1 NUMBER

EXCEPTION2 NUMBER

EXCEPTION3 NUMBER

EXCEPTION4 NUMBER

EXCEPTION5 NUMBER

EXCEPTION6 NUMBER

EXCEPTION7 NUMBER

EXCEPTION8 NUMBER

EXCEPTION9 NUMBER

EXCEPTION10 NUMBER

EXCEPTION11 NUMBER

EXCEPTION12 NUMBER

EXCEPTION13 NUMBER

EXCEPTION14 NUMBER

EXCEPTION15 NUMBER

FIRM_SOURCE_ORG_ID NUMBER

FIRM_SOURCE_ORG_CODE VARCHAR2 (7)
FIRM_SHIP_DATE DATE

FIRM_ARRIVAL_DATE DATE

OLD_SOURCE_ORGANIZATION_ID NUMBER

OLD_DEMAND_CLASS VARCHAR2 (30)
ATTRIBUTE_06 VARCHAR2 (30)
REQUEST_ITEM_ID NUMBER

REQUEST_ITEM_NAME VARCHAR2 (250)
REQ_ITEM_AVAILABLE_DATE DATE

REQ_ITEM_AVAILABLE_DATE_QTY NUMBER

REQ_ITEM_REQ_DATE_QTY NUMBER

SALES_REP VARCHAR2 (255)
CUSTOMER_CONTACT VARCHAR2 (255)
SUBST_FLAG NUMBER

SUBSTITUTION_TYP_CODE NUMBER

REQ_ITEM_DETAIL_FLAG NUMBER

OLD_INVENTORY_ITEM_ID NUMBER

COMPILE_DESIGNATOR VARCHAR2 (10)
CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

FLOW_STATUS_CODE VARCHAR2 (30)
ASSIGNMENT_SET_ID NUMBER

DIAGNOSTIC_ATP_FLAG NUMBER

TOP_MODEL_LINE_ID NUMBER

ATO_PARENT_MODEL_LINE_ID NUMBER

ATO_MODEL_LINE_ID NUMBER

PARENT_LINE_ID NUMBER

MATCH_ITEM_ID NUMBER

VALIDATION_ORG NUMBER

COMPONENT_SEQUENCE_ID NUMBER

COMPONENT_CODE VARCHAR2 (1000)
INCLUDED_ITEM_FLAG NUMBER

LINE_NUMBER VARCHAR2 (255)
BOM_ITEM_TYPE NUMBER

CONFIG_ITEM_LINE_ID NUMBER

OSS_ERROR_CODE NUMBER

SOURCE_DOC_ID NUMBER

PICK_COMPONENTS_FLAG VARCHAR2 (1)
MATCHED_ITEM_NAME VARCHAR2 (255)
ATP_FLAG VARCHAR2 (1)
ATP_COMPONENTS_FLAG VARCHAR2 (1)
WIP_SUPPLY_TYPE NUMBER

FIXED_LT NUMBER

VARIABLE_LT NUMBER

MANDATORY_ITEM_FLAG NUMBER

CASCADE_MODEL_INFO_TO_COMP NUMBER

ORIGINAL_REQUEST_DATE DATE

PLAN_ID NUMBER

INTERNAL_ORG_ID NUMBER

FIRST_VALID_SHIP_ARRIVAL_DATE DATE

PART_OF_SET VARCHAR2 (1)
PARTY_SITE_ID NUMBER

CUSTOMER_COUNTRY VARCHAR2 (60)
CUSTOMER_STATE VARCHAR2 (120)
CUSTOMER_CITY VARCHAR2 (240)
CUSTOMER_POSTAL_CODE VARCHAR2 (60)
Query Text

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


SELECT ACTION
,      CALLING_MODULE
,      SESSION_ID
,      ORDER_HEADER_ID
,      ORDER_LINE_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      ORGANIZATION_CODE
,      ORDER_NUMBER
,      SOURCE_ORGANIZATION_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      DESTINATION_TIME_ZONE
,      QUANTITY_ORDERED
,      UOM_CODE
,      REQUESTED_SHIP_DATE
,      REQUESTED_ARRIVAL_DATE
,      LATEST_ACCEPTABLE_DATE
,      DELIVERY_LEAD_TIME
,      FREIGHT_CARRIER
,      SHIP_METHOD
,      DEMAND_CLASS
,      SHIP_SET_NAME
,      SHIP_SET_ID
,      ARRIVAL_SET_NAME
,      ARRIVAL_SET_ID
,      OVERRIDE_FLAG
,      SCHEDULED_SHIP_DATE
,      SCHEDULED_ARRIVAL_DATE
,      AVAILABLE_QUANTITY
,      REQUESTED_DATE_QUANTITY
,      GROUP_SHIP_DATE
,      GROUP_ARRIVAL_DATE
,      VENDOR_ID
,      VENDOR_SITE_ID
,      INSERT_FLAG
,      ERROR_CODE
,      ERROR_MESSAGE
,      SEQUENCE_NUMBER
,      FIRM_FLAG
,      INVENTORY_ITEM_NAME
,      SOURCE_ORGANIZATION_CODE
,      INSTANCE_ID1
,      ORDER_LINE_NUMBER
,      SHIPMENT_NUMBER
,      OPTION_NUMBER
,      PROMISE_DATE
,      CUSTOMER_NAME
,      CUSTOMER_LOCATION
,      OLD_LINE_SCHEDULE_DATE
,      OLD_SOURCE_ORGANIZATION_CODE
,      SCENARIO_ID
,      VENDOR_NAME
,      VENDOR_SITE_NAME
,      STATUS_FLAG
,      MDI_ROWID
,      DEMAND_SOURCE_TYPE
,      DEMAND_SOURCE_DELIVERY
,      ATP_LEAD_TIME
,      OE_FLAG
,      ITEM_DESC
,      INTRANSIT_LEAD_TIME
,      SHIP_METHOD_TEXT
,      END_PEGGING_ID
,      PROJECT_ID
,      TASK_ID
,      PROJECT_NUMBER
,      TASK_NUMBER
,      EXCEPTION1
,      EXCEPTION2
,      EXCEPTION3
,      EXCEPTION4
,      EXCEPTION5
,      EXCEPTION6
,      EXCEPTION7
,      EXCEPTION8
,      EXCEPTION9
,      EXCEPTION10
,      EXCEPTION11
,      EXCEPTION12
,      EXCEPTION13
,      EXCEPTION14
,      EXCEPTION15
,      FIRM_SOURCE_ORG_ID
,      FIRM_SOURCE_ORG_CODE
,      FIRM_SHIP_DATE
,      FIRM_ARRIVAL_DATE
,      OLD_SOURCE_ORGANIZATION_ID
,      OLD_DEMAND_CLASS
,      ATTRIBUTE_06
,      REQUEST_ITEM_ID
,      REQUEST_ITEM_NAME
,      REQ_ITEM_AVAILABLE_DATE
,      REQ_ITEM_AVAILABLE_DATE_QTY
,      REQ_ITEM_REQ_DATE_QTY
,      SALES_REP
,      CUSTOMER_CONTACT
,      SUBST_FLAG
,      SUBSTITUTION_TYP_CODE
,      REQ_ITEM_DETAIL_FLAG
,      OLD_INVENTORY_ITEM_ID
,      COMPILE_DESIGNATOR
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      FLOW_STATUS_CODE
,      ASSIGNMENT_SET_ID
,      DIAGNOSTIC_ATP_FLAG
,      TOP_MODEL_LINE_ID
,      ATO_PARENT_MODEL_LINE_ID
,      ATO_MODEL_LINE_ID
,      PARENT_LINE_ID
,      MATCH_ITEM_ID
,      VALIDATION_ORG
,      COMPONENT_SEQUENCE_ID
,      COMPONENT_CODE
,      INCLUDED_ITEM_FLAG
,      LINE_NUMBER
,      BOM_ITEM_TYPE
,      CONFIG_ITEM_LINE_ID
,      OSS_ERROR_CODE
,      SOURCE_DOC_ID
,      PICK_COMPONENTS_FLAG
,      MATCHED_ITEM_NAME
,      ATP_FLAG
,      ATP_COMPONENTS_FLAG
,      WIP_SUPPLY_TYPE
,      FIXED_LT
,      VARIABLE_LT
,      MANDATORY_ITEM_FLAG
,      CASCADE_MODEL_INFO_TO_COMP
,      ORIGINAL_REQUEST_DATE
,      PLAN_ID
,      INTERNAL_ORG_ID
,      FIRST_VALID_SHIP_ARRIVAL_DATE
,      PART_OF_SET
,      PARTY_SITE_ID
,      CUSTOMER_COUNTRY
,      CUSTOMER_STATE
,      CUSTOMER_CITY
,      CUSTOMER_POSTAL_CODE
FROM MRP.MRP_ATP_SCHEDULE_TEMP#;

Dependencies

[top of page]

MRP.MRP_ATP_SCHEDULE_TEMP# references the following:

SchemaMRP
TableMRP_ATP_SCHEDULE_TEMP
MRP.MRP_ATP_SCHEDULE_TEMP# is referenced by following:

SchemaAPPS
SynonymMRP_ATP_SCHEDULE_TEMP