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

TYPE: APPS.MSC_ATP_BPEL_ATP_REC_SCALAR_T

Object Details
Object Name: MSC_ATP_BPEL_ATP_REC_SCALAR_T
Object Type: TYPE
Owner: APPS
Subobject Name:
Status: VALID
Type Details
Type Code: OBJECT
Predefined: NO
Incomplete: NO
Attributes
Name Datatype Length Prcn
ROW_ID VARCHAR2 (30)
INSTANCE_ID NUMBER

INVENTORY_ITEM_ID NUMBER

INVENTORY_ITEM_NAME VARCHAR2 (40)
SOURCE_ORGANIZATION_ID NUMBER

SOURCE_ORGANIZATION_CODE VARCHAR2 (7)
ORGANIZATION_ID NUMBER

IDENTIFIER NUMBER

DEMAND_SOURCE_HEADER_ID NUMBER

DEMAND_SOURCE_DELIVERY VARCHAR2 (30)
DEMAND_SOURCE_TYPE NUMBER

SCENARIO_ID NUMBER

CALLING_MODULE NUMBER

CUSTOMER_ID NUMBER

CUSTOMER_SITE_ID NUMBER

DESTINATION_TIME_ZONE VARCHAR2 (30)
QUANTITY_ORDERED NUMBER

QUANTITY_UOM VARCHAR2 (3)
REQUESTED_SHIP_DATE DATE

REQUESTED_ARRIVAL_DATE DATE

EARLIEST_ACCEPTABLE_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)
ARRIVAL_SET_NAME VARCHAR2 (30)
OVERRIDE_FLAG VARCHAR2 (1)
ACTION NUMBER

SHIP_DATE DATE

ARRIVAL_DATE DATE

AVAILABLE_QUANTITY NUMBER

REQUESTED_DATE_QUANTITY NUMBER

GROUP_SHIP_DATE DATE

GROUP_ARRIVAL_DATE DATE

VENDOR_ID NUMBER

VENDOR_NAME VARCHAR2 (80)
VENDOR_SITE_ID NUMBER

VENDOR_SITE_NAME VARCHAR2 (80)
INSERT_FLAG NUMBER

OE_FLAG VARCHAR2 (1)
ATP_LEAD_TIME NUMBER

ERROR_CODE NUMBER

MESSAGE VARCHAR2 (2000)
END_PEGGING_ID NUMBER

ORDER_NUMBER NUMBER

OLD_SOURCE_ORGANIZATION_ID NUMBER

OLD_DEMAND_CLASS VARCHAR2 (30)
ATO_DELETE_FLAG VARCHAR2 (1)
ATTRIBUTE_01 NUMBER

ATTRIBUTE_02 NUMBER

ATTRIBUTE_03 NUMBER

ATTRIBUTE_04 NUMBER

ATTRIBUTE_05 VARCHAR2 (30)
ATTRIBUTE_06 VARCHAR2 (30)
ATTRIBUTE_07 VARCHAR2 (30)
ATTRIBUTE_08 VARCHAR2 (30)
ATTRIBUTE_09 DATE

ATTRIBUTE_10 DATE

CUSTOMER_NAME VARCHAR2 (255)
CUSTOMER_CLASS VARCHAR2 (30)
CUSTOMER_LOCATION VARCHAR2 (40)
CUSTOMER_COUNTRY VARCHAR2 (60)
CUSTOMER_STATE VARCHAR2 (60)
CUSTOMER_CITY VARCHAR2 (60)
CUSTOMER_POSTAL_CODE VARCHAR2 (60)
SUBSTITUTION_TYP_CODE NUMBER

REQ_ITEM_DETAIL_FLAG NUMBER

REQUEST_ITEM_ID NUMBER

REQ_ITEM_REQ_DATE_QTY NUMBER

REQ_ITEM_AVAILABLE_DATE DATE

REQ_ITEM_AVAILABLE_DATE_QTY NUMBER

REQUEST_ITEM_NAME VARCHAR2 (40)
OLD_INVENTORY_ITEM_ID NUMBER

