[Home] [Help] [Dependency Information]

VIEW: APPS.BOM_INVENTORY_COMPONENTS

Object Details

Object Name:	BOM_INVENTORY_COMPONENTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.BOM_INVENTORY_COMPONENTS
Subobject Name:
Status:	VALID

View Type

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

BOM_INVENTORY_COMPONENTS stores information of BOM_COMPONENTS_B which further stores information about bills of material components and stores single-level components.This lists the first level components of an assembly item

[View Source]

Columns

Query Text

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

SELECT OPERATION_SEQ_NUM
,      COMPONENT_ITEM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ITEM_NUM
,      BASIS_TYPE
,      COMPONENT_QUANTITY
,      COMPONENT_YIELD_FACTOR
,      COMPONENT_REMARKS
,      EFFECTIVITY_DATE
,      CHANGE_NOTICE
,      IMPLEMENTATION_DATE
,      DISABLE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PLANNING_FACTOR
,      QUANTITY_RELATED
,      SO_BASIS
,      OPTIONAL
,      MUTUALLY_EXCLUSIVE_OPTIONS
,      INCLUDE_IN_COST_ROLLUP
,      CHECK_ATP
,      SHIPPING_ALLOWED
,      REQUIRED_TO_SHIP
,      REQUIRED_FOR_REVENUE
,      INCLUDE_ON_SHIP_DOCS
,      INCLUDE_ON_BILL_DOCS
,      LOW_QUANTITY
,      HIGH_QUANTITY
,      ACD_TYPE
,      OLD_COMPONENT_SEQUENCE_ID
,      COMPONENT_SEQUENCE_ID
,      BILL_SEQUENCE_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      WIP_SUPPLY_TYPE
,      PICK_COMPONENTS
,      SUPPLY_SUBINVENTORY
,      SUPPLY_LOCATOR_ID
,      OPERATION_LEAD_TIME_PERCENT
,      REVISED_ITEM_SEQUENCE_ID
,      COST_FACTOR
,      BOM_ITEM_TYPE
,      FROM_END_ITEM_UNIT_NUMBER
,      TO_END_ITEM_UNIT_NUMBER
,      COMPONENT_ITEM_REVISION_ID
,      ORIGINAL_SYSTEM_REFERENCE
,      ECO_FOR_PRODUCTION
,      DELETE_GROUP_NAME
,      DG_DESCRIPTION
,      ENFORCE_INT_REQUIREMENTS
,      OPTIONAL_ON_MODEL
,      PARENT_BILL_SEQ_ID
,      MODEL_COMP_SEQ_ID
,      PLAN_LEVEL
,      AUTO_REQUEST_MATERIAL
,      SUGGESTED_VENDOR_NAME
,      VENDOR_ID
,      UNIT_PRICE
,      OBJ_NAME
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      FROM_END_ITEM_REV_ID
,      TO_END_ITEM_REV_ID
,      OVERLAPPING_CHANGES
,      FROM_OBJECT_REVISION_ID
,      FROM_MINOR_REVISION_ID
,      TO_OBJECT_REVISION_ID
,      TO_MINOR_REVISION_ID
,      FROM_END_ITEM_MINOR_REV_ID
,      TO_END_ITEM_MINOR_REV_ID
,      COMPONENT_MINOR_REVISION_ID
,      FROM_BILL_REVISION_ID
,      TO_BILL_REVISION_ID
,      FROM_STRUCTURE_REVISION_CODE
,      TO_STRUCTURE_REVISION_CODE
,      FROM_END_ITEM_STRC_REV_ID
,      TO_END_ITEM_STRC_REV_ID
,      COMMON_COMPONENT_SEQUENCE_ID
FROM APPS.BOM_INVENTORY_COMPONENTS;

Dependencies

[top of page]

APPS

BOM_COMPONENTS_B

APPS

AMS_BOM_PVT - show dependent code

BOMBV_BOM_COMPONENTS

BOMBV_BOM_REFERE_DESIGNATORS

BOMBV_ECO_REVISED_COMPONENTS

BOMBV_SUBSTITUTE_BOM_COMPS

BOMFV_BOM_COMPONENTS

BOMFV_ECO_REVISED_COMPONENTS

BOMFV_SUBSTITUTE_BOM_COMPS

BOMPASGB - show dependent code

BOMPBCMP - show dependent code

BOMPBEXP - show dependent code

BOMPBXIN - show dependent code

BOMPCCLT - 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

BOMPPRCB - show dependent code

BOMPVALB - show dependent code

BOMPXINQ - show dependent code

BOM_BILL_API - show dependent code

BOM_BILL_OF_MATLS_PKG - show dependent code

BOM_BOM_COMPONENT_UTIL - show dependent code

BOM_BOM_COPYORG_IMP - 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_COMPONENT_ALL_OPERATIONS_V

