[Home] [Help] [Dependency Information]
Object Name: | MRP_ATP_SCHEDULE_TEMP# |
---|---|
Object Type: | VIEW |
Owner: | MRP |
Subobject Name: | |
Status: | VALID |
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) |
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#;
|
|
|