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

VIEW: MSC.MSC_ITEM_FCST_BOD_SR_LEVELS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER

SR_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

VENDOR_ID NUMBER

VENDOR_SITE_ID NUMBER

ALLOCATION_PERCENT NUMBER

RANK NUMBER

SHIP_METHOD VARCHAR2 (30)
EFFECTIVE_DATE DATE

DISABLE_DATE DATE

CATEGORY_ID NUMBER

SOURCING_LEVEL NUMBER

ASSIGNMENT_ID NUMBER

SOURCING_RULE_ID NUMBER

SOURCING_RULE_NAME VARCHAR2 (80)
SOURCE_TYPE NUMBER

SOURCE_ORG_CODE VARCHAR2 (6)
SR_DESCRIPTION VARCHAR2 (80)
OWNING_ORG_ID NUMBER

CUSTOMER_ID NUMBER

CUSTOMER_SITE_ID NUMBER

ZONE_ID NUMBER

Query Text

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


SELECT INVENTORY_ITEM_ID
,      SR_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
,      VENDOR_ID
,      VENDOR_SITE_ID
,      ALLOCATION_PERCENT
,      RANK
,      SHIP_METHOD
,      EFFECTIVE_DATE
,      DISABLE_DATE
,      CATEGORY_ID
,      SOURCING_LEVEL
,      ASSIGNMENT_ID
,      SOURCING_RULE_ID
,      SOURCING_RULE_NAME
,      SOURCE_TYPE
,      SOURCE_ORG_CODE
,      SR_DESCRIPTION
,      OWNING_ORG_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      ZONE_ID
FROM MSC.MSC_ITEM_FCST_BOD_SR_LEVELS#;

Dependencies

[top of page]

MSC.MSC_ITEM_FCST_BOD_SR_LEVELS# references the following:

SchemaMSC
TableMSC_ITEM_FCST_BOD_SR_LEVELS
MSC.MSC_ITEM_FCST_BOD_SR_LEVELS# is referenced by following:

SchemaAPPS
SynonymMSC_ITEM_FCST_BOD_SR_LEVELS