DBA Data[Home] [Help]

APPS.WIP_OSP_SHP_I_WF dependencies on PO_REQUISITION_LINES_ALL

Line 660: po_requisition_lines_all prl

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)
664: and prl.line_location_id is null