83: sqltxt := 'select * from ('||sqltxt||') WHERE ROWNUM <= '||row_limit;
84:
85: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Serial Status');
86:
87: delete from inv_diag_msn_temp;
88:
89: insert into inv_diag_msn_temp
90: (serial_number
91: ,org_id
85: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Serial Status');
86:
87: delete from inv_diag_msn_temp;
88:
89: insert into inv_diag_msn_temp
90: (serial_number
91: ,org_id
92: ,inventory_item_id)
93: select distinct serial_number, current_organization_id,inventory_item_id