View: MSC_SUB_INVENTORIES_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_SUB_INVENTORIES_V

View Text

SELECT M.ROWID
, M.SUB_INVENTORY_CODE
, M.PLAN_ID
, M.SR_INSTANCE_ID
, M1.DESCRIPTION
, M.ORGANIZATION_ID
, P.COMPILE_DESIGNATOR
, M.LAST_UPDATE_DATE
, M.LAST_UPDATED_BY
, M.CREATION_DATE
, M.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 MSC_SUB_INVENTORIES M
, MSC_SUB_INVENTORIES M1
, MSC_PLANS P
WHERE M.PLAN_ID = P.PLAN_ID
AND M1.SR_INSTANCE_ID = M.SR_INSTANCE_ID
AND M1.ORGANIZATION_ID = M.ORGANIZATION_ID
AND M1.PLAN_ID = -1
AND M1.SUB_INVENTORY_CODE = M.SUB_INVENTORY_CODE

Columns