APPS.PO_RETROACTIVE_PRICING_PVT dependencies on PO_RELEASES_ALL

Line 192: po_releases_all por, --

188: por.po_release_id,
189: por.authorization_status, por.revision_num,
190: pora.revision_num
191: from po_line_locations poll,
192: po_releases_all por, --
193: po_releases_archive pora
194: where nvl(por.frozen_flag, 'N') = 'N'
195: and nvl(por.authorization_status, 'INCOMPLETE') IN
196: ('APPROVED', 'INCOMPLETE', 'REJECTED',

Line 317: po_releases_all por, --

313: por.po_release_id,
314: por.authorization_status, por.revision_num,
315: pora.revision_num
316: from po_line_locations poll,
317: po_releases_all por, --
318: po_releases_archive pora
319: where nvl(por.frozen_flag, 'N') = 'N'
320: and nvl(por.authorization_status, 'INCOMPLETE') IN
321: ('APPROVED', 'INCOMPLETE', 'REJECTED',

Line 2789: l_consigned_flag PO_RELEASES_ALL.consigned_consumption_flag%TYPE;

2785: x_sub_check_status varchar2(1);
2786: x_msg_data varchar2(2000);
2787: x_online_report_id number;
2788: -- Bug 3318625
2789: l_consigned_flag PO_RELEASES_ALL.consigned_consumption_flag%TYPE;
2790: x_text_line po_online_report_text.text_line%TYPE; --Bug9040655
2791: max_sequence_num po_online_report_text.sequence%TYPE; --Bug9040655
2792: begin
2793:

Line 2809: from po_releases_all

2805: if (g_rel_auth_table(i) in ('APPROVED', 'REQUIRES REAPPROVAL')) then
2806:
2807: select NVL(consigned_consumption_flag, 'N') -- Bug 3318625
2808: into l_consigned_flag
2809: from po_releases_all
2810: where po_release_id = g_po_release_id_table(i);
2811:
2812: IF (g_rel_auth_table(i) = 'APPROVED' OR
2813: (g_rel_auth_table(i) = 'REQUIRES REAPPROVAL' AND

Line 2967: FROM po_releases_all por

2963: WHERE poh.po_header_id = p_doc_id;
2964: elsif (p_doc_type = 'RELEASE') then
2965: SELECT por.org_id
2966: into l_org_id
2967: FROM po_releases_all por
2968: WHERE por.po_release_id = p_doc_id;
2969: end if; /*If ((p_document_type = 'PO') OR (p_document_type = 'PA'))*/
2970:
2971: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --

Line 4586: po_releases_all por

4582: por.org_id,
4583: null -- Bug 3880758
4584: from po_line_locations_all pll,
4585: -- Bug 3541961
4586: po_releases_all por
4587: where pll.line_location_id = p_po_line_loc_id
4588: -- Bug 3541961
4589: and pll.po_release_id = por.po_release_id;
4590:

Line 4822: po_releases_all por

4818: SELECT NVL(por.consigned_consumption_flag, 'N'),
4819: pll.ship_to_organization_id,
4820: NULL
4821: FROM po_line_locations_all pll,
4822: po_releases_all por
4823: WHERE pll.line_location_id = p_po_line_loc_id
4824: AND pll.po_release_id = por.po_release_id;
4825:
4826: BEGIN