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.

APPS.WIP_JSI_DEFAULTER dependencies on BOM_OPERATIONAL_ROUTINGS

Line 1005: from bom_operational_routings bor,

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

Line 1072: from bom_operational_routings bor,

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

Line 1111: from bom_operational_routings bor,

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

Line 1149: from bom_operational_routings bor,

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

Line 1205: from bom_operational_routings bor

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,'@@@') =

Line 1216: from bom_operational_routings bor

1212: for a Non-Standard Job*/
1213: elsif (wjsi_row.load_type = wip_constants.create_ns_job) then
1214: select bor.completion_subinventory
1215: into wjsi_row.completion_subinventory
1216: from bom_operational_routings bor
1217: where bor.organization_id = wjsi_row.organization_id
1218: and nvl(bor.cfm_routing_flag,2) = 2
1219: and bor.assembly_item_id = nvl(wjsi_row.routing_reference_id,wjsi_row.primary_item_id)
1220: and nvl(bor.alternate_routing_designator,'@@@') =

Line 1247: from bom_operational_routings bor

1243: (wjsi_row.load_type = wip_constants.create_eam_job and --for eam, comp sub in valid for rebuild jobs only
1244: (wjsi_row.rebuild_item_id is not null or wjsi_row.rebuild_item_segments is not null))) then
1245: select bor.completion_locator_id
1246: into wjsi_row.completion_locator_id
1247: from bom_operational_routings bor
1248: where bor.organization_id = wjsi_row.organization_id
1249: and nvl(bor.cfm_routing_flag,2) = 2
1250: and bor.assembly_item_id = wjsi_row.primary_item_id
1251: and nvl(bor.alternate_routing_designator,'@@@') =

Line 1256: table BOM_OPERATIONAL_ROUTINGS only if the completion sub inventory in

1252: nvl(wjsi_row.alternate_routing_designator,'@@@')
1253: /* Fixed for bug#3060266
1254: While defaulting the value for completion locator,completion sub inventory mus
1255: t be checked.Completion locator would be defaulted from
1256: table BOM_OPERATIONAL_ROUTINGS only if the completion sub inventory in
1257: BOM_OPERATIONAL_ROUTINGS is same as completion sub inventory given in
1258: table WIP_JOB_SCHEDULE_INTERFACE otherwise leave it null.
1259: */
1260: and bor.COMPLETION_SUBINVENTORY=wjsi_row.COMPLETION_SUBINVENTORY;

Line 1257: BOM_OPERATIONAL_ROUTINGS is same as completion sub inventory given in

1253: /* Fixed for bug#3060266
1254: While defaulting the value for completion locator,completion sub inventory mus
1255: t be checked.Completion locator would be defaulted from
1256: table BOM_OPERATIONAL_ROUTINGS only if the completion sub inventory in
1257: BOM_OPERATIONAL_ROUTINGS is same as completion sub inventory given in
1258: table WIP_JOB_SCHEDULE_INTERFACE otherwise leave it null.
1259: */
1260: and bor.COMPLETION_SUBINVENTORY=wjsi_row.COMPLETION_SUBINVENTORY;
1261: /*Fix for Bug#9765343 (FP of 9668143) Derive Completion Locator based on routing_reference_id

Line 1266: from bom_operational_routings bor

1262: for a Non-Standard Job*/
1263: elsif (wjsi_row.load_type = wip_constants.create_ns_job) then
1264: select bor.completion_locator_id
1265: into wjsi_row.completion_locator_id
1266: from bom_operational_routings bor
1267: where bor.organization_id = wjsi_row.organization_id
1268: and nvl(bor.cfm_routing_flag,2) = 2
1269: and bor.assembly_item_id = nvl(wjsi_row.routing_reference_id,wjsi_row.primary_item_id)
1270: and nvl(bor.alternate_routing_designator,'@@@') =