1. Tables and Views for SCM
  2. MSC_AP_ORGANIZATION_SITES_V

MSC_AP_ORGANIZATION_SITES_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

SR_TP_ID

SR_TP_SITE_ID

PARTNER_ADDRESS

LOCATION

ADDRESS_LINE_1

ADDRESS_LINE_2

ADDRESS_LINE_3

CITY

COUNTY

STATE

POSTAL_CODE

COUNTRY

PARTNER_TYPE

Query

SQL_Statement

SELECT requiredorg.ORGANIZATION_ID SR_TP_ID,

NVL(hrloc.LOCATION_ID,-1) SR_TP_SITE_ID,

hrloc.ADDRESS_LINE_1||','||hrloc.ADDRESS_LINE_2||','||hrloc.ADDRESS_LINE_3||','||

hrloc.REGION_1||','||hrloc.REGION_2||','||hrloc.POSTAL_CODE||','||

hrloc.COUNTRY PARTNER_ADDRESS,

hrloc.LOCATION_CODE LOCATION,

hrloc.ADDRESS_LINE_1,

hrloc.ADDRESS_LINE_2,

hrloc.ADDRESS_LINE_3,

hrloc.TOWN_OR_CITY CITY,

hrloc.REGION_1 COUNTY,

hrloc.REGION_2 STATE,

hrloc.POSTAL_CODE,

hrloc.COUNTRY,

3 PARTNER_TYPE

FROM ( select org.ORGANIZATION_ID, hrorgunit.LOCATION_ID from

INV_ORG_PARAMETERS_V org, HR_ALL_ORGANIZATION_UNITS hrorgunit

where hrorgunit.ORGANIZATION_ID(+) = org.ORGANIZATION_ID

and hrorgunit.LOCATION_ID is not null

and org.schedule_id is not null

and org.organization_id is not null) requiredorg,

HR_LOCATIONS hrloc

WHERE

hrloc.location_id(+) = requiredorg.location_id