APPS.PO_RELGEN_PKG dependencies on PO_ASL_ATTRIBUTES_VAL_V

Line 258: po_asl_attributes_val_v paa -- Bug: 1945461

254: po_requisition_headers prh,
255: po_headers poh,
256: po_vendors pov,
257: po_lines pol,
258: po_asl_attributes_val_v paa -- Bug: 1945461
259: --bug 2005755 po_asl_documents pod -- Bug 1790311
260: -- po_autosource_documents pad,
261: -- po_autosource_rules par,
262: where porl.requisition_header_id = prh.requisition_header_id

Line 328: from po_asl_attributes_val_v paa4

324: --Bug#2279155 start
325: and not exists
326: (select 'commodity level ASL should be used
327: only if there is no item level ASL'
328: from po_asl_attributes_val_v paa4
329: where paa4.item_id=porl.item_id
330: and paa4.vendor_id=paa.vendor_id
331: and nvl(paa4.vendor_site_id,-1)=nvl(paa.vendor_site_id,-1)
332: AND paa4.using_organization_id in (-1,porl.destination_organization_id))

Line 347: FROM po_asl_attributes_val_v paa3

343: and (paa.vendor_site_id is null or
344: ( poh.vendor_site_id = paa.vendor_site_id and
345: not exists
346: (SELECT 'select supplier line with null supplier site'
347: FROM po_asl_attributes_val_v paa3
348: WHERE nvl(paa.item_id, -1) = nvl(paa3.item_id, -1)
349: AND nvl(paa.category_id, -1) = nvl(paa3.category_id, -1)
350: AND paa.vendor_id = paa3.vendor_id
351: AND paa3.vendor_site_id is null

Line 365: FROM po_asl_attributes_val_v paa2

361: AND paa3.release_generation_method in ('CREATE_AND_APPROVE','CREATE'))))
362: --end of bug 2005755
363: and paa.using_organization_id =
364: (SELECT max(paa2.using_organization_id)
365: FROM po_asl_attributes_val_v paa2
366: WHERE nvl(paa.item_id, -1) = nvl(paa2.item_id, -1)
367: AND nvl(paa.category_id, -1) = nvl(paa2.category_id, -1)
368: AND paa.vendor_id = paa2.vendor_id
369: AND nvl(paa.vendor_site_id, -1) = nvl(paa2.vendor_site_id, -1)