Product: | INV - Inventory |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.INVBV_PRODUCT_FAMILY_MEMBERS |
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