VIEW: PO.RCV_TRANSACTIONS#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, TRANSACTION_TYPE TRANSACTION_TYPE, TRANSACTION_DATE TRANSACTION_DATE, QUANTITY QUANTITY, UNIT_OF_MEASURE UNIT_OF_MEASURE, SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID, SHIPMENT_LINE_ID SHIPMENT_LINE_ID, USER_ENTERED_FLAG USER_ENTERED_FLAG, INTERFACE_SOURCE_CODE INTERFACE_SOURCE_CODE, INTERFACE_SOURCE_LINE_ID INTERFACE_SOURCE_LINE_ID, INV_TRANSACTION_ID INV_TRANSACTION_ID, SOURCE_DOCUMENT_CODE SOURCE_DOCUMENT_CODE, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE, PRIMARY_QUANTITY PRIMARY_QUANTITY, PRIMARY_UNIT_OF_MEASURE PRIMARY_UNIT_OF_MEASURE, UOM_CODE UOM_CODE, EMPLOYEE_ID EMPLOYEE_ID, PARENT_TRANSACTION_ID PARENT_TRANSACTION_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, PO_REVISION_NUM PO_REVISION_NUM, REQUISITION_LINE_ID REQUISITION_LINE_ID, PO_UNIT_PRICE PO_UNIT_PRICE, CURRENCY_CODE CURRENCY_CODE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, ROUTING_HEADER_ID ROUTING_HEADER_ID, ROUTING_STEP_ID ROUTING_STEP_ID, DELIVER_TO_PERSON_ID DELIVER_TO_PERSON_ID, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, ORGANIZATION_ID ORGANIZATION_ID, SUBINVENTORY SUBINVENTORY, LOCATOR_ID LOCATOR_ID, WIP_ENTITY_ID WIP_ENTITY_ID, WIP_LINE_ID WIP_LINE_ID, WIP_REPETITIVE_SCHEDULE_ID WIP_REPETITIVE_SCHEDULE_ID, WIP_OPERATION_SEQ_NUM WIP_OPERATION_SEQ_NUM, WIP_RESOURCE_SEQ_NUM WIP_RESOURCE_SEQ_NUM, BOM_RESOURCE_ID BOM_RESOURCE_ID, LOCATION_ID LOCATION_ID, SUBSTITUTE_UNORDERED_CODE SUBSTITUTE_UNORDERED_CODE, RECEIPT_EXCEPTION_FLAG RECEIPT_EXCEPTION_FLAG, INSPECTION_STATUS_CODE INSPECTION_STATUS_CODE, ACCRUAL_STATUS_CODE ACCRUAL_STATUS_CODE, INSPECTION_QUALITY_CODE INSPECTION_QUALITY_CODE, VENDOR_LOT_NUM VENDOR_LOT_NUM, RMA_REFERENCE RMA_REFERENCE, COMMENTS COMMENTS, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, REQ_DISTRIBUTION_ID REQ_DISTRIBUTION_ID, DEPARTMENT_CODE DEPARTMENT_CODE, REASON_ID REASON_ID, DESTINATION_CONTEXT DESTINATION_CONTEXT, LOCATOR_ATTRIBUTE LOCATOR_ATTRIBUTE, CHILD_INSPECTION_FLAG CHILD_INSPECTION_FLAG, SOURCE_DOC_UNIT_OF_MEASURE SOURCE_DOC_UNIT_OF_MEASURE, SOURCE_DOC_QUANTITY SOURCE_DOC_QUANTITY, INTERFACE_TRANSACTION_ID INTERFACE_TRANSACTION_ID, GROUP_ID GROUP_ID, MOVEMENT_ID MOVEMENT_ID, INVOICE_ID INVOICE_ID, INVOICE_STATUS_CODE INVOICE_STATUS_CODE, QA_COLLECTION_ID QA_COLLECTION_ID, MRC_CURRENCY_CONVERSION_TYPE MRC_CURRENCY_CONVERSION_TYPE, MRC_CURRENCY_CONVERSION_DATE MRC_CURRENCY_CONVERSION_DATE, MRC_CURRENCY_CONVERSION_RATE MRC_CURRENCY_CONVERSION_RATE, COUNTRY_OF_ORIGIN_CODE COUNTRY_OF_ORIGIN_CODE, MVT_STAT_STATUS MVT_STAT_STATUS, QUANTITY_BILLED QUANTITY_BILLED, MATCH_FLAG MATCH_FLAG, AMOUNT_BILLED AMOUNT_BILLED, MATCH_OPTION MATCH_OPTION, OE_ORDER_HEADER_ID OE_ORDER_HEADER_ID, OE_ORDER_LINE_ID OE_ORDER_LINE_ID, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, LPN_ID LPN_ID, TRANSFER_LPN_ID TRANSFER_LPN_ID, MOBILE_TXN MOBILE_TXN, SECONDARY_QUANTITY SECONDARY_QUANTITY, SECONDARY_UNIT_OF_MEASURE SECONDARY_UNIT_OF_MEASURE, QC_GRADE QC_GRADE, SECONDARY_UOM_CODE SECONDARY_UOM_CODE, PA_ADDITION_FLAG PA_ADDITION_FLAG, CONSIGNED_FLAG CONSIGNED_FLAG, SOURCE_TRANSACTION_NUM SOURCE_TRANSACTION_NUM, FROM_SUBINVENTORY FROM_SUBINVENTORY, FROM_LOCATOR_ID FROM_LOCATOR_ID, AMOUNT AMOUNT, DROPSHIP_TYPE_CODE DROPSHIP_TYPE_CODE, LPN_GROUP_ID LPN_GROUP_ID, JOB_ID JOB_ID, TIMECARD_ID TIMECARD_ID, TIMECARD_OVN TIMECARD_OVN, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, REQUESTED_AMOUNT REQUESTED_AMOUNT, MATERIAL_STORED_AMOUNT MATERIAL_STORED_AMOUNT, REPLENISH_ORDER_LINE_ID REPLENISH_ORDER_LINE_ID, LCM_SHIPMENT_LINE_ID LCM_SHIPMENT_LINE_ID, UNIT_LANDED_COST UNIT_LANDED_COST, RECEIPT_CONFIRMATION_EXTRACTED RECEIPT_CONFIRMATION_EXTRACTED, LCM_ADJUSTMENT_NUM LCM_ADJUSTMENT_NUM, XML_DOCUMENT_ID XML_DOCUMENT_ID from "PO"."RCV_TRANSACTIONS"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TRANSACTION_TYPE TRANSACTION_TYPE
, TRANSACTION_DATE TRANSACTION_DATE
, QUANTITY QUANTITY
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID
, SHIPMENT_LINE_ID SHIPMENT_LINE_ID
, USER_ENTERED_FLAG USER_ENTERED_FLAG
, INTERFACE_SOURCE_CODE INTERFACE_SOURCE_CODE
, INTERFACE_SOURCE_LINE_ID INTERFACE_SOURCE_LINE_ID
, INV_TRANSACTION_ID INV_TRANSACTION_ID
, SOURCE_DOCUMENT_CODE SOURCE_DOCUMENT_CODE
, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE
, PRIMARY_QUANTITY PRIMARY_QUANTITY
, PRIMARY_UNIT_OF_MEASURE PRIMARY_UNIT_OF_MEASURE
, UOM_CODE UOM_CODE
, EMPLOYEE_ID EMPLOYEE_ID
, PARENT_TRANSACTION_ID PARENT_TRANSACTION_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
, PO_REVISION_NUM PO_REVISION_NUM
, REQUISITION_LINE_ID REQUISITION_LINE_ID
, PO_UNIT_PRICE PO_UNIT_PRICE
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, ROUTING_HEADER_ID ROUTING_HEADER_ID
, ROUTING_STEP_ID ROUTING_STEP_ID
, DELIVER_TO_PERSON_ID DELIVER_TO_PERSON_ID
, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SUBINVENTORY SUBINVENTORY
, LOCATOR_ID LOCATOR_ID
, WIP_ENTITY_ID WIP_ENTITY_ID
, WIP_LINE_ID WIP_LINE_ID
, WIP_REPETITIVE_SCHEDULE_ID WIP_REPETITIVE_SCHEDULE_ID
, WIP_OPERATION_SEQ_NUM WIP_OPERATION_SEQ_NUM
, WIP_RESOURCE_SEQ_NUM WIP_RESOURCE_SEQ_NUM
, BOM_RESOURCE_ID BOM_RESOURCE_ID
, LOCATION_ID LOCATION_ID
, SUBSTITUTE_UNORDERED_CODE SUBSTITUTE_UNORDERED_CODE
, RECEIPT_EXCEPTION_FLAG RECEIPT_EXCEPTION_FLAG
, INSPECTION_STATUS_CODE INSPECTION_STATUS_CODE
, ACCRUAL_STATUS_CODE ACCRUAL_STATUS_CODE
, INSPECTION_QUALITY_CODE INSPECTION_QUALITY_CODE
, VENDOR_LOT_NUM VENDOR_LOT_NUM
, RMA_REFERENCE RMA_REFERENCE
, COMMENTS COMMENTS
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, REQ_DISTRIBUTION_ID REQ_DISTRIBUTION_ID
, DEPARTMENT_CODE DEPARTMENT_CODE
, REASON_ID REASON_ID
, DESTINATION_CONTEXT DESTINATION_CONTEXT
, LOCATOR_ATTRIBUTE LOCATOR_ATTRIBUTE
, CHILD_INSPECTION_FLAG CHILD_INSPECTION_FLAG
, SOURCE_DOC_UNIT_OF_MEASURE SOURCE_DOC_UNIT_OF_MEASURE
, SOURCE_DOC_QUANTITY SOURCE_DOC_QUANTITY
, INTERFACE_TRANSACTION_ID INTERFACE_TRANSACTION_ID
, GROUP_ID GROUP_ID
, MOVEMENT_ID MOVEMENT_ID
, INVOICE_ID INVOICE_ID
, INVOICE_STATUS_CODE INVOICE_STATUS_CODE
, QA_COLLECTION_ID QA_COLLECTION_ID
, MRC_CURRENCY_CONVERSION_TYPE MRC_CURRENCY_CONVERSION_TYPE
, MRC_CURRENCY_CONVERSION_DATE MRC_CURRENCY_CONVERSION_DATE
, MRC_CURRENCY_CONVERSION_RATE MRC_CURRENCY_CONVERSION_RATE
, COUNTRY_OF_ORIGIN_CODE COUNTRY_OF_ORIGIN_CODE
, MVT_STAT_STATUS MVT_STAT_STATUS
, QUANTITY_BILLED QUANTITY_BILLED
, MATCH_FLAG MATCH_FLAG
, AMOUNT_BILLED AMOUNT_BILLED
, MATCH_OPTION MATCH_OPTION
, OE_ORDER_HEADER_ID OE_ORDER_HEADER_ID
, OE_ORDER_LINE_ID OE_ORDER_LINE_ID
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, LPN_ID LPN_ID
, TRANSFER_LPN_ID TRANSFER_LPN_ID
, MOBILE_TXN MOBILE_TXN
, SECONDARY_QUANTITY SECONDARY_QUANTITY
, SECONDARY_UNIT_OF_MEASURE SECONDARY_UNIT_OF_MEASURE
, QC_GRADE QC_GRADE
, SECONDARY_UOM_CODE SECONDARY_UOM_CODE
, PA_ADDITION_FLAG PA_ADDITION_FLAG
, CONSIGNED_FLAG CONSIGNED_FLAG
, SOURCE_TRANSACTION_NUM SOURCE_TRANSACTION_NUM
, FROM_SUBINVENTORY FROM_SUBINVENTORY
, FROM_LOCATOR_ID FROM_LOCATOR_ID
, AMOUNT AMOUNT
, DROPSHIP_TYPE_CODE DROPSHIP_TYPE_CODE
, LPN_GROUP_ID LPN_GROUP_ID
, JOB_ID JOB_ID
, TIMECARD_ID TIMECARD_ID
, TIMECARD_OVN TIMECARD_OVN
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, REQUESTED_AMOUNT REQUESTED_AMOUNT
, MATERIAL_STORED_AMOUNT MATERIAL_STORED_AMOUNT
, REPLENISH_ORDER_LINE_ID REPLENISH_ORDER_LINE_ID
, LCM_SHIPMENT_LINE_ID LCM_SHIPMENT_LINE_ID
, UNIT_LANDED_COST UNIT_LANDED_COST
, RECEIPT_CONFIRMATION_EXTRACTED RECEIPT_CONFIRMATION_EXTRACTED
, LCM_ADJUSTMENT_NUM LCM_ADJUSTMENT_NUM
, XML_DOCUMENT_ID XML_DOCUMENT_ID
FROM "PO"."RCV_TRANSACTIONS"