Product: | INV - Inventory |
---|---|
Description: | For Consumption setup forms |
Implementation/DBA Data: | APPS.MTL_CONSUMPTION_DEFINITION_V |
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