VIEW: PO.RCV_TRANSACTIONS_INTERFACE#

Source

View Text - Preformatted

select INTERFACE_TRANSACTION_ID INTERFACE_TRANSACTION_ID, GROUP_ID GROUP_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, PROCESSING_STATUS_CODE PROCESSING_STATUS_CODE, PROCESSING_MODE_CODE PROCESSING_MODE_CODE, PROCESSING_REQUEST_ID PROCESSING_REQUEST_ID, TRANSACTION_STATUS_CODE TRANSACTION_STATUS_CODE, CATEGORY_ID CATEGORY_ID, QUANTITY QUANTITY, UNIT_OF_MEASURE UNIT_OF_MEASURE, INTERFACE_SOURCE_CODE INTERFACE_SOURCE_CODE, INTERFACE_SOURCE_LINE_ID INTERFACE_SOURCE_LINE_ID, INV_TRANSACTION_ID INV_TRANSACTION_ID, ITEM_ID ITEM_ID, ITEM_DESCRIPTION ITEM_DESCRIPTION, ITEM_REVISION ITEM_REVISION, UOM_CODE UOM_CODE, EMPLOYEE_ID EMPLOYEE_ID, AUTO_TRANSACT_CODE AUTO_TRANSACT_CODE, SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID, SHIPMENT_LINE_ID SHIPMENT_LINE_ID, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, PRIMARY_QUANTITY PRIMARY_QUANTITY, PRIMARY_UNIT_OF_MEASURE PRIMARY_UNIT_OF_MEASURE, RECEIPT_SOURCE_CODE RECEIPT_SOURCE_CODE, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID, FROM_SUBINVENTORY FROM_SUBINVENTORY, TO_ORGANIZATION_ID TO_ORGANIZATION_ID, INTRANSIT_OWNING_ORG_ID INTRANSIT_OWNING_ORG_ID, ROUTING_HEADER_ID ROUTING_HEADER_ID, ROUTING_STEP_ID ROUTING_STEP_ID, SOURCE_DOCUMENT_CODE SOURCE_DOCUMENT_CODE, PARENT_TRANSACTION_ID PARENT_TRANSACTION_ID, PO_HEADER_ID PO_HEADER_ID, PO_REVISION_NUM PO_REVISION_NUM, PO_RELEASE_ID PO_RELEASE_ID, PO_LINE_ID PO_LINE_ID, PO_LINE_LOCATION_ID PO_LINE_LOCATION_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, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, REQUISITION_LINE_ID REQUISITION_LINE_ID, REQ_DISTRIBUTION_ID REQ_DISTRIBUTION_ID, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_ID, SUBSTITUTE_UNORDERED_CODE SUBSTITUTE_UNORDERED_CODE, RECEIPT_EXCEPTION_FLAG RECEIPT_EXCEPTION_FLAG, ACCRUAL_STATUS_CODE ACCRUAL_STATUS_CODE, INSPECTION_STATUS_CODE INSPECTION_STATUS_CODE, INSPECTION_QUALITY_CODE INSPECTION_QUALITY_CODE, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE, DELIVER_TO_PERSON_ID DELIVER_TO_PERSON_ID, LOCATION_ID LOCATION_ID, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID, SUBINVENTORY SUBINVENTORY, LOCATOR_ID LOCATOR_ID, WIP_ENTITY_ID WIP_ENTITY_ID, WIP_LINE_ID WIP_LINE_ID, DEPARTMENT_CODE DEPARTMENT_CODE, 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, SHIPMENT_NUM SHIPMENT_NUM, FREIGHT_CARRIER_CODE FREIGHT_CARRIER_CODE, BILL_OF_LADING BILL_OF_LADING, PACKING_SLIP PACKING_SLIP, SHIPPED_DATE SHIPPED_DATE, EXPECTED_RECEIPT_DATE EXPECTED_RECEIPT_DATE, ACTUAL_COST ACTUAL_COST, TRANSFER_COST TRANSFER_COST, TRANSPORTATION_COST TRANSPORTATION_COST, TRANSPORTATION_ACCOUNT_ID TRANSPORTATION_ACCOUNT_ID, NUM_OF_CONTAINERS NUM_OF_CONTAINERS, WAYBILL_AIRBILL_NUM WAYBILL_AIRBILL_NUM, VENDOR_ITEM_NUM VENDOR_ITEM_NUM, 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, SHIP_HEAD_ATTRIBUTE_CATEGORY SHIP_HEAD_ATTRIBUTE_CATEGORY, SHIP_HEAD_ATTRIBUTE1 SHIP_HEAD_ATTRIBUTE1, SHIP_HEAD_ATTRIBUTE2 SHIP_HEAD_ATTRIBUTE2, SHIP_HEAD_ATTRIBUTE3 SHIP_HEAD_ATTRIBUTE3, SHIP_HEAD_ATTRIBUTE4 SHIP_HEAD_ATTRIBUTE4, SHIP_HEAD_ATTRIBUTE5 SHIP_HEAD_ATTRIBUTE5, SHIP_HEAD_ATTRIBUTE6 SHIP_HEAD_ATTRIBUTE6, SHIP_HEAD_ATTRIBUTE7 SHIP_HEAD_ATTRIBUTE7, SHIP_HEAD_ATTRIBUTE8 SHIP_HEAD_ATTRIBUTE8, SHIP_HEAD_ATTRIBUTE9 SHIP_HEAD_ATTRIBUTE9, SHIP_HEAD_ATTRIBUTE10 SHIP_HEAD_ATTRIBUTE10, SHIP_HEAD_ATTRIBUTE11 SHIP_HEAD_ATTRIBUTE11, SHIP_HEAD_ATTRIBUTE12 SHIP_HEAD_ATTRIBUTE12, SHIP_HEAD_ATTRIBUTE13 SHIP_HEAD_ATTRIBUTE13, SHIP_HEAD_ATTRIBUTE14 SHIP_HEAD_ATTRIBUTE14, SHIP_HEAD_ATTRIBUTE15 SHIP_HEAD_ATTRIBUTE15, SHIP_LINE_ATTRIBUTE_CATEGORY SHIP_LINE_ATTRIBUTE_CATEGORY, SHIP_LINE_ATTRIBUTE1 SHIP_LINE_ATTRIBUTE1, SHIP_LINE_ATTRIBUTE2 SHIP_LINE_ATTRIBUTE2, SHIP_LINE_ATTRIBUTE3 SHIP_LINE_ATTRIBUTE3, SHIP_LINE_ATTRIBUTE4 SHIP_LINE_ATTRIBUTE4, SHIP_LINE_ATTRIBUTE5 SHIP_LINE_ATTRIBUTE5, SHIP_LINE_ATTRIBUTE6 SHIP_LINE_ATTRIBUTE6, SHIP_LINE_ATTRIBUTE7 SHIP_LINE_ATTRIBUTE7, SHIP_LINE_ATTRIBUTE8 SHIP_LINE_ATTRIBUTE8, SHIP_LINE_ATTRIBUTE9 SHIP_LINE_ATTRIBUTE9, SHIP_LINE_ATTRIBUTE10 SHIP_LINE_ATTRIBUTE10, SHIP_LINE_ATTRIBUTE11 SHIP_LINE_ATTRIBUTE11, SHIP_LINE_ATTRIBUTE12 SHIP_LINE_ATTRIBUTE12, SHIP_LINE_ATTRIBUTE13 SHIP_LINE_ATTRIBUTE13, SHIP_LINE_ATTRIBUTE14 SHIP_LINE_ATTRIBUTE14, SHIP_LINE_ATTRIBUTE15 SHIP_LINE_ATTRIBUTE15, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT, REASON_ID REASON_ID, DESTINATION_CONTEXT DESTINATION_CONTEXT, SOURCE_DOC_QUANTITY SOURCE_DOC_QUANTITY, SOURCE_DOC_UNIT_OF_MEASURE SOURCE_DOC_UNIT_OF_MEASURE, MOVEMENT_ID MOVEMENT_ID, HEADER_INTERFACE_ID HEADER_INTERFACE_ID, VENDOR_CUM_SHIPPED_QTY VENDOR_CUM_SHIPPED_QTY, ITEM_NUM ITEM_NUM, DOCUMENT_NUM DOCUMENT_NUM, DOCUMENT_LINE_NUM DOCUMENT_LINE_NUM, TRUCK_NUM TRUCK_NUM, SHIP_TO_LOCATION_CODE SHIP_TO_LOCATION_CODE, CONTAINER_NUM CONTAINER_NUM, SUBSTITUTE_ITEM_NUM SUBSTITUTE_ITEM_NUM, NOTICE_UNIT_PRICE NOTICE_UNIT_PRICE, ITEM_CATEGORY ITEM_CATEGORY, LOCATION_CODE LOCATION_CODE, VENDOR_NAME VENDOR_NAME, VENDOR_NUM VENDOR_NUM, VENDOR_SITE_CODE VENDOR_SITE_CODE, FROM_ORGANIZATION_CODE FROM_ORGANIZATION_CODE, TO_ORGANIZATION_CODE TO_ORGANIZATION_CODE, INTRANSIT_OWNING_ORG_CODE INTRANSIT_OWNING_ORG_CODE, ROUTING_CODE ROUTING_CODE, ROUTING_STEP ROUTING_STEP, RELEASE_NUM RELEASE_NUM, DOCUMENT_SHIPMENT_LINE_NUM DOCUMENT_SHIPMENT_LINE_NUM, DOCUMENT_DISTRIBUTION_NUM DOCUMENT_DISTRIBUTION_NUM, DELIVER_TO_PERSON_NAME DELIVER_TO_PERSON_NAME, DELIVER_TO_LOCATION_CODE DELIVER_TO_LOCATION_CODE, USE_MTL_LOT USE_MTL_LOT, USE_MTL_SERIAL USE_MTL_SERIAL, LOCATOR LOCATOR, REASON_NAME REASON_NAME, VALIDATION_FLAG VALIDATION_FLAG, SUBSTITUTE_ITEM_ID SUBSTITUTE_ITEM_ID, QUANTITY_SHIPPED QUANTITY_SHIPPED, QUANTITY_INVOICED QUANTITY_INVOICED, TAX_NAME TAX_NAME, TAX_AMOUNT TAX_AMOUNT, REQ_NUM REQ_NUM, REQ_LINE_NUM REQ_LINE_NUM, REQ_DISTRIBUTION_NUM REQ_DISTRIBUTION_NUM, WIP_ENTITY_NAME WIP_ENTITY_NAME, WIP_LINE_CODE WIP_LINE_CODE, RESOURCE_CODE RESOURCE_CODE, SHIPMENT_LINE_STATUS_CODE SHIPMENT_LINE_STATUS_CODE, BARCODE_LABEL BARCODE_LABEL, TRANSFER_PERCENTAGE TRANSFER_PERCENTAGE, QA_COLLECTION_ID QA_COLLECTION_ID, COUNTRY_OF_ORIGIN_CODE COUNTRY_OF_ORIGIN_CODE, 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, CUSTOMER_ITEM_NUM CUSTOMER_ITEM_NUM, CREATE_DEBIT_MEMO_FLAG CREATE_DEBIT_MEMO_FLAG, PUT_AWAY_RULE_ID PUT_AWAY_RULE_ID, PUT_AWAY_STRATEGY_ID PUT_AWAY_STRATEGY_ID, LPN_ID LPN_ID, TRANSFER_LPN_ID TRANSFER_LPN_ID, COST_GROUP_ID COST_GROUP_ID, MOBILE_TXN MOBILE_TXN, MMTT_TEMP_ID MMTT_TEMP_ID, TRANSFER_COST_GROUP_ID TRANSFER_COST_GROUP_ID, SECONDARY_QUANTITY SECONDARY_QUANTITY, SECONDARY_UNIT_OF_MEASURE SECONDARY_UNIT_OF_MEASURE, SECONDARY_UOM_CODE SECONDARY_UOM_CODE, QC_GRADE QC_GRADE, FROM_LOCATOR FROM_LOCATOR, FROM_LOCATOR_ID FROM_LOCATOR_ID, PARENT_SOURCE_TRANSACTION_NUM PARENT_SOURCE_TRANSACTION_NUM, INTERFACE_AVAILABLE_QTY INTERFACE_AVAILABLE_QTY, INTERFACE_TRANSACTION_QTY INTERFACE_TRANSACTION_QTY, INTERFACE_AVAILABLE_AMT INTERFACE_AVAILABLE_AMT, INTERFACE_TRANSACTION_AMT INTERFACE_TRANSACTION_AMT, LICENSE_PLATE_NUMBER LICENSE_PLATE_NUMBER, SOURCE_TRANSACTION_NUM SOURCE_TRANSACTION_NUM, TRANSFER_LICENSE_PLATE_NUMBER TRANSFER_LICENSE_PLATE_NUMBER, LPN_GROUP_ID LPN_GROUP_ID, ORDER_TRANSACTION_ID ORDER_TRANSACTION_ID, CUSTOMER_ACCOUNT_NUMBER CUSTOMER_ACCOUNT_NUMBER, CUSTOMER_PARTY_NAME CUSTOMER_PARTY_NAME, OE_ORDER_LINE_NUM OE_ORDER_LINE_NUM, OE_ORDER_NUM OE_ORDER_NUM, PARENT_INTERFACE_TXN_ID PARENT_INTERFACE_TXN_ID, CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID, AMOUNT AMOUNT, JOB_ID JOB_ID, TIMECARD_ID TIMECARD_ID, TIMECARD_OVN TIMECARD_OVN, ERECORD_ID ERECORD_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, ASN_ATTACH_ID ASN_ATTACH_ID, ORG_ID ORG_ID, OPERATING_UNIT OPERATING_UNIT, REQUESTED_AMOUNT REQUESTED_AMOUNT, MATERIAL_STORED_AMOUNT MATERIAL_STORED_AMOUNT, AMOUNT_SHIPPED AMOUNT_SHIPPED, MATCHING_BASIS MATCHING_BASIS, REPLENISH_ORDER_LINE_ID REPLENISH_ORDER_LINE_ID, EXPRESS_TRANSACTION EXPRESS_TRANSACTION, LCM_SHIPMENT_LINE_ID LCM_SHIPMENT_LINE_ID, UNIT_LANDED_COST UNIT_LANDED_COST, LCM_ADJUSTMENT_NUM LCM_ADJUSTMENT_NUM from "PO"."RCV_TRANSACTIONS_INTERFACE"

