View: RCV_SHIPMENT_LINES_MRC_V

View Text

SELECT SHIPMENT_LINE_ID
, TO_NUMBER(SUBSTRB( SUBSTRB(MRC_SHIPMENT_UNIT_PRICE
, INSTR(MRC_SHIPMENT_UNIT_PRICE
, '<'||RTRIM(SUBSTRB(USERENV( 'CLIENT_INFO')
, 45
, 10)
, ' ')|| '>')+1)
, INSTR( SUBSTRB(MRC_SHIPMENT_UNIT_PRICE
, INSTR(MRC_SHIPMENT_UNIT_PRICE
, '<'|| RTRIM(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10)
, ' ')||'>')+1)
, '>') + 1
, ( INSTR( SUBSTRB(MRC_SHIPMENT_UNIT_PRICE
, INSTR(MRC_SHIPMENT_UNIT_PRICE
, '<'|| RTRIM(SUBSTRB(USERENV( 'CLIENT_INFO')
, 45
, 10)
, ' ')||'>')+1)
, '<') - INSTR( SUBSTRB(MRC_SHIPMENT_UNIT_PRICE
, INSTR(MRC_SHIPMENT_UNIT_PRICE
, '<'|| RTRIM(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10)
, ' ')||'>')+1)
, '>' ) - 1))
, 'FM99999999999999999999999999999999999999.999999999999999')
, TO_NUMBER(SUBSTRB( SUBSTRB(MRC_TRANSFER_COST
, INSTR(MRC_TRANSFER_COST
, '<'|| RTRIM(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10)
, ' ')||'>')+1)
, INSTR( SUBSTRB(MRC_TRANSFER_COST
, INSTR(MRC_TRANSFER_COST
, '<'|| RTRIM(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10)
, ' ')||'>')+1)
, '>') + 1
, ( INSTR( SUBSTRB(MRC_TRANSFER_COST
, INSTR(MRC_TRANSFER_COST
, '<'|| RTRIM(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10)
, ' ')||'>')+1)
, '<') - INSTR( SUBSTRB(MRC_TRANSFER_COST
, INSTR(MRC_TRANSFER_COST
, '<'|| RTRIM(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10)
, ' ')||'>')+1)
, '>' ) - 1))
, 'FM99999999999999999999999999999999999999.999999999999999')
, TO_NUMBER(SUBSTRB( SUBSTRB(MRC_TRANSPORTATION_COST
, INSTR(MRC_TRANSPORTATION_COST
, '<'|| RTRIM(SUBSTRB(USERENV( 'CLIENT_INFO')
, 45
, 10)
, ' ')||'>')+1)
, INSTR( SUBSTRB(MRC_TRANSPORTATION_COST
, INSTR(MRC_TRANSPORTATION_COST
, '<'|| RTRIM(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10)
, ' ')||'>')+1)
, '>') + 1
, ( INSTR( SUBSTRB(MRC_TRANSPORTATION_COST
, INSTR(MRC_TRANSPORTATION_COST
, '<'|| RTRIM(SUBSTRB(USERENV( 'CLIENT_INFO')
, 45
, 10)
, ' ')||'>')+1)
, '<') - INSTR( SUBSTRB(MRC_TRANSPORTATION_COST
, INSTR(MRC_TRANSPORTATION_COST
, '<'|| RTRIM(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10)
, ' ')||'>')+1)
, '>' ) - 1))
, 'FM99999999999999999999999999999999999999.999999999999999')
, TO_NUMBER(SUBSTRB( SUBSTRB(MRC_NOTICE_UNIT_PRICE
, INSTR(MRC_NOTICE_UNIT_PRICE
, '<'|| RTRIM(SUBSTRB(USERENV( 'CLIENT_INFO')
, 45
, 10)
, ' ')||'>')+1)
, INSTR( SUBSTRB(MRC_NOTICE_UNIT_PRICE
, INSTR(MRC_NOTICE_UNIT_PRICE
, '<'|| RTRIM(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10)
, ' ')||'>')+1)
, '>') + 1
, ( INSTR( SUBSTRB(MRC_NOTICE_UNIT_PRICE
, INSTR(MRC_NOTICE_UNIT_PRICE
, '<'|| RTRIM(SUBSTRB(USERENV( 'CLIENT_INFO')
, 45
, 10)
, ' ')||'>')+1)
, '<') - INSTR( SUBSTRB(MRC_NOTICE_UNIT_PRICE
, INSTR(MRC_NOTICE_UNIT_PRICE
, '<'|| RTRIM(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10)
, ' ')||'>')+1)
, '>' ) - 1))
, 'FM99999999999999999999999999999999999999.999999999999999')
, TAX_AMOUNT
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SHIPMENT_HEADER_ID
, LINE_NUM
, CATEGORY_ID
, QUANTITY_SHIPPED
, QUANTITY_RECEIVED
, UNIT_OF_MEASURE
, ITEM_DESCRIPTION
, ITEM_ID
, ITEM_REVISION
, VENDOR_ITEM_NUM
, VENDOR_LOT_NUM
, UOM_CONVERSION_RATE
, SHIPMENT_LINE_STATUS_CODE
, SOURCE_DOCUMENT_CODE
, PO_HEADER_ID
, PO_RELEASE_ID
, PO_LINE_ID
, PO_LINE_LOCATION_ID
, PO_DISTRIBUTION_ID
, REQUISITION_LINE_ID
, REQ_DISTRIBUTION_ID
, ROUTING_HEADER_ID
, PACKING_SLIP
, FROM_ORGANIZATION_ID
, DELIVER_TO_PERSON_ID
, EMPLOYEE_ID
, DESTINATION_TYPE_CODE
, TO_ORGANIZATION_ID
, TO_SUBINVENTORY
, LOCATOR_ID
, DELIVER_TO_LOCATION_ID
, CHARGE_ACCOUNT_ID
, TRANSPORTATION_ACCOUNT_ID
, COMMENTS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REASON_ID
, USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, DESTINATION_CONTEXT
, PRIMARY_UNIT_OF_MEASURE
, TAX_NAME
, INVOICE_STATUS_CODE
, EXCESS_TRANSPORT_REASON
, EXCESS_TRANSPORT_RESPONSIBLE
, EXCESS_TRANSPORT_AUTH_NUM
, ASN_LINE_FLAG
, ORIGINAL_ASN_PARENT_LINE_ID
, ORIGINAL_ASN_LINE_FLAG
, VENDOR_CUM_SHIPPED_QUANTITY
, CUM_COMPARISON_FLAG
, CONTAINER_NUM
, TRUCK_NUM
, BAR_CODE_LABEL
, TRANSFER_PERCENTAGE
, MRC_SHIPMENT_UNIT_PRICE
, MRC_TRANSFER_COST
, MRC_TRANSPORTATION_COST
, MRC_NOTICE_UNIT_PRICE
, SHIP_TO_LOCATION_ID
, COUNTRY_OF_ORIGIN_CODE
FROM RCV_SHIPMENT_LINES

Columns