View: MRPBV_PLAN_SUBINVENTORIES

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

View Text

SELECT PARA.ORGANIZATION_CODE
, ORG.NAME
, MRPSUB.COMPILE_DESIGNATOR
, MRPSUB.SUB_INVENTORY_CODE
, '_LA:MRPSUB.NETTING_TYPE:MFG_LOOKUPS:MTL_AVAILABILITY:MEANING'
, MRPSUB.ORGANIZATION_ID
, MRPSUB.LAST_UPDATE_DATE
, MRPSUB.LAST_UPDATED_BY
, MRPSUB.CREATION_DATE
, MRPSUB.CREATED_BY
FROM MTL_PARAMETERS PARA
, HR_ALL_ORGANIZATION_UNITS ORG
, MTL_SECONDARY_INVENTORIES SUBINV
, MRP_PLAN_ORGANIZATIONS PLANORG
, MRP_PLANS PLAN
, MRP_SUB_INVENTORIES MRPSUB
WHERE MRPSUB.COMPILE_DESIGNATOR = PLAN.COMPILE_DESIGNATOR
AND PLANORG.PLAN_LEVEL(+) = 2
AND PLANORG.COMPILE_DESIGNATOR(+) = PLAN.COMPILE_DESIGNATOR
AND PLANORG.ORGANIZATION_ID(+) = PLAN.ORGANIZATION_ID
AND NVL(PLANORG.PLANNED_ORGANIZATION
, PLAN.ORGANIZATION_ID) = MRPSUB.ORGANIZATION_ID
AND MRPSUB.ORGANIZATION_ID = SUBINV.ORGANIZATION_ID
AND MRPSUB.SUB_INVENTORY_CODE = SUBINV.SECONDARY_INVENTORY_NAME
AND MRPSUB.ORGANIZATION_ID = PARA.ORGANIZATION_ID
AND MRPSUB.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND '_SEC:MRPSUB.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns