View: MRPFV_PLAN_ITEM_CAPACITIES

Product:	MRP - Master Scheduling/MRP
Description:
Implementation/DBA Data:	APPS.MRPFV_PLAN_ITEM_CAPACITIES

View Text

SELECT DISTINCT PARA.ORGANIZATION_CODE
, ORG.NAME
, ITEMS.COMPILE_DESIGNATOR
, '_KF:INV:MSTK:SYSITEM'
, SUPPLIER.VENDOR_NAME
, SUPPSITE.VENDOR_SITE_CODE
, CAP.TO_DATE
, CAP.FROM_DATE
, CAP.CAPACITY_PER_DAY
, PLANS.ORGANIZATION_ID
, ITEMS.INVENTORY_ITEM_ID
, PO.VENDOR_ID
, PO.VENDOR_SITE_ID
, PO.LAST_UPDATE_DATE
, PO.LAST_UPDATED_BY
, PO.CREATION_DATE
, PO.CREATED_BY
FROM MTL_PARAMETERS PARA
, HR_ALL_ORGANIZATION_UNITS ORG
, MTL_SYSTEM_ITEMS SYSITEM
, PO_VENDORS SUPPLIER
, PO_VENDOR_SITES_ALL SUPPSITE
, PO_APPROVED_SUPPLIER_LIST ASL
, PO_ASL_ATTRIBUTES PO
, PO_SUPPLIER_ITEM_CAPACITY CAP
, MRP_SYSTEM_ITEMS ITEMS
, MRP_PLAN_ORGANIZATIONS MPO
, MRP_PLANS PLANS
WHERE ASL.ITEM_ID = ITEMS.INVENTORY_ITEM_ID
AND ASL.USING_ORGANIZATION_ID = -1
AND PO.ASL_ID = ASL.ASL_ID
AND PO.USING_ORGANIZATION_ID = ASL.USING_ORGANIZATION_ID
AND PO_ASL_SV.CHECK_ASL_ACTION('2_SOURCING'
, PO.VENDOR_ID
, PO.VENDOR_SITE_ID
, ITEMS.INVENTORY_ITEM_ID
, NULL
, NULL) = 1
AND CAP.ASL_ID = PO.ASL_ID
AND CAP.USING_ORGANIZATION_ID = PO.USING_ORGANIZATION_ID
AND TRUNC(NVL(CAP.TO_DATE
, SYSDATE+1)) > TRUNC(SYSDATE)
AND MPO.PLAN_LEVEL(+) = 2
AND MPO.COMPILE_DESIGNATOR(+) = PLANS.COMPILE_DESIGNATOR
AND MPO.ORGANIZATION_ID(+) = PLANS.ORGANIZATION_ID
AND ITEMS.ORGANIZATION_ID = NVL(MPO.PLANNED_ORGANIZATION
, PLANS.ORGANIZATION_ID)
AND ITEMS.COMPILE_DESIGNATOR = PLANS.COMPILE_DESIGNATOR
AND PLANS.ORGANIZATION_ID = PARA.ORGANIZATION_ID
AND PLANS.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND ITEMS.ORGANIZATION_ID = SYSITEM.ORGANIZATION_ID
AND ITEMS.INVENTORY_ITEM_ID = SYSITEM.INVENTORY_ITEM_ID
AND PO.VENDOR_ID = SUPPLIER.VENDOR_ID(+)
AND PO.VENDOR_SITE_ID = SUPPSITE.VENDOR_SITE_ID(+)
AND '_SEC:PLANS.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns