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

VIEW: BOM.CST_SC_SOURCING_RULES#

Object Details
Object Name: CST_SC_SOURCING_RULES#
Object Type: VIEW
Owner: BOM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROLLUP_ID NUMBER (15) Yes
ASSIGNMENT_SET_ID NUMBER (15)
INVENTORY_ITEM_ID NUMBER (15) Yes
ORGANIZATION_ID NUMBER (15) Yes
SOURCE_ORGANIZATION_ID NUMBER (15)
VENDOR_ID NUMBER (15)
SOURCE_TYPE NUMBER (15) Yes
SHIP_METHOD VARCHAR2 (30)
ALLOCATION_PERCENT NUMBER
Yes
MARKUP_CODE NUMBER

MARKUP NUMBER

SHIP_CHARGE_CODE NUMBER

SHIP_CHARGE NUMBER

ITEM_COST NUMBER

BUY_COST_FLAG VARCHAR2 (1)
CONVERSION_TYPE VARCHAR2 (30)
CONVERSION_RATE NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

VENDOR_SITE_ID NUMBER (15)
SOURCING_RULE_NAME VARCHAR2 (50)
Query Text

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


SELECT ROLLUP_ID
,      ASSIGNMENT_SET_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SOURCE_ORGANIZATION_ID
,      VENDOR_ID
,      SOURCE_TYPE
,      SHIP_METHOD
,      ALLOCATION_PERCENT
,      MARKUP_CODE
,      MARKUP
,      SHIP_CHARGE_CODE
,      SHIP_CHARGE
,      ITEM_COST
,      BUY_COST_FLAG
,      CONVERSION_TYPE
,      CONVERSION_RATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      VENDOR_SITE_ID
,      SOURCING_RULE_NAME
FROM BOM.CST_SC_SOURCING_RULES#;

Dependencies

[top of page]

BOM.CST_SC_SOURCING_RULES# references the following:

SchemaBOM
TableCST_SC_SOURCING_RULES
BOM.CST_SC_SOURCING_RULES# is referenced by following:

SchemaAPPS
SynonymCST_SC_SOURCING_RULES