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