eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.WIP_FLOW_OPEN_ALLOCATIONS_V

Source

View Text - Preformatted


SELECT wl.line_code, wl.description line_description, wl.line_id, ((wl.stop_time - wl.start_time)/3600) * wl.maximum_rate line_rate, wfs.schedule_number, wfs.organization_id, msik.concatenated_segments primary_item, msik.inventory_item_id primary_item_id, msik.description primary_item_description, msik.primary_uom_code, wfs.scheduled_start_date, wfs.scheduled_completion_date, wfs.planned_quantity schedule_quantity, wfs.build_sequence, wfs.project_id, wfs.task_id, wsg.schedule_group_name, wfs.alternate_bom_designator, wfs.alternate_routing_designator, wfs.wip_entity_id, wfs.demand_source_header_id from wip_flow_schedules wfs, wip_schedule_groups wsg, wip_lines wl, mtl_system_items_kfv msik where wfs.status = 1 and wfs.line_id = wl.line_id and wfs.schedule_group_id = wsg.schedule_group_id (+) and wfs.organization_id = wsg.organization_id (+) and wfs.status = 1 and msik.inventory_item_id = wfs.primary_item_id and msik.organization_id = wfs.organization_id and ( wfs.allocated_flag is null or wfs.allocated_flag = 'N')

View Text - HTML Formatted

SELECT WL.LINE_CODE
, WL.DESCRIPTION LINE_DESCRIPTION
, WL.LINE_ID
, ((WL.STOP_TIME - WL.START_TIME)/3600) * WL.MAXIMUM_RATE LINE_RATE
, WFS.SCHEDULE_NUMBER
, WFS.ORGANIZATION_ID
, MSIK.CONCATENATED_SEGMENTS PRIMARY_ITEM
, MSIK.INVENTORY_ITEM_ID PRIMARY_ITEM_ID
, MSIK.DESCRIPTION PRIMARY_ITEM_DESCRIPTION
, MSIK.PRIMARY_UOM_CODE
, WFS.SCHEDULED_START_DATE
, WFS.SCHEDULED_COMPLETION_DATE
, WFS.PLANNED_QUANTITY SCHEDULE_QUANTITY
, WFS.BUILD_SEQUENCE
, WFS.PROJECT_ID
, WFS.TASK_ID
, WSG.SCHEDULE_GROUP_NAME
, WFS.ALTERNATE_BOM_DESIGNATOR
, WFS.ALTERNATE_ROUTING_DESIGNATOR
, WFS.WIP_ENTITY_ID
, WFS.DEMAND_SOURCE_HEADER_ID
FROM WIP_FLOW_SCHEDULES WFS
, WIP_SCHEDULE_GROUPS WSG
, WIP_LINES WL
, MTL_SYSTEM_ITEMS_KFV MSIK
WHERE WFS.STATUS = 1
AND WFS.LINE_ID = WL.LINE_ID
AND WFS.SCHEDULE_GROUP_ID = WSG.SCHEDULE_GROUP_ID (+)
AND WFS.ORGANIZATION_ID = WSG.ORGANIZATION_ID (+)
AND WFS.STATUS = 1
AND MSIK.INVENTORY_ITEM_ID = WFS.PRIMARY_ITEM_ID
AND MSIK.ORGANIZATION_ID = WFS.ORGANIZATION_ID
AND ( WFS.ALLOCATED_FLAG IS NULL OR WFS.ALLOCATED_FLAG = 'N')