APPS.PO_AUTOCREATE_DOC dependencies on PO_RELEASES

Line 4070: from po_releases_all por, --

4066: /* Get the release number as the next release in sequence */
4067:
4068: select nvl(max(release_num),0)+1
4069: into x_release_num
4070: from po_releases_all por, --
4071: po_headers poh
4072: where poh.po_header_id = x_source_doc_id
4073: and poh.po_header_id = por.po_header_id;
4074:

Line 4076: * Even if the po_releases table gives us the next one in sequence,

4072: where poh.po_header_id = x_source_doc_id
4073: and poh.po_header_id = por.po_header_id;
4074:
4075: /* Bug565530. gtummala. 10/23/97.
4076: * Even if the po_releases table gives us the next one in sequence,
4077: * this could conflict with a release_num that we have inserted into
4078: * the po_headers_interface table previously that has yet to converted
4079: * into a release eg. when we have two req lines that will be created
4080: * onto two diff. releases.

Line 4959: po_releases por

4955: por.release_num
4956: into x_segment1,
4957: x_release_num
4958: from po_headers_all poh, --
4959: po_releases por
4960: where por.po_release_id = x_autocreated_doc_id
4961: and por.po_header_id = poh.po_header_id;
4962:
4963: /* Append the release num to blanket po num */

Line 5058: l_po_release_id po_releases_all.po_release_id%TYPE;

5054: l_doc_type_to_create po_headers_all.type_lookup_code%TYPE;
5055: l_doc_type po_document_types_all_b.document_type_code%TYPE;
5056: l_doc_subtype po_document_types_all_b.document_subtype%TYPE;
5057: l_po_header_id po_headers_all.po_header_id%TYPE;
5058: l_po_release_id po_releases_all.po_release_id%TYPE;
5059: l_return_status VARCHAR2(1);
5060: --
5061:
5062: begin

Line 5351: po_releases pr

5347: from ece_tp_details etd,
5348: po_vendor_sites pvs,
5349: po_vendors pv,
5350: po_headers ph ,
5351: po_releases pr
5352: where pv.vendor_id = pvs.vendor_id
5353: and pvs.tp_header_id = etd.tp_header_id
5354: and etd.document_id = l_transaction_subtype
5355: and ph.vendor_id = pv.vendor_id