MSC_INTERORG_SHIP_METHODSRC

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
TRANSACTION_ID PLAN_ID ORIGIN_TYPE ORIGIN_ID DESTINATION_TYPE DESTINATION_ID SHIP_METHOD CARRIER_ID MODE_OF_TRANSPORT SERVICE_LEVEL TRANSIT_TIME_ID INTRANSIT_TIME TIME_UOM_CODE DEFAULT_FLAG COLLECTED_FLAG WEIGHT_CAPACITY WEIGHT_UOM VOLUME_CAPACITY VOLUME_UOM COST_PER_WEIGHT_UNIT COST_PER_VOLUME_UNIT TRANSPORT_CAP_OVER_UTIL_COST SHIPMENT_WEIGHT SHIPMENT_VOLUME SHIPMENT_WEIGHT_UOM SHIPMENT_VOLUME_UOM CURRENCY LEADTIME_VARIABILITY SHIP_METHOD_TEXT REFRESH_NUMBER LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15

Name

TRANSACTION_ID

PLAN_ID

ORIGIN_TYPE

ORIGIN_ID

DESTINATION_TYPE

DESTINATION_ID

SHIP_METHOD

CARRIER_ID

MODE_OF_TRANSPORT

SERVICE_LEVEL

TRANSIT_TIME_ID

INTRANSIT_TIME

TIME_UOM_CODE

DEFAULT_FLAG

COLLECTED_FLAG

WEIGHT_CAPACITY

WEIGHT_UOM

VOLUME_CAPACITY

VOLUME_UOM

COST_PER_WEIGHT_UNIT

COST_PER_VOLUME_UNIT

TRANSPORT_CAP_OVER_UTIL_COST

SHIPMENT_WEIGHT

SHIPMENT_VOLUME

SHIPMENT_WEIGHT_UOM

SHIPMENT_VOLUME_UOM

CURRENCY

LEADTIME_VARIABILITY

SHIP_METHOD_TEXT

REFRESH_NUMBER

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

Query

SQL_Statement
select "TRANSACTION_ID","PLAN_ID","ORIGIN_TYPE","ORIGIN_ID","DESTINATION_TYPE","DESTINATION_ID","SHIP_METHOD","CARRIER_ID","MODE_OF_TRANSPORT","SERVICE_LEVEL","TRANSIT_TIME_ID","INTRANSIT_TIME","TIME_UOM_CODE","DEFAULT_FLAG","COLLECTED_FLAG","WEIGHT_CAPACITY","WEIGHT_UOM","VOLUME_CAPACITY","VOLUME_UOM","COST_PER_WEIGHT_UNIT","COST_PER_VOLUME_UNIT","TRANSPORT_CAP_OVER_UTIL_COST","SHIPMENT_WEIGHT","SHIPMENT_VOLUME","SHIPMENT_WEIGHT_UOM","SHIPMENT_VOLUME_UOM","CURRENCY","LEADTIME_VARIABILITY","SHIP_METHOD_TEXT","REFRESH_NUMBER","LAST_UPDATE_DATE","LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN","OBJECT_VERSION_NUMBER","ATTRIBUTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE8","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15" from msc_interorg_ship_methods as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))

SQL_Statement

select "TRANSACTION_ID","PLAN_ID","ORIGIN_TYPE","ORIGIN_ID","DESTINATION_TYPE","DESTINATION_ID","SHIP_METHOD","CARRIER_ID","MODE_OF_TRANSPORT","SERVICE_LEVEL","TRANSIT_TIME_ID","INTRANSIT_TIME","TIME_UOM_CODE","DEFAULT_FLAG","COLLECTED_FLAG","WEIGHT_CAPACITY","WEIGHT_UOM","VOLUME_CAPACITY","VOLUME_UOM","COST_PER_WEIGHT_UNIT","COST_PER_VOLUME_UNIT","TRANSPORT_CAP_OVER_UTIL_COST","SHIPMENT_WEIGHT","SHIPMENT_VOLUME","SHIPMENT_WEIGHT_UOM","SHIPMENT_VOLUME_UOM","CURRENCY","LEADTIME_VARIABILITY","SHIP_METHOD_TEXT","REFRESH_NUMBER","LAST_UPDATE_DATE","LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN","OBJECT_VERSION_NUMBER","ATTRIBUTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE8","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15" from msc_interorg_ship_methods as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))