VIEW: PO.RCV_SHIPMENT_LINES#

Source

View Text - Preformatted

select SHIPMENT_LINE_ID SHIPMENT_LINE_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, SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID, LINE_NUM LINE_NUM, CATEGORY_ID CATEGORY_ID, QUANTITY_SHIPPED QUANTITY_SHIPPED, QUANTITY_RECEIVED QUANTITY_RECEIVED, UNIT_OF_MEASURE UNIT_OF_MEASURE, ITEM_DESCRIPTION ITEM_DESCRIPTION, ITEM_ID ITEM_ID, ITEM_REVISION ITEM_REVISION, VENDOR_ITEM_NUM VENDOR_ITEM_NUM, VENDOR_LOT_NUM VENDOR_LOT_NUM, UOM_CONVERSION_RATE UOM_CONVERSION_RATE, SHIPMENT_LINE_STATUS_CODE SHIPMENT_LINE_STATUS_CODE, SOURCE_DOCUMENT_CODE SOURCE_DOCUMENT_CODE, 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, REQUISITION_LINE_ID REQUISITION_LINE_ID, REQ_DISTRIBUTION_ID REQ_DISTRIBUTION_ID, ROUTING_HEADER_ID ROUTING_HEADER_ID, PACKING_SLIP PACKING_SLIP, FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID, DELIVER_TO_PERSON_ID DELIVER_TO_PERSON_ID, EMPLOYEE_ID EMPLOYEE_ID, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE, TO_ORGANIZATION_ID TO_ORGANIZATION_ID, TO_SUBINVENTORY TO_SUBINVENTORY, LOCATOR_ID LOCATOR_ID, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_ID, TRANSPORTATION_ACCOUNT_ID TRANSPORTATION_ACCOUNT_ID, SHIPMENT_UNIT_PRICE SHIPMENT_UNIT_PRICE, TRANSFER_COST TRANSFER_COST, TRANSPORTATION_COST TRANSPORTATION_COST, 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, REASON_ID REASON_ID, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, DESTINATION_CONTEXT DESTINATION_CONTEXT, PRIMARY_UNIT_OF_MEASURE PRIMARY_UNIT_OF_MEASURE, EXCESS_TRANSPORT_REASON EXCESS_TRANSPORT_REASON, EXCESS_TRANSPORT_RESPONSIBLE EXCESS_TRANSPORT_RESPONSIBLE, EXCESS_TRANSPORT_AUTH_NUM EXCESS_TRANSPORT_AUTH_NUM, ASN_LINE_FLAG ASN_LINE_FLAG, ORIGINAL_ASN_PARENT_LINE_ID ORIGINAL_ASN_PARENT_LINE_ID, ORIGINAL_ASN_LINE_FLAG ORIGINAL_ASN_LINE_FLAG, VENDOR_CUM_SHIPPED_QUANTITY VENDOR_CUM_SHIPPED_QUANTITY, NOTICE_UNIT_PRICE NOTICE_UNIT_PRICE, TAX_NAME TAX_NAME, TAX_AMOUNT TAX_AMOUNT, INVOICE_STATUS_CODE INVOICE_STATUS_CODE, CUM_COMPARISON_FLAG CUM_COMPARISON_FLAG, CONTAINER_NUM CONTAINER_NUM, TRUCK_NUM TRUCK_NUM, BAR_CODE_LABEL BAR_CODE_LABEL, TRANSFER_PERCENTAGE TRANSFER_PERCENTAGE, MRC_SHIPMENT_UNIT_PRICE MRC_SHIPMENT_UNIT_PRICE, MRC_TRANSFER_COST MRC_TRANSFER_COST, MRC_TRANSPORTATION_COST MRC_TRANSPORTATION_COST, MRC_NOTICE_UNIT_PRICE MRC_NOTICE_UNIT_PRICE, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_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_ITEM_NUM CUSTOMER_ITEM_NUM, COST_GROUP_ID COST_GROUP_ID, SECONDARY_QUANTITY_SHIPPED SECONDARY_QUANTITY_SHIPPED, SECONDARY_QUANTITY_RECEIVED SECONDARY_QUANTITY_RECEIVED, SECONDARY_UNIT_OF_MEASURE SECONDARY_UNIT_OF_MEASURE, QC_GRADE QC_GRADE, MMT_TRANSACTION_ID MMT_TRANSACTION_ID, ASN_LPN_ID ASN_LPN_ID, AMOUNT AMOUNT, AMOUNT_RECEIVED AMOUNT_RECEIVED, JOB_ID JOB_ID, TIMECARD_ID TIMECARD_ID, TIMECARD_OVN TIMECARD_OVN, OSA_FLAG OSA_FLAG, REQUESTED_AMOUNT REQUESTED_AMOUNT, MATERIAL_STORED_AMOUNT MATERIAL_STORED_AMOUNT, APPROVAL_STATUS APPROVAL_STATUS, AMOUNT_SHIPPED AMOUNT_SHIPPED, LCM_SHIPMENT_LINE_ID LCM_SHIPMENT_LINE_ID, UNIT_LANDED_COST UNIT_LANDED_COST from "PO"."RCV_SHIPMENT_LINES"

View Text - HTML Formatted

SELECT SHIPMENT_LINE_ID SHIPMENT_LINE_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
, SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID
, LINE_NUM LINE_NUM
, CATEGORY_ID CATEGORY_ID
, QUANTITY_SHIPPED QUANTITY_SHIPPED
, QUANTITY_RECEIVED QUANTITY_RECEIVED
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, ITEM_ID ITEM_ID
, ITEM_REVISION ITEM_REVISION
, VENDOR_ITEM_NUM VENDOR_ITEM_NUM
, VENDOR_LOT_NUM VENDOR_LOT_NUM
, UOM_CONVERSION_RATE UOM_CONVERSION_RATE
, SHIPMENT_LINE_STATUS_CODE SHIPMENT_LINE_STATUS_CODE
, SOURCE_DOCUMENT_CODE SOURCE_DOCUMENT_CODE
, 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
, REQUISITION_LINE_ID REQUISITION_LINE_ID
, REQ_DISTRIBUTION_ID REQ_DISTRIBUTION_ID
, ROUTING_HEADER_ID ROUTING_HEADER_ID
, PACKING_SLIP PACKING_SLIP
, FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID
, DELIVER_TO_PERSON_ID DELIVER_TO_PERSON_ID
, EMPLOYEE_ID EMPLOYEE_ID
, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE
, TO_ORGANIZATION_ID TO_ORGANIZATION_ID
, TO_SUBINVENTORY TO_SUBINVENTORY
, LOCATOR_ID LOCATOR_ID
, DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID
, CHARGE_ACCOUNT_ID CHARGE_ACCOUNT_ID
, TRANSPORTATION_ACCOUNT_ID TRANSPORTATION_ACCOUNT_ID
, SHIPMENT_UNIT_PRICE SHIPMENT_UNIT_PRICE
, TRANSFER_COST TRANSFER_COST
, TRANSPORTATION_COST TRANSPORTATION_COST
, 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
, REASON_ID REASON_ID
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, DESTINATION_CONTEXT DESTINATION_CONTEXT
, PRIMARY_UNIT_OF_MEASURE PRIMARY_UNIT_OF_MEASURE
, EXCESS_TRANSPORT_REASON EXCESS_TRANSPORT_REASON
, EXCESS_TRANSPORT_RESPONSIBLE EXCESS_TRANSPORT_RESPONSIBLE
, EXCESS_TRANSPORT_AUTH_NUM EXCESS_TRANSPORT_AUTH_NUM
, ASN_LINE_FLAG ASN_LINE_FLAG
, ORIGINAL_ASN_PARENT_LINE_ID ORIGINAL_ASN_PARENT_LINE_ID
, ORIGINAL_ASN_LINE_FLAG ORIGINAL_ASN_LINE_FLAG
, VENDOR_CUM_SHIPPED_QUANTITY VENDOR_CUM_SHIPPED_QUANTITY
, NOTICE_UNIT_PRICE NOTICE_UNIT_PRICE
, TAX_NAME TAX_NAME
, TAX_AMOUNT TAX_AMOUNT
, INVOICE_STATUS_CODE INVOICE_STATUS_CODE
, CUM_COMPARISON_FLAG CUM_COMPARISON_FLAG
, CONTAINER_NUM CONTAINER_NUM
, TRUCK_NUM TRUCK_NUM
, BAR_CODE_LABEL BAR_CODE_LABEL
, TRANSFER_PERCENTAGE TRANSFER_PERCENTAGE
, MRC_SHIPMENT_UNIT_PRICE MRC_SHIPMENT_UNIT_PRICE
, MRC_TRANSFER_COST MRC_TRANSFER_COST
, MRC_TRANSPORTATION_COST MRC_TRANSPORTATION_COST
, MRC_NOTICE_UNIT_PRICE MRC_NOTICE_UNIT_PRICE
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_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_ITEM_NUM CUSTOMER_ITEM_NUM
, COST_GROUP_ID COST_GROUP_ID
, SECONDARY_QUANTITY_SHIPPED SECONDARY_QUANTITY_SHIPPED
, SECONDARY_QUANTITY_RECEIVED SECONDARY_QUANTITY_RECEIVED
, SECONDARY_UNIT_OF_MEASURE SECONDARY_UNIT_OF_MEASURE
, QC_GRADE QC_GRADE
, MMT_TRANSACTION_ID MMT_TRANSACTION_ID
, ASN_LPN_ID ASN_LPN_ID
, AMOUNT AMOUNT
, AMOUNT_RECEIVED AMOUNT_RECEIVED
, JOB_ID JOB_ID
, TIMECARD_ID TIMECARD_ID
, TIMECARD_OVN TIMECARD_OVN
, OSA_FLAG OSA_FLAG
, REQUESTED_AMOUNT REQUESTED_AMOUNT
, MATERIAL_STORED_AMOUNT MATERIAL_STORED_AMOUNT
, APPROVAL_STATUS APPROVAL_STATUS
, AMOUNT_SHIPPED AMOUNT_SHIPPED
, LCM_SHIPMENT_LINE_ID LCM_SHIPMENT_LINE_ID
, UNIT_LANDED_COST UNIT_LANDED_COST
FROM "PO"."RCV_SHIPMENT_LINES"