DBA Data[Home] [Help]

APPS.WIP_JSI_DEFAULTER dependencies on WIP_REPETITIVE_ITEMS

Line 1006: wip_repetitive_items wri

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
1010: and wri.organization_id = wjsi_row.organization_id

Line 1073: wip_repetitive_items wri

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
1077: and wri.organization_id = wjsi_row.organization_id

Line 1112: wip_repetitive_items wri

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
1116: and wri.organization_id = wjsi_row.organization_id

Line 1150: wip_repetitive_items wri

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
1154: and wri.organization_id = wjsi_row.organization_id