BOM_COMPONENT_API - show dependent code

BOM_COPY_BILL - show dependent code

BOM_COPY_ROUTING - show dependent code

BOM_DEFAULT_BOM_COMPONENT - show dependent code

BOM_DEFAULT_SUB_COMPONENT - show dependent code

BOM_DELETE_ENTITY - show dependent code

BOM_DELETE_GROUPS_API - show dependent code

BOM_DELETE_ITEMS - show dependent code

BOM_IMPORT_PUB - 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_ODI_WS_COMPONENTS_V

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_DESIGNATORS_V

BOM_REFERENCE_DESIGNATOR_API - show dependent code

BOM_REF_DESIGNATORS_VIEW

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_COMPONENTS_VIEW

BOM_SUB_COMPS_PKG - show dependent code

BOM_SUB_COMPS_QF_V

BOM_TA_EXCLUSIONS_PVT - show dependent code

BOM_UTIL - show dependent code

BOM_UTIL - show dependent code

BOM_VALIDATE_BOM_COMPONENT - show dependent code

BOM_VALIDATE_BOM_HEADER - show dependent code

BOM_VALIDATE_COMP_OPERATION - show dependent code

BOM_VALIDATE_OP_SEQ - 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

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_MATCH_CONFIG - show dependent code

CTO_SUBASSEMBLY_SUP_PK - 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_BOM_CONFIG_EXPLOSIONS_PKG - show dependent code

CZ_BOM_SYNCH - show dependent code

EAM_EXPLODE_ACTIVITY_PVT - show dependent code

EAM_WORKORDERREP_PVT - show dependent code

EAM_WORKORDER_UTIL_PKG - show dependent code

ENGECOBO - show dependent code

ENGPKIMP - show dependent code

ENG_BOM_PKG - show dependent code

ENG_CANCEL_ECO - show dependent code

ENG_CHANGE_IMPORT_UTIL - show dependent code

ENG_COMPONENT_VIEW

ENG_DEFAULT_REVISED_ITEM - show dependent code

ENG_DEFAULT_REV_COMPONENT - show dependent code

ENG_DEFAULT_SUB_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_PKG - show dependent code

ENG_REVISED_ITEM_UTIL - show dependent code

ENG_REV_COMPONENT_UTIL - show dependent code

ENG_VALIDATE - show dependent code

ENG_VALIDATE_ECO - 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_REF_DESIG_V

ENG_WEB_REVISED_COMPS_V

ENG_WEB_SUB_COMPS_V

FLM_AUTO_REPLENISHMENT - 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_SUPPLY_DEMAND - show dependent code

INVBV_PRODUCT_FAMILY_MEMBERS

INVFV_PRODUCT_FAMILY_MEMBERS

INVIDIT3 - show dependent code

INV_COPY_ORGANIZATION_REPORT - show dependent code

INV_EBI_CHANGE_ORDER_HELPER - show dependent code

INV_KANBAN_PKG - show dependent code

JAI_PO_OSP_PKG - show dependent code

JTF_RS_COMPONENTS_V

MODAL_DELETE - show dependent code

MRPBV_PLAN_BILL_OF_MATERIALS

MRPBV_PLAN_BOM_COMPONENTS

MRPFV_PLAN_BILL_OF_MATERIALS

MRPFV_PLAN_BOM_COMPONENTS

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_PRD_PF_V

MSD_SR_UTIL - show dependent code

OE_CONFIG - show dependent code

OE_INVOICE_PUB - show dependent code

OE_LINE_DETAILS_PKG - show dependent code

OE_LINE_UTIL - show dependent code

OKS_EXTWAR_UTIL_PVT - show dependent code

OKX_INV_COMPONENTS_V

PRODUCT_FAMILY_PKG - show dependent code

QPR_SR_PF_HIER_V

SO_CONFIG_COMPONENTS_V

SO_INCLUDED_ITEMS_OEXORRSO_V

WIPBV_FLOW_SCHED_COMPS

WIPFV_FLOW_SCHED_COMPS

WIP_BFLPROC_PRIV - show dependent code

WIP_BOMROUTINGUTIL_PVT - show dependent code

WIP_EXPLOSIONS_V

WIP_MRP_RELIEF - show dependent code

WSH_REPORT_QUANTITIES - show dependent code

WSMPCOGI - show dependent code

WSMPJUPD - show dependent code

WSMPLBJI - show dependent code

WSMPLOAD - show dependent code

WSMPPCPD - show dependent code

WSMPUTIL - show dependent code

WSMPVCPD - show dependent code

WSMPWROT - show dependent code

WSM_COMPONENTS_V

WSM_JOBCOPIES_PVT - show dependent code

WSM_LBJ_INTERFACE_PVT - show dependent code

XDP_ORDER - show dependent code