View: MRP_AP_ORGANIZATIONS_V

View Text

SELECT MP.ORGANIZATION_CODE ORGANIZATION_CODE
, MP.ORGANIZATION_ID SR_TP_ID
, MP.MASTER_ORGANIZATION_ID MASTER_ORGANIZATION
, 3 PARTNER_TYPE
, HAOTL.NAME PARTNER_NAME
, MP.CALENDAR_CODE CALENDAR_CODE
, MP.CALENDAR_EXCEPTION_SET_ID CALENDAR_EXCEPTION_SET_ID
, HAO.BUSINESS_GROUP_ID OPERATING_UNIT
, HAOTL.LANGUAGE
, MP.MAXIMUM_WEIGHT
, MP.MAXIMUM_VOLUME
, MP.WEIGHT_UOM
, MP.VOLUME_UOM
, MP.PROJECT_REFERENCE_ENABLED
, MP.PROJECT_CONTROL_LEVEL
, X.MODELED_CUSTOMER_ID
, X.MODELED_CUSTOMER_SITE_ID
, X.MODELED_SUPPLIER_ID
, X.MODELED_SUPPLIER_SITE_ID
, 0 RN3
, MP.RN RN2
, ORG.RN RN1
FROM ( SELECT HOI.ORGANIZATION_ID
, TO_NUMBER(HOI.ORG_INFORMATION1) MODELED_CUSTOMER_ID
, TO_NUMBER(HOI.ORG_INFORMATION2) MODELED_CUSTOMER_SITE_ID
, TO_NUMBER(HOI.ORG_INFORMATION3) MODELED_SUPPLIER_ID
, TO_NUMBER(HOI.ORG_INFORMATION4) MODELED_SUPPLIER_SITE_ID
FROM HR_ORGANIZATION_INFORMATION HOI
WHERE HOI.ORG_INFORMATION_CONTEXT='CUSTOMER/SUPPLIER ASSOCIATION'
AND ( HOI.ORG_INFORMATION1 IS NOT NULL OR HOI.ORG_INFORMATION3 IS NOT NULL)) X
, HR_ALL_ORGANIZATION_UNITS_TL HAOTL
, MRP_AP_ORG_UNITS_SN HAO
, MRP_AP_MTL_PARAS_SN MP
, MRP_AP_MRP_PARAS_SN ORG
WHERE MP.ORGANIZATION_ID= ORG.ORGANIZATION_ID
AND HAO.ORGANIZATION_ID(+)= MP.ORGANIZATION_ID
AND HAOTL.ORGANIZATION_ID(+)= HAO.ORGANIZATION_ID
AND X.ORGANIZATION_ID(+)= ORG.ORGANIZATION_ID

Columns