FND Design Data [Home] [Help]

View: MSC_SEARCH_SUPPLIERS_V

Product: MSC - Advanced Supply Chain Planning
Description: this view shows the search criteria for suppliers
Implementation/DBA Data: ViewAPPS.MSC_SEARCH_SUPPLIERS_V
View Text

SELECT P.PLAN_ID
, P.COMPILE_DESIGNATOR
, P.PLAN_TYPE
, P.PLANNED_INSTANCE_ID
, P.PLANNED_ORGANIZATION
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
FROM MSC_PLANS_TREE_V P
WHERE P.PLAN_COMPLETION_DATE IS NOT NULL
AND P.DATA_COMPLETION_DATE IS NOT NULL UNION ALL SELECT DISTINCT I.PLAN_ID
, P.COMPILE_DESIGNATOR
, P.PLAN_TYPE
, P.PLANNED_INSTANCE_ID
, P.PLANNED_ORGANIZATION
, I.SR_INSTANCE_ID
, I.ORGANIZATION_ID
, I.ORGANIZATION_CODE
, TO_NUMBER(NULL)
, NULL
, C.CATEGORY_SET_ID
, C.SR_CATEGORY_ID
, C.CATEGORY_NAME
, I.INVENTORY_ITEM_ID
, I.ITEM_NAME
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, I.PLANNER_CODE
, I.BUYER_ID
, I.BUYER_NAME
, I.ABC_CLASS
, I.ABC_CLASS_NAME
, S.SUPPLIER_ID
, TP.PARTNER_NAME
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
FROM MSC_ITEM_CATEGORIES C
, MSC_SYSTEM_ITEMS I
, MSC_PLANS_TREE_V P
, MSC_ITEM_SUPPLIERS S
, MSC_TRADING_PARTNERS TP
WHERE I.INVENTORY_ITEM_ID = C.INVENTORY_ITEM_ID
AND I.ORGANIZATION_ID = C.ORGANIZATION_ID
AND I.SR_INSTANCE_ID = C.SR_INSTANCE_ID
AND P.PLAN_ID = I.PLAN_ID
AND S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
AND S.ORGANIZATION_ID = I.ORGANIZATION_ID
AND S.SR_INSTANCE_ID = I.SR_INSTANCE_ID
AND S.PLAN_ID = I.PLAN_ID
AND S.SUPPLIER_ID = TP.PARTNER_ID
AND TP.PARTNER_TYPE = 1
AND P.PLAN_COMPLETION_DATE IS NOT NULL
AND P.DATA_COMPLETION_DATE IS NOT NULL UNION ALL SELECT DISTINCT S.PLAN_ID
, P.COMPILE_DESIGNATOR
, P.PLAN_TYPE
, P.PLANNED_INSTANCE_ID
, P.PLANNED_ORGANIZATION
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, S.SUPPLIER_ID
, TP.PARTNER_NAME
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
FROM MSC_PLANS_TREE_V P
, MSC_ITEM_SUPPLIERS S
, MSC_TRADING_PARTNERS TP
WHERE P.PLAN_ID = S.PLAN_ID
AND S.SUPPLIER_ID = TP.PARTNER_ID
AND TP.PARTNER_TYPE = 1
AND P.PLAN_COMPLETION_DATE IS NOT NULL
AND P.DATA_COMPLETION_DATE IS NOT NULL UNION ALL SELECT DISTINCT I.PLAN_ID
, P.COMPILE_DESIGNATOR
, P.PLAN_TYPE
, P.PLANNED_INSTANCE_ID
, P.PLANNED_ORGANIZATION
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, C.CATEGORY_SET_ID
, C.SR_CATEGORY_ID
, C.CATEGORY_NAME
, I.INVENTORY_ITEM_ID
, I.ITEM_NAME
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, I.PLANNER_CODE
, I.BUYER_ID
, I.BUYER_NAME
, I.ABC_CLASS
, I.ABC_CLASS_NAME
, S.SUPPLIER_ID
, TP.PARTNER_NAME
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
FROM MSC_ITEM_CATEGORIES C
, MSC_SYSTEM_ITEMS I
, MSC_PLANS_TREE_V P
, MSC_ITEM_SUPPLIERS S
, MSC_TRADING_PARTNERS TP
WHERE I.INVENTORY_ITEM_ID = C.INVENTORY_ITEM_ID
AND I.ORGANIZATION_ID = C.ORGANIZATION_ID
AND I.SR_INSTANCE_ID = C.SR_INSTANCE_ID
AND P.PLAN_ID = I.PLAN_ID
AND S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
AND S.ORGANIZATION_ID = I.ORGANIZATION_ID
AND S.SR_INSTANCE_ID = I.SR_INSTANCE_ID
AND S.PLAN_ID = I.PLAN_ID
AND S.SUPPLIER_ID = TP.PARTNER_ID
AND TP.PARTNER_TYPE = 1
AND P.PLAN_COMPLETION_DATE IS NOT NULL
AND P.DATA_COMPLETION_DATE IS NOT NULL UNION ALL SELECT DISTINCT S.PLAN_ID
, P.COMPILE_DESIGNATOR
, P.PLAN_TYPE
, P.PLANNED_INSTANCE_ID
, P.PLANNED_ORGANIZATION
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, C.CATEGORY_SET_ID
, C.SR_CATEGORY_ID
, C.CATEGORY_NAME
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, S.SUPPLIER_ID
, TP.PARTNER_NAME
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
FROM MSC_ITEM_CATEGORIES C
, MSC_PLANS_TREE_V P
, MSC_ITEM_SUPPLIERS S
, MSC_TRADING_PARTNERS TP
WHERE P.PLAN_ID = S.PLAN_ID
AND P.PLAN_COMPLETION_DATE IS NOT NULL
AND P.DATA_COMPLETION_DATE IS NOT NULL
AND S.INVENTORY_ITEM_ID = S.INVENTORY_ITEM_ID
AND S.ORGANIZATION_ID = S.ORGANIZATION_ID
AND S.SR_INSTANCE_ID = S.SR_INSTANCE_ID
AND S.SUPPLIER_ID = TP.PARTNER_ID
AND TP.PARTNER_TYPE = 1

Columns

Name
PLAN_ID
COMPILE_DESIGNATOR
PLAN_TYPE
PLANNED_INSTANCE_ID
PLANNED_ORGANIZATION
SR_INSTANCE_ID
ORGANIZATION_ID
ORGANIZATION_CODE
PRODUCT_FAMILY_ID
PRODUCT_FAMILY_NAME
CATEGORY_SET_ID
CATEGORY_ID
CATEGORY_NAME
INVENTORY_ITEM_ID
ITEM_NAME
COMPONENT_ID
COMPONENT_NAME
DEPARTMENT_ID
DEPARTMENT_CODE
RESOURCE_ID
RESOURCE_CODE
LINE_ID
LINE_CODE
PLANNER_CODE
BUYER_ID
BUYER_NAME
ABC_CLASS
ABC_CLASS_NAME
SUPPLIER_ID
SUPPLIER_NAME
VERSION
EXCEPTION_TYPE
EXCEPTION_GROUP
DEPARTMENT_CLASS
RESOURCE_GROUP