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


VIEW: APPS.BOM_BILL_OF_MATERIALS

Object Details
Object Name: BOM_BILL_OF_MATERIALS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.BOM_BILL_OF_MATERIALS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


BOM_BILL_OF_MATERIALS stores information of BOM_STRUCTURES_B which further stores information about manufacturing and engineering bills of material. Each row in this table represents a unique manufacturing or engineering bill and is identified by
BILL_SEQUENCE_ID.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ASSEMBLY_ITEM_ID NUMBER

Inventory item identifier of manufactured assembly
ORGANIZATION_ID NUMBER
Yes Organization identifier
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Alternate designator code
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
COMMON_ASSEMBLY_ITEM_ID NUMBER

Assembly item identifier of common bill
SPECIFIC_ASSEMBLY_COMMENT VARCHAR2 (240)
Specific bill of material comment
PENDING_FROM_ECN VARCHAR2 (10)
Change notice that created this bill of material
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ASSEMBLY_TYPE NUMBER
Yes Assembly type: 1=Manufacturing bill 2=Engineering bill
COMMON_BILL_SEQUENCE_ID NUMBER
Yes Identifier of common bill
BILL_SEQUENCE_ID NUMBER
Yes Bill of material unique identifier
REQUEST_ID NUMBER

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
COMMON_ORGANIZATION_ID NUMBER

Organization identifier of common bill
NEXT_EXPLODE_DATE DATE

Next date when pre-explosion will be refreshed
PROJECT_ID NUMBER

Project Identifier for Project Manufacturing
TASK_ID NUMBER

Task identifier for Project Manufacturing
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
Original system that data for the current record has come from.
STRUCTURE_TYPE_ID NUMBER

Structure Type Id
IMPLEMENTATION_DATE DATE

Implementation date
OBJ_NAME VARCHAR2 (30)
Object Name
PK1_VALUE VARCHAR2 (240)
Pk1 Value
PK2_VALUE VARCHAR2 (240)
Pk2 Value
PK3_VALUE VARCHAR2 (240)
Pk3 Value
PK4_VALUE VARCHAR2 (240)
Pk4 Value
PK5_VALUE VARCHAR2 (240)
Pk5 Value
EFFECTIVITY_CONTROL NUMBER

Effectivity control
IS_PREFERRED VARCHAR2 (1)
Is preferred
SOURCE_BILL_SEQUENCE_ID NUMBER

Source Bill Sequence Id
Query Text

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


SELECT ASSEMBLY_ITEM_ID
,      ORGANIZATION_ID
,      ALTERNATE_BOM_DESIGNATOR
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      COMMON_ASSEMBLY_ITEM_ID
,      SPECIFIC_ASSEMBLY_COMMENT
,      PENDING_FROM_ECN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ASSEMBLY_TYPE
,      COMMON_BILL_SEQUENCE_ID
,      BILL_SEQUENCE_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      COMMON_ORGANIZATION_ID
,      NEXT_EXPLODE_DATE
,      PROJECT_ID
,      TASK_ID
,      ORIGINAL_SYSTEM_REFERENCE
,      STRUCTURE_TYPE_ID
,      IMPLEMENTATION_DATE
,      OBJ_NAME
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      EFFECTIVITY_CONTROL
,      IS_PREFERRED
,      SOURCE_BILL_SEQUENCE_ID
FROM APPS.BOM_BILL_OF_MATERIALS;

Dependencies

[top of page]

APPS.BOM_BILL_OF_MATERIALS references the following:

SchemaAPPS
SynonymBOM_STRUCTURES_B
PL/SQL PackageFND_GLOBAL - show dependent code
APPS.BOM_BILL_OF_MATERIALS is referenced by following:

