VIEW: APPS.MSC_SHIPMENT_LINES_V

Source

View Text - Preformatted

SELECT ms.rowid, ms.SHIPMENT_ID, ms.transaction_id, ms.plan_id , ms.ORGANIZATION_ID, ms.sr_instance_id , ms.inventory_item_id, mtp.organization_code, msi.item_name, ms.new_ship_date, ms.new_dock_date, ms.new_schedule_date, ms.new_order_placement_date, ms.new_wip_start_date, ms.need_by_date, ms.implement_date, ms.firm_date, nvl(msi.unit_weight,0)*ms.new_order_quantity, nvl(msi.unit_volume,0)*ms.new_order_quantity, ms.new_order_quantity, ms.SHIP_METHOD, nvl(ms.release_status,2), nvl(ms.firm_planned_type,2), ms.order_type, msc_get_name.lookup_meaning('MRP_ORDER_TYPE', ms.order_type), nvl(ms.order_number,to_char(ms.transaction_id)), msc_get_name.action('MSC_SUPPLIES', msi.bom_item_type, msi.base_item_id, msi.wip_supply_type, ms.order_type, DECODE(ms.firm_planned_type,1,1,ms.reschedule_flag), ms.disposition_status_type, ms.new_schedule_date, ms.old_schedule_date, ms.implemented_quantity, ms.quantity_in_process, decode(ms.new_order_quantity,0,ms.firm_quantity,ms.new_order_quantity), msi.release_time_fence_code, ms.reschedule_days, ms.firm_quantity, ms.plan_id, msi.critical_component_flag, msi.mrp_planning_code), ms.status, ms.applied, msc_drp_util.material_avail_date(ms.plan_id, ms.transaction_id), ms.LAST_UPDATE_DATE , ms.LAST_UPDATED_BY , ms.CREATION_DATE , ms.CREATED_BY , ms.LAST_UPDATE_LOGIN, msi.WEIGHT_UOM, msi.VOLUME_UOM, msi. POSTPROCESSING_LEAD_TIME FROM msc_system_items msi, msc_trading_partners mtp, msc_supplies ms WHERE MSI.inventory_item_id = ms.INVENTORY_ITEM_ID AND MSI.organization_id = ms.organization_id AND MSI.sr_instance_id = ms.sr_instance_id AND MSI.plan_id = ms.plan_id AND mtp.sr_tp_id = ms.organization_id AND mtp.sr_instance_id= ms.sr_instance_id AND mtp.partner_type= 3

View Text - HTML Formatted

SELECT MS.ROWID
, MS.SHIPMENT_ID
, MS.TRANSACTION_ID
, MS.PLAN_ID
, MS.ORGANIZATION_ID
, MS.SR_INSTANCE_ID
, MS.INVENTORY_ITEM_ID
, MTP.ORGANIZATION_CODE
, MSI.ITEM_NAME
, MS.NEW_SHIP_DATE
, MS.NEW_DOCK_DATE
, MS.NEW_SCHEDULE_DATE
, MS.NEW_ORDER_PLACEMENT_DATE
, MS.NEW_WIP_START_DATE
, MS.NEED_BY_DATE
, MS.IMPLEMENT_DATE
, MS.FIRM_DATE
, NVL(MSI.UNIT_WEIGHT
, 0)*MS.NEW_ORDER_QUANTITY
, NVL(MSI.UNIT_VOLUME
, 0)*MS.NEW_ORDER_QUANTITY
, MS.NEW_ORDER_QUANTITY
, MS.SHIP_METHOD
, NVL(MS.RELEASE_STATUS
, 2)
, NVL(MS.FIRM_PLANNED_TYPE
, 2)
, MS.ORDER_TYPE
, MSC_GET_NAME.LOOKUP_MEANING('MRP_ORDER_TYPE'
, MS.ORDER_TYPE)
, NVL(MS.ORDER_NUMBER
, TO_CHAR(MS.TRANSACTION_ID))
, MSC_GET_NAME.ACTION('MSC_SUPPLIES'
, MSI.BOM_ITEM_TYPE
, MSI.BASE_ITEM_ID
, MSI.WIP_SUPPLY_TYPE
, MS.ORDER_TYPE
, DECODE(MS.FIRM_PLANNED_TYPE
, 1
, 1
, MS.RESCHEDULE_FLAG)
, MS.DISPOSITION_STATUS_TYPE
, MS.NEW_SCHEDULE_DATE
, MS.OLD_SCHEDULE_DATE
, MS.IMPLEMENTED_QUANTITY
, MS.QUANTITY_IN_PROCESS
, DECODE(MS.NEW_ORDER_QUANTITY
, 0
, MS.FIRM_QUANTITY
, MS.NEW_ORDER_QUANTITY)
, MSI.RELEASE_TIME_FENCE_CODE
, MS.RESCHEDULE_DAYS
, MS.FIRM_QUANTITY
, MS.PLAN_ID
, MSI.CRITICAL_COMPONENT_FLAG
, MSI.MRP_PLANNING_CODE)
, MS.STATUS
, MS.APPLIED
, MSC_DRP_UTIL.MATERIAL_AVAIL_DATE(MS.PLAN_ID
, MS.TRANSACTION_ID)
, MS.LAST_UPDATE_DATE
, MS.LAST_UPDATED_BY
, MS.CREATION_DATE
, MS.CREATED_BY
, MS.LAST_UPDATE_LOGIN
, MSI.WEIGHT_UOM
, MSI.VOLUME_UOM
, MSI. POSTPROCESSING_LEAD_TIME
FROM MSC_SYSTEM_ITEMS MSI
, MSC_TRADING_PARTNERS MTP
, MSC_SUPPLIES MS
WHERE MSI.INVENTORY_ITEM_ID = MS.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MS.ORGANIZATION_ID
AND MSI.SR_INSTANCE_ID = MS.SR_INSTANCE_ID
AND MSI.PLAN_ID = MS.PLAN_ID
AND MTP.SR_TP_ID = MS.ORGANIZATION_ID
AND MTP.SR_INSTANCE_ID= MS.SR_INSTANCE_ID
AND MTP.PARTNER_TYPE= 3