DBA Data[Home] [Help]

APPS.PO_COMMUNICATION_PVT dependencies on PO_DISTRIBUTIONS_ALL

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

5879: FROM PO_HEADERS_XML phx WHERE phx.PO_HEADER_ID = PO_COMMUNICATION_PVT.getDocumentId() AND phx.revision_num = PO_COMMUNICATION_PVT.getRevisionNum()';
5880: END IF;
5881:
5882: IF(p_document_subtype <> 'BLANKET') THEN -- blankets will not have distributions
5883: SELECT count(*) into l_count FROM po_distributions_all WHERE po_header_id = p_document_id;
5884:
5885: IF l_count >0 THEN
5886: --Bug 5506417 :Added order by pllx.shipment_num and order by plx.line_num clauses
5887: /*Bug 10388305 Added l_tax_name_query to get tax names*/