View Text - HTML Formatted

SELECT INTERFACE_TRANSACTION_ID INTERFACE_TRANSACTION_ID
, GROUP_ID GROUP_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
, PROCESSING_STATUS_CODE PROCESSING_STATUS_CODE
, PROCESSING_MODE_CODE PROCESSING_MODE_CODE
, PROCESSING_REQUEST_ID PROCESSING_REQUEST_ID
, TRANSACTION_STATUS_CODE TRANSACTION_STATUS_CODE
, CATEGORY_ID CATEGORY_ID
, QUANTITY QUANTITY
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, INTERFACE_SOURCE_CODE INTERFACE_SOURCE_CODE
, INTERFACE_SOURCE_LINE_ID INTERFACE_SOURCE_LINE_ID
, INV_TRANSACTION_ID INV_TRANSACTION_ID
, ITEM_ID ITEM_ID
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, ITEM_REVISION ITEM_REVISION
, UOM_CODE UOM_CODE
, EMPLOYEE_ID EMPLOYEE_ID
, AUTO_TRANSACT_CODE AUTO_TRANSACT_CODE
, SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID
, SHIPMENT_LINE_ID SHIPMENT_LINE_ID
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, PRIMARY_QUANTITY PRIMARY_QUANTITY
, PRIMARY_UNIT_OF_MEASURE PRIMARY_UNIT_OF_MEASURE
, RECEIPT_SOURCE_CODE RECEIPT_SOURCE_CODE
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID
, FROM_SUBINVENTORY FROM_SUBINVENTORY
, TO_ORGANIZATION_ID TO_ORGANIZATION_ID
, INTRANSIT_OWNING_ORG_ID INTRANSIT_OWNING_ORG_ID
, ROUTING_HEADER_ID ROUTING_HEADER_ID
, ROUTING_STEP_ID ROUTING_STEP_ID
, SOURCE_DOCUMENT_CODE SOURCE_DOCUMENT_CODE
, PARENT_TRANSACTION_ID PARENT_TRANSACTION_ID
, PO_HEADER_ID PO_HEADER_ID
, PO_REVISION_NUM PO_REVISION_NUM
, PO_RELEASE_ID PO_RELEASE_ID
, PO_LINE_ID PO_LINE_ID
, PO_LINE_LOCATION_ID PO_LINE_LOCATION_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
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, REQUISITION_LINE_ID REQUISITION_LINE_ID
, REQ_DISTRIBUTION_ID REQ_DISTRIBUTION_ID
, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_ID
, SUBSTITUTE_UNORDERED_CODE SUBSTITUTE_UNORDERED_CODE
, RECEIPT_EXCEPTION_FLAG RECEIPT_EXCEPTION_FLAG
, ACCRUAL_STATUS_CODE ACCRUAL_STATUS_CODE
, INSPECTION_STATUS_CODE INSPECTION_STATUS_CODE
, INSPECTION_QUALITY_CODE INSPECTION_QUALITY_CODE
, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE
, DELIVER_TO_PERSON_ID DELIVER_TO_PERSON_ID
, LOCATION_ID LOCATION_ID
, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID
, SUBINVENTORY SUBINVENTORY
, LOCATOR_ID LOCATOR_ID
, WIP_ENTITY_ID WIP_ENTITY_ID
, WIP_LINE_ID WIP_LINE_ID
, DEPARTMENT_CODE DEPARTMENT_CODE
, 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
, SHIPMENT_NUM SHIPMENT_NUM
, FREIGHT_CARRIER_CODE FREIGHT_CARRIER_CODE
, BILL_OF_LADING BILL_OF_LADING
, PACKING_SLIP PACKING_SLIP
, SHIPPED_DATE SHIPPED_DATE
, EXPECTED_RECEIPT_DATE EXPECTED_RECEIPT_DATE
, ACTUAL_COST ACTUAL_COST
, TRANSFER_COST TRANSFER_COST
, TRANSPORTATION_COST TRANSPORTATION_COST
, TRANSPORTATION_ACCOUNT_ID TRANSPORTATION_ACCOUNT_ID
, NUM_OF_CONTAINERS NUM_OF_CONTAINERS
, WAYBILL_AIRBILL_NUM WAYBILL_AIRBILL_NUM
, VENDOR_ITEM_NUM VENDOR_ITEM_NUM
, 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
, SHIP_HEAD_ATTRIBUTE_CATEGORY SHIP_HEAD_ATTRIBUTE_CATEGORY
, SHIP_HEAD_ATTRIBUTE1 SHIP_HEAD_ATTRIBUTE1
, SHIP_HEAD_ATTRIBUTE2 SHIP_HEAD_ATTRIBUTE2
, SHIP_HEAD_ATTRIBUTE3 SHIP_HEAD_ATTRIBUTE3
, SHIP_HEAD_ATTRIBUTE4 SHIP_HEAD_ATTRIBUTE4
, SHIP_HEAD_ATTRIBUTE5 SHIP_HEAD_ATTRIBUTE5
, SHIP_HEAD_ATTRIBUTE6 SHIP_HEAD_ATTRIBUTE6
, SHIP_HEAD_ATTRIBUTE7 SHIP_HEAD_ATTRIBUTE7
, SHIP_HEAD_ATTRIBUTE8 SHIP_HEAD_ATTRIBUTE8
, SHIP_HEAD_ATTRIBUTE9 SHIP_HEAD_ATTRIBUTE9
, SHIP_HEAD_ATTRIBUTE10 SHIP_HEAD_ATTRIBUTE10
, SHIP_HEAD_ATTRIBUTE11 SHIP_HEAD_ATTRIBUTE11
, SHIP_HEAD_ATTRIBUTE12 SHIP_HEAD_ATTRIBUTE12
, SHIP_HEAD_ATTRIBUTE13 SHIP_HEAD_ATTRIBUTE13
, SHIP_HEAD_ATTRIBUTE14 SHIP_HEAD_ATTRIBUTE14
, SHIP_HEAD_ATTRIBUTE15 SHIP_HEAD_ATTRIBUTE15
, SHIP_LINE_ATTRIBUTE_CATEGORY SHIP_LINE_ATTRIBUTE_CATEGORY
, SHIP_LINE_ATTRIBUTE1 SHIP_LINE_ATTRIBUTE1
, SHIP_LINE_ATTRIBUTE2 SHIP_LINE_ATTRIBUTE2
, SHIP_LINE_ATTRIBUTE3 SHIP_LINE_ATTRIBUTE3
, SHIP_LINE_ATTRIBUTE4 SHIP_LINE_ATTRIBUTE4
, SHIP_LINE_ATTRIBUTE5 SHIP_LINE_ATTRIBUTE5
, SHIP_LINE_ATTRIBUTE6 SHIP_LINE_ATTRIBUTE6
, SHIP_LINE_ATTRIBUTE7 SHIP_LINE_ATTRIBUTE7
, SHIP_LINE_ATTRIBUTE8 SHIP_LINE_ATTRIBUTE8
, SHIP_LINE_ATTRIBUTE9 SHIP_LINE_ATTRIBUTE9
, SHIP_LINE_ATTRIBUTE10 SHIP_LINE_ATTRIBUTE10
, SHIP_LINE_ATTRIBUTE11 SHIP_LINE_ATTRIBUTE11
, SHIP_LINE_ATTRIBUTE12 SHIP_LINE_ATTRIBUTE12
, SHIP_LINE_ATTRIBUTE13 SHIP_LINE_ATTRIBUTE13
, SHIP_LINE_ATTRIBUTE14 SHIP_LINE_ATTRIBUTE14
, SHIP_LINE_ATTRIBUTE15 SHIP_LINE_ATTRIBUTE15
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT
, REASON_ID REASON_ID
, DESTINATION_CONTEXT DESTINATION_CONTEXT
, SOURCE_DOC_QUANTITY SOURCE_DOC_QUANTITY
, SOURCE_DOC_UNIT_OF_MEASURE SOURCE_DOC_UNIT_OF_MEASURE
, MOVEMENT_ID MOVEMENT_ID
, HEADER_INTERFACE_ID HEADER_INTERFACE_ID
, VENDOR_CUM_SHIPPED_QTY VENDOR_CUM_SHIPPED_QTY
, ITEM_NUM ITEM_NUM
, DOCUMENT_NUM DOCUMENT_NUM
, DOCUMENT_LINE_NUM DOCUMENT_LINE_NUM
, TRUCK_NUM TRUCK_NUM
, SHIP_TO_LOCATION_CODE SHIP_TO_LOCATION_CODE
, CONTAINER_NUM CONTAINER_NUM
, SUBSTITUTE_ITEM_NUM SUBSTITUTE_ITEM_NUM
, NOTICE_UNIT_PRICE NOTICE_UNIT_PRICE
, ITEM_CATEGORY ITEM_CATEGORY
, LOCATION_CODE LOCATION_CODE
, VENDOR_NAME VENDOR_NAME
, VENDOR_NUM VENDOR_NUM
, VENDOR_SITE_CODE VENDOR_SITE_CODE
, FROM_ORGANIZATION_CODE FROM_ORGANIZATION_CODE
, TO_ORGANIZATION_CODE TO_ORGANIZATION_CODE
, INTRANSIT_OWNING_ORG_CODE INTRANSIT_OWNING_ORG_CODE
, ROUTING_CODE ROUTING_CODE
, ROUTING_STEP ROUTING_STEP
, RELEASE_NUM RELEASE_NUM
, DOCUMENT_SHIPMENT_LINE_NUM DOCUMENT_SHIPMENT_LINE_NUM
, DOCUMENT_DISTRIBUTION_NUM DOCUMENT_DISTRIBUTION_NUM
, DELIVER_TO_PERSON_NAME DELIVER_TO_PERSON_NAME
, DELIVER_TO_LOCATION_CODE DELIVER_TO_LOCATION_CODE
, USE_MTL_LOT USE_MTL_LOT
, USE_MTL_SERIAL USE_MTL_SERIAL
, LOCATOR LOCATOR
, REASON_NAME REASON_NAME
, VALIDATION_FLAG VALIDATION_FLAG
, SUBSTITUTE_ITEM_ID SUBSTITUTE_ITEM_ID
, QUANTITY_SHIPPED QUANTITY_SHIPPED
, QUANTITY_INVOICED QUANTITY_INVOICED
, TAX_NAME TAX_NAME
, TAX_AMOUNT TAX_AMOUNT
, REQ_NUM REQ_NUM
, REQ_LINE_NUM REQ_LINE_NUM
, REQ_DISTRIBUTION_NUM REQ_DISTRIBUTION_NUM
, WIP_ENTITY_NAME WIP_ENTITY_NAME
, WIP_LINE_CODE WIP_LINE_CODE
, RESOURCE_CODE RESOURCE_CODE
, SHIPMENT_LINE_STATUS_CODE SHIPMENT_LINE_STATUS_CODE
, BARCODE_LABEL BARCODE_LABEL
, TRANSFER_PERCENTAGE TRANSFER_PERCENTAGE
, QA_COLLECTION_ID QA_COLLECTION_ID
, COUNTRY_OF_ORIGIN_CODE COUNTRY_OF_ORIGIN_CODE
, 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
, CUSTOMER_ITEM_NUM CUSTOMER_ITEM_NUM
, CREATE_DEBIT_MEMO_FLAG CREATE_DEBIT_MEMO_FLAG
, PUT_AWAY_RULE_ID PUT_AWAY_RULE_ID
, PUT_AWAY_STRATEGY_ID PUT_AWAY_STRATEGY_ID
, LPN_ID LPN_ID
, TRANSFER_LPN_ID TRANSFER_LPN_ID
, COST_GROUP_ID COST_GROUP_ID
, MOBILE_TXN MOBILE_TXN
, MMTT_TEMP_ID MMTT_TEMP_ID
, TRANSFER_COST_GROUP_ID TRANSFER_COST_GROUP_ID
, SECONDARY_QUANTITY SECONDARY_QUANTITY
, SECONDARY_UNIT_OF_MEASURE SECONDARY_UNIT_OF_MEASURE
, SECONDARY_UOM_CODE SECONDARY_UOM_CODE
, QC_GRADE QC_GRADE
, FROM_LOCATOR FROM_LOCATOR
, FROM_LOCATOR_ID FROM_LOCATOR_ID
, PARENT_SOURCE_TRANSACTION_NUM PARENT_SOURCE_TRANSACTION_NUM
, INTERFACE_AVAILABLE_QTY INTERFACE_AVAILABLE_QTY
, INTERFACE_TRANSACTION_QTY INTERFACE_TRANSACTION_QTY
, INTERFACE_AVAILABLE_AMT INTERFACE_AVAILABLE_AMT
, INTERFACE_TRANSACTION_AMT INTERFACE_TRANSACTION_AMT
, LICENSE_PLATE_NUMBER LICENSE_PLATE_NUMBER
, SOURCE_TRANSACTION_NUM SOURCE_TRANSACTION_NUM
, TRANSFER_LICENSE_PLATE_NUMBER TRANSFER_LICENSE_PLATE_NUMBER
, LPN_GROUP_ID LPN_GROUP_ID
, ORDER_TRANSACTION_ID ORDER_TRANSACTION_ID
, CUSTOMER_ACCOUNT_NUMBER CUSTOMER_ACCOUNT_NUMBER
, CUSTOMER_PARTY_NAME CUSTOMER_PARTY_NAME
, OE_ORDER_LINE_NUM OE_ORDER_LINE_NUM
, OE_ORDER_NUM OE_ORDER_NUM
, PARENT_INTERFACE_TXN_ID PARENT_INTERFACE_TXN_ID
, CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID
, AMOUNT AMOUNT
, JOB_ID JOB_ID
, TIMECARD_ID TIMECARD_ID
, TIMECARD_OVN TIMECARD_OVN
, ERECORD_ID ERECORD_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, ASN_ATTACH_ID ASN_ATTACH_ID
, ORG_ID ORG_ID
, OPERATING_UNIT OPERATING_UNIT
, REQUESTED_AMOUNT REQUESTED_AMOUNT
, MATERIAL_STORED_AMOUNT MATERIAL_STORED_AMOUNT
, AMOUNT_SHIPPED AMOUNT_SHIPPED
, MATCHING_BASIS MATCHING_BASIS
, REPLENISH_ORDER_LINE_ID REPLENISH_ORDER_LINE_ID
, EXPRESS_TRANSACTION EXPRESS_TRANSACTION
, LCM_SHIPMENT_LINE_ID LCM_SHIPMENT_LINE_ID
, UNIT_LANDED_COST UNIT_LANDED_COST
, LCM_ADJUSTMENT_NUM LCM_ADJUSTMENT_NUM
FROM "PO"."RCV_TRANSACTIONS_INTERFACE"