View: INVBV_INVENTORY_SUPPLIES

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.INVBV_INVENTORY_SUPPLIES

View Text

SELECT MTS.SUPPLY_TYPE_CODE
, MTS.SUPPLY_SOURCE_ID
, MTS.PO_HEADER_ID
, MTS.PO_RELEASE_ID
, MTS.PO_LINE_ID
, MTS.PO_LINE_LOCATION_ID
, MTS.PO_DISTRIBUTION_ID
, MTS.RCV_TRANSACTION_ID
, MTS.REQ_HEADER_ID
, MTS.REQ_LINE_ID
, MTS.SHIPMENT_HEADER_ID
, MTS.SHIPMENT_LINE_ID
, MTS.ITEM_ID
, MTS.ITEM_REVISION
, /*--MTS.CATEGORY_ID
, */ MTS.QUANTITY
, MTS.UNIT_OF_MEASURE
, MTS.TO_ORG_PRIMARY_QUANTITY
, MTS.TO_ORG_PRIMARY_UOM
, MTS.RECEIPT_DATE
, MTS.NEED_BY_DATE
, MTS.EXPECTED_DELIVERY_DATE
, '_LA:MTS.DESTINATION_TYPE_CODE:PO_LOOKUP_CODES:DESTINATION TYPE:DESCRIPTION'
, /* LOOKUP */ MTS.LOCATION_ID
, MTS.FROM_ORGANIZATION_ID
, MTS.FROM_SUBINVENTORY
, MTS.TO_ORGANIZATION_ID
, MTS.TO_SUBINVENTORY
, MTS.INTRANSIT_OWNING_ORG_ID
, MTS.CREATED_BY
, MTS.CREATION_DATE
, MTS.LAST_UPDATED_BY
, MTS.LAST_UPDATE_DATE
FROM MTL_SUPPLY MTS
WHERE '_SEC:MTS.FROM_ORGANIZATION_ID' IS NOT NULL
AND '_SEC:MTS.TO_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns