DBA Data[Home] [Help]

APPS.AHL_PRD_NONROUTINE_PUB dependencies on WIP_SCHED_RELATIONSHIPS

Line 763: WIP_SCHED_RELATIONSHIPS WOR

759:
760: SELECT WO.workorder_id,WO.workorder_name
761: INTO x_create_nr_output_rec.WORKORDER_ID,x_create_nr_output_rec.WORKORDER_NUMBER
762: FROM AHL_WORKORDERS WO,AHL_WORKORDERS WO1,
763: WIP_SCHED_RELATIONSHIPS WOR
764: WHERE WOR.parent_object_id = WO1.wip_entity_id
765: AND WOR.child_object_id = WO.wip_entity_id
766: AND WO.master_workorder_flag = 'N'
767: AND WO.status_code <> '22'