DBA Data[Home] [Help]

APPS.POS_WCAPPROVE_PVT dependencies on PO_HEADERS_ALL

Line 499: from po_headers_all poh

495: select poh.segment1,
496: poh.agent_id
497: into l_po_number,
498: l_po_preparer_id
499: from po_headers_all poh
500: where po_header_id = l_po_header_id;
501:
502: IF (g_asn_debug = 'Y') THEN
503: debug_log(FND_LOG.LEVEL_STATEMENT,

Line 3904: po_headers_all ph,

3900: FROM
3901: --po_distributions_all pod,
3902: po_line_locations_all pll,
3903: po_lines_all pl,
3904: po_headers_all ph,
3905: rcv_shipment_lines rsl,
3906: rcv_shipment_headers rsh,
3907: po_doc_style_headers pdsh
3908: WHERE

Line 5085: from po_headers_all

5081: PROCEDURE get_multiorg_context(p_document_id number,
5082: x_orgid IN OUT NOCOPY number) IS
5083: cursor get_po_orgid is
5084: select org_id
5085: from po_headers_all
5086: where po_header_id = p_document_id;
5087:
5088: l_progress varchar2(300);
5089: l_api_name varchar2(50) := ' get_multiorg_context';