[Home] [Help]
| Product: | MRP - Master Scheduling/MRP |
|---|---|
| Description: | An Integration Toolkit view supporting the time phased bill and revision information of each component |
| Implementation/DBA Data: | Not implemented in this database |
SELECT BIC.COMPONENT_SEQUENCE_ID
, BIC.COMPONENT_ITEM_ID
, MSI_COMP.ITEM_NUMBER
, MSI.ORGANIZATION_ID
, NVL(ERI.CHANGE_NOTICE
, BIC.CHANGE_NOTICE)
, MSI.INVENTORY_ITEM_ID
, MSI.ITEM_NUMBER
, BIC.OPERATION_SEQ_NUM
, DECODE(NVL(ERI.STATUS_TYPE
, 6)
, 6
, NULL
, NVL(ERI.USE_UP
, 2))
, BIC.COMPONENT_QUANTITY
, BIC.COMPONENT_YIELD_FACTOR
, BIC.PLANNING_FACTOR
, BIC.OPERATION_LEAD_TIME_PERCENT
, DECODE(NVL(ERI.STATUS_TYPE
, 6)
, 6
, NULL
, ERI.USE_UP_ITEM_ID)
, BIC.OPTIONAL
, BIC.EFFECTIVITY_DATE
, BIC.DISABLE_DATE
, NVL(BIC.WIP_SUPPLY_TYPE
, NVL(MSI_COMP.WIP_SUPPLY_TYPE
, 1))
, BBM.ALTERNATE_BOM_DESIGNATOR
, MSI.FIXED_ORDER_QUANTITY
, MSI.MINIMUM_ORDER_QUANTITY
, MSI.MAXIMUM_ORDER_QUANTITY
, MSI.FIXED_DAYS_SUPPLY
, MSI.FIXED_LOT_MULTIPLIER
, MSI.BOM_ITEM_TYPE
, BIC.IMPLEMENTATION_DATE
, BBM.BILL_SEQUENCE_ID
, BBM.COMMON_BILL_SEQUENCE_ID
, BBM.ATTRIBUTE_CATEGORY
, BBM.ATTRIBUTE1
, BBM.ATTRIBUTE2
, BBM.ATTRIBUTE3
, BBM.ATTRIBUTE4
, BBM.ATTRIBUTE5
, BBM.ATTRIBUTE6
, BBM.ATTRIBUTE7
, BBM.ATTRIBUTE8
, BBM.ATTRIBUTE9
, BBM.ATTRIBUTE10
, BBM.ATTRIBUTE11
, BBM.ATTRIBUTE12
, BBM.ATTRIBUTE13
, BBM.ATTRIBUTE14
, BBM.ATTRIBUTE15
, BIC.ACD_TYPE
, ERI.REVISED_ITEM_ID
, BIC.OLD_COMPONENT_SEQUENCE_ID
, ERI.STATUS_TYPE
, ERI.REVISED_ITEM_SEQUENCE_ID
, BIC.ATTRIBUTE_CATEGORY
, BIC.ATTRIBUTE1
, BIC.ATTRIBUTE2
, BIC.ATTRIBUTE3
, BIC.ATTRIBUTE4
, BIC.ATTRIBUTE5
, BIC.ATTRIBUTE6
, BIC.ATTRIBUTE7
, BIC.ATTRIBUTE8
, BIC.ATTRIBUTE9
, BIC.ATTRIBUTE10
, BIC.ATTRIBUTE11
, BIC.ATTRIBUTE12
, BIC.ATTRIBUTE13
, BIC.ATTRIBUTE14
, BIC.ATTRIBUTE15
FROM MRP_RHX_PLANNED_ITEMS_V MSI_COMP
, ENG_REVISED_ITEMS ERI
, BOM_INVENTORY_COMPONENTS BIC
, BOM_BILL_OF_MATERIALS BBM
, MRP_RHX_PLANNED_ITEMS_V MSI
WHERE ERI.REVISED_ITEM_SEQUENCE_ID(+) = BIC.REVISED_ITEM_SEQUENCE_ID
AND DECODE(BIC.OLD_COMPONENT_SEQUENCE_ID
, NULL
, NVL(BIC.DISABLE_DATE
, TRUNC(SYSDATE) + 1)
, TRUNC(SYSDATE) + 1) > (TRUNC(SYSDATE) - MRP_RHX_EXT_APS.GET_CONSTANT)
AND ((MSI.BOM_ITEM_TYPE = 4
AND BIC.BOM_ITEM_TYPE NOT IN (1
, 2)) OR MSI.BOM_ITEM_TYPE IN (1
, 2))
AND BIC.COMPONENT_QUANTITY >= 0
AND MSI_COMP.ORGANIZATION_ID = BBM.ORGANIZATION_ID
AND BIC.COMPONENT_ITEM_ID = MSI_COMP.INVENTORY_ITEM_ID
AND BIC.BILL_SEQUENCE_ID = BBM.COMMON_BILL_SEQUENCE_ID
AND BBM.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND BBM.ASSEMBLY_ITEM_ID = MSI.INVENTORY_ITEM_ID