Product: | MSC - Advanced Supply Chain Planning |
---|---|
Description: | |
Implementation/DBA Data: | APPS.MSC_ORGS_TREE_V |
SELECT PLAN_ID
, ORGANIZATION_ID
, TO_NUMBER(NULL)
, SR_INSTANCE_ID
, ORGANIZATION_CODE
, NET_WIP
, NET_RESERVATIONS
, NET_PURCHASING
, PLAN_SAFETY_STOCK
, SIMULATION_SET
, BILL_OF_RESOURCES
, PLAN_LEVEL
, ORGANIZATION_DESCRIPTION
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM MSC_PLAN_ORGANIZATIONS
WHERE PLAN_ID <> -1
AND PLAN_LEVEL = 2 UNION ALL SELECT -1
, SR_TP_ID
, MASTER_ORGANIZATION
, SR_INSTANCE_ID
, ORGANIZATION_CODE
, 2
, 2
, 2
, 2
, NULL
, NULL
, 2
, PARTNER_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM MSC_TRADING_PARTNERS
WHERE PARTNER_TYPE = 3