[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:	BOM.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

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_STRUCTURES_B

FND_GLOBAL - show dependent code

APPS

AMS_BOM_PVT - show dependent code

BOMBV_BILL_OF_MATERIALS

BOMBV_BOM_COMPONENTS

BOMBV_BOM_REFERE_DESIGNATORS

BOMBV_ECO_REVISED_COMPONENTS

BOMBV_ENGINEERING_BOMS

BOMBV_MANUFACTURING_BOMS

BOMBV_SUBSTITUTE_BOM_COMPS

BOMDELEX - show dependent code

BOMFV_BILL_OF_MATERIALS

BOMFV_BOM_COMPONENTS

BOMFV_ECO_REVISED_COMPONENTS

BOMFV_ENGINEERING_BOMS

BOMFV_MANUFACTURING_BOMS

BOMFV_SUBSTITUTE_BOM_COMPS

BOMPASGB - show dependent code

BOMPBEXP - show dependent code

BOMPBXIN - show dependent code

BOMPCCLT - show dependent code

BOMPCMBM - show dependent code

BOMPECOD - show dependent code

BOMPEXPL - show dependent code

BOMPIINQ - show dependent code

BOMPIMPL - show dependent code

BOMPKMUD - show dependent code

BOMPLDCB - show dependent code

BOMPNORD - show dependent code

BOMPPRCB - show dependent code

BOMPVALB - show dependent code

BOMPXINQ - show dependent code

BOM_ALTERNATE_DESIGNATORS_PKG - show dependent code

BOM_BILL_ALTERNATES_V

BOM_BILL_API - show dependent code

BOM_BILL_OF_MATERIALS_ERV

BOM_BILL_OF_MATERIALS_V

BOM_BILL_OF_MATLS_PKG - show dependent code

BOM_BILL_OF_MTLS_QF_V

BOM_BOM_COMPONENT_UTIL - show dependent code

BOM_BOM_COPYORG_IMP - show dependent code

BOM_BOM_HEADER_UTIL - show dependent code

BOM_BOM_ISETUP_IMP - show dependent code

BOM_BULKLOAD_PVT_PKG - show dependent code

BOM_CALC_OP_TIMES_PK - show dependent code

BOM_COMPARISON_TEMP_PKG - show dependent code

BOM_COMPONENT_API - show dependent code

BOM_COPY_ROUTING - show dependent code

BOM_DEFAULT_BOM_COMPONENT - show dependent code

BOM_DELETE_ENTITY - show dependent code

BOM_DELETE_GROUPS_API - show dependent code

BOM_DELETE_ITEMS - show dependent code

BOM_EXPLODER_PUB - show dependent code

BOM_EXPL_INQUIRY_VIEW

BOM_GLOBALS - show dependent code

BOM_INVENTORY_COMPONENTS_ERV

BOM_INVENTORY_COMPONENTS_V

BOM_INV_COMPS1_PKG - show dependent code

BOM_INV_COMPS2_PKG - show dependent code

BOM_OE_EXPLODER_PKG - show dependent code

BOM_OPEN_INTERFACE_UTL - show dependent code

BOM_OPERATION_PVT - show dependent code

BOM_OP_SEQ_UTIL - show dependent code

BOM_PRODUCTFAMILY_MEM_V

BOM_REFERENCE_DESIGNATOR_API - show dependent code

BOM_REF_DESIG_PKG - show dependent code

BOM_ROLLUP_PUB - show dependent code

BOM_SUBSTITUTE_COMPONENTS_ERV

BOM_SUBSTITUTE_COMPONENTS_V

BOM_SUBSTITUTE_COMPONENT_API - show dependent code

BOM_SUB_COMPS_PKG - show dependent code

BOM_SUB_COMPS_QF_V

BOM_UTIL - show dependent code

BOM_UTIL - show dependent code

BOM_VALIDATE - show dependent code

BOM_VALIDATE_BOM_COMPONENT - show dependent code

BOM_VALIDATE_BOM_HEADER - show dependent code

BOM_VALIDATE_BOM_REVISION - show dependent code

BOM_VALIDATE_COMP_OPERATION - show dependent code

BOM_VALIDATE_REF_DESIGNATOR - show dependent code

BOM_VALIDATE_RTG_HEADER - show dependent code

BOM_VALIDATE_SUB_COMPONENT - show dependent code

BOM_VAL_TO_ID - show dependent code

CSD_BOM_INQUIRY_EXPL_V

CSD_HV_WIP_JOB_PVT - show dependent code

CSD_RECALLS_PVT - show dependent code

CSD_SC_BOM_AND_ROUTE_V

CSD_SC_WORK_ENTITIES_PVT - show dependent code

CSD_WIP_JOB_PVT - show dependent code

CSI_INTERFACE_PKG - show dependent code

CSI_ITEM_INSTANCE_PVT - show dependent code

CSI_ITEM_INSTANCE_VLD_PVT - show dependent code

CSI_ORDER_FULFILL_PUB - show dependent code

CSI_UTL_PKG - show dependent code

CSTPSCCR - show dependent code

CSTPSCEX - show dependent code

CST_EAMJOB_ACTESTIMATE - show dependent code

CS_SERVICEREQUEST_UTIL - show dependent code

CS_SR_INV_COMPONENTS_V

CS_SR_INV_SUBCOMPONENTS_V

CS_STD - show dependent code

CS_WAR - show dependent code

CTO_ATP_INTERFACE_PK - show dependent code

CTO_BOM_RTG_PK - show dependent code

CTO_CHANGE_ORDER_PK - show dependent code

CTO_CONFIG_BOM_PK - show dependent code

CTO_CONFIG_BOM_PK - show dependent code

CTO_CONFIG_ITEM_PK - show dependent code

CTO_CONFIG_ROUTING_PK - show dependent code

CTO_DEACTIVATE_CONFIG_PK - show dependent code

CTO_MANUAL_LINK_CONFIG - show dependent code

CTO_MSUTIL_PUB - show dependent code

CTO_SUBASSEMBLY_SUP_PK - show dependent code

CTO_TRANSFER_PRICE_PK - show dependent code

CTO_UPDATE_BOM_RTG_PK - show dependent code

CTO_UPDATE_BOM_RTG_PK - show dependent code

CTO_UPDATE_CONFIGS_PK - show dependent code

CTO_UTILITY_PK - show dependent code

CZ_ATP_CALLBACK_UTIL - show dependent code

CZ_BOM_CONFIG_EXPLOSIONS_PKG - show dependent code

CZ_BOM_SYNCH - show dependent code

CZ_CF_API - show dependent code

CZ_EXV_BILL_OF_MATERIALS

CZ_EXV_INTL_TEXT

CZ_EXV_ITEMS

CZ_EXV_ITEM_MASTER

CZ_OM_ATP_CALLBACK - show dependent code

EAM_ACTIVITYUTILITIES_PVT - show dependent code

EAM_EXPLODE_ACTIVITY_PVT - show dependent code

EAM_WORKORDERREP_PVT - show dependent code

EAM_WORKORDER_UTIL_PKG - show dependent code

EGO_BOM_BULKLOAD_PVT_PKG - show dependent code

ENGECOBO - show dependent code

ENGPKIMP - show dependent code

ENG_BOM_PKG - show dependent code

ENG_BOM_RTG_TRANSFER_PKG - show dependent code

ENG_CANCEL_ECO - show dependent code

ENG_CHANGE_LINE_UTIL - show dependent code

ENG_DEFAULT_REVISED_ITEM - show dependent code

ENG_DEFAULT_REV_COMPONENT - show dependent code

ENG_ECO_COST - show dependent code

ENG_ECO_UTIL - show dependent code

ENG_ITEM_PKG - show dependent code

ENG_REVISED_COMPONENTS_ERV

ENG_REVISED_COMPONENTS_V

ENG_REVISED_ITEMS_API_V

ENG_REVISED_ITEMS_ERV

ENG_REVISED_ITEMS_PKG - show dependent code

ENG_REVISED_ITEMS_SCHEDULE_V

ENG_REVISED_ITEMS_V

ENG_REVISED_ITEM_UTIL - show dependent code

ENG_REV_COMPONENT_UTIL - show dependent code

ENG_VALIDATE - show dependent code

ENG_VALIDATE_REF_DESIGNATOR - show dependent code

ENG_VALIDATE_REVISED_ITEM - show dependent code

ENG_VALIDATE_REV_COMPONENT - show dependent code

ENG_VALIDATE_SUB_COMPONENT - show dependent code

ENG_VAL_TO_ID - show dependent code

ENG_WEB_SCHEDULE_V

FLM_AUTO_REPLENISHMENT - show dependent code

FLM_COPY_ROUTING - show dependent code

FLM_CREATE_PRODUCT_SYNCH - show dependent code

FLM_EXECUTION_UTIL - show dependent code

FLM_KANBAN - show dependent code

FLM_KANBAN_PURGE - show dependent code

FLM_ROUTING - show dependent code

FLM_SEQ_READER_WRITER - show dependent code

FLM_SUPPLY_DEMAND - show dependent code

INVBV_PRODUCT_FAMILY_MEMBERS

INVFV_MATERIAL_TRANSACTIONS

INVFV_PRODUCT_FAMILY_MEMBERS

INVIDIT3 - show dependent code

INV_COPY_ORGANIZATION_REPORT - show dependent code

INV_EBI_CHANGE_ORDER_HELPER - show dependent code

INV_LABEL_PVT10 - show dependent code

INV_TXN_MANAGER_GRP - show dependent code

JAI_PO_OSP_PKG - show dependent code

JMF_SHIKYU_WIP_PVT - show dependent code

JTF_RS_COMPONENTS_V

MRP_ATP_COLLECTION - show dependent code

MRP_ATP_V

MRP_HORIZONTAL_PLAN_SC - show dependent code

MRP_KANBAN_PLAN_PK - show dependent code

MRP_KANBAN_SNAPSHOT_PK - show dependent code

MRP_MANAGER_PK - show dependent code

MRP_SCATP_PUB - show dependent code

MRP_SC_BILL_BOM_V

MRP_SC_BILL_SF_V

MRP_SC_BILL_WU_V

MSD_DEM_SR_UTIL - show dependent code

MSD_SR_PF_ALL_V

MSD_SR_PRD_PF_V

MSD_SR_UTIL - show dependent code

OE_BULK_LINE_UTIL - show dependent code

OE_BULK_PROCESS_LINE - show dependent code

OE_CONFIG_PVT - show dependent code

OE_CONFIG_UTIL - show dependent code

OE_GRP_SCH_UTIL - show dependent code

OE_INBOUND_INT - show dependent code

OE_ORDER_SCH_UTIL - show dependent code

OE_SCHEDULE_UTIL - show dependent code

OKS_EXTWAR_UTIL_PVT - show dependent code

OKX_BILL_OF_MATERIALS_V

PRODUCT_FAMILY_PKG - show dependent code

QPR_SR_PF_HIER_V

WIPBV_FLOW_SCHED_COMPS

WIPFV_FLOW_SCHED_COMPS

WIPFV_REPETITIVE_SCHEDULES

WIPFV_WIP_JOBS

WIP_BFLPROC_PRIV - show dependent code

WIP_COMMON - show dependent code

WIP_JSI_PROCESSOR - show dependent code

WIP_JSI_VALIDATOR - show dependent code

WIP_MRP_RELIEF - show dependent code

WIP_PICKING_PVT - show dependent code

WIP_VALIDATE - show dependent code

WPS_SUPPLY_DEMAND - show dependent code

WSMPCOGI - show dependent code

WSMPLBJI - show dependent code

WSMPPCPD - show dependent code

WSMPUTIL - show dependent code

WSMPVCPD - show dependent code

WSMPWROT - show dependent code

WSM_COMPONENTS_V

WSM_JOBCOPIES_PUB - show dependent code

WSM_JOBCOPIES_PVT - show dependent code

WSM_LBJ_INTERFACE_PVT - show dependent code

WSM_SM_STARTING_JOBS_V

WSM_WLT_VALIDATE_PVT - show dependent code

XDP_ORDER - show dependent code