APPS.INV_DIAG_MSN SQL Statements

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

Line: 39

JTF_DIAGNOSTIC_COREAPI.insert_style_sheet;

Line: 52

    sqltxt :='SELECT msn.serial_number "Serial|Number" '||
             ', msn.inventory_item_id "Item ID" '||
             ', ml.meaning || '' ( '' || msn.current_status || '' )'' "Current Status (Id)" '||
             ', msn.current_subinventory_code "Current|Subinventory" '||
             ', msn.current_locator_id "Current|Locator Id" '||
             ', msn.cost_group_id "Cost Group|Id" '||
             ', msn.lpn_id "LPN Id" '||
             ', msn.group_mark_id "Group Mark|Id" '||
             ', msn.line_mark_id "Line Mark|Id" '||
             ', msn.lot_line_mark_id "Lot Line Mark|Id" '||
             ', TO_CHAR( msn.last_update_date, ''DD-MON-RR HH24:MI'' ) "Last|Updated" '||
             ', msn.last_transaction_id "Last Transaction ID" '||
             ', msn.wip_entity_id "WIP Entity ID" '||
             ', msn.original_wip_entity_id "Original|WIP Entity ID" '||
             'FROM mtl_serial_numbers msn  '||
             ', mfg_lookups ml '||
             'WHERE 1 = 1 ';

Line: 83

    sqltxt := 'select * from ('||sqltxt||') WHERE ROWNUM <= '||row_limit;

Line: 87

    delete from inv_diag_msn_temp;

Line: 89

    insert into inv_diag_msn_temp
           (serial_number
           ,org_id
           ,inventory_item_id)
    select distinct serial_number, current_organization_id,inventory_item_id
        from mtl_serial_numbers
       where inventory_item_id = nvl(l_item_id, inventory_item_id)
         and current_organization_id = nvl(l_org_id, current_organization_id)
         and serial_number = nvl(l_sn, serial_number);