APPS.PO_RELGEN_PKG dependencies on PO_ASL_ATTRIBUTES_VAL_V

Line 242: po_asl_attributes_val_v paa -- Bug: 1945461

238: po_requisition_headers prh,
239: po_headers poh,
240: po_vendors pov,
241: po_lines pol,
242: po_asl_attributes_val_v paa -- Bug: 1945461
243: --bug 2005755 po_asl_documents pod -- Bug 1790311
244: -- po_autosource_documents pad,
245: -- po_autosource_rules par,
246: where porl.requisition_header_id = prh.requisition_header_id

Line 306: from po_asl_attributes_val_v paa4

302: --Bug#2279155 start
303: and not exists
304: (select 'commodity level ASL should be used
305: only if there is no item level ASL'
306: from po_asl_attributes_val_v paa4
307: where paa4.item_id=porl.item_id
308: and paa4.vendor_id=paa.vendor_id
309: and nvl(paa4.vendor_site_id,-1)=nvl(paa.vendor_site_id,-1)
310: AND paa4.using_organization_id in (-1,porl.destination_organization_id))

Line 325: FROM po_asl_attributes_val_v paa3

321: and (paa.vendor_site_id is null or
322: ( poh.vendor_site_id = paa.vendor_site_id and
323: not exists
324: (SELECT 'select supplier line with null supplier site'
325: FROM po_asl_attributes_val_v paa3
326: WHERE nvl(paa.item_id, -1) = nvl(paa3.item_id, -1)
327: AND nvl(paa.category_id, -1) = nvl(paa3.category_id, -1)
328: AND paa.vendor_id = paa3.vendor_id
329: AND paa3.vendor_site_id is null

Line 343: FROM po_asl_attributes_val_v paa2

339: AND paa3.release_generation_method in ('CREATE_AND_APPROVE','CREATE'))))
340: --end of bug 2005755
341: and paa.using_organization_id =
342: (SELECT max(paa2.using_organization_id)
343: FROM po_asl_attributes_val_v paa2
344: WHERE nvl(paa.item_id, -1) = nvl(paa2.item_id, -1)
345: AND nvl(paa.category_id, -1) = nvl(paa2.category_id, -1)
346: AND paa.vendor_id = paa2.vendor_id
347: AND nvl(paa.vendor_site_id, -1) = nvl(paa2.vendor_site_id, -1)