DBA Data[Home] [Help]

APPS.WIP_VALIDATEMLHEADER_PVT dependencies on WIP_REPETITIVE_ITEMS

Line 1245: from wip_repetitive_items wri

1241: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION
1242: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
1243: and wjsi.load_type = wip_constants.create_sched
1244: and not exists (select 1
1245: from wip_repetitive_items wri
1246: where wri.line_id = wjsi.line_id
1247: and wri.primary_item_id = wjsi.primary_item_id
1248: and wri.organization_id = wjsi.organization_id)
1249: returning wjsi.interface_id bulk collect into l_interfaceTbl;

Line 4180: wip_repetitive_items wri

4176:
4177: select count(*)
4178: into l_rtgCount
4179: from bom_operational_routings bor,
4180: wip_repetitive_items wri
4181: where wri.line_id = wjsi_row.line_id
4182: and nvl(bor.cfm_routing_flag, 2) = 2 --ignore flow rtgs
4183: and wri.primary_item_id = wjsi_row.primary_item_id
4184: and wri.organization_id = wjsi_row.organization_id

Line 4197: wip_repetitive_items wri

4193:
4194: select count(*)
4195: into l_rtgCount
4196: from bom_operational_routings bor,
4197: wip_repetitive_items wri
4198: where wri.line_id = wjsi_row.line_id
4199: and nvl(bor.cfm_routing_flag,2) = 2 --ignore flow routings
4200: and wri.primary_item_id = wjsi_row.primary_item_id
4201: and wri.organization_id = wjsi_row.organization_id