DBA Data[Home] [Help]

APPS.FLM_SEQ_ID2NAME SQL Statements

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

Line: 33

  select
    attribute_type, attribute_source
  into l_type, l_col
  from flm_seq_attributes
  where attribute_id = p_attribute_id;
Line: 99

  select
    attribute_type, attribute_source
  into l_type, l_col
  from flm_seq_attributes
  where attribute_id = p_attribute_id;
Line: 333

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT CONCATENATED_SEGMENTS NAME_VALUE, INVENTORY_ITEM_ID ID_VALUE ' ||
    'FROM MTL_SYSTEM_ITEMS_KFV ' ||
    'WHERE ORGANIZATION_ID = :ORG_ID' ||
    ')';
Line: 344

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT CONCATENATED_SEGMENTS NAME_VALUE, INVENTORY_ITEM_ID ID_VALUE ' ||
    'FROM MTL_SYSTEM_ITEMS_KFV ' ||
    'WHERE ORGANIZATION_ID = :ORG_ID AND BOM_ITEM_TYPE = 5' ||
    ')';
Line: 355

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT CONCATENATED_SEGMENTS NAME_VALUE, INVENTORY_ITEM_ID ID_VALUE ' ||
    'FROM MTL_SYSTEM_ITEMS_KFV ' ||
    'WHERE ORGANIZATION_ID = :ORG_ID AND BOM_ITEM_TYPE = 1' ||
    ')';
Line: 366

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT RULE_NAME NAME_VALUE, RULE_ID ID_VALUE ' ||
    'FROM MTL_ATP_RULES ' ||
    'WHERE :ORG_ID IS NOT NULL' ||
    ')';
Line: 377

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT CONCATENATED_SEGMENTS NAME_VALUE, ITEM_CATALOG_GROUP_ID ID_VALUE ' ||
    'FROM MTL_ITEM_CATALOG_GROUPS_KFV ' ||
    'WHERE :ORG_ID IS NOT NULL' ||
    ')';
Line: 388

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT PICKING_RULE_NAME NAME_VALUE, PICKING_RULE_ID ID_VALUE ' ||
    'FROM MTL_PICKING_RULES ' ||
    'WHERE :ORG_ID IS NOT NULL' ||
    ')';
Line: 399

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT HAZARD_CLASS NAME_VALUE, HAZARD_CLASS_ID ID_VALUE ' ||
    'FROM PO_HAZARD_CLASSES ' ||
    'WHERE :ORG_ID IS NOT NULL' ||
    ')';
Line: 410

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT CONCATENATED_SEGMENTS NAME_VALUE, INVENTORY_ITEM_ID ID_VALUE ' ||
    'FROM MTL_SYSTEM_ITEMS_KFV ' ||
    'WHERE ORGANIZATION_ID = :ORG_ID AND ENG_ITEM_FLAG = ''Y''' ||
    ')';
Line: 423

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT CONCATENATED_SEGMENTS NAME_VALUE, INVENTORY_ITEM_ID ID_VALUE ' ||
    'FROM MTL_SYSTEM_ITEMS_KFV ' ||
    'WHERE ORGANIZATION_ID = :ORG_ID' ||
    ')';
Line: 434

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT SET_NAME NAME_VALUE, SET_ID ID_VALUE ' ||
    'FROM OE_SETS ' ||
    'WHERE :ORG_ID IS NOT NULL AND SET_TYPE = ''ARRIVAL''' ||
    ')';
Line: 445

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT SET_NAME NAME_VALUE, SET_ID ID_VALUE ' ||
    'FROM OE_SETS ' ||
    'WHERE :ORG_ID IS NOT NULL AND SET_TYPE = ''SHIP''' ||
    ')';
Line: 456

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT TRANSACTION_TYPE_CODE NAME_VALUE, TRANSACTION_TYPE_ID ID_VALUE ' ||
    'FROM OE_TRANSACTION_TYPES_ALL ' ||
    'WHERE :ORG_ID IS NOT NULL' ||
    ')';
Line: 467

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT NAME NAME_VALUE, ORGANIZATION_ID ID_VALUE ' ||
    'FROM HR_ALL_ORGANIZATION_UNITS ' ||
    'WHERE :ORG_ID IS NOT NULL' ||
    ')';
