MSC_AP_CARRIERS_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
SR_TP_ID FREIGHT_CODE PARTNER_TYPE PARTNER_NAME PARTNER_NUMBER STATUS CARR_ROWID PARTY_ROWID

Query

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