VIEW: PO.RCV_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, 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, 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, CHANGE_FLAG CHANGE_FLAG, CHANGE_TYPE CHANGE_TYPE, OE_ORDER_HEADER_ID OE_ORDER_HEADER_ID, OE_ORDER_LINE_ID OE_ORDER_LINE_ID, TO_LOCATOR_ID TO_LOCATOR_ID, LPN_ID LPN_ID, SECONDARY_QUANTITY SECONDARY_QUANTITY, SECONDARY_UNIT_OF_MEASURE SECONDARY_UNIT_OF_MEASURE from "PO"."RCV_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
, 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
, 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
, CHANGE_FLAG CHANGE_FLAG
, CHANGE_TYPE CHANGE_TYPE
, OE_ORDER_HEADER_ID OE_ORDER_HEADER_ID
, OE_ORDER_LINE_ID OE_ORDER_LINE_ID
, TO_LOCATOR_ID TO_LOCATOR_ID
, LPN_ID LPN_ID
, SECONDARY_QUANTITY SECONDARY_QUANTITY
, SECONDARY_UNIT_OF_MEASURE SECONDARY_UNIT_OF_MEASURE
FROM "PO"."RCV_SUPPLY"