Skip to content

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

TABLE: JA.JAI_BOM_FINISHED_GOODS

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


This table contains every information regarding finish goods and its mapping to principal inputs.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
BOM_HEADER_ID NUMBER
Yes BOM Header Identifier which is sequence driven.
ORGANIZATION_ID NUMBER
Yes Indicates Organization Identifier
LOCATION_ID NUMBER
Yes Indicates Location Identifier
FIN_YEAR NUMBER (4) Yes Indicates Fin Year identifier
INVENTORY_ITEM_ID NUMBER (15) Yes Indicates Inventory Item Identifier
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Alternate BOM designator identifier from BOM_BILL_OF_MATERIALS of particular inventory item id
COST_TYPE_ID NUMBER

Indicates Cost Type Identifier
TOTAL_COST NUMBER

Stores the Raw Mateiral cost total
PROCESSED_FLAG VARCHAR2 (1)
Flag to check whether record is processed. Possible values are Y or 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_HEADER_ID
,      ORGANIZATION_ID
,      LOCATION_ID
,      FIN_YEAR
,      INVENTORY_ITEM_ID
,      ALTERNATE_BOM_DESIGNATOR
,      COST_TYPE_ID
,      TOTAL_COST
,      PROCESSED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM JA.JAI_BOM_FINISHED_GOODS;

Dependencies

[top of page]

JA.JAI_BOM_FINISHED_GOODS does not reference any database object

JA.JAI_BOM_FINISHED_GOODS is referenced by following:

SchemaJA
ViewJAI_BOM_FINISHED_GOODS#