DBA Data[Home] [Help]

APPS.PO_MASS_UPDATE_PO_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 2108: UPDATE po_distributions_all

2104: END IF;
2105:
2106:
2107:
2108: UPDATE po_distributions_all
2109: SET deliver_to_person_id = p_new_personid,
2110: last_update_date = sysdate,
2111: last_updated_by = fnd_global.user_id,
2112: last_update_login = fnd_global.login_id

Line 2186: po_distributions_all pod

2182: pdt.type_name
2183: FROM po_releases por,
2184: po_headers poh,
2185: po_document_types_vl pdt,
2186: po_distributions_all pod
2187: WHERE por.po_header_id = poh.po_header_id
2188: AND poh.po_header_id = pod.po_header_id
2189: AND pod.po_release_id = por.po_release_id /* Bug 6868589 */
2190: AND pod.deliver_to_person_id = PO_MASS_UPDATE_PO_PVT.get_old_personid

Line 2318: UPDATE po_distributions_all

2314: PO_DEBUG.debug_var(l_log_head,l_progress,'l_doc_type',l_doc_type );
2315:
2316: END IF;
2317:
2318: UPDATE po_distributions_all
2319: SET deliver_to_person_id = p_new_personid,
2320: last_update_date = sysdate,
2321: last_updated_by = fnd_global.user_id,
2322: last_update_login = fnd_global.login_id