View: JTF_RS_COMPONENTS_V

Product:	JTF - CRM Foundation
Description:	Stores all valid components that skills can be assigned to.
Implementation/DBA Data:	APPS.JTF_RS_COMPONENTS_V

View Text

SELECT KFV.INVENTORY_ITEM_ID COMPONENT_ID
, KFV.ORGANIZATION_ID PRODUCT_ORG_ID
, KFV.CONCATENATED_SEGMENTS COMPONENT_NAME
, KFV.DESCRIPTION DESCRIPTION
, MTL.INVENTORY_ITEM_ID PRODUCT_ID
FROM MTL_SYSTEM_ITEMS_KFV KFV
, BOM_INVENTORY_COMPONENTS BIC
, BOM_BILL_OF_MATERIALS BOM
, MTL_SYSTEM_ITEMS MTL
WHERE BOM.ORGANIZATION_ID = KFV.ORGANIZATION_ID
AND BIC.BILL_SEQUENCE_ID = BOM.COMMON_BILL_SEQUENCE_ID
AND TRUNC(SYSDATE) BETWEEN TRUNC(BIC.EFFECTIVITY_DATE)
AND NVL(TRUNC(BIC.DISABLE_DATE)
, TRUNC(SYSDATE))
AND KFV.INVENTORY_ITEM_ID = BIC.COMPONENT_ITEM_ID
AND MTL.ORGANIZATION_ID = KFV.ORGANIZATION_ID
AND MTL.INVENTORY_ITEM_ID = BOM.ASSEMBLY_ITEM_ID
AND BOM.ALTERNATE_BOM_DESIGNATOR IS NULL

Columns