MSC_AP_CARRIERS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MSC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
SR_TP_ID FREIGHT_CODE PARTNER_TYPE PARTNER_NAME PARTNER_NUMBER STATUS CARR_ROWID PARTY_ROWID |
問合せ
| SQL_Statement |
|---|
|
SELECT msc.CARRIER_ID sr_tp_id, NULL FREIGHT_CODE, 4 Partner_Type, HZ.PARTY_NAME Partner_name, HZ.PARTY_NUMBER Partner_number, DECODE(msc.enabled_flag,'Y',1,2) status, msc.rowid carr_rowid , hz.rowid party_rowid FROM WSH_CARRIERS msc, HZ_PARTIES HZ WHERE HZ.party_id = msc.carrier_id |