Skip to content

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

TABLE: JA.JAI_BOM_RAW_MATERIALS

Object Details
Object Name: JAI_BOM_RAW_MATERIALS
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JAI_BOM_RAW_MATERIALS
Subobject Name:
Status: VALID


This table contains raw materials and cost information for finished goods.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
BOM_DETAIL_ID NUMBER
Yes Bom Detail Identifier which is sequence driven
BOM_HEADER_ID NUMBER
Yes Bom Header Identifier. Refers to JAI_BOM_FINISHED_GOODS.
INVENTORY_ITEM_ID NUMBER
Yes Indicates Inventory Item Identifier
ORGANIZATION_ID NUMBER
Yes Indicates Organization Identifier
ITEM_COST NUMBER

indicates Item Cost
ITEM_QUANTITY NUMBER

Indicates Item Quantity
SELECTED_FLAG VARCHAR2 (1)
Flag specfying whether item needs to be present in ER5 report. Possible values are Y and N
CREATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
Query Text

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


SELECT BOM_DETAIL_ID
,      BOM_HEADER_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      ITEM_COST
,      ITEM_QUANTITY
,      SELECTED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM JA.JAI_BOM_RAW_MATERIALS;

Dependencies

[top of page]

JA.JAI_BOM_RAW_MATERIALS does not reference any database object

JA.JAI_BOM_RAW_MATERIALS is referenced by following:

SchemaJA
ViewJAI_BOM_RAW_MATERIALS#