DBA Data[Home] [Help]

APPS.CTO_WORKBENCH_UTIL_PK dependencies on WIP_DISCRETE_JOBS

Line 784: FROM mtl_reservations mr, wip_discrete_jobs wdj

780: --
781: Select max(exp_comp_date) into l_date
782: from
783: (SELECT wdj.scheduled_completion_date exp_comp_date
784: FROM mtl_reservations mr, wip_discrete_jobs wdj
785: WHERE mr.demand_source_type_id = decode(CTO_WORKBENCH_UTIL_PK.get_source_document_id(l_config_line_id), 10,8,2)
786: AND mr.demand_source_line_id = l_config_line_id
787: AND mr.supply_source_type_id = 5
788: AND wdj.wip_entity_id = mr.supply_source_header_id