APPS.PO_POXCORIT_XMLP_PKG SQL Statements

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

Line: 12

    select organization_name
    into l_org_displayed
    from org_organization_definitions
    where organization_id = P_org_id ;

Line: 65

        select structure_id
        into l_p_struct_num
        from mtl_default_sets_view
        where functional_area_id = 2 ;

Line: 84

  SELECT primary_vendor_item
  INTO l_item_number
  FROM po_approved_supplier_list
  WHERE using_organization_id = p_org_id
  AND   vendor_id = p_vendor_id
  AND   vendor_site_id = p_vendor_site_id
  AND   item_id = p_item_id;