VIEW: APPS.MSC_ORGS_TREE_V

Source

View Text - Preformatted

SELECT p.PLAN_ID, p.ORGANIZATION_ID, to_number(NULL), p.SR_INSTANCE_ID, p.ORGANIZATION_CODE, p.NET_WIP, p.NET_RESERVATIONS, p.NET_PURCHASING, p.PLAN_SAFETY_STOCK, p.SIMULATION_SET, p.BILL_OF_RESOURCES, p.PLAN_LEVEL, p.ORGANIZATION_DESCRIPTION, mtp.modeled_supplier_id, mtp.modeled_supplier_site_id, p.LAST_UPDATE_DATE, p.LAST_UPDATED_BY, p.CREATION_DATE, p.CREATED_BY, p.LAST_UPDATE_LOGIN FROM msc_plan_organizations p, msc_trading_partners mtp WHERE plan_id <> -1 and plan_level = 2 and mtp.sr_instance_id = p.sr_instance_id and mtp.sr_tp_id = p.organization_id and mtp.partner_type=3 UNION ALL SELECT -1, sr_tp_id, master_organization, sr_instance_id, organization_code, 2, 2, 2, 2, NULL, NULL, 2, partner_name, modeled_supplier_id, modeled_supplier_site_id, last_update_date, last_updated_by, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN FROM msc_trading_partners WHERE partner_type = 3

View Text - HTML Formatted

SELECT P.PLAN_ID
, P.ORGANIZATION_ID
, TO_NUMBER(NULL)
, P.SR_INSTANCE_ID
, P.ORGANIZATION_CODE
, P.NET_WIP
, P.NET_RESERVATIONS
, P.NET_PURCHASING
, P.PLAN_SAFETY_STOCK
, P.SIMULATION_SET
, P.BILL_OF_RESOURCES
, P.PLAN_LEVEL
, P.ORGANIZATION_DESCRIPTION
, MTP.MODELED_SUPPLIER_ID
, MTP.MODELED_SUPPLIER_SITE_ID
, P.LAST_UPDATE_DATE
, P.LAST_UPDATED_BY
, P.CREATION_DATE
, P.CREATED_BY
, P.LAST_UPDATE_LOGIN
FROM MSC_PLAN_ORGANIZATIONS P
, MSC_TRADING_PARTNERS MTP
WHERE PLAN_ID <> -1
AND PLAN_LEVEL = 2
AND MTP.SR_INSTANCE_ID = P.SR_INSTANCE_ID
AND MTP.SR_TP_ID = P.ORGANIZATION_ID
AND MTP.PARTNER_TYPE=3 UNION ALL SELECT -1
, SR_TP_ID
, MASTER_ORGANIZATION
, SR_INSTANCE_ID
, ORGANIZATION_CODE
, 2
, 2
, 2
, 2
, NULL
, NULL
, 2
, PARTNER_NAME
, MODELED_SUPPLIER_ID
, MODELED_SUPPLIER_SITE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM MSC_TRADING_PARTNERS
WHERE PARTNER_TYPE = 3