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.

APPS.PO_COMMUNICATION_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 5029: SELECT count(*) into l_count FROM po_distributions_all WHERE po_header_id = p_document_id;

5025: FROM PO_HEADERS_XML phx WHERE phx.PO_HEADER_ID = PO_COMMUNICATION_PVT.getDocumentId() AND phx.revision_num = PO_COMMUNICATION_PVT.getRevisionNum()';
5026: END IF;
5027:
5028: IF(p_document_subtype <> 'BLANKET') THEN -- blankets will not have distributions
5029: SELECT count(*) into l_count FROM po_distributions_all WHERE po_header_id = p_document_id;
5030:
5031: IF l_count >0 THEN
5032: --Bug 5506417 :Added order by pllx.shipment_num and order by plx.line_num clauses
5033: l_xml_query := 'SELECT phx.*, PO_COMMUNICATION_PVT.getIsComplexWorkPO() is_complex_work_po, PO_COMMUNICATION_PVT.getDocumentType() document_type, PO_COMMUNICATION_PVT.getCoverMessage() cover_message,