[Home] [Help]
940: and ((p_start_date is NULL) OR (wro.date_required >= p_start_date)) /* Enh#2824753 */
941: and ((p_cutoff_date is NULL) OR (wro.date_required <= p_cutoff_date))
942: and (
943: ( 'Y' = (select allocate_backflush_components
944: from wip_parameters wp
945: where organization_id = wro.organization_id)
946: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
947: )
948: or wro.wip_supply_type = wip_constants.push
1031: and ((p_start_date is NULL) OR (wro.date_required >= p_start_date)) /* Enh#2824753 */
1032: and ((p_cutoff_date is NULL) OR (wro.date_required <= p_cutoff_date))
1033: and (
1034: ( 'Y' = (select allocate_backflush_components
1035: from wip_parameters wp
1036: where organization_id = wro.organization_id)
1037: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1038: )
1039: or wro.wip_supply_type = wip_constants.push
1080: and ((p_start_date is NULL) OR (wro.date_required >= p_start_date)) /* Enh#2824753 */
1081: and ((p_cutoff_date is null) OR (wro.date_required <= p_cutoff_date))
1082: and (
1083: ( 'Y' = (select allocate_backflush_components
1084: from wip_parameters wp
1085: where organization_id = wro.organization_id)
1086: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1087: )
1088: or wro.wip_supply_type = wip_constants.push
1115: SAVEPOINT WIP_ALLOCATE_PVT_START;
1116: x_msg_data := null;
1117: select default_pull_supply_subinv, default_pull_supply_locator_id
1118: into l_defaultSub, l_defaultLocator
1119: from wip_parameters
1120: where organization_id = p_organization_id;
1121:
1122: /*Component Yield Enhancement(Bug 4369064) -> Fetch the value of component yield parameter*/
1123: select nvl(include_component_yield,1)
1121:
1122: /*Component Yield Enhancement(Bug 4369064) -> Fetch the value of component yield parameter*/
1123: select nvl(include_component_yield,1)
1124: into l_include_yield
1125: from wip_parameters
1126: where organization_id = p_organization_id;
1127: if (l_logLevel <= wip_constants.trace_logging) then
1128: wip_logger.log('wip_picking_pvt.allocate => job count in table passed into allocate(): '
1129: || p_alloc_tbl.COUNT, l_dummy2);
1704: p_linesRec.organization_id := p_organization_id;
1705: p_linesRec.line_status := l_lineStatus;
1706: p_linesRec.operation := INV_Globals.G_OPR_CREATE;
1707:
1708: /* for EAM entity type, select picksilp grouping rule from wip_parameters. If no rule is defined, raise an exception with suitable message */
1709: if(p_wip_entity_type = wip_constants.eam) then
1710:
1711: select pickslip_grouping_rule_id
1712: into l_pick_grouping_rule_id
1709: if(p_wip_entity_type = wip_constants.eam) then
1710:
1711: select pickslip_grouping_rule_id
1712: into l_pick_grouping_rule_id
1713: from wip_parameters
1714: where organization_id = p_organization_id;
1715:
1716: if(l_pick_grouping_rule_id IS NULL) then
1717: fnd_message.set_name('WIP','WIP_PICKING_EAM_PICKSLIP_ERROR');
1864: x_msg_data := null;
1865:
1866: select default_pull_supply_subinv, default_pull_supply_locator_id
1867: into l_defaultSub, l_defaultLocator
1868: from wip_parameters
1869: where organization_id = p_organization_id;
1870:
1871: for i in 1..p_alloc_comp_tbl.COUNT LOOP
1872: if(p_wip_entity_type = l_disc) then
1893: where wro.wip_entity_id = p_alloc_comp_tbl(i).wip_entity_id
1894: and ((p_cutoff_date is NULL) OR (wro.date_required < p_cutoff_date))
1895: and (
1896: ( 'Y' = (select allocate_backflush_components
1897: from wip_parameters wp
1898: where organization_id = wro.organization_id)
1899: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1900: )
1901: or wro.wip_supply_type = wip_constants.push
1976: and wro.operation_seq_num = wo.operation_seq_num
1977: and ((p_cutoff_date is NULL) OR (wro.date_required < p_cutoff_date))
1978: and (
1979: ( 'Y' = (select allocate_backflush_components
1980: from wip_parameters wp
1981: where organization_id = wro.organization_id)
1982: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1983: )
1984: or wro.wip_supply_type = wip_constants.push
2023: and wrs.repetitive_schedule_id = p_alloc_comp_tbl(i).repetitive_schedule_id
2024: and ((p_cutoff_date is null) OR (wro.date_required < p_cutoff_date))
2025: and (
2026: ( 'Y' = (select allocate_backflush_components
2027: from wip_parameters wp
2028: where organization_id = wro.organization_id)
2029: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
2030: )
2031: or wro.wip_supply_type = wip_constants.push
2206: wdj.project_id,
2207: wdj.task_id
2208: from wip_entities we,
2209: wip_discrete_jobs wdj,
2210: wip_parameters wp
2211: where we.wip_entity_id = wdj.wip_entity_id
2212: and we.organization_id = wdj.organization_id
2213: and wp.organization_id = wdj.organization_id
2214: and wp.organization_id = we.organization_id
2240: wdj.task_id
2241: from wip_entities we,
2242: wip_discrete_jobs wdj,
2243: wip_requirement_operations wro,
2244: wip_parameters wp,
2245: wip_operations wo
2246: where wo.wip_entity_id = we.wip_entity_id
2247: and wo.operation_seq_num = wro.operation_seq_num
2248: and we.wip_entity_id = wdj.wip_entity_id
2281: wdj.task_id,
2282: min(wro.date_required) min_date_required
2283: from wip_entities we,
2284: wip_discrete_jobs wdj,
2285: wip_parameters wp,
2286: wip_requirement_operations wro,
2287: wip_operations wo
2288: where we.wip_entity_id = wdj.wip_entity_id
2289: and we.organization_id = wdj.organization_id
2326: mtl_system_items_kfv msik,
2327: wip_repetitive_schedules wrs,
2328: wip_repetitive_items wri,
2329: wip_requirement_operations wro,
2330: wip_parameters wp,
2331: wip_lines wl,
2332: wip_operations wo
2333: where we.wip_entity_id = wrs.wip_entity_id
2334: and wrs.repetitive_schedule_id = wro.repetitive_schedule_id