DBA Data[Home] [Help]

APPS.PO_RETROACTIVE_PRICING_PVT dependencies on PO_RELEASES_ALL

Line 191: po_releases_all por, --

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

Line 304: po_releases_all por, --

300: por.po_release_id,
301: por.authorization_status, por.revision_num,
302: pora.revision_num
303: from po_line_locations poll,
304: po_releases_all por, --
305: po_releases_archive pora
306: where nvl(por.frozen_flag, 'N') = 'N'
307: and nvl(por.authorization_status, 'INCOMPLETE') IN
308: ('APPROVED', 'INCOMPLETE', 'REJECTED',

Line 2699: l_consigned_flag PO_RELEASES_ALL.consigned_consumption_flag%TYPE;

2695: x_sub_check_status varchar2(1);
2696: x_msg_data varchar2(2000);
2697: x_online_report_id number;
2698: -- Bug 3318625
2699: l_consigned_flag PO_RELEASES_ALL.consigned_consumption_flag%TYPE;
2700: begin
2701:
2702: /* Get po_header_id for the documents that are in the Approved STate.
2703: * Call submission checks and initiate approval.

Line 2717: from po_releases_all

2713: if (g_rel_auth_table(i) in ('APPROVED', 'REQUIRES REAPPROVAL')) then
2714:
2715: select NVL(consigned_consumption_flag, 'N') -- Bug 3318625
2716: into l_consigned_flag
2717: from po_releases_all
2718: where po_release_id = g_po_release_id_table(i);
2719:
2720: IF (g_rel_auth_table(i) = 'APPROVED' OR
2721: (g_rel_auth_table(i) = 'REQUIRES REAPPROVAL' AND

Line 2855: FROM po_releases_all por

2851: WHERE poh.po_header_id = p_doc_id;
2852: elsif (p_doc_type = 'RELEASE') then
2853: SELECT por.org_id
2854: into l_org_id
2855: FROM po_releases_all por
2856: WHERE por.po_release_id = p_doc_id;
2857: end if; /*If ((p_document_type = 'PO') OR (p_document_type = 'PA'))*/
2858:
2859: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --

Line 4465: po_releases_all por

4461: por.org_id,
4462: null -- Bug 3880758
4463: from po_line_locations_all pll,
4464: -- Bug 3541961
4465: po_releases_all por
4466: where pll.line_location_id = p_po_line_loc_id
4467: -- Bug 3541961
4468: and pll.po_release_id = por.po_release_id;
4469:

Line 4701: po_releases_all por

4697: SELECT NVL(por.consigned_consumption_flag, 'N'),
4698: pll.ship_to_organization_id,
4699: NULL
4700: FROM po_line_locations_all pll,
4701: po_releases_all por
4702: WHERE pll.line_location_id = p_po_line_loc_id
4703: AND pll.po_release_id = por.po_release_id;
4704:
4705: BEGIN