Line: 478

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT ORGANIZATION_CODE NAME_VALUE, ORGANIZATION_ID ID_VALUE ' ||
    'FROM MTL_PARAMETERS ' ||
    'WHERE :ORG_ID IS NOT NULL' ||
    ')';
Line: 489

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT segment1 NAME_VALUE, PROJECT_ID ID_VALUE ' ||
    'FROM PA_PROJECTS_ALL ' ||
    'WHERE :ORG_ID IS NOT NULL ' ||
    'union ' ||
    'select  project_number NAME_VALUE, PROJECT_ID ID_VALUE ' ||
    'from  mrp_seiban_numbers ' ||
    ')';
Line: 503

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT TASK_NUMBER NAME_VALUE, TASK_ID ID_VALUE ' ||
    'FROM PA_TASKS ' ||
    'WHERE :ORG_ID IS NOT NULL' ||
    ')';
Line: 514

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT SET_NAME NAME_VALUE, SET_ID ID_VALUE ' ||
    'FROM OE_SETS ' ||
    'WHERE :ORG_ID IS NOT NULL AND SET_TYPE = ''LINE''' ||
    ')';
Line: 525

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT NAME NAME_VALUE, ORDER_SOURCE_ID ID_VALUE ' ||
    'FROM OE_ORDER_SOURCES ' ||
    'WHERE :ORG_ID IS NOT NULL' ||
    ')';
Line: 537

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT NAME NAME_VALUE, CONFIG_HDR_ID ID_VALUE ' ||
    'FROM CZ_CONFIG_HDRS ' ||
    'WHERE :ORG_ID IS NOT NULL' ||
    ')';
Line: 552

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT CONCATENATED_SEGMENTS NAME_VALUE, INVENTORY_ITEM_ID ID_VALUE ' ||
    'FROM MTL_SYSTEM_ITEMS_KFV ' ||
    'WHERE ORGANIZATION_ID = :ORG_ID' ||
    ')';
Line: 563

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT segment1 NAME_VALUE, PROJECT_ID ID_VALUE ' ||
    'FROM PA_PROJECTS_ALL ' ||
    'WHERE :ORG_ID IS NOT NULL ' ||
    'union ' ||
    'select  project_number NAME_VALUE, PROJECT_ID ID_VALUE ' ||
    'from  mrp_seiban_numbers ' ||
    ')';
Line: 577

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT TASK_NUMBER NAME_VALUE, TASK_ID ID_VALUE ' ||
    'FROM PA_TASKS ' ||
    'WHERE :ORG_ID IS NOT NULL' ||
    ')';
Line: 591

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT CONCATENATED_SEGMENTS NAME_VALUE, INVENTORY_ITEM_ID ID_VALUE ' ||
    'FROM MTL_SYSTEM_ITEMS_KFV ' ||
    'WHERE ORGANIZATION_ID = :ORG_ID' ||
    ')';
Line: 602

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT SCHEDULE_GROUP_NAME NAME_VALUE, SCHEDULE_GROUP_ID ID_VALUE ' ||
    'FROM WIP_SCHEDULE_GROUPS ' ||
    'WHERE ORGANIZATION_ID = :ORG_ID' ||
    ')';
Line: 613

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT KANBAN_CARD_NUMBER NAME_VALUE, KANBAN_CARD_ID ID_VALUE ' ||
    'FROM MTL_KANBAN_CARDS ' ||
    'WHERE ORGANIZATION_ID = :ORG_ID' ||
    ')';
Line: 624

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT segment1 NAME_VALUE, PROJECT_ID ID_VALUE ' ||
    'FROM PA_PROJECTS_ALL ' ||
    'WHERE :ORG_ID IS NOT NULL ' ||
    'union ' ||
    'select  project_number NAME_VALUE, PROJECT_ID ID_VALUE ' ||
    'from  mrp_seiban_numbers ' ||
    ')';
Line: 638

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT TASK_NUMBER NAME_VALUE, TASK_ID ID_VALUE ' ||
    'FROM PA_TASKS ' ||
    'WHERE :ORG_ID IS NOT NULL' ||
    ')';
Line: 649

    'SELECT NAME_VALUE, ID_VALUE FROM ' ||
    '(' ||
    'SELECT concatenated_segments NAME_VALUE, CATEGORY_ID ID_VALUE ' ||
    'FROM MTL_CATEGORIES_KFV ' ||
    'WHERE :ORG_ID IS NOT NULL' ||
    ')';