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.

[Home] [Help]

APPS.WIP_VALIDATEMLHEADER_PVT dependencies on WIP_REPETITIVE_ITEMS

Line 1247: from wip_repetitive_items wri

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

Line 4309: wip_repetitive_items wri

4305:
4306: select count(*)
4307: into l_rtgCount
4308: from bom_operational_routings bor,
4309: wip_repetitive_items wri
4310: where wri.line_id = wjsi_row.line_id
4311: and nvl(bor.cfm_routing_flag, 2) = 2 --ignore flow rtgs
4312: and wri.primary_item_id = wjsi_row.primary_item_id
4313: and wri.organization_id = wjsi_row.organization_id

Line 4326: wip_repetitive_items wri

4322:
4323: select count(*)
4324: into l_rtgCount
4325: from bom_operational_routings bor,
4326: wip_repetitive_items wri
4327: where wri.line_id = wjsi_row.line_id
4328: and nvl(bor.cfm_routing_flag,2) = 2 --ignore flow routings
4329: and wri.primary_item_id = wjsi_row.primary_item_id
4330: and wri.organization_id = wjsi_row.organization_id