4484: SELECT 1
4485:
4486: FROM po_lines_all pol,
4487: po_lines_all_ext_b ple,
4488: po_uda_ag_template_usages ptu
4489: WHERE pol.po_line_id = l_po_line_id_tbl(i)
4490: AND ple.po_line_id = pol.po_line_id
4491: --AND ple.draft_id = p_draft_id
4492: AND ple.attr_group_id = ptu.attribute_group_id
4654: FROM po_headers_all_ext_b
4655: WHERE po_header_id = p_doc_rec.po_header_id
4656: AND Nvl(draft_id,-1) = -1
4657: AND UDA_TEMPLATE_ID = l_template_id
4658: AND ATTR_GROUP_ID = ( SELECT ATTRIBUTE_GROUP_ID FROM po_uda_ag_template_usages
4659: WHERE template_id = l_template_id
4660: AND attribute_category = 'DOCUMENT_NUMBERING'
4661: AND ATTRIBUTE1 = 'Base Document'
4662: AND ATTRIBUTE2 = l_source_org_owned
4690: FROM po_headers_all_ext_b
4691: WHERE po_header_id = p_doc_rec.po_header_id
4692: AND Nvl(draft_id,-1) = -1
4693: AND UDA_TEMPLATE_ID = l_template_id
4694: AND ATTR_GROUP_ID = ( SELECT ATTRIBUTE_GROUP_ID FROM po_uda_ag_template_usages
4695: WHERE template_id = l_template_id
4696: AND attribute_category = 'DOCUMENT_NUMBERING'
4697: AND ATTRIBUTE1 = 'Base Document'
4698: AND ATTRIBUTE2 = l_source_org_owned