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_VALIDATEMLHEADER_PVT dependencies on WIP_ENTITIES

Line 496: from wip_entities we

492: and wjsi.job_name is not null
493: and wjsi.wip_entity_id is null
494: and wjsi.load_type = WIP_CONSTANTS.RESCHED_JOB
495: and not exists (select 1
496: from wip_entities we
497: where we.wip_entity_name = wjsi.job_name
498: and we.organization_id = wjsi.organization_id)
499: returning wjsi.interface_id bulk collect into l_interfaceTbl;
500:

Line 536: from wip_entities we

532: and wjsi.load_type in (WIP_CONSTANTS.CREATE_JOB, WIP_CONSTANTS.CREATE_NS_JOB);
533:
534: update wip_job_schedule_interface wjsi
535: set wjsi.wip_entity_id = (select we.wip_entity_id
536: from wip_entities we
537: where we.wip_entity_name = wjsi.job_name
538: and we.organization_id = wjsi.organization_id),
539: wjsi.last_update_date = sysdate
540: where wjsi.group_id = p_groupID

Line 555: from wip_entities we

551: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION
552: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
553: and wjsi.load_type in (WIP_CONSTANTS.CREATE_JOB, WIP_CONSTANTS.CREATE_NS_JOB)
554: and exists (select 1
555: from wip_entities we
556: where we.wip_entity_name = wjsi.job_name
557: and we.organization_id = wjsi.organization_id)
558: returning wjsi.interface_id bulk collect into l_interfaceTbl;
559:

Line 587: set wip_entity_id = wip_entities_s.nextval,

583: loadInterfaceError(l_interfaceTbl, fnd_message.get, validationWarning);
584: end if;
585:
586: update wip_job_schedule_interface wjsi
587: set wip_entity_id = wip_entities_s.nextval,
588: last_update_date = sysdate
589: where wjsi.group_id = p_groupID
590: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION
591: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)

Line 604: from wip_entities we

600: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION
601: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
602: and ( ( wjsi.load_type = WIP_CONSTANTS.RESCHED_JOB
603: and not exists (select 1
604: from wip_entities we
605: where we.organization_id = wjsi.organization_id
606: and we.wip_entity_id = wjsi.wip_entity_id))
607: OR ( wjsi.load_type in (WIP_CONSTANTS.CREATE_JOB, WIP_CONSTANTS.CREATE_NS_JOB)
608: and exists (select 1

Line 609: from wip_entities we

605: where we.organization_id = wjsi.organization_id
606: and we.wip_entity_id = wjsi.wip_entity_id))
607: OR ( wjsi.load_type in (WIP_CONSTANTS.CREATE_JOB, WIP_CONSTANTS.CREATE_NS_JOB)
608: and exists (select 1
609: from wip_entities we
610: where we.organization_id = wjsi.organization_id
611: and we.wip_entity_id = wjsi.wip_entity_id)))
612: returning wjsi.interface_id bulk collect into l_interfaceTbl;
613:

Line 630: from wip_entities we

626: and wjsi.process_phase = WIP_CONSTANTS.ML_VALIDATION
627: and wjsi.process_status in (WIP_CONSTANTS.RUNNING, WIP_CONSTANTS.WARNING)
628: and wjsi.load_type = WIP_CONSTANTS.RESCHED_JOB
629: and exists (select 1
630: from wip_entities we
631: where we.wip_entity_id = wjsi.wip_entity_id
632: and we.organization_id = wjsi.organization_id
633: and we.entity_type <> 1)
634: returning wjsi.interface_id bulk collect into l_interfaceTbl;

Line 3311: wip_entities we

3307: wdj_row.completion_locator_id,
3308: wdj_row.build_sequence,
3309: wdj_row.class_code
3310: from wip_discrete_jobs wdj,
3311: wip_entities we
3312: where wdj.wip_entity_id = wjsi_row.wip_entity_id
3313: and we.wip_entity_id = wdj.wip_entity_id;
3314:
3315: l_primaryItemID := wdj_row.primary_item_id;