DBA Data[Home] [Help]

APPS.CTO_WORKBENCH_UTIL_PK dependencies on WIP_DISCRETE_JOBS

Line 694: FROM mtl_reservations mr, wip_discrete_jobs wdj

690: --
691: Select max(exp_comp_date) into l_date
692: from
693: (SELECT wdj.scheduled_completion_date exp_comp_date
694: FROM mtl_reservations mr, wip_discrete_jobs wdj
695: WHERE mr.demand_source_type_id = decode(CTO_WORKBENCH_UTIL_PK.get_source_document_id(l_config_line_id), 10,8,2)
696: AND mr.demand_source_line_id = l_config_line_id
697: AND mr.supply_source_type_id = 5
698: AND wdj.wip_entity_id = mr.supply_source_header_id