SALES_REP VARCHAR2 (255)
CUSTOMER_CONTACT VARCHAR2 (255)
SUBST_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

CONFIG_ITEM_LINE_ID NUMBER

VALIDATION_ORG NUMBER

COMPONENT_SEQUENCE_ID NUMBER

COMPONENT_CODE VARCHAR2 (255)
LINE_NUMBER VARCHAR2 (80)
INCLUDED_ITEM_FLAG NUMBER

ATP_FLAG VARCHAR2 (1)
ATP_COMPONENTS_FLAG VARCHAR2 (1)
WIP_SUPPLY_TYPE NUMBER

BOM_ITEM_TYPE NUMBER

MANDATORY_ITEM_FLAG NUMBER

PICK_COMPONENTS_FLAG VARCHAR2 (1)
BASE_MODEL_ID NUMBER

OSS_ERROR_CODE NUMBER

MATCHED_ITEM_NAME VARCHAR2 (255)
CASCADE_MODEL_INFO_TO_COMP NUMBER

SEQUENCE_NUMBER NUMBER

FIRM_FLAG NUMBER

ORDER_LINE_NUMBER NUMBER

OPTION_NUMBER NUMBER

SHIPMENT_NUMBER NUMBER

ITEM_DESC VARCHAR2 (255)
OLD_LINE_SCHEDULE_DATE DATE

OLD_SOURCE_ORGANIZATION_CODE VARCHAR2 (7)
FIRM_SOURCE_ORG_ID NUMBER

FIRM_SOURCE_ORG_CODE VARCHAR2 (7)
FIRM_SHIP_DATE DATE

FIRM_ARRIVAL_DATE DATE

SHIP_METHOD_TEXT VARCHAR2 (255)
SHIP_SET_ID NUMBER

ARRIVAL_SET_ID NUMBER

PROJECT_ID NUMBER

TASK_ID NUMBER

PROJECT_NUMBER VARCHAR2 (30)
TASK_NUMBER VARCHAR2 (30)
ATTRIBUTE_11 NUMBER

ATTRIBUTE_12 NUMBER

ATTRIBUTE_13 NUMBER

ATTRIBUTE_14 NUMBER

ATTRIBUTE_15 VARCHAR2 (30)
ATTRIBUTE_16 VARCHAR2 (30)
ATTRIBUTE_17 VARCHAR2 (30)
ATTRIBUTE_18 VARCHAR2 (30)
ATTRIBUTE_19 DATE

ATTRIBUTE_20 DATE

ATTRIBUTE_21 NUMBER

ATTRIBUTE_22 NUMBER

ATTRIBUTE_23 NUMBER

ATTRIBUTE_24 NUMBER

ATTRIBUTE_25 VARCHAR2 (30)
ATTRIBUTE_26 VARCHAR2 (30)
ATTRIBUTE_27 VARCHAR2 (30)
ATTRIBUTE_28 VARCHAR2 (30)
ATTRIBUTE_29 DATE

ATTRIBUTE_30 DATE

ATF_DATE DATE

PLAN_ID NUMBER

ORIGINAL_REQUEST_DATE DATE

RECEIVING_CAL_CODE VARCHAR2 (14)
INTRANSIT_CAL_CODE VARCHAR2 (14)
SHIPPING_CAL_CODE VARCHAR2 (14)
MANUFACTURING_CAL_CODE VARCHAR2 (14)
INTERNAL_ORG_ID NUMBER

FIRST_VALID_SHIP_ARRIVAL_DATE DATE

PARTY_SITE_ID NUMBER

Dependencies

[top of page]

APPS.MSC_ATP_BPEL_ATP_REC_SCALAR_T references the following:

SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
APPS.MSC_ATP_BPEL_ATP_REC_SCALAR_T is referenced by following:

SchemaAPPS
TYPEMSC_ATP_BPEL_ATP_REC_TABLE_TY
PL/SQL PackageXX_BPEL_EBS11I10ATPCHECK - show dependent code
Package BodyXX_BPEL_EBS11I10ATPCHECK - show dependent code