DBA Data[Home] [Help]

APPS.WIP_OSP_SHP_I_WF dependencies on PO_REQUISITION_LINES_ALL

Line 703: po_requisition_lines_all prl

699: l_osp_operation_num number
700: ) is
701: select prh.segment1 req_num
702: from po_requisition_headers_all prh,
703: po_requisition_lines_all prl
704: where prl.wip_entity_id = l_wip_entity_id
705: and prl.wip_operation_seq_num = l_osp_operation_num
706: and nvl(prl.wip_repetitive_schedule_id, -1) = nvl(l_rep_sched_id, -1)
707: and prl.line_location_id is null