View: MSC_FLP_SUPPLY_ATP_V

Product:	MSC - Advanced Supply Chain Planning
Description:	View of supply information
Implementation/DBA Data:	APPS.MSC_FLP_SUPPLY_ATP_V

View Text

SELECT MR.TRANSACTION_ID
, MR.INVENTORY_ITEM_ID
, MR.ORGANIZATION_ID
, MR.PLAN_ID
, MR.NEW_SCHEDULE_DATE
, MR.NEW_ORDER_QUANTITY
, MR.ORDER_TYPE
, MR.NEW_PROCESSING_DAYS
, MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE'
, MR.ORDER_TYPE)
, DECODE(MR.ORDER_TYPE
, 5
, TO_CHAR(MR.TRANSACTION_ID)
, MR.ORDER_NUMBER)
, MSC_GET_NAME.PROJECT(MR.PROJECT_ID
, MR.ORGANIZATION_ID
, MR.PLAN_ID
, MR.SR_INSTANCE_ID)
, MSC_GET_NAME.TASK(MR.TASK_ID
, MR.PROJECT_ID
, MR.ORGANIZATION_ID
, MR.PLAN_ID
, MR.SR_INSTANCE_ID)
, MIF.ITEM_NAME||'/'|| MSC_GET_NAME.ORG_CODE(MR.ORGANIZATION_ID
, MR.SR_INSTANCE_ID)
, SUBSTR(MSC_GET_NAME.ITEM_DESC(MR.INVENTORY_ITEM_ID
, MR.ORGANIZATION_ID
, MR.PLAN_ID
, MR.SR_INSTANCE_ID)
, 1
, 20)
, MR.UNIT_NUMBER
, MR.SR_INSTANCE_ID
, MR.NEED_BY_DATE
, NVL(MSC_GET_NAME.ORG_CODE(MR.SOURCE_ORGANIZATION_ID
, MR.SOURCE_SR_INSTANCE_ID)
, MSC_GET_NAME.SUPPLIER(MR.SOURCE_SUPPLIER_ID))
, MR.NEW_ORDER_QUANTITY
, MR.BY_PRODUCT_USING_ASSY_ID
, MR.DISPOSITION_ID
FROM MSC_ITEMS MIF
, MSC_SUPPLIES MR
WHERE MIF.INVENTORY_ITEM_ID = MR.INVENTORY_ITEM_ID

Columns