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

VIEW: APPS.MSC_ORDERS_V

Object Details
Object Name: MSC_ORDERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSC.MSC_ORDERS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
SOURCE_TABLE VARCHAR2 (12)
ROW_ID ROWID (10)
TRANSACTION_ID NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

INVENTORY_ITEM_ID NUMBER

ORGANIZATION_ID NUMBER

ORGANIZATION_CODE VARCHAR2 (7)
PLAN_ORGANIZATION_ID NUMBER

PLAN_INSTANCE_ID NUMBER

SR_INSTANCE_ID NUMBER

PLAN_ID NUMBER

COMPILE_DESIGNATOR VARCHAR2 (0)
ACTION VARCHAR2 (4000)
NEW_DUE_DATE DATE

OLD_DUE_DATE DATE

NEW_START_DATE DATE

DISPOSITION_ID NUMBER

ORDER_NUMBER VARCHAR2 (4000)
DISPOSITION_STATUS_TYPE NUMBER

ORDER_TYPE NUMBER

ORDER_TYPE_TEXT VARCHAR2 (4000)
QUANTITY_RATE NUMBER

OLD_ORDER_QUANTITY NUMBER

NEW_ORDER_DATE DATE

FIRM_PLANNED_TYPE NUMBER

RESCHEDULED_FLAG NUMBER

NEW_PROCESSING_DAYS NUMBER

IMPLEMENTED_QUANTITY NUMBER

LAST_UNIT_COMPLETION_DATE DATE

FIRST_UNIT_START_DATE DATE

LAST_UNIT_START_DATE DATE

NEW_DOCK_DATE DATE

QUANTITY_IN_PROCESS NUMBER

FIRM_QUANTITY NUMBER

FIRM_DATE DATE

LINE_ID NUMBER

LINE_CODE VARCHAR2 (4000)
IMPLEMENT_DEMAND_CLASS VARCHAR2 (30)
ITEM_SEGMENTS VARCHAR2 (250)
IMPLEMENT_DATE DATE

IMPLEMENT_QUANTITY_RATE NUMBER

IMPLEMENT_FIRM NUMBER

IMPLEMENT_PROCESSING_DAYS NUMBER

IMPLEMENT_WIP_CLASS_CODE VARCHAR2 (10)
IMPLEMENT_JOB_NAME VARCHAR2 (240)
IMPLEMENT_LINE_ID NUMBER

IMPLEMENT_STATUS_CODE NUMBER

IMPLEMENT_LOCATION_ID NUMBER

RELEASE_STATUS NUMBER

IMPLEMENT_AS NUMBER

IMPLEMENT_AS_TEXT VARCHAR2 (4000)
PLANNER_CODE VARCHAR2 (10)
USING_ASSEMBLY_ITEM_ID NUMBER

CATEGORY_ID NUMBER

MRP_PLANNING_CODE NUMBER

REPETITIVE_TYPE NUMBER

BUILD_IN_WIP_FLAG NUMBER

PURCHASING_ENABLED_FLAG NUMBER

PLANNING_MAKE_BUY_CODE NUMBER

DAYS_FROM_TODAY NUMBER

BOM_ITEM_TYPE NUMBER

BASE_ITEM_ID NUMBER

WIP_SUPPLY_TYPE NUMBER

SOURCE_ORGANIZATION_ID NUMBER

SOURCE_SR_INSTANCE_ID NUMBER

SOURCE_ORGANIZATION_CODE VARCHAR2 (4000)
STATUS_CODE NUMBER

USING_ASSEMBLY_SEGMENTS VARCHAR2 (4000)
FULL_PEGGING NUMBER

SOURCE_VENDOR_ID NUMBER

SOURCE_VENDOR_NAME VARCHAR2 (4000)
SOURCE_VENDOR_SITE_ID NUMBER

SOURCE_VENDOR_SITE_CODE VARCHAR2 (4000)
VENDOR_ID NUMBER

SUPPLIER_NAME VARCHAR2 (0)
VENDOR_SITE_ID NUMBER

SUPPLIER_SITE_CODE VARCHAR2 (0)
IMPLEMENT_SOURCE_ORG_ID NUMBER

IMPLEMENT_SR_INSTANCE_ID NUMBER

IMPLEMENT_VENDOR_ID NUMBER

