VIEW: APPS.MSC_FLP_SUPPLY_V

Source

View Text - Preformatted

SELECT MR.TRANSACTION_ID , MR.INVENTORY_ITEM_ID , MR.ORGANIZATION_ID , MR.plan_id , MR.NEW_SCHEDULE_DATE , MR.NEW_ORDER_QUANTITY , decode(MR.ORDER_TYPE,92,70,mr.order_type) , MR.NEW_PROCESSING_DAYS , msc_get_name.lookup_by_plan('MRP_ORDER_TYPE', decode(MR.ORDER_TYPE,92,70,mr.order_type) , mp.plan_type,mr.source_organization_id) , msc_get_name.supply_order_number ( mr.order_type ,mr.order_number ,mr.plan_id ,mr.sr_instance_id ,mr.transaction_id ,mr.disposition_id ) , 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,80) , 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.source_supplier(mr.sr_instance_id, mr.plan_id, mr.supplier_id, mr.source_supplier_id, mr.SOURCE_ORGANIZATION_ID, mr.order_type)) , mr.new_order_quantity ,mr.by_product_using_assy_id ,mr.disposition_id ,substrb(nvl(MIF.Description , MIF.ITEM_name),1,80)||'/'|| msc_get_name.org_code(mr.organization_id,mr.sr_instance_id), mr.PRODUCT_CLASSIFICATION, mr.MAINTENANCE_REQT, msc_get_name.lookup_meaning('SYS_YES_NO', decode(MR.ORDER_TYPE , 70 , nvl(mr.PRODUCES_TO_STOCK, 2) , mr.produces_to_stock) ), msc_get_name.visit_name(mr.visit_id), msc_get_name.lookup_meaning('MSC_ACTIVITY_TYPE', mr.ACTIVITY_TYPE) , msc_get_name.item_name(mr.activity_item_id, null, null, null), mr.CLASS_CODE, msc_get_name.lookup_meaning('MSC_PART_CONDITION',mr.item_type_value) FROM Msc_system_items MIF, Msc_supplies MR, msc_plans mp WHERE MIF.INVENTORY_ITEM_ID = MR.INVENTORY_ITEM_ID and MIF.SR_INSTANCE_ID = MR.SR_INSTANCE_ID and MIF.ORGANIZATION_ID = MR.ORGANIZATION_ID and MIF.PLAN_ID = MR.PLAN_ID and mp.plan_id = mr.plan_id

View Text - HTML Formatted

SELECT MR.TRANSACTION_ID
, MR.INVENTORY_ITEM_ID
, MR.ORGANIZATION_ID
, MR.PLAN_ID
, MR.NEW_SCHEDULE_DATE
, MR.NEW_ORDER_QUANTITY
, DECODE(MR.ORDER_TYPE
, 92
, 70
, MR.ORDER_TYPE)
, MR.NEW_PROCESSING_DAYS
, MSC_GET_NAME.LOOKUP_BY_PLAN('MRP_ORDER_TYPE'
, DECODE(MR.ORDER_TYPE
, 92
, 70
, MR.ORDER_TYPE)
, MP.PLAN_TYPE
, MR.SOURCE_ORGANIZATION_ID)
, MSC_GET_NAME.SUPPLY_ORDER_NUMBER ( MR.ORDER_TYPE
, MR.ORDER_NUMBER
, MR.PLAN_ID
, MR.SR_INSTANCE_ID
, MR.TRANSACTION_ID
, MR.DISPOSITION_ID )
, 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
, 80)
, 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.SOURCE_SUPPLIER(MR.SR_INSTANCE_ID
, MR.PLAN_ID
, MR.SUPPLIER_ID
, MR.SOURCE_SUPPLIER_ID
, MR.SOURCE_ORGANIZATION_ID
, MR.ORDER_TYPE))
, MR.NEW_ORDER_QUANTITY
, MR.BY_PRODUCT_USING_ASSY_ID
, MR.DISPOSITION_ID
, SUBSTRB(NVL(MIF.DESCRIPTION
, MIF.ITEM_NAME)
, 1
, 80)||'/'|| MSC_GET_NAME.ORG_CODE(MR.ORGANIZATION_ID
, MR.SR_INSTANCE_ID)
, MR.PRODUCT_CLASSIFICATION
, MR.MAINTENANCE_REQT
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, DECODE(MR.ORDER_TYPE
, 70
, NVL(MR.PRODUCES_TO_STOCK
, 2)
, MR.PRODUCES_TO_STOCK) )
, MSC_GET_NAME.VISIT_NAME(MR.VISIT_ID)
, MSC_GET_NAME.LOOKUP_MEANING('MSC_ACTIVITY_TYPE'
, MR.ACTIVITY_TYPE)
, MSC_GET_NAME.ITEM_NAME(MR.ACTIVITY_ITEM_ID
, NULL
, NULL
, NULL)
, MR.CLASS_CODE
, MSC_GET_NAME.LOOKUP_MEANING('MSC_PART_CONDITION'
, MR.ITEM_TYPE_VALUE)
FROM MSC_SYSTEM_ITEMS MIF
, MSC_SUPPLIES MR
, MSC_PLANS MP
WHERE MIF.INVENTORY_ITEM_ID = MR.INVENTORY_ITEM_ID
AND MIF.SR_INSTANCE_ID = MR.SR_INSTANCE_ID
AND MIF.ORGANIZATION_ID = MR.ORGANIZATION_ID
AND MIF.PLAN_ID = MR.PLAN_ID
AND MP.PLAN_ID = MR.PLAN_ID