DBA Data[Home] [Help]

APPS.PO_AUTO_IMPLEMENT_PVT dependencies on PO_HEADERS_ALL

Line 92: FROM po_headers_all pha

88: x_rate,
89: x_org_id,
90: x_style_id,
91: x_pcard_id
92: FROM po_headers_all pha
93: WHERE pha.po_header_id = po_doc_id;
94:
95: l_progress:= '010';
96:

Line 450: x_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

446: x_info_slin_falg VARCHAR2(1):='N';
447:
448: x_group_line_id PO_REQUISITION_LINES_ALL.group_line_id%TYPE;
449: x_po_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
450: x_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
451: x_req_operating_unit_id PO_REQUISITION_LINES_ALL.org_id%TYPE;
452:
453:
454: BEGIN

Line 514: po_headers_all pha

510:
511: SELECT pha.po_header_id
512: INTO x_po_header_id
513: FROM po_line_locations_all pll,
514: po_headers_all pha
515: WHERE pha.po_header_id = pll.po_header_id
516: AND pll.line_location_id = x_po_line_location_id;
517:
518: