APPS.PO_CHG_REQUEST_GRP dependencies on PO_RELEASES_ALL

Line 108: from po_releases_all

104: v_document_subtype := 'BLANKET';
105:
106: select org_id
107: into x_org_id
108: from po_releases_all
109: where po_release_id= p_po_release_id;
110:
111: else
112: p_document_id := p_po_header_id;

Line 298: from po_releases_all

294: -- Bug 7287009 - End
295:
296: if (upper(p_po_type) = 'RELEASE') then
297: select po_release_id into l_release_id
298: from po_releases_all
299: where po_header_id = l_po_header_id and release_num = p_release_number;
300: end if;
301:
302: if (p_ack_type = 'CANCELLATION') then

Line 850: PO_RELEASES_ALL PRAA, PO_HEADERS_ALL PHA,

846: PO_LINE_LOCATIONS_ALL PLLA,
847: PO_LINES_ALL PLA,
848: FINANCIALS_SYSTEM_PARAMS_ALL FSPA,
849: -- MTL_UNITS_OF_MEASURE_TL MUOMTL,
850: PO_RELEASES_ALL PRAA, PO_HEADERS_ALL PHA,
851: PO_CHANGE_REQUESTS POCR
852: WHERE
853: PLA.PO_Line_id= PLLA.PO_Line_ID and
854: (PLLA.QUANTITY - PLLA.QUANTITY_CANCELLED) > 0 AND

Line 1503: from po_releases_all pra, po_headers_all pha

1499:
1500: --Check if the given release exists and belongs to the given TP
1501: if ('RELEASE' = upper(p_po_type) ) then
1502: select count(1) into l_count
1503: from po_releases_all pra, po_headers_all pha
1504: where pra.po_header_id = pha.po_header_id
1505: and pra.release_num = p_release_number
1506: and pha.segment1 = p_po_number
1507: and pha.org_id = l_org_id

Line 1634: from po_releases_all

1630: if ('RELEASE' = upper(p_po_type) ) then
1631:
1632: select authorization_status, po_release_id, last_update_date
1633: into l_rel_status, l_release_id, g_last_upd_date
1634: from po_releases_all
1635: where po_header_id = l_po_header_id and release_num = p_release_number;
1636:
1637: --Common validation for RELEASE for both CHANGE and ACKNOWLEDGE
1638: if (l_rel_status in ('CANCELLED', 'CLOSED', 'FINALLY CLOSED',

Line 2099: from po_releases_all praa

2095:
2096: if (p_po_type = 'RELEASE') then
2097: select to_char(po_release_id), to_char(agent_id), LAST_UPDATE_DATE
2098: into l_po_release_id, l_po_buyer_id, l_last_update_date
2099: from po_releases_all praa
2100: where po_header_id = l_po_header_id
2101: and RELEASE_NUM = p_release_number;
2102: end if;
2103: