1. Tables and Views for SCM
  2. WSH_CARRIERS_V

WSH_CARRIERS_V

Details

  • Schema: FUSION

  • Object owner: RCS

  • Object type: VIEW

Columns

Name

CARRIER_NAME

CARRIER_ID

ENABLED_FLAG

MANIFESTING_ENABLED_FLAG

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_TIMESTAMP1

ATTRIBUTE_TIMESTAMP2

ATTRIBUTE_TIMESTAMP3

ATTRIBUTE_TIMESTAMP4

ATTRIBUTE_TIMESTAMP5

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

REQUEST_ID

PARTY_ID

PARTY_NAME

PARTY_ID1

ORGANIZATION_PROFILE_ID

ORGANIZATION_NAME

OBJECT_VERSION_NUMBER1

Query

SQL_Statement

SELECT PartyEO.PARTY_NAME AS CARRIER_NAME,

CarrierEO.CARRIER_ID,

CarrierEO.ENABLED_FLAG,

CarrierEO.MANIFESTING_ENABLED_FLAG,

CarrierEO.ATTRIBUTE_CATEGORY,

CarrierEO.ATTRIBUTE1,

CarrierEO.ATTRIBUTE2,

CarrierEO.ATTRIBUTE3,

CarrierEO.ATTRIBUTE4,

CarrierEO.ATTRIBUTE5,

CarrierEO.ATTRIBUTE6,

CarrierEO.ATTRIBUTE7,

CarrierEO.ATTRIBUTE8,

CarrierEO.ATTRIBUTE9,

CarrierEO.ATTRIBUTE10,

CarrierEO.ATTRIBUTE11,

CarrierEO.ATTRIBUTE12,

CarrierEO.ATTRIBUTE13,

CarrierEO.ATTRIBUTE14,

CarrierEO.ATTRIBUTE15,

CarrierEO.ATTRIBUTE_NUMBER1,

CarrierEO.ATTRIBUTE_NUMBER2,

CarrierEO.ATTRIBUTE_NUMBER3,

CarrierEO.ATTRIBUTE_NUMBER4,

CarrierEO.ATTRIBUTE_NUMBER5,

CarrierEO.ATTRIBUTE_NUMBER6,

CarrierEO.ATTRIBUTE_NUMBER7,

CarrierEO.ATTRIBUTE_NUMBER8,

CarrierEO.ATTRIBUTE_NUMBER9,

CarrierEO.ATTRIBUTE_NUMBER10,

CarrierEO.ATTRIBUTE_DATE1,

CarrierEO.ATTRIBUTE_DATE2,

CarrierEO.ATTRIBUTE_DATE3,

CarrierEO.ATTRIBUTE_DATE4,

CarrierEO.ATTRIBUTE_DATE5,

CarrierEO.ATTRIBUTE_TIMESTAMP1,

CarrierEO.ATTRIBUTE_TIMESTAMP2,

CarrierEO.ATTRIBUTE_TIMESTAMP3,

CarrierEO.ATTRIBUTE_TIMESTAMP4,

CarrierEO.ATTRIBUTE_TIMESTAMP5,

CarrierEO.CREATION_DATE,

CarrierEO.CREATED_BY,

CarrierEO.LAST_UPDATE_DATE,

CarrierEO.LAST_UPDATED_BY,

CarrierEO.LAST_UPDATE_LOGIN,

CarrierEO.OBJECT_VERSION_NUMBER,

CarrierEO.REQUEST_ID,

PartyEO.PARTY_ID,

PartyEO.PARTY_NAME,

OrganizationDEO.PARTY_ID AS PARTY_ID1,

OrganizationDEO.ORGANIZATION_PROFILE_ID,

OrganizationDEO.ORGANIZATION_NAME,

PartyEO.OBJECT_VERSION_NUMBER AS OBJECT_VERSION_NUMBER1

FROM HZ_PARTIES PartyEO,

WSH_CARRIERS CarrierEO,

HZ_ORGANIZATION_PROFILES OrganizationDEO

WHERE (CarrierEO.CARRIER_ID = PartyEO.PARTY_ID)

AND (PartyEO.PARTY_ID = OrganizationDEO.PARTY_ID)

AND sysdate BETWEEN OrganizationDEO.effective_start_date AND OrganizationDEO.effective_end_date