APPS.INV_RESERVATION_VALIDATE_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 288: FROM po_distributions_all

284: document in the reservation private API before come to
285: this validation.
286: CURSOR c_po_supply IS
287: SELECT 'Y'
288: FROM po_distributions_all
289: WHERE po_distribution_id = p_supply_source_line_id
290: AND po_header_id = p_supply_source_header_id;
291: *** End R12 }} ***/
292: BEGIN

Line 4353: FROM po_distributions_all

4349: p_supply_source_type_id = inv_reservation_global.g_source_type_asn) THEN
4350:
4351: SELECT count(min(po_distribution_id))
4352: INTO l_project_count
4353: FROM po_distributions_all
4354: WHERE po_header_id = p_supply_source_header_id
4355: AND line_location_id = p_supply_source_line_id
4356: group by project_id, task_id;
4357:

Line 4410: FROM po_distributions_all

4406:
4407: IF ((p_project_id is not null) AND (l_project_count = 1)) THEN
4408: SELECT MIN(project_id), MIN(task_id)
4409: INTO l_project_id, l_task_id
4410: FROM po_distributions_all
4411: WHERE po_header_id = p_supply_source_header_id
4412: AND line_location_id = p_supply_source_line_id;
4413:
4414: IF (l_project_id <> p_project_id or l_task_id <> p_task_id) THEN