Skip to content

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

TABLE: BOM.BOM_RULES_B

Object Details
Object Name: BOM_RULES_B
Object Type: TABLE
Owner: BOM
FND Design Data: TableBOM.BOM_RULES_B
Subobject Name:
Status: VALID


This table stores the header information of a Rule.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BOM_RULES_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRULE_ID
BOM_RULES_B_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBILL_SEQUENCE_ID
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER
Yes Rule ID, which uniquely identifies the Rule.
RULE_NAME VARCHAR2 (240) Yes Name of the rule.
BILL_SEQUENCE_ID NUMBER
Yes Structure's primary key.
EFFECTIVE_DATE DATE

Effective Date
DISABLE_DATE DATE

Disable Date
LAST_UPDATE_DATE DATE
Yes Standard WHO coloumn
LAST_UPDATED_BY NUMBER
Yes Standard WHO coloumn
CREATION_DATE DATE
Yes Standard WHO coloumn
CREATED_BY NUMBER
Yes Standard WHO coloumn
LAST_UPDATE_LOGIN NUMBER

Standard WHO coloumn
REQUEST_ID NUMBER

Standard WHO coloumn
PROGRAM_APPLICATION_ID NUMBER

Standard WHO coloumn
PROGRAM_ID NUMBER

Standard WHO coloumn
PROGRAM_UPDATE_DATE DATE

Standard WHO coloumn
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard DFF Column
ATTRIBUTE1 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE2 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE3 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE4 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE5 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE6 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE7 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE8 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE9 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE10 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE11 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE12 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE13 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE14 VARCHAR2 (150)
Standard DFF Column
ATTRIBUTE15 VARCHAR2 (150)
Standard DFF Column
CHANGE_ID NUMBER

Change ID, which uniquely identifies the ECO
IMPLEMENTATION_DATE DATE

Implementation Date
Query Text

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


SELECT RULE_ID
,      RULE_NAME
,      BILL_SEQUENCE_ID
,      EFFECTIVE_DATE
,      DISABLE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CHANGE_ID
,      IMPLEMENTATION_DATE
FROM BOM.BOM_RULES_B;

Dependencies

[top of page]

BOM.BOM_RULES_B does not reference any database object

BOM.BOM_RULES_B is referenced by following:

SchemaBOM
ViewBOM_RULES_B#