VIEW: APPS.INVBV_PRODUCT_FAMILY_MEMBERS

Source

View Text - Preformatted

SELECT '_KF:INV:MSTK:SY2' , PA.ORGANIZATION_CODE , AL.NAME , '_KF:INV:MSTK:SY1' , CO.EFFECTIVITY_DATE , CO.DISABLE_DATE , CO.PLANNING_FACTOR , CO.COMPONENT_REMARKS , CO.BILL_SEQUENCE_ID , BI.ORGANIZATION_ID , CO.COMPONENT_ITEM_ID , CO.COMPONENT_SEQUENCE_ID , CO.LAST_UPDATE_DATE , CO.LAST_UPDATED_BY , CO.CREATION_DATE , CO.CREATED_BY FROM BOM_BILL_OF_MATERIALS BI, MTL_PARAMETERS PA, HR_ALL_ORGANIZATION_UNITS AL, MTL_SYSTEM_ITEMS SY2, MTL_SYSTEM_ITEMS SY1, BOM_INVENTORY_COMPONENTS CO WHERE CO.BILL_SEQUENCE_ID = BI.BILL_SEQUENCE_ID AND CO.COMPONENT_ITEM_ID = SY1.INVENTORY_ITEM_ID AND BI.ORGANIZATION_ID = SY1.ORGANIZATION_ID AND BI.ORGANIZATION_ID = AL.ORGANIZATION_ID AND BI.ORGANIZATION_ID = PA.ORGANIZATION_ID AND BI.ORGANIZATION_ID = SY2.ORGANIZATION_ID AND BI.ASSEMBLY_ITEM_ID = SY2.INVENTORY_ITEM_ID AND SY2.BOM_ITEM_TYPE = 5 AND '_SEC:bi.organization_id' is not null WITH READ ONLY

View Text - HTML Formatted

SELECT '_KF:INV:MSTK:SY2'
, PA.ORGANIZATION_CODE
, AL.NAME
, '_KF:INV:MSTK:SY1'
, CO.EFFECTIVITY_DATE
, CO.DISABLE_DATE
, CO.PLANNING_FACTOR
, CO.COMPONENT_REMARKS
, CO.BILL_SEQUENCE_ID
, BI.ORGANIZATION_ID
, CO.COMPONENT_ITEM_ID
, CO.COMPONENT_SEQUENCE_ID
, CO.LAST_UPDATE_DATE
, CO.LAST_UPDATED_BY
, CO.CREATION_DATE
, CO.CREATED_BY
FROM BOM_BILL_OF_MATERIALS BI
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_SYSTEM_ITEMS SY2
, MTL_SYSTEM_ITEMS SY1
, BOM_INVENTORY_COMPONENTS CO
WHERE CO.BILL_SEQUENCE_ID = BI.BILL_SEQUENCE_ID
AND CO.COMPONENT_ITEM_ID = SY1.INVENTORY_ITEM_ID
AND BI.ORGANIZATION_ID = SY1.ORGANIZATION_ID
AND BI.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND BI.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND BI.ORGANIZATION_ID = SY2.ORGANIZATION_ID
AND BI.ASSEMBLY_ITEM_ID = SY2.INVENTORY_ITEM_ID
AND SY2.BOM_ITEM_TYPE = 5
AND '_SEC:BI.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY