FND Design Data [Home] [Help]

View: MSC_FLP_END_DEMAND2_V

Product: MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data: ViewAPPS.MSC_FLP_END_DEMAND2_V
View Text

SELECT MGR.ROWID
, MGR.DEMAND_ID
, MGR.INVENTORY_ITEM_ID
, MGR.ORGANIZATION_ID
, MGR.PLAN_ID
, MGR.USING_ASSEMBLY_DEMAND_DATE
, MGR.ASSEMBLY_DEMAND_COMP_DATE
, ROUND(MGR.USING_REQUIREMENT_QUANTITY
, 2)
, MGR.DEMAND_TYPE
, MGR.ORIGINATION_TYPE
, MSC_GET_NAME.LOOKUP_MEANING('MRP_DEMAND_ORIGINATION'
, MGR.ORIGINATION_TYPE)
, DECODE(MGR.ORIGINATION_TYPE
, 6
, MGR.ORDER_NUMBER
, MSC_GET_NAME.SUPPLY_ORDER(MGR.ORIGINATION_TYPE
, MGR.DEMAND_ID
, MGR.ORGANIZATION_ID
, MGR.PLAN_ID
, MGR.SR_INSTANCE_ID))
, MIF.ITEM_NAME||'/'|| MSC_GET_NAME.ORG_CODE(MGR.ORGANIZATION_ID
, MGR.SR_INSTANCE_ID)
, SUBSTR(MSC_GET_NAME.ITEM_DESC(MGR.INVENTORY_ITEM_ID
, MGR.ORGANIZATION_ID
, MGR.PLAN_ID
, MGR.SR_INSTANCE_ID)
, 1
, 20)
, MSC_GET_NAME.PROJECT(MGR.PROJECT_ID
, MGR.ORGANIZATION_ID
, MGR.PLAN_ID
, MGR.SR_INSTANCE_ID)
, MSC_GET_NAME.TASK(MGR.TASK_ID
, MGR.PROJECT_ID
, MGR.ORGANIZATION_ID
, MGR.PLAN_ID
, MGR.SR_INSTANCE_ID)
, MGR.UNIT_NUMBER
, MSC_GET_NAME.PROJECT(MGR.LENDING_PROJECT_ID
, MGR.ORGANIZATION_ID
, MGR.PLAN_ID
, MGR.SR_INSTANCE_ID)
, MSC_GET_NAME.TASK(MGR.LENDING_TASK_ID
, MGR.LENDING_PROJECT_ID
, MGR.ORGANIZATION_ID
, MGR.PLAN_ID
, MGR.SR_INSTANCE_ID)
, MGR.SR_INSTANCE_ID
, MGR.DMD_SATISFIED_DATE
, MSC_GET_NAME.CUSTOMER(MGR.CUSTOMER_ID)
, MGR.DEMAND_PRIORITY
, MGR.ATTRIBUTE1
FROM MSC_ITEMS MIF
, MSC_DEMANDS MGR
WHERE MIF.INVENTORY_ITEM_ID = MGR.INVENTORY_ITEM_ID

Columns

Name
ROW_ID
DEMAND_ID
INVENTORY_ITEM_ID
ORGANIZATION_ID
PLAN_ID
USING_ASSEMBLY_DEMAND_DATE
ASSEMBLY_DEMAND_COMP_DATE
USING_REQUIREMENTS_QUANTITY
DEMAND_TYPE
ORIGINATION_TYPE
ORIGINATION_NAME
DISPOSITION
ITEM_ORG
DESCRIPTION
PROJECT_NUMBER
TASK_NUMBER
UNIT_NUMBER
LENDING_PROJECT_NUMBER
LENDING_TASK_NUMBER
SR_INSTANCE_ID
SATISFIED_DATE
CUSTOMER
DEMAND_PRIORITY
ATTRIBUTE1