VIEW: APPS.MSC_FLP_SUPPLY_ATP_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 , 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

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
, 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