APPS.PO_RCO_VALIDATION_PVT dependencies on PO_RELEASES_ALL

Line 927: po_releases_all pra

923: l_buyer_id,
924: l_release_num,
925: l_type_lookup_code
926: FROM po_headers_all pha,
927: po_releases_all pra
928: WHERE pra.po_release_id = p_release_id
929: AND pra.po_header_id = pha.po_header_id;
930:
931: IF(l_type_lookup_code = 'BLANKET') THEN

Line 2414: po_releases_all pra,

2410: l_old_curr_amount,
2411: l_old_po_amount
2412: FROM
2413: po_headers_all pha,
2414: po_releases_all pra,
2415: po_lines_all pla,
2416: po_line_locations_all plla,
2417: po_distributions_all pda,
2418: po_req_distributions_all prda,

Line 2497: po_releases_all pra,

2493: l_old_curr_amount,
2494: l_old_po_amount
2495: FROM
2496: po_headers_all pha,
2497: po_releases_all pra,
2498: po_lines_all pla,
2499: po_line_locations_all plla,
2500: po_requisition_lines_all prla,
2501: po_requisition_headers_all prha

Line 3179: FROM po_releases_all

3175:
3176: -- select org id of the release
3177: SELECT agent_id, org_id
3178: INTO l_agent_id, l_po_org_id
3179: FROM po_releases_all
3180: WHERE po_release_id = l_po_release_id;
3181: END IF;
3182:
3183: l_progress := '011';

Line 3565: po_releases_all pra

3561: FROM
3562: po_lines_all pla,
3563: po_line_locations_all plla,
3564: po_requisition_lines_all prla,
3565: po_releases_all pra
3566: WHERE pla.po_line_id = plla.po_line_id
3567: AND plla.line_location_id = prla.line_location_id
3568: AND prla.requisition_line_id = p_req_line_id
3569: AND pra.po_release_id = plla.po_release_id;

Line 4013: FROM po_releases_all

4009: WHERE po_header_id = l_po_header_id;
4010:
4011: SELECT revision_num, release_num
4012: INTO l_po_revision_num, l_po_release_num
4013: FROM po_releases_all
4014: WHERE po_release_id = l_po_release_id;
4015: END IF;
4016: END IF;
4017: x_retmsg := '002';

Line 5467: from po_releases_all

5463: where po_header_id = l_po_header_id;
5464:
5465: select revision_num, release_num
5466: into l_po_revision_num, l_po_release_num
5467: from po_releases_all
5468: where po_release_id = l_po_release_id;
5469: end if;
5470: end if;
5471: */