DBA Data[Home] [Help]

APPS.PO_MASS_UPDATE_REQ_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 1306: po_requisition_lines_all prl

1302: por.segment1,
1303: pdt.type_name
1304: FROM po_requisition_headers por,
1305: po_document_types_vl pdt,
1306: po_requisition_lines_all prl
1307: WHERE prl.to_person_id = PO_MASS_UPDATE_REQ_PVT.get_old_personid
1308: AND por.requisition_header_id = prl.requisition_header_id
1309: AND pdt.document_type_code IN (''REQUISITION'')
1310: AND pdt.document_subtype = por.type_lookup_code

Line 1441: UPDATE po_requisition_lines_all

1437: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_type',l_doc_type );
1438:
1439: END IF;
1440:
1441: UPDATE po_requisition_lines_all
1442: SET to_person_id = p_new_personid,
1443: requester_email = l_requester_email,-- Bug 14153104
1444: requester_phone = l_requester_phone,
1445: requester_fax = l_requester_fax,