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 3736: po_headers_all ph,

3732: FROM
3733: --po_distributions_all pod,
3734: po_line_locations_all pll,
3735: po_lines_all pl,
3736: po_headers_all ph,
3737: rcv_shipment_lines rsl,
3738: rcv_shipment_headers rsh
3739: WHERE
3740: rsh.shipment_header_id = l_shipment_header_id

Line 4758: from po_headers_all

4754: PROCEDURE get_multiorg_context(p_document_id number,
4755: x_orgid IN OUT NOCOPY number) IS
4756: cursor get_po_orgid is
4757: select org_id
4758: from po_headers_all
4759: where po_header_id = p_document_id;
4760:
4761: l_progress varchar2(300);
4762: l_api_name varchar2(50) := ' get_multiorg_context';