DBA Data[Home] [Help]

APPS.INV_SHORTCHECKEXEC_PVT dependencies on WIP_REPETITIVE_SCHEDULES

Line 625: wip_repetitive_schedules WRS,

621: UNION
622: SELECT DISTINCT FU.user_name
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

Line 669: wip_repetitive_schedules WRS,

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
673: AND MSCT.object_type = 2

Line 1090: , wip_repetitive_schedules wrs

1086: INTO l_open_qty
1087: FROM wip_parameters wp
1088: , wip_requirement_operations wro
1089: , wip_operations wo
1090: , wip_repetitive_schedules wrs
1091: WHERE wp.organization_id = p_organization_id
1092: AND wro.organization_id = wp.organization_id
1093: AND wro.wip_entity_id = p_wip_entity_id
1094: AND wro.repetitive_schedule_id = p_repetitive_schedule_id