VIEW: APPS.MTL_CONSUMPTION_DEFINITION_V

Source

View Text - Preformatted

SELECT MCD.ROWID , MTT.TRANSACTION_TYPE_NAME , MCD.TRANSACTION_TYPE_ID , MP.ORGANIZATION_CODE , MCD.ORGANIZATION_ID , MCD.SUBINVENTORY_CODE , MCD.XFER_SUBINVENTORY_CODE , MCD.FROM_LOCATOR_ID , MCD.TO_LOCATOR_ID , MCD.INVENTORY_ITEM_ID , MSIT.CONCATENATED_SEGMENTS , MCD.OWNING_ORGANIZATION_ID , MCD.PLANNING_ORGANIZATION_ID , MCD.CONSUME_CONSIGNED_FLAG , MCD.CONSUME_VMI_FLAG , POV1.VENDOR_NAME || '-' || POVS1.VENDOR_SITE_CODE , POV2.VENDOR_NAME || '-' || POVS2.VENDOR_SITE_CODE , MCD.CREATION_DATE , MCD.CREATED_BY , MCD.LAST_UPDATE_DATE , MCD.LAST_UPDATED_BY , MCD.LAST_UPDATE_LOGIN , MCD.ATTRIBUTE_CATEGORY , MCD.ATTRIBUTE1 , MCD.ATTRIBUTE2 , MCD.ATTRIBUTE3 , MCD.ATTRIBUTE4 , MCD.ATTRIBUTE5 , MCD.ATTRIBUTE6 , MCD.ATTRIBUTE7 , MCD.ATTRIBUTE8 , MCD.ATTRIBUTE9 , MCD.ATTRIBUTE10 , MCD.ATTRIBUTE11 , MCD.ATTRIBUTE12 , MCD.ATTRIBUTE13 , MCD.ATTRIBUTE14 , MCD.ATTRIBUTE15 , MCD.WEIGHT FROM MTL_CONSUMPTION_DEFINITION MCD , MTL_PARAMETERS MP , MTL_SYSTEM_ITEMS_KFV MSIT , MTL_TRANSACTION_TYPES MTT , PO_VENDORS POV1 , PO_VENDOR_SITES_ALL POVS1 , PO_VENDORS POV2 , PO_VENDOR_SITES_ALL POVS2 WHERE MCD.TRANSACTION_TYPE_ID = MTT.TRANSACTION_TYPE_ID AND MCD.ORGANIZATION_ID = MP.ORGANIZATION_ID(+) AND MCD.ORGANIZATION_ID = MSIT.ORGANIZATION_ID(+) AND MCD.INVENTORY_ITEM_ID = MSIT.INVENTORY_ITEM_ID(+) AND PLANNING_ORGANIZATION_ID = POVS1.VENDOR_SITE_ID(+) AND POV1.VENDOR_ID(+) = POVS1.VENDOR_ID AND OWNING_ORGANIZATION_ID = POVS2.VENDOR_SITE_ID(+) AND POV2.VENDOR_ID(+) = POVS2.VENDOR_ID

View Text - HTML Formatted

SELECT MCD.ROWID
, MTT.TRANSACTION_TYPE_NAME
, MCD.TRANSACTION_TYPE_ID
, MP.ORGANIZATION_CODE
, MCD.ORGANIZATION_ID
, MCD.SUBINVENTORY_CODE
, MCD.XFER_SUBINVENTORY_CODE
, MCD.FROM_LOCATOR_ID
, MCD.TO_LOCATOR_ID
, MCD.INVENTORY_ITEM_ID
, MSIT.CONCATENATED_SEGMENTS
, MCD.OWNING_ORGANIZATION_ID
, MCD.PLANNING_ORGANIZATION_ID
, MCD.CONSUME_CONSIGNED_FLAG
, MCD.CONSUME_VMI_FLAG
, POV1.VENDOR_NAME || '-' || POVS1.VENDOR_SITE_CODE
, POV2.VENDOR_NAME || '-' || POVS2.VENDOR_SITE_CODE
, MCD.CREATION_DATE
, MCD.CREATED_BY
, MCD.LAST_UPDATE_DATE
, MCD.LAST_UPDATED_BY
, MCD.LAST_UPDATE_LOGIN
, MCD.ATTRIBUTE_CATEGORY
, MCD.ATTRIBUTE1
, MCD.ATTRIBUTE2
, MCD.ATTRIBUTE3
, MCD.ATTRIBUTE4
, MCD.ATTRIBUTE5
, MCD.ATTRIBUTE6
, MCD.ATTRIBUTE7
, MCD.ATTRIBUTE8
, MCD.ATTRIBUTE9
, MCD.ATTRIBUTE10
, MCD.ATTRIBUTE11
, MCD.ATTRIBUTE12
, MCD.ATTRIBUTE13
, MCD.ATTRIBUTE14
, MCD.ATTRIBUTE15
, MCD.WEIGHT
FROM MTL_CONSUMPTION_DEFINITION MCD
, MTL_PARAMETERS MP
, MTL_SYSTEM_ITEMS_KFV MSIT
, MTL_TRANSACTION_TYPES MTT
, PO_VENDORS POV1
, PO_VENDOR_SITES_ALL POVS1
, PO_VENDORS POV2
, PO_VENDOR_SITES_ALL POVS2
WHERE MCD.TRANSACTION_TYPE_ID = MTT.TRANSACTION_TYPE_ID
AND MCD.ORGANIZATION_ID = MP.ORGANIZATION_ID(+)
AND MCD.ORGANIZATION_ID = MSIT.ORGANIZATION_ID(+)
AND MCD.INVENTORY_ITEM_ID = MSIT.INVENTORY_ITEM_ID(+)
AND PLANNING_ORGANIZATION_ID = POVS1.VENDOR_SITE_ID(+)
AND POV1.VENDOR_ID(+) = POVS1.VENDOR_ID
AND OWNING_ORGANIZATION_ID = POVS2.VENDOR_SITE_ID(+)
AND POV2.VENDOR_ID(+) = POVS2.VENDOR_ID