eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: XNC_ORG_ITEM_BOM_V

Product:	XNC - Sales for Communications (Obsolete)
Description:	XNC_ORG_ITEM_BOM_V retrieves all bills of materials (or packages) available for an Organization and Inventory Item.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT A.ORGANIZATION_ID
, A.ASSEMBLY_ITEM_ID TOP_ITEM_ID
, C.PADDED_CONCATENATED_SEGMENTS TOP_ITEM_NAME
, A.DESCRIPTION TOP_ITEM_DESCRIPTION
, A.ALTERNATE_BOM_DESIGNATOR
, A.BILL_SEQUENCE_ID
, B.COMPONENT_ITEM_ID
, D.PADDED_CONCATENATED_SEGMENTS COMPONENT_ITEM_NAME
, B.DESCRIPTION COMPONENT_ITEM_DESCRIPTION
FROM BOM_BILL_OF_MATERIALS_V A
, BOM_INVENTORY_COMPONENTS_V B
, MTL_SYSTEM_ITEMS_KFV C
, MTL_SYSTEM_ITEMS_KFV D
WHERE A.BILL_SEQUENCE_ID = B.BILL_SEQUENCE_ID
AND C.ORGANIZATION_ID = A.ORGANIZATION_ID
AND C.INVENTORY_ITEM_ID = A.ASSEMBLY_ITEM_ID
AND D.ORGANIZATION_ID = A.ORGANIZATION_ID
AND D.INVENTORY_ITEM_ID = B.COMPONENT_ITEM_ID

Columns

Name
ORGANIZATION_ID
TOP_ITEM_ID
TOP_ITEM_NAME
TOP_ITEM_DESCRIPTION
ALTERNATE_BOM_DESIGNATOR
BILL_SEQUENCE_ID
COMPONENT_ITEM_ID
COMPONENT_ITEM_NAME
COMPONENT_ITEM_DESCRIPTION