VIEW: APPS.MSD_SR_ORG_ALL_LB_V

Source

View Text - Preformatted

SELECT distinct mpo.plan_id, 7, mtp.partner_name, mtp.partner_name, mtp.SR_INSTANCE_ID||':'|| mtp.SR_TP_ID , 29, MSD_SR_UTIL.get_all_org_desc, MSD_SR_UTIL.get_all_org_desc, MSD_SR_UTIL.get_all_org_pk FROM msc_plan_organizations mpo, msc_trading_partners mtp , msc_asl_auth_details maad, msc_plans mp WHERE mtp.partner_type = 3 and mpo.organization_id = mtp.sr_tp_id and mpo.sr_instance_id = mtp.sr_instance_id and maad.sr_instance_id = mpo.sr_instance_id and maad.organization_id = mpo.organization_id and mp.plan_id = mpo.plan_id and mp.CALCULATE_LIABILITY = 1 union SELECT distinct -1, 7, mtp.partner_name, mtp.partner_name, mtp.SR_INSTANCE_ID||':'|| mtp.SR_TP_ID , 29, MSD_SR_UTIL.get_all_org_desc, MSD_SR_UTIL.get_all_org_desc, MSD_SR_UTIL.get_all_org_pk FROM msc_trading_partners mtp , msc_asl_auth_details maad WHERE mtp.partner_type = 3 and maad.sr_instance_id = mtp.sr_instance_id and maad.organization_id = mtp.sr_tp_id

View Text - HTML Formatted

SELECT DISTINCT MPO.PLAN_ID
, 7
, MTP.PARTNER_NAME
, MTP.PARTNER_NAME
, MTP.SR_INSTANCE_ID||':'|| MTP.SR_TP_ID
, 29
, MSD_SR_UTIL.GET_ALL_ORG_DESC
, MSD_SR_UTIL.GET_ALL_ORG_DESC
, MSD_SR_UTIL.GET_ALL_ORG_PK
FROM MSC_PLAN_ORGANIZATIONS MPO
, MSC_TRADING_PARTNERS MTP
, MSC_ASL_AUTH_DETAILS MAAD
, MSC_PLANS MP
WHERE MTP.PARTNER_TYPE = 3
AND MPO.ORGANIZATION_ID = MTP.SR_TP_ID
AND MPO.SR_INSTANCE_ID = MTP.SR_INSTANCE_ID
AND MAAD.SR_INSTANCE_ID = MPO.SR_INSTANCE_ID
AND MAAD.ORGANIZATION_ID = MPO.ORGANIZATION_ID
AND MP.PLAN_ID = MPO.PLAN_ID
AND MP.CALCULATE_LIABILITY = 1 UNION SELECT DISTINCT -1
, 7
, MTP.PARTNER_NAME
, MTP.PARTNER_NAME
, MTP.SR_INSTANCE_ID||':'|| MTP.SR_TP_ID
, 29
, MSD_SR_UTIL.GET_ALL_ORG_DESC
, MSD_SR_UTIL.GET_ALL_ORG_DESC
, MSD_SR_UTIL.GET_ALL_ORG_PK
FROM MSC_TRADING_PARTNERS MTP
, MSC_ASL_AUTH_DETAILS MAAD
WHERE MTP.PARTNER_TYPE = 3
AND MAAD.SR_INSTANCE_ID = MTP.SR_INSTANCE_ID
AND MAAD.ORGANIZATION_ID = MTP.SR_TP_ID