eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PO_OTM_INTEGRATION_PVT dependencies on PO_RELEASES_ALL

Line 231: l_release_number PO_RELEASES_ALL.release_num%TYPE;

227: l_doc_revision NUMBER;
228: l_blanket_revision PO_HEADERS_ALL.revision_num%TYPE;
229: l_org_name HR_ALL_ORGANIZATION_UNITS.name%TYPE;
230: l_po_number PO_HEADERS_ALL.segment1%TYPE;
231: l_release_number PO_RELEASES_ALL.release_num%TYPE;
232: l_shipping_control PO_HEADERS_ALL.shipping_control%TYPE;
233: l_line_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --
234:
235: l_return_status VARCHAR2(1);

Line 340: FROM po_releases_all por

336: d_progress := '230';
337:
338: SELECT por.shipping_control
339: INTO l_shipping_control
340: FROM po_releases_all por
341: WHERE por.po_release_id = p_doc_id;
342:
343: d_progress := '240';
344: ELSE

Line 2216: , po_releases_all por

2212: , x_otm_doc.po_number
2213: , x_otm_doc.release_number
2214: , x_otm_doc.org_name
2215: FROM po_headers_archive_all poha
2216: , po_releases_all por
2217: , hr_all_organization_units hou
2218: WHERE por.po_release_id = p_doc_id
2219: AND poha.po_header_id = por.po_header_id
2220: AND poha.revision_num = p_blanket_revision