VIEW: APPS.MSD_SR_SUP_ALL_LB_V

Source

View Text - Preformatted

SELECT DISTINCT mis.plan_id, 12, mtp.partner_name supplier_name , mtp.partner_name supplier_name , mis.supplier_id, 30 , MSD_SR_UTIL.get_all_sup_desc , MSD_SR_UTIL.get_all_sup_desc , MSD_SR_UTIL.get_all_sup_pk FROM msc_trading_partners mtp, msc_item_suppliers mis, MSC_ASL_AUTH_DETAILS maad, msc_plans mp WHERE mtp.partner_id = mis.supplier_id and maad.supplier_id= mis.supplier_id and mtp.partner_type = 1 and maad.organization_id = mis.organization_id and maad.sr_instance_id = mis.sr_instance_id and mis.plan_id = mp.plan_id and ( mp.CALCULATE_LIABILITY = 1 or mp.plan_id = -1)

View Text - HTML Formatted

SELECT DISTINCT MIS.PLAN_ID
, 12
, MTP.PARTNER_NAME SUPPLIER_NAME
, MTP.PARTNER_NAME SUPPLIER_NAME
, MIS.SUPPLIER_ID
, 30
, MSD_SR_UTIL.GET_ALL_SUP_DESC
, MSD_SR_UTIL.GET_ALL_SUP_DESC
, MSD_SR_UTIL.GET_ALL_SUP_PK
FROM MSC_TRADING_PARTNERS MTP
, MSC_ITEM_SUPPLIERS MIS
, MSC_ASL_AUTH_DETAILS MAAD
, MSC_PLANS MP
WHERE MTP.PARTNER_ID = MIS.SUPPLIER_ID
AND MAAD.SUPPLIER_ID= MIS.SUPPLIER_ID
AND MTP.PARTNER_TYPE = 1
AND MAAD.ORGANIZATION_ID = MIS.ORGANIZATION_ID
AND MAAD.SR_INSTANCE_ID = MIS.SR_INSTANCE_ID
AND MIS.PLAN_ID = MP.PLAN_ID
AND ( MP.CALCULATE_LIABILITY = 1 OR MP.PLAN_ID = -1)