VIEW: INV.MTL_SUPPLY#

Source

View Text - Preformatted

select SUPPLY_TYPE_CODE SUPPLY_TYPE_CODE, SUPPLY_SOURCE_ID SUPPLY_SOURCE_ID, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQ_HEADER_ID REQ_HEADER_ID, REQ_LINE_ID REQ_LINE_ID, PO_HEADER_ID PO_HEADER_ID, PO_RELEASE_ID PO_RELEASE_ID, PO_LINE_ID PO_LINE_ID, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID, SHIPMENT_LINE_ID SHIPMENT_LINE_ID, RCV_TRANSACTION_ID RCV_TRANSACTION_ID, ITEM_ID ITEM_ID, ITEM_REVISION ITEM_REVISION, CATEGORY_ID CATEGORY_ID, QUANTITY QUANTITY, UNIT_OF_MEASURE UNIT_OF_MEASURE, TO_ORG_PRIMARY_QUANTITY TO_ORG_PRIMARY_QUANTITY, TO_ORG_PRIMARY_UOM TO_ORG_PRIMARY_UOM, RECEIPT_DATE RECEIPT_DATE, NEED_BY_DATE NEED_BY_DATE, EXPECTED_DELIVERY_DATE EXPECTED_DELIVERY_DATE, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE, LOCATION_ID LOCATION_ID, FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID, FROM_SUBINVENTORY FROM_SUBINVENTORY, TO_ORGANIZATION_ID TO_ORGANIZATION_ID, TO_SUBINVENTORY TO_SUBINVENTORY, INTRANSIT_OWNING_ORG_ID INTRANSIT_OWNING_ORG_ID, MRP_PRIMARY_QUANTITY MRP_PRIMARY_QUANTITY, MRP_PRIMARY_UOM MRP_PRIMARY_UOM, MRP_EXPECTED_DELIVERY_DATE MRP_EXPECTED_DELIVERY_DATE, MRP_DESTINATION_TYPE_CODE MRP_DESTINATION_TYPE_CODE, MRP_TO_ORGANIZATION_ID MRP_TO_ORGANIZATION_ID, MRP_TO_SUBINVENTORY MRP_TO_SUBINVENTORY, CHANGE_FLAG CHANGE_FLAG, CHANGE_TYPE CHANGE_TYPE, COST_GROUP_ID COST_GROUP_ID, EXCLUDE_FROM_PLANNING EXCLUDE_FROM_PLANNING from "INV"."MTL_SUPPLY"

View Text - HTML Formatted

SELECT SUPPLY_TYPE_CODE SUPPLY_TYPE_CODE
, SUPPLY_SOURCE_ID SUPPLY_SOURCE_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQ_HEADER_ID REQ_HEADER_ID
, REQ_LINE_ID REQ_LINE_ID
, PO_HEADER_ID PO_HEADER_ID
, PO_RELEASE_ID PO_RELEASE_ID
, PO_LINE_ID PO_LINE_ID
, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID
, SHIPMENT_LINE_ID SHIPMENT_LINE_ID
, RCV_TRANSACTION_ID RCV_TRANSACTION_ID
, ITEM_ID ITEM_ID
, ITEM_REVISION ITEM_REVISION
, CATEGORY_ID CATEGORY_ID
, QUANTITY QUANTITY
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, TO_ORG_PRIMARY_QUANTITY TO_ORG_PRIMARY_QUANTITY
, TO_ORG_PRIMARY_UOM TO_ORG_PRIMARY_UOM
, RECEIPT_DATE RECEIPT_DATE
, NEED_BY_DATE NEED_BY_DATE
, EXPECTED_DELIVERY_DATE EXPECTED_DELIVERY_DATE
, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE
, LOCATION_ID LOCATION_ID
, FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID
, FROM_SUBINVENTORY FROM_SUBINVENTORY
, TO_ORGANIZATION_ID TO_ORGANIZATION_ID
, TO_SUBINVENTORY TO_SUBINVENTORY
, INTRANSIT_OWNING_ORG_ID INTRANSIT_OWNING_ORG_ID
, MRP_PRIMARY_QUANTITY MRP_PRIMARY_QUANTITY
, MRP_PRIMARY_UOM MRP_PRIMARY_UOM
, MRP_EXPECTED_DELIVERY_DATE MRP_EXPECTED_DELIVERY_DATE
, MRP_DESTINATION_TYPE_CODE MRP_DESTINATION_TYPE_CODE
, MRP_TO_ORGANIZATION_ID MRP_TO_ORGANIZATION_ID
, MRP_TO_SUBINVENTORY MRP_TO_SUBINVENTORY
, CHANGE_FLAG CHANGE_FLAG
, CHANGE_TYPE CHANGE_TYPE
, COST_GROUP_ID COST_GROUP_ID
, EXCLUDE_FROM_PLANNING EXCLUDE_FROM_PLANNING
FROM "INV"."MTL_SUPPLY"