IMPLEMENT_VENDOR_SITE_ID NUMBER

IN_SOURCE_PLAN NUMBER

SCHEDULE_COMPRESSION_DAYS NUMBER

PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
PROJECT_NUMBER VARCHAR2 (4000)
TASK_NUMBER VARCHAR2 (4000)
IMPLEMENT_PROJECT_ID NUMBER

IMPLEMENT_TASK_ID NUMBER

PLANNING_GROUP VARCHAR2 (30)
STATUS NUMBER

APPLIED NUMBER

RELEASE_TIME_FENCE_CODE NUMBER

IMPLEMENT_SCHEDULE_GROUP_ID NUMBER

IMPLEMENT_BUILD_SEQUENCE NUMBER

BUILD_SEQUENCE NUMBER

SCHEDULE_GROUP_ID NUMBER

ALTERNATE_BOM_DESIGNATOR VARCHAR2 (4000)
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (4000)
PROCESS_SEQ_ID NUMBER

IMPLEMENT_ALTERNATE_BOM VARCHAR2 (10)
IMPLEMENT_ALTERNATE_ROUTING VARCHAR2 (10)
SCHEDULE_GROUP_NAME VARCHAR2 (30)
IMPLEMENT_EMPLOYEE_ID NUMBER

CFM_ROUTING_FLAG NUMBER

BUYER_NAME VARCHAR2 (240)
RELEASE_ERRORS VARCHAR2 (250)
REL_ALL_QTY NUMBER

UNIT_NUMBER VARCHAR2 (30)
IMPLEMENT_UNIT_NUMBER VARCHAR2 (30)
DESCRIPTION VARCHAR2 (240)
PLANNING_GROUP_HIDDEN VARCHAR2 (30)
BUYER_NAME_HIDDEN VARCHAR2 (240)
PLANNER_CODE_HIDDEN VARCHAR2 (10)
PROJECT_ID_HIDDEN NUMBER

TASK_ID_HIDDEN NUMBER

LENDING_PROJECT_NUMBER VARCHAR2 (4000)
LENDING_TASK_NUMBER VARCHAR2 (4000)
CATEGORY_SET_ID NUMBER

CATEGORY_NAME VARCHAR2 (250)
PRODUCT_FAMILY_ID NUMBER

PRODUCT_FAMILY_NAME VARCHAR2 (4000)
BASE_ITEM_NAME VARCHAR2 (4000)
ABC_CLASS VARCHAR2 (40)
UOM_CODE VARCHAR2 (3)
INTERNAL_SO_NUMBER VARCHAR2 (4000)
DEMAND_PRIORITY NUMBER

PROMISE_DATE DATE

REQUEST_DATE DATE

CUSTOMER_ID NUMBER

CUSTOMER_NAME VARCHAR2 (4000)
CUSTOMER_SITE_ID NUMBER

CUSTOMER_SITE_NAME VARCHAR2 (4000)
SHIP_TO_SITE_ID NUMBER

SHIP_TO_SITE_NAME VARCHAR2 (4000)
LOT_NUMBER VARCHAR2 (80)
SUBINVENTORY_CODE VARCHAR2 (10)
PARENT_ID NUMBER

WIP_STATUS_CODE NUMBER

WIP_STATUS_TEXT VARCHAR2 (4000)
DMD_LATENESS_COST NUMBER

DMD_SATISFIED_DATE DATE

NEED_BY_DATE DATE

DESIGNATOR_NAME VARCHAR2 (4000)
LIST_PRICE NUMBER

STANDARD_COST NUMBER

SELLING_PRICE NUMBER

SERVICE_LEVEL NUMBER

DEMAND_CLASS VARCHAR2 (34)
PROBABILITY NUMBER

SHIP_DATE DATE

QUANTITY NUMBER

ASSEMBLY_DEMAND_COMP_DATE DATE

BUCKET_TYPE VARCHAR2 (7)
SOURCE_DMD_PRIORITY NUMBER

PO_LINE_ID NUMBER

RESCHEDULE_DAYS NUMBER

OLD_NEED_BY_DATE DATE

CUMULATIVE_PROBABILITY NUMBER

ORIGINAL_ITEM_ID NUMBER

ORIGINAL_ITEM_NAME VARCHAR2 (4000)
ORIGINAL_ITEM_QTY NUMBER

