MSC_TRADING_PARTNER_SITESRC

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
PARTNER_SITE_ID SR_TP_SITE_ID SR_INSTANCE_ID PARTNER_ID PARTNER_NAME PARTNER_ADDRESS TP_SITE_CODE SR_TP_ID LOCATION LOCATION_ID PARTNER_TYPE DELETED_FLAG LONGITUDE LATITUDE REFRESH_NUMBER LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 OPERATING_UNIT_NAME COUNTRY STATE CITY POSTAL_CODE SHIPPING_CONTROL ATTRIBUTE8

Name

PARTNER_SITE_ID

SR_TP_SITE_ID

SR_INSTANCE_ID

PARTNER_ID

PARTNER_NAME

PARTNER_ADDRESS

TP_SITE_CODE

SR_TP_ID

LOCATION

LOCATION_ID

PARTNER_TYPE

DELETED_FLAG

LONGITUDE

LATITUDE

REFRESH_NUMBER

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

OPERATING_UNIT_NAME

COUNTRY

STATE

CITY

POSTAL_CODE

SHIPPING_CONTROL

ATTRIBUTE8

Query

SQL_Statement
select "PARTNER_SITE_ID","SR_TP_SITE_ID","SR_INSTANCE_ID","PARTNER_ID","PARTNER_NAME","PARTNER_ADDRESS","TP_SITE_CODE","SR_TP_ID","LOCATION","LOCATION_ID","PARTNER_TYPE","DELETED_FLAG","LONGITUDE","LATITUDE","REFRESH_NUMBER","LAST_UPDATE_DATE","LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN","ATTRIBUTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15","OPERATING_UNIT_NAME","COUNTRY","STATE","CITY","POSTAL_CODE","SHIPPING_CONTROL","ATTRIBUTE8" from msc_trading_partner_sites as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))

SQL_Statement

select "PARTNER_SITE_ID","SR_TP_SITE_ID","SR_INSTANCE_ID","PARTNER_ID","PARTNER_NAME","PARTNER_ADDRESS","TP_SITE_CODE","SR_TP_ID","LOCATION","LOCATION_ID","PARTNER_TYPE","DELETED_FLAG","LONGITUDE","LATITUDE","REFRESH_NUMBER","LAST_UPDATE_DATE","LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN","ATTRIBUTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15","OPERATING_UNIT_NAME","COUNTRY","STATE","CITY","POSTAL_CODE","SHIPPING_CONTROL","ATTRIBUTE8" from msc_trading_partner_sites as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))