[Home] [Help]
918: and ((p_start_date is NULL) OR (wro.date_required >= p_start_date)) /* Enh#2824753 */
919: and ((p_cutoff_date is NULL) OR (wro.date_required <= p_cutoff_date))
920: and (
921: ( 'Y' = (select allocate_backflush_components
922: from wip_parameters wp
923: where organization_id = wro.organization_id)
924: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
925: )
926: or wro.wip_supply_type = wip_constants.push
1006: and ((p_start_date is NULL) OR (wro.date_required >= p_start_date)) /* Enh#2824753 */
1007: and ((p_cutoff_date is NULL) OR (wro.date_required <= p_cutoff_date))
1008: and (
1009: ( 'Y' = (select allocate_backflush_components
1010: from wip_parameters wp
1011: where organization_id = wro.organization_id)
1012: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1013: )
1014: or wro.wip_supply_type = wip_constants.push
1055: and ((p_start_date is NULL) OR (wro.date_required >= p_start_date)) /* Enh#2824753 */
1056: and ((p_cutoff_date is null) OR (wro.date_required <= p_cutoff_date))
1057: and (
1058: ( 'Y' = (select allocate_backflush_components
1059: from wip_parameters wp
1060: where organization_id = wro.organization_id)
1061: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1062: )
1063: or wro.wip_supply_type = wip_constants.push
1090: SAVEPOINT WIP_ALLOCATE_PVT_START;
1091: x_msg_data := null;
1092: select default_pull_supply_subinv, default_pull_supply_locator_id
1093: into l_defaultSub, l_defaultLocator
1094: from wip_parameters
1095: where organization_id = p_organization_id;
1096:
1097: /*Component Yield Enhancement(Bug 4369064) -> Fetch the value of component yield parameter*/
1098: select nvl(include_component_yield,1)
1096:
1097: /*Component Yield Enhancement(Bug 4369064) -> Fetch the value of component yield parameter*/
1098: select nvl(include_component_yield,1)
1099: into l_include_yield
1100: from wip_parameters
1101: where organization_id = p_organization_id;
1102: if (l_logLevel <= wip_constants.trace_logging) then
1103: wip_logger.log('wip_picking_pvt.allocate => job count in table passed into allocate(): '
1104: || p_alloc_tbl.COUNT, l_dummy2);
1679: p_linesRec.organization_id := p_organization_id;
1680: p_linesRec.line_status := l_lineStatus;
1681: p_linesRec.operation := INV_Globals.G_OPR_CREATE;
1682:
1683: /* for EAM entity type, select picksilp grouping rule from wip_parameters. If no rule is defined, raise an exception with suitable message */
1684: if(p_wip_entity_type = wip_constants.eam) then
1685:
1686: select pickslip_grouping_rule_id
1687: into l_pick_grouping_rule_id
1684: if(p_wip_entity_type = wip_constants.eam) then
1685:
1686: select pickslip_grouping_rule_id
1687: into l_pick_grouping_rule_id
1688: from wip_parameters
1689: where organization_id = p_organization_id;
1690:
1691: if(l_pick_grouping_rule_id IS NULL) then
1692: fnd_message.set_name('WIP','WIP_PICKING_EAM_PICKSLIP_ERROR');
1826: x_msg_data := null;
1827:
1828: select default_pull_supply_subinv, default_pull_supply_locator_id
1829: into l_defaultSub, l_defaultLocator
1830: from wip_parameters
1831: where organization_id = p_organization_id;
1832:
1833: for i in 1..p_alloc_comp_tbl.COUNT LOOP
1834: if(p_wip_entity_type = l_disc) then
1855: where wro.wip_entity_id = p_alloc_comp_tbl(i).wip_entity_id
1856: and ((p_cutoff_date is NULL) OR (wro.date_required < p_cutoff_date))
1857: and (
1858: ( 'Y' = (select allocate_backflush_components
1859: from wip_parameters wp
1860: where organization_id = wro.organization_id)
1861: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1862: )
1863: or wro.wip_supply_type = wip_constants.push
1938: and wro.operation_seq_num = wo.operation_seq_num
1939: and ((p_cutoff_date is NULL) OR (wro.date_required < p_cutoff_date))
1940: and (
1941: ( 'Y' = (select allocate_backflush_components
1942: from wip_parameters wp
1943: where organization_id = wro.organization_id)
1944: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1945: )
1946: or wro.wip_supply_type = wip_constants.push
1985: and wrs.repetitive_schedule_id = p_alloc_comp_tbl(i).repetitive_schedule_id
1986: and ((p_cutoff_date is null) OR (wro.date_required < p_cutoff_date))
1987: and (
1988: ( 'Y' = (select allocate_backflush_components
1989: from wip_parameters wp
1990: where organization_id = wro.organization_id)
1991: and wro.wip_supply_type in (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull)
1992: )
1993: or wro.wip_supply_type = wip_constants.push
2169: wdj.task_id
2170: from wip_entities we,
2171: wip_discrete_jobs wdj,
2172: wip_requirement_operations wro,
2173: wip_parameters wp,
2174: wip_operations wo
2175: where we.wip_entity_id = wdj.wip_entity_id
2176: and we.entity_type = 1
2177: and wdj.status_type in (3,4)
2198: wdj.task_id
2199: from wip_entities we,
2200: wip_discrete_jobs wdj,
2201: wip_requirement_operations wro,
2202: wip_parameters wp,
2203: wip_operations wo
2204: where wo.wip_entity_id = we.wip_entity_id
2205: and wo.operation_seq_num = wro.operation_seq_num
2206: and we.wip_entity_id = wdj.wip_entity_id
2235: mtl_system_items_kfv msik,
2236: wip_repetitive_schedules wrs,
2237: wip_repetitive_items wri,
2238: wip_requirement_operations wro,
2239: wip_parameters wp,
2240: wip_lines wl,
2241: wip_operations wo
2242: where we.wip_entity_id = wrs.wip_entity_id
2243: and wrs.repetitive_schedule_id = wro.repetitive_schedule_id