APPS.PO_POXSERPR_XMLP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 114

  SELECT papf.person_id
  INTO l_person_id
  FROM per_all_people_f  papf
  WHERE papf.business_group_id = (
                    SELECT nvl(max(fsp.business_group_id),0)
                    FROM financials_system_parameters fsp)
    AND trunc(sysdate) BETWEEN
                papf.effective_start_date and papf.effective_end_date
    AND decode(hr_general.get_xbg_profile,'Y', papf.business_group_id
            , hr_general.get_business_group_id) = papf.business_group_id
    AND papf.full_name = nvl(P_BUYER,papf.full_name);

Line: 135

    SELECT fsp.inventory_organization_id
  INTO l_inv_org_id
  FROM financials_system_parameters fsp;

Line: 144

       || '               SELECT msi.inventory_item_id '
       || '               FROM mtl_system_items msi '
       || '               WHERE nvl(msi.organization_id, ' || l_inv_org_id || ' ) = ' || l_inv_org_id
       || '               AND ' || P_WHERE_ITEM
       || '            )';

Line: 157

       || '              SELECT mca.category_id FROM mtl_categories mca '
       || '              WHERE ' || P_WHERE_CAT
       || '            ) ';

Line: 167

       || '              SELECT mca.category_id FROM mtl_categories mca '
       || '              WHERE ' || P_WHERE_CAT
       || '            ) ';

Line: 176

       || ' SELECT DISTINCT pov.vendor_name Vendor '
       || '               , pov.segment1    Vendor_Number '
       || '               , pov.vendor_id   Parent_vendor_id '
       || ' FROM po_headers poh, po_vendors pov '
       || ' WHERE poh.vendor_id = pov.vendor_id '
       || l_buyer_where_h
       || l_creation_date_where_h
       || l_vendor_name_where
       || '   AND EXISTS '
       || '       ( '
       || '         SELECT 1 '
       || '         FROM rcv_transactions rct '
       || '         WHERE rct.po_header_id = poh.po_header_id '
       || '           AND rct.transaction_type = ''RECEIVE'' '
       || '           AND rct.po_release_id IS NULL '
       || '       ) '
       || '   AND poh.po_header_id IN '
       || '       ( '
       || '         SELECT DISTINCT pol.po_header_id '
       || '         FROM po_lines pol '
       || '         WHERE ' || l_item_query_filter
       || '        ) '
       || ' UNION '
       || ' SELECT DISTINCT pov.vendor_name Vendor '
       || '               , pov.segment1    Vendor_Number '
       || '               , pov.vendor_id   Parent_vendor_id '
       || ' FROM po_headers poh, po_releases_all por, po_vendors pov '
       || ' WHERE poh.vendor_id = pov.vendor_id '
       || '   AND poh.org_id = por.org_id '
       || '   AND por.po_header_id = poh.po_header_id '
       || l_buyer_where_r
       || l_creation_date_where_r
       || l_vendor_name_where
       || '   AND EXISTS '
       || '       ( '
       || '         SELECT 1 '
       || '         FROM rcv_transactions rct '
       || '         WHERE rct.po_header_id = poh.po_header_id '
       || '           AND rct.transaction_type = ''RECEIVE'' '
       || '           AND rct.po_release_id IS NOT NULL '
       || '       ) '
       || '   AND por.po_release_id IN '
       || '       ( '
       || '         SELECT DISTINCT pll.po_release_id '
       || '         FROM po_lines_all pol, po_line_locations pll '
       || '         WHERE pol.po_line_id = pll.po_line_id '
       || '           AND pol.org_id = pll.org_id '
       || '           AND ' || l_item_query_filter
       || '        ) ';

Line: 230

       || ' SELECT DISTINCT pov.vendor_name Vendor  '
       || '               , pov.segment1    Vendor_Number '
       || '               , pov.vendor_id   Parent_vendor_id '
       || ' FROM po_headers poh, po_vendors pov '
       || ' WHERE poh.vendor_id = pov.vendor_id '
       || l_buyer_where_h
       || l_creation_date_where_h
       || l_vendor_name_where
       || '   AND EXISTS '
       || '     ( '
       || '       SELECT 1 '
       || '       FROM rcv_transactions rct '
       || '       WHERE rct.po_header_id = poh.po_header_id '
       || '         AND rct.transaction_type = ''RECEIVE'' '
       || '         AND rct.po_release_id IS NULL '
       || '     ) '
       || ' UNION '
       || ' SELECT DISTINCT pov.vendor_name Vendor '
       || '               , pov.segment1    Vendor_Number '
       || '               , pov.vendor_id   Parent_vendor_id '
       || ' FROM po_releases por, po_headers poh, po_vendors pov '
       || ' WHERE poh.vendor_id = pov.vendor_id '
       || ' AND por.po_header_id = poh.po_header_id '
       || l_buyer_where_r
       || l_creation_date_where_r
       || l_vendor_name_where
       || '   AND EXISTS '
       || '     ( '
       || '       SELECT 1 '
       || '       FROM rcv_transactions rct '
       || '       WHERE rct.po_header_id = poh.po_header_id '
       || '         AND rct.transaction_type = ''RECEIVE'' '
       || '         AND rct.po_release_id IS NOT NULL '
       || '     ) ';

Line: 268

       || ' SELECT pov.vendor_name Vendor, pov.segment1 Vendor_Number, pov.vendor_id Parent_vendor_id'
       || ' FROM po_vendors pov'
       || ' WHERE'
       || ' ( '
       || '   EXISTS  '
       || '   (  '
       || '    SELECT 1 '
       || '    FROM po_headers poh '
       || '    WHERE poh.vendor_id = pov.vendor_id '
       || '     AND EXISTS '
       || '        ( '
       || '          SELECT 1 '
       || '          FROM rcv_transactions rct '
       || '          WHERE rct.po_header_id = poh.po_header_id '
       || '          AND rct.transaction_type = ''RECEIVE'' '
       || '          AND rct.po_release_id IS NULL '
       || '        ) '
       || '    ) '
       || ' OR EXISTS '
       || '    ( '
       || '     SELECT 1 '
       || '     FROM po_releases por, po_headers poh '
       || '     WHERE poh.vendor_id = pov.vendor_id '
       || '     AND por.po_header_id = poh.po_header_id '
       || '     AND EXISTS '
       || '        ( '
       || '         SELECT 1 '
       || '         FROM rcv_transactions rct '
       || '         WHERE rct.po_header_id = poh.po_header_id '
       || '         AND rct.transaction_type = ''RECEIVE'' '
       || '         AND rct.po_release_id IS NOT NULL '
       || '        ) '
       || '     ) '
       || '  ) '
       || l_vendor_name_where;

Line: 352

        select structure_id
        into l_p_struct_num
        from mtl_default_sets_view
        where functional_area_id = 2 ;