[Home] [Help]
1001: from wip_lines wl
1002: where wl.line_id = wjsi_row.line_id
1003: and wl.line_schedule_type = 2))
1004: and (not exists (select 1
1005: from bom_operational_routings bor,
1006: wip_repetitive_items wri
1007: where wri.line_id = wjsi_row.line_id
1008: and nvl(bor.cfm_routing_flag,2) = 2
1009: and wri.primary_item_id = wjsi_row.primary_item_id
1068: from wip_lines wl
1069: where wl.line_id = wjsi_row.line_id
1070: and wl.line_schedule_type = 2))
1071: and (not exists (select 1
1072: from bom_operational_routings bor,
1073: wip_repetitive_items wri
1074: where wri.line_id = wjsi_row.line_id
1075: and nvl(bor.cfm_routing_flag,2) = 2
1076: and wri.primary_item_id = wjsi_row.primary_item_id
1107: from wip_lines wl
1108: where wl.line_id = wjsi_row.line_id
1109: and wl.line_schedule_type = 2))
1110: and (not exists (select 1
1111: from bom_operational_routings bor,
1112: wip_repetitive_items wri
1113: where wri.line_id = wjsi_row.line_id
1114: and nvl(bor.cfm_routing_flag,2) = 2
1115: and wri.primary_item_id = wjsi_row.primary_item_id
1145: from wip_lines wl
1146: where wl.line_id = wjsi_row.line_id
1147: and wl.line_schedule_type = 2))
1148: and (not exists (select 1
1149: from bom_operational_routings bor,
1150: wip_repetitive_items wri
1151: where wri.line_id = wjsi_row.line_id
1152: and nvl(bor.cfm_routing_flag,2) = 2
1153: and wri.primary_item_id = wjsi_row.primary_item_id
1201: (wjsi_row.load_type = wip_constants.create_eam_job and --for eam, comp sub in valid for rebuild jobs only
1202: (wjsi_row.rebuild_item_id is not null or wjsi_row.rebuild_item_segments is not null))) then
1203: select bor.completion_subinventory
1204: into wjsi_row.completion_subinventory
1205: from bom_operational_routings bor
1206: where bor.organization_id = wjsi_row.organization_id
1207: and nvl(bor.cfm_routing_flag,2) = 2
1208: and bor.assembly_item_id = wjsi_row.primary_item_id
1209: and nvl(bor.alternate_routing_designator,'@@@') =
1231: (wjsi_row.load_type = wip_constants.create_eam_job and --for eam, comp sub in valid for rebuild jobs only
1232: (wjsi_row.rebuild_item_id is not null or wjsi_row.rebuild_item_segments is not null))) then
1233: select bor.completion_locator_id
1234: into wjsi_row.completion_locator_id
1235: from bom_operational_routings bor
1236: where bor.organization_id = wjsi_row.organization_id
1237: and nvl(bor.cfm_routing_flag,2) = 2
1238: and bor.assembly_item_id = wjsi_row.primary_item_id
1239: and nvl(bor.alternate_routing_designator,'@@@') =
1240: nvl(wjsi_row.alternate_routing_designator,'@@@')
1241: /* Fixed for bug#3060266
1242: While defaulting the value for completion locator,completion sub inventory mus
1243: t be checked.Completion locator would be defaulted from
1244: table BOM_OPERATIONAL_ROUTINGS only if the completion sub inventory in
1245: BOM_OPERATIONAL_ROUTINGS is same as completion sub inventory given in
1246: table WIP_JOB_SCHEDULE_INTERFACE otherwise leave it null.
1247: */
1248: and bor.COMPLETION_SUBINVENTORY=wjsi_row.COMPLETION_SUBINVENTORY;
1241: /* Fixed for bug#3060266
1242: While defaulting the value for completion locator,completion sub inventory mus
1243: t be checked.Completion locator would be defaulted from
1244: table BOM_OPERATIONAL_ROUTINGS only if the completion sub inventory in
1245: BOM_OPERATIONAL_ROUTINGS is same as completion sub inventory given in
1246: table WIP_JOB_SCHEDULE_INTERFACE otherwise leave it null.
1247: */
1248: and bor.COMPLETION_SUBINVENTORY=wjsi_row.COMPLETION_SUBINVENTORY;
1249: end if;