APPS.FLM_FLMRFPKB_XMLP_PKG SQL Statements

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

Line: 6

      DELETE FROM FLM_KANBAN_PURGE_TEMP
       WHERE GROUP_ID = P_CONC_REQUEST_ID;

Line: 28

  MODE="SELECT"
  DISPLAY="ALL"');

Line: 37

  MODE="SELECT"
  DISPLAY="ALL"');*/

Line: 41

   select organization_code into P_ORG_NAME
   from org_organization_definitions
   where organization_id = P_ORG_ID;

Line: 47

     select line_code into P_LINE_CODE
       from wip_lines
      where line_id = P_LINE_ID
        and organization_id = P_ORG_ID;

Line: 55

      select vendor_name
        into P_SUPPLIER_NAME
        from po_suppliers_val_v
       where vendor_id = P_SUPPLIER_ID;

Line: 63

      select organization_code into P_SOURCE_ORG_NAME
        from org_organization_definitions
      where organization_id = P_SOURCE_ORG_ID;

Line: 70

      select meaning into P_SOURCE_TYPE_CODE
        from mfg_lookups
       where lookup_type = 'MTL_KANBAN_SOURCE_TYPE'
         and lookup_code = P_SOURCE_TYPE;

Line: 77

   select meaning into P_REPORT_OPT
     from mfg_lookups
    where lookup_type = 'FLM_RPT_LIN_REPORT_OPT'
      and lookup_code = P_REPORT_OPTION;

Line: 83

   select meaning into P_DELETE_CARD_OPT
     from mfg_lookups
    where lookup_type = 'FLM_KANBAN_PURGE_CARD'
      and lookup_code = P_DELETE_CARD;

Line: 92

                            p_source_org_id,p_source_subinv,p_delete_card);