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.INV_SHORTCHECKEXEC_PVT dependencies on FND_USER

Line 593: fnd_user FU,

589: -- WIP component planner
590: SELECT DISTINCT FU.user_name user_name
591: FROM mtl_planners MP,
592: mtl_system_items MSI,
593: fnd_user FU,
594: mtl_short_chk_temp MSCT
595: WHERE L_ShortParam_rec.wip_notif_comp_planner_flag = 1
596: AND MSCT.object_type IN (1,2)
597: AND MSCT.seq_num = p_seq_num

Line 609: fnd_user FU,

605: SELECT DISTINCT FU.user_name
606: FROM mtl_planners MP,
607: mtl_system_items MSI,
608: wip_entities WE,
609: fnd_user FU,
610: mtl_short_chk_temp MSCT
611: WHERE L_ShortParam_rec.wip_notif_ass_planner_flag = 1
612: AND MSCT.seq_num = p_seq_num
613: AND MSCT.object_type = 1

Line 627: fnd_user FU,

623: FROM mtl_planners MP,
624: mtl_system_items MSI,
625: wip_repetitive_schedules WRS,
626: wip_repetitive_items WRI,
627: fnd_user FU,
628: mtl_short_chk_temp MSCT
629: WHERE L_ShortParam_rec.wip_notif_ass_planner_flag = 1
630: AND MSCT.seq_num = p_seq_num
631: AND MSCT.object_type = 2

Line 645: fnd_user FU,

641: -- WIP component buyer
642: UNION
643: SELECT DISTINCT FU.user_name
644: FROM mtl_system_items MSI,
645: fnd_user FU,
646: mtl_short_chk_temp MSCT
647: WHERE L_ShortParam_rec.wip_notif_comp_buyer_flag = 1
648: AND MSCT.seq_num = p_seq_num
649: AND MSCT.object_type IN (1,2)

Line 656: FROM fnd_user FU,

652: AND FU.employee_id = MSI.buyer_id
653: -- WIP discrete job creator
654: UNION
655: SELECT DISTINCT FU.user_name
656: FROM fnd_user FU,
657: wip_discrete_jobs WDJ,
658: mtl_short_chk_temp MSCT
659: WHERE L_ShortParam_rec.wip_notif_job_creator_flag = 1
660: AND MSCT.seq_num = p_seq_num

Line 668: FROM fnd_user FU,

664: AND WDJ.created_by = FU.user_id
665: -- WIP repetitive schedule creator
666: UNION
667: SELECT DISTINCT FU.user_name
668: FROM fnd_user FU,
669: wip_repetitive_schedules WRS,
670: mtl_short_chk_temp MSCT
671: WHERE L_ShortParam_rec.wip_notif_job_creator_flag = 1
672: AND MSCT.seq_num = p_seq_num

Line 682: fnd_user FU,

678: UNION
679: SELECT DISTINCT FU.user_name user_name
680: FROM mtl_planners MP,
681: mtl_system_items MSI,
682: fnd_user FU,
683: mtl_short_chk_temp MSCT
684: WHERE L_ShortParam_rec.oe_notif_item_planner_flag = 1
685: AND MSCT.object_type = 4
686: AND MSCT.seq_num = p_seq_num

Line 695: FROM fnd_user FU,

691: AND FU.employee_id = MP.employee_id
692: -- OE sales order creator
693: UNION
694: SELECT DISTINCT FU.user_name
695: FROM fnd_user FU,
696: oe_order_headers SH,
697: mtl_short_chk_temp MSCT
698: WHERE L_ShortParam_rec.oe_notif_so_creator_flag = 1
699: AND MSCT.seq_num = p_seq_num