SchemaAPPS
Package BodyAMS_BOM_PVT - show dependent code
ViewBOMBV_BILL_OF_MATERIALS
ViewBOMBV_BOM_COMPONENTS
ViewBOMBV_BOM_REFERE_DESIGNATORS
ViewBOMBV_ECO_REVISED_COMPONENTS
ViewBOMBV_ENGINEERING_BOMS
ViewBOMBV_MANUFACTURING_BOMS
ViewBOMBV_SUBSTITUTE_BOM_COMPS
Package BodyBOMDELEX - show dependent code
ViewBOMFV_BILL_OF_MATERIALS
ViewBOMFV_BOM_COMPONENTS
ViewBOMFV_ECO_REVISED_COMPONENTS
ViewBOMFV_ENGINEERING_BOMS
ViewBOMFV_MANUFACTURING_BOMS
ViewBOMFV_SUBSTITUTE_BOM_COMPS
Package BodyBOMPASGB - show dependent code
Package BodyBOMPBEXP - show dependent code
Package BodyBOMPBXIN - show dependent code
Package BodyBOMPCCLT - show dependent code
Package BodyBOMPECOD - show dependent code
Package BodyBOMPEXPL - show dependent code
Package BodyBOMPIINQ - show dependent code
Package BodyBOMPIMPL - show dependent code
Package BodyBOMPKMUD - show dependent code
Package BodyBOMPLDCB - show dependent code
Package BodyBOMPNORD - show dependent code
Package BodyBOMPPRCB - show dependent code
Package BodyBOMPVALB - show dependent code
Package BodyBOMPXINQ - show dependent code
Package BodyBOM_ALTERNATE_DESIGNATORS_PKG - show dependent code
ViewBOM_BILL_ALTERNATES_V
Package BodyBOM_BILL_API - show dependent code
ViewBOM_BILL_OF_MATERIALS_ERV
ViewBOM_BILL_OF_MATERIALS_V
Package BodyBOM_BILL_OF_MATLS_PKG - show dependent code
ViewBOM_BILL_OF_MTLS_QF_V
Package BodyBOM_BOM_COMPONENT_UTIL - show dependent code
Package BodyBOM_BOM_COPYORG_IMP - show dependent code
Package BodyBOM_BOM_HEADER_UTIL - show dependent code
Package BodyBOM_BOM_ISETUP_IMP - show dependent code
Package BodyBOM_BULKLOAD_PVT_PKG - show dependent code
Package BodyBOM_CALC_OP_TIMES_PK - show dependent code
Package BodyBOM_COMPARISON_TEMP_PKG - show dependent code
Package BodyBOM_COMPONENT_API - show dependent code
Package BodyBOM_COPY_ROUTING - show dependent code
Package BodyBOM_DEFAULT_BOM_COMPONENT - show dependent code
Package BodyBOM_DELETE_ENTITY - show dependent code
Package BodyBOM_DELETE_GROUPS_API - show dependent code
Package BodyBOM_DELETE_ITEMS - show dependent code
Package BodyBOM_EXPLODER_PUB - show dependent code
ViewBOM_EXPL_INQUIRY_VIEW
Package BodyBOM_GLOBALS - show dependent code
ViewBOM_INVENTORY_COMPONENTS_ERV
ViewBOM_INVENTORY_COMPONENTS_V
Package BodyBOM_INV_COMPS1_PKG - show dependent code
Package BodyBOM_INV_COMPS2_PKG - show dependent code
Package BodyBOM_OE_EXPLODER_PKG - show dependent code
Package BodyBOM_OPEN_INTERFACE_UTL - show dependent code
Package BodyBOM_OPERATION_PVT - show dependent code
Package BodyBOM_OP_SEQ_UTIL - show dependent code
ViewBOM_PRODUCTFAMILY_MEM_V
Package BodyBOM_REFERENCE_DESIGNATOR_API - show dependent code
Package BodyBOM_REF_DESIG_PKG - show dependent code
Package BodyBOM_ROLLUP_PUB - show dependent code
ViewBOM_SUBSTITUTE_COMPONENTS_ERV
ViewBOM_SUBSTITUTE_COMPONENTS_V
Package BodyBOM_SUBSTITUTE_COMPONENT_API - show dependent code
Package BodyBOM_SUB_COMPS_PKG - show dependent code
ViewBOM_SUB_COMPS_QF_V
PL/SQL PackageBOM_UTIL - show dependent code
Package BodyBOM_UTIL - show dependent code
Package BodyBOM_VALIDATE - show dependent code
Package BodyBOM_VALIDATE_BOM_COMPONENT - show dependent code
Package BodyBOM_VALIDATE_BOM_HEADER - show dependent code
Package BodyBOM_VALIDATE_BOM_REVISION - show dependent code
Package BodyBOM_VALIDATE_COMP_OPERATION - show dependent code
Package BodyBOM_VALIDATE_REF_DESIGNATOR - show dependent code
Package BodyBOM_VALIDATE_RTG_HEADER - show dependent code
Package BodyBOM_VALIDATE_SUB_COMPONENT - show dependent code
Package BodyBOM_VAL_TO_ID - show dependent code
ViewCSD_BOM_INQUIRY_EXPL_V
Package BodyCSD_HV_WIP_JOB_PVT - show dependent code
ViewCSD_SC_BOM_AND_ROUTE_V
Package BodyCSD_SC_WORK_ENTITIES_PVT - show dependent code
Package BodyCSI_INTERFACE_PKG - show dependent code
Package BodyCSI_ITEM_INSTANCE_PVT - show dependent code
Package BodyCSI_ITEM_INSTANCE_VLD_PVT - show dependent code
Package BodyCSI_UTL_PKG - show dependent code
Package BodyCSTPSCCR - show dependent code
Package BodyCSTPSCEX - show dependent code
Package BodyCST_EAMJOB_ACTESTIMATE - show dependent code
Package BodyCS_SERVICEREQUEST_UTIL - show dependent code
ViewCS_SR_INV_COMPONENTS_V
ViewCS_SR_INV_SUBCOMPONENTS_V
Package BodyCS_STD - show dependent code
Package BodyCS_WAR - show dependent code
Package BodyCTO_ATP_INTERFACE_PK - show dependent code
Package BodyCTO_BOM_RTG_PK - show dependent code
Package BodyCTO_CHANGE_ORDER_PK - show dependent code
Package BodyCTO_CONFIG_BOM_PK - show dependent code
PL/SQL PackageCTO_CONFIG_BOM_PK - show dependent code
Package BodyCTO_CONFIG_ITEM_PK - show dependent code
Package BodyCTO_CONFIG_ROUTING_PK - show dependent code
Package BodyCTO_DEACTIVATE_CONFIG_PK - show dependent code
Package BodyCTO_MANUAL_LINK_CONFIG - show dependent code
Package BodyCTO_MSUTIL_PUB - show dependent code
Package BodyCTO_SUBASSEMBLY_SUP_PK - show dependent code
Package BodyCTO_TRANSFER_PRICE_PK - show dependent code
Package BodyCTO_UPDATE_BOM_RTG_PK - show dependent code
PL/SQL PackageCTO_UPDATE_BOM_RTG_PK - show dependent code
Package BodyCTO_UPDATE_CONFIGS_PK - show dependent code
Package BodyCTO_UTILITY_PK - show dependent code
Package BodyCZ_ATP_CALLBACK_UTIL - show dependent code
Package BodyCZ_BOM_CONFIG_EXPLOSIONS_PKG - show dependent code
Package BodyCZ_BOM_SYNCH - show dependent code
Package BodyCZ_CF_API - show dependent code
ViewCZ_EXV_BILL_OF_MATERIALS
ViewCZ_EXV_INTL_TEXT
ViewCZ_EXV_ITEMS
ViewCZ_EXV_ITEM_MASTER
Package BodyCZ_OM_ATP_CALLBACK - show dependent code
Package BodyEAM_ACTIVITYUTILITIES_PVT - show dependent code
Package BodyEAM_EXPLODE_ACTIVITY_PVT - show dependent code
Package BodyEAM_WORKORDERREP_PVT - show dependent code
Package BodyEAM_WORKORDER_UTIL_PKG - show dependent code
Package BodyEGO_BOM_BULKLOAD_PVT_PKG - show dependent code
Package BodyENGECOBO - show dependent code
Package BodyENGPKIMP - show dependent code
Package BodyENG_BOM_PKG - show dependent code
Package BodyENG_BOM_RTG_TRANSFER_PKG - show dependent code
Package BodyENG_CANCEL_ECO - show dependent code
Package BodyENG_CHANGE_LINE_UTIL - show dependent code
Package BodyENG_DEFAULT_REVISED_ITEM - show dependent code
Package BodyENG_DEFAULT_REV_COMPONENT - show dependent code
Package BodyENG_ECO_COST - show dependent code
Package BodyENG_ECO_UTIL - show dependent code
Package BodyENG_ITEM_PKG - show dependent code
ViewENG_REVISED_COMPONENTS_ERV
ViewENG_REVISED_COMPONENTS_V
ViewENG_REVISED_ITEMS_API_V
ViewENG_REVISED_ITEMS_ERV
Package BodyENG_REVISED_ITEMS_PKG - show dependent code
ViewENG_REVISED_ITEMS_SCHEDULE_V
ViewENG_REVISED_ITEMS_V
Package BodyENG_REVISED_ITEM_UTIL - show dependent code
Package BodyENG_REV_COMPONENT_UTIL - show dependent code
Package BodyENG_VALIDATE - show dependent code
Package BodyENG_VALIDATE_REF_DESIGNATOR - show dependent code
Package BodyENG_VALIDATE_REVISED_ITEM - show dependent code
Package BodyENG_VALIDATE_REV_COMPONENT - show dependent code
Package BodyENG_VALIDATE_SUB_COMPONENT - show dependent code
Package BodyENG_VAL_TO_ID - show dependent code
ViewENG_WEB_SCHEDULE_V
Package BodyENI_DBI_CDE_PKG - show dependent code
Package BodyENI_DBI_PCB_PKG - show dependent code
Package BodyENI_DBI_PCM_PKG - show dependent code
Package BodyENI_DBI_PCO_LOAD_PKG - show dependent code
Package BodyENI_DBI_PCO_PKG - show dependent code
Package BodyENI_DBI_PME_KPI_PKG - show dependent code
Package BodyFLM_AUTO_REPLENISHMENT - show dependent code
Package BodyFLM_COPY_ROUTING - show dependent code
Package BodyFLM_CREATE_PRODUCT_SYNCH - show dependent code
Package BodyFLM_EXECUTION_UTIL - show dependent code
Package BodyFLM_KANBAN - show dependent code
Package BodyFLM_KANBAN_PURGE - show dependent code
Package BodyFLM_ROUTING - show dependent code
Package BodyFLM_SEQ_READER_WRITER - show dependent code
Package BodyFLM_SUPPLY_DEMAND - show dependent code
ViewINVBV_PRODUCT_FAMILY_MEMBERS
ViewINVFV_MATERIAL_TRANSACTIONS
ViewINVFV_PRODUCT_FAMILY_MEMBERS
Package BodyINVIDIT3 - show dependent code
Package BodyINV_COPY_ORGANIZATION_REPORT - show dependent code
Package BodyINV_EBI_CHANGE_ORDER_HELPER - show dependent code
Package BodyINV_LABEL_PVT10 - show dependent code
Package BodyINV_TXN_MANAGER_GRP - show dependent code
Package BodyJAI_PO_OSP_PKG - show dependent code
Package BodyJMF_SHIKYU_WIP_PVT - show dependent code
ViewJTF_RS_COMPONENTS_V
Package BodyMRP_ATP_COLLECTION - show dependent code
ViewMRP_ATP_V
Package BodyMRP_HORIZONTAL_PLAN_SC - show dependent code
Package BodyMRP_KANBAN_PLAN_PK - show dependent code
Package BodyMRP_KANBAN_SNAPSHOT_PK - show dependent code
Package BodyMRP_MANAGER_PK - show dependent code
Package BodyMRP_SCATP_PUB - show dependent code
ViewMRP_SC_BILL_BOM_V
ViewMRP_SC_BILL_SF_V
ViewMRP_SC_BILL_WU_V
Package BodyMSD_DEM_SR_UTIL - show dependent code
ViewMSD_SR_PF_ALL_V
ViewMSD_SR_PRD_PF_V
Package BodyMSD_SR_UTIL - show dependent code
Package BodyOE_BULK_LINE_UTIL - show dependent code
Package BodyOE_BULK_PROCESS_LINE - show dependent code
Package BodyOE_CONFIG_PVT - show dependent code
Package BodyOE_CONFIG_UTIL - show dependent code
Package BodyOE_GRP_SCH_UTIL - show dependent code
Package BodyOE_ORDER_SCH_UTIL - show dependent code
Package BodyOE_SCHEDULE_UTIL - show dependent code
Package BodyOKS_EXTWAR_UTIL_PVT - show dependent code
ViewOKX_BILL_OF_MATERIALS_V
Package BodyOPI_DBI_JOB_TXN_STG_PKG - show dependent code
Package BodyPRODUCT_FAMILY_PKG - show dependent code
ViewQPR_SR_PF_HIER_V
ViewWIPBV_FLOW_SCHED_COMPS
ViewWIPFV_FLOW_SCHED_COMPS
ViewWIPFV_REPETITIVE_SCHEDULES
ViewWIPFV_WIP_JOBS
Package BodyWIP_BFLPROC_PRIV - show dependent code
Package BodyWIP_COMMON - show dependent code
Package BodyWIP_JSI_PROCESSOR - show dependent code
Package BodyWIP_JSI_VALIDATOR - show dependent code
Package BodyWIP_MASSLOAD_PVT - show dependent code
Package BodyWIP_MRP_RELIEF - show dependent code
Package BodyWIP_PICKING_PVT - show dependent code
Package BodyWIP_VALIDATE - show dependent code
Package BodyWPS_SUPPLY_DEMAND - show dependent code
Package BodyWSMPCOGI - show dependent code
Package BodyWSMPLBJI - show dependent code
Package BodyWSMPPCPD - show dependent code
Package BodyWSMPUTIL - show dependent code
Package BodyWSMPVCPD - show dependent code
Package BodyWSMPVLDT - show dependent code
Package BodyWSMPWROT - show dependent code
ViewWSM_COMPONENTS_V
Package BodyWSM_JOBCOPIES_PUB - show dependent code
Package BodyWSM_JOBCOPIES_PVT - show dependent code
Package BodyWSM_LBJ_INTERFACE_PVT - show dependent code
ViewWSM_SM_STARTING_JOBS_V
Package BodyWSM_WLT_VALIDATE_PVT - show dependent code
Package BodyXDP_ORDER - show dependent code