VIEW: APPS.MSC_SUB_INVENTORIES_V

Source

View Text - Preformatted

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 ,NVL(M.INCLUDE_NON_NETTABLE,2) 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

View Text - HTML Formatted

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
, NVL(M.INCLUDE_NON_NETTABLE
, 2)
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