DBA Data[Home] [Help]

APPS.PO_MASS_UPDATE_PO_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 2181: UPDATE po_distributions_all

2177: END IF;
2178:
2179:
2180:
2181: UPDATE po_distributions_all
2182: SET deliver_to_person_id = p_new_personid,
2183: last_update_date = sysdate,
2184: last_updated_by = fnd_global.user_id,
2185: last_update_login = fnd_global.login_id

Line 2259: po_distributions_all pod

2255: pdt.type_name
2256: FROM po_releases por,
2257: po_headers poh,
2258: po_document_types_vl pdt,
2259: po_distributions_all pod
2260: WHERE por.po_header_id = poh.po_header_id
2261: AND poh.po_header_id = pod.po_header_id
2262: AND pod.po_release_id = por.po_release_id /* Bug 6868589 */
2263: AND pod.deliver_to_person_id = PO_MASS_UPDATE_PO_PVT.get_old_personid

Line 2391: UPDATE po_distributions_all

2387: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_type',l_doc_type );
2388:
2389: END IF;
2390:
2391: UPDATE po_distributions_all
2392: SET deliver_to_person_id = p_new_personid,
2393: last_update_date = sysdate,
2394: last_updated_by = fnd_global.user_id,
2395: last_update_login = fnd_global.login_id