Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | MRP subinventory view |
Implementation/DBA Data: | APPS.MRP_SUB_INVENTORIES_V |
SELECT M.ROWID
, M.SUB_INVENTORY_CODE
, MTL.DESCRIPTION
, M.ORGANIZATION_ID
, D.DESIGNATOR
, NVL(M.LAST_UPDATE_DATE
, D.LAST_UPDATE_DATE)
, NVL(M.LAST_UPDATED_BY
, D.LAST_UPDATED_BY)
, NVL(M.CREATION_DATE
, D.CREATION_DATE)
, NVL(M.CREATED_BY
, D.CREATED_BY)
, M.LAST_UPDATE_LOGIN
, M.NETTING_TYPE
, M.REQUEST_ID
, M.PROGRAM_APPLICATION_ID
, M.PROGRAM_ID
, M.PROGRAM_UPDATE_DATE
, M.ATTRIBUTE_CATEGORY
, M.ATTRIBUTE1
, M.ATTRIBUTE2
, M.ATTRIBUTE3
, M.ATTRIBUTE4
, M.ATTRIBUTE5
, M.ATTRIBUTE6
, M.ATTRIBUTE7
, M.ATTRIBUTE8
, M.ATTRIBUTE9
, M.ATTRIBUTE10
, M.ATTRIBUTE11
, M.ATTRIBUTE12
, M.ATTRIBUTE13
, M.ATTRIBUTE14
, M.ATTRIBUTE15
FROM MRP_SUB_INVENTORIES M
, MTL_SECONDARY_INVENTORIES MTL
, MRP_PLAN_ORGANIZATIONS_V MPO
, MRP_DESIGNATORS_VIEW D
WHERE D.DESIGNATOR_TYPE IN (2
, 3
, 4)
AND MTL.SECONDARY_INVENTORY_NAME = M.SUB_INVENTORY_CODE
AND MTL.ORGANIZATION_ID = M.ORGANIZATION_ID
AND MPO.PLANNED_ORGANIZATION = M.ORGANIZATION_ID
AND MPO.COMPILE_DESIGNATOR = M.COMPILE_DESIGNATOR
AND MPO.ORGANIZATION_ID = D.ORGANIZATION_ID
AND MPO.COMPILE_DESIGNATOR = D.DESIGNATOR