VIEW: APPS.MSC_LOCATIONS_V

Source

View Text - Preformatted

SELECT distinct tps.sr_tp_site_id, msc_get_name.org_code(ism.from_organization_id, ism.sr_instance_id), tps.location, ism.from_organization_id, ism.sr_instance_id, tps1.sr_tp_site_id, msc_get_name.org_code(ism.to_organization_id, ism.sr_instance_id2), tps1.location, ism.to_organization_id, ism.sr_instance_id2, tp.organization_type, tp1.organization_type from msc_interorg_ship_methods ism, msc_trading_partner_sites tps, msc_trading_partner_sites tps1, msc_trading_partners tp, msc_trading_partners tp1 WHERE ism.plan_id =-1 and ism.sr_instance_id = tp.sr_instance_id and ism.sr_instance_id2 = tp1.sr_instance_id and ism.from_organization_id = tp.sr_tp_id and ism.to_organization_id = tp1.sr_tp_id and tp.partner_type=3 and tp1.partner_type=3 and tp.sr_tp_id=tps.sr_tp_id and tp.sr_instance_id=tps.sr_instance_id and tp.partner_type=3 and tp1.sr_tp_id=tps1.sr_tp_id and tp1.sr_instance_id=tps1.sr_instance_id and tp1.partner_type=3

View Text - HTML Formatted

SELECT DISTINCT TPS.SR_TP_SITE_ID
, MSC_GET_NAME.ORG_CODE(ISM.FROM_ORGANIZATION_ID
, ISM.SR_INSTANCE_ID)
, TPS.LOCATION
, ISM.FROM_ORGANIZATION_ID
, ISM.SR_INSTANCE_ID
, TPS1.SR_TP_SITE_ID
, MSC_GET_NAME.ORG_CODE(ISM.TO_ORGANIZATION_ID
, ISM.SR_INSTANCE_ID2)
, TPS1.LOCATION
, ISM.TO_ORGANIZATION_ID
, ISM.SR_INSTANCE_ID2
, TP.ORGANIZATION_TYPE
, TP1.ORGANIZATION_TYPE
FROM MSC_INTERORG_SHIP_METHODS ISM
, MSC_TRADING_PARTNER_SITES TPS
, MSC_TRADING_PARTNER_SITES TPS1
, MSC_TRADING_PARTNERS TP
, MSC_TRADING_PARTNERS TP1
WHERE ISM.PLAN_ID =-1
AND ISM.SR_INSTANCE_ID = TP.SR_INSTANCE_ID
AND ISM.SR_INSTANCE_ID2 = TP1.SR_INSTANCE_ID
AND ISM.FROM_ORGANIZATION_ID = TP.SR_TP_ID
AND ISM.TO_ORGANIZATION_ID = TP1.SR_TP_ID
AND TP.PARTNER_TYPE=3
AND TP1.PARTNER_TYPE=3
AND TP.SR_TP_ID=TPS.SR_TP_ID
AND TP.SR_INSTANCE_ID=TPS.SR_INSTANCE_ID
AND TP.PARTNER_TYPE=3
AND TP1.SR_TP_ID=TPS1.SR_TP_ID
AND TP1.SR_INSTANCE_ID=TPS1.SR_INSTANCE_ID
AND TP1.PARTNER_TYPE=3