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 495: from wip_entities we

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

Line 535: from wip_entities we

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

Line 554: from wip_entities we

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

Line 586: set wip_entity_id = wip_entities_s.nextval,

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

Line 603: from wip_entities we

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

Line 608: from wip_entities we

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

Line 629: from wip_entities we

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

Line 3281: wip_entities we

3277: wdj_row.completion_subinventory,
3278: wdj_row.completion_locator_id,
3279: wdj_row.build_sequence
3280: from wip_discrete_jobs wdj,
3281: wip_entities we
3282: where wdj.wip_entity_id = wjsi_row.wip_entity_id
3283: and we.wip_entity_id = wdj.wip_entity_id;
3284:
3285: l_primaryItemID := wdj_row.primary_item_id;