SHIP_METHOD VARCHAR2 (30)
EXPLOSION_DATE DATE

UNMET_QUANTITY NUMBER

ORIGINAL_QUANTITY NUMBER

ORIGINAL_NEED_BY_DATE DATE

EPST DATE

EPCT DATE

MIN_START_TIME DATE

LOW_LEVEL_CODE NUMBER

ORDERS_DAYS_LATE NUMBER

ULPSD DATE

ULPCD DATE

UEPSD DATE

UEPCD DATE

EACD DATE

SUPPLY_IS_SHARED NUMBER

RECORD_SOURCE NUMBER

FORWARD_DAYS NUMBER

BACKWARD_DAYS NUMBER

WIP_START_QUANTITY NUMBER

EXPIRATION_DATE DATE

MRP_PLANNING_CODE_TEXT VARCHAR2 (4000)
ORIGINAL_ORG_ID NUMBER

ORIGINAL_INST_ID NUMBER

START_QUANTITY NUMBER

CRITICAL_COMPONENT_FLAG NUMBER

ORDER_DATE_TYPE_CODE NUMBER

ORDER_DATE_TYPE_TEXT VARCHAR2 (4000)
SCHEDULE_ARRIVAL_DATE DATE

LATEST_ACCEPTABLE_DATE DATE

PLANNED_ARRIVAL_DATE DATE

SHIPMENT_ID NUMBER

SHIP_CALENDAR VARCHAR2 (15)
RECEIVING_CALENDAR VARCHAR2 (15)
INTRANSIT_CALENDAR VARCHAR2 (15)
INTRANSIT_LEAD_TIME NUMBER

IMPLEMENT_DOCK_DATE DATE

IMPLEMENT_SHIP_DATE DATE

IMPLEMENT_ARRIVAL_DATE DATE

REQUEST_SHIP_DATE DATE

PROMISE_SHIP_DATE DATE

LATE_DAYS NUMBER

To indicate days late of supply and demand
RECOMMENDED VARCHAR2 (0)
SUBSTITUTE_COMPONENT_RANK NUMBER

COMPONENT_YIELD NUMBER

SOURCE_TABLE2 VARCHAR2 (0)
VMI_FLAG NUMBER

WEIGHT NUMBER

VOLUME NUMBER

SCHEDULE_SHIP_DATE DATE

DEST_ORG_CODE VARCHAR2 (4000)
QTY_BY_DUE_DATE NUMBER

SHIP_SET_NAME VARCHAR2 (30)
ARRIVAL_SET_NAME VARCHAR2 (30)
ORIG_ORG_CODE VARCHAR2 (4000)
ORIG_LEAD_TIME NUMBER

ORIG_SHIP_METHOD VARCHAR2 (30)
DEST_ORG_ID NUMBER

DEST_INST_ID NUMBER

IMPLEMENT_DEST_ORG_ID NUMBER

IMPLEMENT_DEST_INST_ID NUMBER

IMPLEMENT_DEST_ORG_CODE VARCHAR2 (0)
HIDDEN_DOCK_DATE DATE

FINAL_USE_PRIORITY NUMBER

FINAL_USE_DATE DATE

ZONE VARCHAR2 (4000)
ALLOCATION_QTY NUMBER

FIRM_ALLOCATION_FLAG NUMBER

ALLOCATION_DATE DATE

SALES_ORDER_LINE_SPLIT VARCHAR2 (4000)
PARENT_WORK_ORDER NUMBER

EAM Parent work order of a child work order
ASSET_GROUP VARCHAR2 (4000)
Asset Item Description
ASSET_NUMBER VARCHAR2 (30)
Asset number or rebuild serial number
REQUESTED_START_DATE DATE

Requested start date of the WO
REQUESTED_COMPLETION_DATE DATE

Requested completion/Due date of the WO
FILL_KILL_FLAG NUMBER

LOTS_EXIST NUMBER

IMPLEMENT_SHIP_METHOD VARCHAR2 (30)
ACTUAL_START_DATE DATE

FIRM_DUE_DATE DATE

IMPLEMENT_DUE_DATE DATE

HIDDEN_DUE_DATE DATE

WITHIN_REL_TIME_FENCE NUMBER

Flag to indicate whether an item order is with in the release time fence or not. 1 - Yes, 2 - No
AMOUNT NUMBER

Cost of an Order Line.
SO_LINE_SPLIT NUMBER

FORECAST_SET_ID NUMBER

SCHEDULE_DESIGNATOR_ID NUMBER

DELIVERY_PRICE NUMBER

SALES_ORDER_LINE_ID NUMBER

Sales Order Line ID
SHIP_SET_ID NUMBER

Ship Set ID
ARRIVAL_SET_ID NUMBER

Arrival Set ID
ITEM_TYPE_ID NUMBER

ITEM_TYPE_VALUE NUMBER

PART_CONDITION VARCHAR2 (4000)
FIRM_START_DATE DATE

BILL_SEQUENCE_ID NUMBER

ROUTING_SEQUENCE_ID NUMBER

PREV_SUBST_ITEM_ID NUMBER

PREV_SUBST_ORG_ID NUMBER

PREV_SUBST_ITEM VARCHAR2 (4000)
PREV_SUBST_ORG VARCHAR2 (4000)
OTM_ARRIVAL_DATE DATE

Updated arrival date received from OTM.
MIN_REM_SHELF_LIFE_DAYS NUMBER

COMMENTS VARCHAR2 (4000)
Used to store user Comments
SUGGESTED_PICK_DATE DATE

PICK_PACK_LT NUMBER

Query Text

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


