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

VIEW: MSC.MSC_BOD_SO_SR_LEVELS#

Object Details
Object Name: MSC_BOD_SO_SR_LEVELS#
Object Type: VIEW
Owner: MSC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER

ORGANIZATION_ID NUMBER

SR_INSTANCE_ID NUMBER

PLAN_ID NUMBER

ASSIGNMENT_TYPE NUMBER

ASSIGNMENT_SET_ID NUMBER

SOURCING_RULE_TYPE NUMBER

SOURCE_ORGANIZATION_ID NUMBER

SOURCE_ORG_INSTANCE_ID NUMBER

ALLOCATION_PERCENT NUMBER

RANK NUMBER

SHIP_METHOD VARCHAR2 (30)
EFFECTIVE_DATE DATE

DISABLE_DATE DATE

SOURCING_LEVEL NUMBER

ASSIGNMENT_ID NUMBER

SOURCING_RULE_ID NUMBER

SOURCING_RULE_NAME VARCHAR2 (80)
SOURCE_TYPE NUMBER

SR_DESCRIPTION VARCHAR2 (80)
COMPILE_DESIGNATOR VARCHAR2 (10)
OWNING_ORG_ID NUMBER

MRP_PLANNING_CODE NUMBER

BOM_ITEM_TYPE NUMBER

PLANNING_MAKE_BUY_CODE NUMBER

PRIMARY_UOM_CODE VARCHAR2 (3)
CUSTOMER_ID NUMBER

CUSTOMER_SITE_ID NUMBER

REGION_ID NUMBER

REGION_TYPE NUMBER

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      PLAN_ID
,      ASSIGNMENT_TYPE
,      ASSIGNMENT_SET_ID
,      SOURCING_RULE_TYPE
,      SOURCE_ORGANIZATION_ID
,      SOURCE_ORG_INSTANCE_ID
,      ALLOCATION_PERCENT
,      RANK
,      SHIP_METHOD
,      EFFECTIVE_DATE
,      DISABLE_DATE
,      SOURCING_LEVEL
,      ASSIGNMENT_ID
,      SOURCING_RULE_ID
,      SOURCING_RULE_NAME
,      SOURCE_TYPE
,      SR_DESCRIPTION
,      COMPILE_DESIGNATOR
,      OWNING_ORG_ID
,      MRP_PLANNING_CODE
,      BOM_ITEM_TYPE
,      PLANNING_MAKE_BUY_CODE
,      PRIMARY_UOM_CODE
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      REGION_ID
,      REGION_TYPE
FROM MSC.MSC_BOD_SO_SR_LEVELS#;

Dependencies

[top of page]

MSC.MSC_BOD_SO_SR_LEVELS# references the following:

SchemaMSC
TableMSC_BOD_SO_SR_LEVELS
MSC.MSC_BOD_SO_SR_LEVELS# is referenced by following:

SchemaAPPS
SynonymMSC_BOD_SO_SR_LEVELS