APPS.PO_RCO_VALIDATION_PVT dependencies on PO_RELEASES_ALL

Line 914: po_releases_all pra

910: l_blanket_num,
911: l_release_num,
912: l_type_lookup_code
913: FROM po_headers_all pha,
914: po_releases_all pra
915: WHERE pra.po_release_id = p_release_id
916: AND pra.po_header_id = pha.po_header_id;
917:
918: IF(l_type_lookup_code = 'BLANKET') THEN

Line 2377: po_releases_all pra,

2373: l_old_curr_amount,
2374: l_old_po_amount
2375: FROM
2376: po_headers_all pha,
2377: po_releases_all pra,
2378: po_lines_all pla,
2379: po_line_locations_all plla,
2380: po_distributions_all pda,
2381: po_req_distributions_all prda,

Line 2460: po_releases_all pra,

2456: l_old_curr_amount,
2457: l_old_po_amount
2458: FROM
2459: po_headers_all pha,
2460: po_releases_all pra,
2461: po_lines_all pla,
2462: po_line_locations_all plla,
2463: po_requisition_lines_all prla,
2464: po_requisition_headers_all prha

Line 3115: FROM po_releases_all

3111:
3112: -- select org id of the release
3113: SELECT agent_id, org_id
3114: INTO l_agent_id, l_po_org_id
3115: FROM po_releases_all
3116: WHERE po_release_id = l_po_release_id;
3117: END IF;
3118:
3119: l_progress := '011';

Line 3494: po_releases_all pra

3490: FROM
3491: po_lines_all pla,
3492: po_line_locations_all plla,
3493: po_requisition_lines_all prla,
3494: po_releases_all pra
3495: WHERE pla.po_line_id = plla.po_line_id
3496: AND plla.line_location_id = prla.line_location_id
3497: AND prla.requisition_line_id = p_req_line_id
3498: AND pra.po_release_id = plla.po_release_id;

Line 3932: FROM po_releases_all

3928: WHERE po_header_id = l_po_header_id;
3929:
3930: SELECT revision_num, release_num
3931: INTO l_po_revision_num, l_po_release_num
3932: FROM po_releases_all
3933: WHERE po_release_id = l_po_release_id;
3934: END IF;
3935: END IF;
3936: x_retmsg := '002';

Line 5309: from po_releases_all

5305: where po_header_id = l_po_header_id;
5306:
5307: select revision_num, release_num
5308: into l_po_revision_num, l_po_release_num
5309: from po_releases_all
5310: where po_release_id = l_po_release_id;
5311: end if;
5312: end if;
5313: */