SELECT SOURCE_TABLE
,      ROW_ID
,      TRANSACTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      PLAN_ORGANIZATION_ID
,      PLAN_INSTANCE_ID
,      SR_INSTANCE_ID
,      PLAN_ID
,      COMPILE_DESIGNATOR
,      ACTION
,      NEW_DUE_DATE
,      OLD_DUE_DATE
,      NEW_START_DATE
,      DISPOSITION_ID
,      ORDER_NUMBER
,      DISPOSITION_STATUS_TYPE
,      ORDER_TYPE
,      ORDER_TYPE_TEXT
,      QUANTITY_RATE
,      OLD_ORDER_QUANTITY
,      NEW_ORDER_DATE
,      FIRM_PLANNED_TYPE
,      RESCHEDULED_FLAG
,      NEW_PROCESSING_DAYS
,      IMPLEMENTED_QUANTITY
,      LAST_UNIT_COMPLETION_DATE
,      FIRST_UNIT_START_DATE
,      LAST_UNIT_START_DATE
,      NEW_DOCK_DATE
,      QUANTITY_IN_PROCESS
,      FIRM_QUANTITY
,      FIRM_DATE
,      LINE_ID
,      LINE_CODE
,      IMPLEMENT_DEMAND_CLASS
,      ITEM_SEGMENTS
,      IMPLEMENT_DATE
,      IMPLEMENT_QUANTITY_RATE
,      IMPLEMENT_FIRM
,      IMPLEMENT_PROCESSING_DAYS
,      IMPLEMENT_WIP_CLASS_CODE
,      IMPLEMENT_JOB_NAME
,      IMPLEMENT_LINE_ID
,      IMPLEMENT_STATUS_CODE
,      IMPLEMENT_LOCATION_ID
,      RELEASE_STATUS
,      IMPLEMENT_AS
,      IMPLEMENT_AS_TEXT
,      PLANNER_CODE
,      USING_ASSEMBLY_ITEM_ID
,      CATEGORY_ID
,      MRP_PLANNING_CODE
,      REPETITIVE_TYPE
,      BUILD_IN_WIP_FLAG
,      PURCHASING_ENABLED_FLAG
,      PLANNING_MAKE_BUY_CODE
,      DAYS_FROM_TODAY
,      BOM_ITEM_TYPE
,      BASE_ITEM_ID
,      WIP_SUPPLY_TYPE
,      SOURCE_ORGANIZATION_ID
,      SOURCE_SR_INSTANCE_ID
,      SOURCE_ORGANIZATION_CODE
,      STATUS_CODE
,      USING_ASSEMBLY_SEGMENTS
,      FULL_PEGGING
,      SOURCE_VENDOR_ID
,      SOURCE_VENDOR_NAME
,      SOURCE_VENDOR_SITE_ID
,      SOURCE_VENDOR_SITE_CODE
,      VENDOR_ID
,      SUPPLIER_NAME
,      VENDOR_SITE_ID
,      SUPPLIER_SITE_CODE
,      IMPLEMENT_SOURCE_ORG_ID
,      IMPLEMENT_SR_INSTANCE_ID
,      IMPLEMENT_VENDOR_ID
,      IMPLEMENT_VENDOR_SITE_ID
,      IN_SOURCE_PLAN
,      SCHEDULE_COMPRESSION_DAYS
,      PROJECT_ID
,      TASK_ID
,      PROJECT_NUMBER
,      TASK_NUMBER
,      IMPLEMENT_PROJECT_ID
,      IMPLEMENT_TASK_ID
,      PLANNING_GROUP
,      STATUS
,      APPLIED
,      RELEASE_TIME_FENCE_CODE
,      IMPLEMENT_SCHEDULE_GROUP_ID
,      IMPLEMENT_BUILD_SEQUENCE
,      BUILD_SEQUENCE
,      SCHEDULE_GROUP_ID
,      ALTERNATE_BOM_DESIGNATOR
,      ALTERNATE_ROUTING_DESIGNATOR
,      PROCESS_SEQ_ID
,      IMPLEMENT_ALTERNATE_BOM
,      IMPLEMENT_ALTERNATE_ROUTING
,      SCHEDULE_GROUP_NAME
,      IMPLEMENT_EMPLOYEE_ID
,      CFM_ROUTING_FLAG
,      BUYER_NAME
,      RELEASE_ERRORS
,      REL_ALL_QTY
,      UNIT_NUMBER
,      IMPLEMENT_UNIT_NUMBER
,      DESCRIPTION
,      PLANNING_GROUP_HIDDEN
,      BUYER_NAME_HIDDEN
,      PLANNER_CODE_HIDDEN
,      PROJECT_ID_HIDDEN
,      TASK_ID_HIDDEN
,      LENDING_PROJECT_NUMBER
,      LENDING_TASK_NUMBER
,      CATEGORY_SET_ID
,      CATEGORY_NAME
,      PRODUCT_FAMILY_ID
,      PRODUCT_FAMILY_NAME
,      BASE_ITEM_NAME
,      ABC_CLASS
,      UOM_CODE
,      INTERNAL_SO_NUMBER
,      DEMAND_PRIORITY
,      PROMISE_DATE
,      REQUEST_DATE
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_SITE_ID
,      CUSTOMER_SITE_NAME
,      SHIP_TO_SITE_ID
,      SHIP_TO_SITE_NAME
,      LOT_NUMBER
,      SUBINVENTORY_CODE
,      PARENT_ID
,      WIP_STATUS_CODE
,      WIP_STATUS_TEXT
,      DMD_LATENESS_COST
,      DMD_SATISFIED_DATE
,      NEED_BY_DATE
,      DESIGNATOR_NAME
,      LIST_PRICE
,      STANDARD_COST
,      SELLING_PRICE
,      SERVICE_LEVEL
,      DEMAND_CLASS
,      PROBABILITY
,      SHIP_DATE
,      QUANTITY
,      ASSEMBLY_DEMAND_COMP_DATE
,      BUCKET_TYPE
,      SOURCE_DMD_PRIORITY
,      PO_LINE_ID
,      RESCHEDULE_DAYS
,      OLD_NEED_BY_DATE
,      CUMULATIVE_PROBABILITY
,      ORIGINAL_ITEM_ID
,      ORIGINAL_ITEM_NAME
,      ORIGINAL_ITEM_QTY
,      SHIP_METHOD
,      EXPLOSION_DATE
,      UNMET_QUANTITY
,      ORIGINAL_QUANTITY
,      ORIGINAL_NEED_BY_DATE
,      EPST
,      EPCT
,      MIN_START_TIME
,      LOW_LEVEL_CODE
,      ORDERS_DAYS_LATE
,      ULPSD
,      ULPCD
,      UEPSD
,      UEPCD
,      EACD
,      SUPPLY_IS_SHARED
,      RECORD_SOURCE
,      FORWARD_DAYS
,      BACKWARD_DAYS
,      WIP_START_QUANTITY
,      EXPIRATION_DATE
,      MRP_PLANNING_CODE_TEXT
,      ORIGINAL_ORG_ID
,      ORIGINAL_INST_ID
,      START_QUANTITY
,      CRITICAL_COMPONENT_FLAG
,      ORDER_DATE_TYPE_CODE
,      ORDER_DATE_TYPE_TEXT
,      SCHEDULE_ARRIVAL_DATE
,      LATEST_ACCEPTABLE_DATE
,      PLANNED_ARRIVAL_DATE
,      SHIPMENT_ID
,      SHIP_CALENDAR
,      RECEIVING_CALENDAR
,      INTRANSIT_CALENDAR
,      INTRANSIT_LEAD_TIME
,      IMPLEMENT_DOCK_DATE
,      IMPLEMENT_SHIP_DATE
,      IMPLEMENT_ARRIVAL_DATE
,      REQUEST_SHIP_DATE
,      PROMISE_SHIP_DATE
,      LATE_DAYS
,      RECOMMENDED
,      SUBSTITUTE_COMPONENT_RANK
,      COMPONENT_YIELD
,      SOURCE_TABLE2
,      VMI_FLAG
,      WEIGHT
,      VOLUME
,      SCHEDULE_SHIP_DATE
,      DEST_ORG_CODE
,      QTY_BY_DUE_DATE
,      SHIP_SET_NAME
,      ARRIVAL_SET_NAME
,      ORIG_ORG_CODE
,      ORIG_LEAD_TIME
,      ORIG_SHIP_METHOD
,      DEST_ORG_ID
,      DEST_INST_ID
,      IMPLEMENT_DEST_ORG_ID
,      IMPLEMENT_DEST_INST_ID
,      IMPLEMENT_DEST_ORG_CODE
,      HIDDEN_DOCK_DATE
,      FINAL_USE_PRIORITY
,      FINAL_USE_DATE
,      ZONE
,      ALLOCATION_QTY
,      FIRM_ALLOCATION_FLAG
,      ALLOCATION_DATE
,      SALES_ORDER_LINE_SPLIT
,      PARENT_WORK_ORDER
,      ASSET_GROUP
,      ASSET_NUMBER
,      REQUESTED_START_DATE
,      REQUESTED_COMPLETION_DATE
,      FILL_KILL_FLAG
,      LOTS_EXIST
,      IMPLEMENT_SHIP_METHOD
,      ACTUAL_START_DATE
,      FIRM_DUE_DATE
,      IMPLEMENT_DUE_DATE
,      HIDDEN_DUE_DATE
,      WITHIN_REL_TIME_FENCE
,      AMOUNT
,      SO_LINE_SPLIT
,      FORECAST_SET_ID
,      SCHEDULE_DESIGNATOR_ID
,      DELIVERY_PRICE
,      SALES_ORDER_LINE_ID
,      SHIP_SET_ID
,      ARRIVAL_SET_ID
,      ITEM_TYPE_ID
,      ITEM_TYPE_VALUE
,      PART_CONDITION
,      FIRM_START_DATE
,      BILL_SEQUENCE_ID
,      ROUTING_SEQUENCE_ID
,      PREV_SUBST_ITEM_ID
,      PREV_SUBST_ORG_ID
,      PREV_SUBST_ITEM
,      PREV_SUBST_ORG
,      OTM_ARRIVAL_DATE
,      MIN_REM_SHELF_LIFE_DAYS
,      COMMENTS
,      SUGGESTED_PICK_DATE
,      PICK_PACK_LT
FROM APPS.MSC_ORDERS_V;

Dependencies

[top of page]

APPS.MSC_ORDERS_V references the following:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymMSC_DEMANDS
PL/SQL PackageMSC_DRP_UTIL - show dependent code
PL/SQL PackageMSC_GET_NAME - show dependent code
SynonymMSC_ITEM_CATEGORIES
SynonymMSC_PLANS
SynonymMSC_PROCESS_EFFECTIVITY
PL/SQL PackageMSC_REL_PLAN_PUB - show dependent code
SynonymMSC_SUPPLIES
SynonymMSC_SYSTEM_ITEMS
PL/SQL PackageMSC_UTIL - show dependent code
APPS.MSC_ORDERS_V is referenced by following:

SchemaAPPS
Package BodyMSC_DS_SCHEDULE - show dependent code
Package BodyMSC_PQ_UTILS - show dependent code