VIEW: APPS.INVBV_INVENTORY_SUPPLIES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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