APPS.WMA_FLOW dependencies on WIP_FLOW_SCHEDULES

Line 350: from wip_flow_schedules

346: select project_id,
347: task_id
348: into flowRec.source_project_id,
349: flowRec.source_task_id
350: from wip_flow_schedules
351: where wip_entity_id = param.wipEntityID
352: and organization_id = param.environment.orgID;
353:
354: --if the destination sub is known, transfer the reservation. The sub is

Line 379: from wip_flow_schedules

375: demand_source_delivery
376: into flowRec.demand_source_header_id,
377: flowRec.demand_source_line,
378: flowRec.demand_source_delivery
379: from wip_flow_schedules
380: where organization_id = param.environment.orgID
381: and wip_entity_id = param.wipEntityID;
382: end if;
383: end if;

Line 1010: from wip_flow_schedules wfs

1006: planned_quantity,
1007: nvl(quantity_completed,0) as quantity_completed,
1008: nvl(quantity_scrapped,0) as quantity_scrapped,
1009: (planned_quantity - nvl(quantity_completed,0) - nvl(quantity_scrapped,0)) as open_quantity
1010: from wip_flow_schedules wfs
1011: where wfs.wip_entity_id = wipEntityId
1012: ;
1013:
1014: l_wfs_info wfs_info_cursor%ROWTYPE := null;

Line 1037: from wip_flow_schedules

1033: /*
1034: if ( p_wipEntityID is not null ) then
1035: select scheduled_completion_date
1036: into l_bomRevDate
1037: from wip_flow_schedules
1038: where wip_entity_id = p_wipEntityID;
1039: end if;
1040: */
1041:

Line 1047: from wip_flow_schedules

1043: if ( p_wipEntityID is not null ) then
1044: select scheduled_completion_date, line_id, alternate_bom_designator,
1045: alternate_routing_designator
1046: into l_bomRevDate, l_line_id, l_alt_bom, l_alt_rtg
1047: from wip_flow_schedules
1048: where wip_entity_id = p_wipEntityID;
1049: end if;
1050:
1051: