DBA Data[Home] [Help]

APPS.WIP_OSP_SHP_I_WF dependencies on PO_REQUISITION_HEADERS_ALL

Line 659: from po_requisition_headers_all prh,

655: l_rep_sched_id number,
656: l_osp_operation_num number
657: ) is
658: select prh.segment1 req_num
659: from po_requisition_headers_all prh,
660: po_requisition_lines_all prl
661: where prl.wip_entity_id = l_wip_entity_id
662: and prl.wip_operation_seq_num = l_osp_operation_num
663: and nvl(prl.wip_repetitive_schedule_id, -1) = nvl(l_rep_sched_id, -1)