VIEW: APPS.MRP_SUB_INVENTORIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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